Rendering table heading of XLSX does not work properly for hidden cells.
GroupDocs.Viewer version 21.4.1 with those options was used:
options.SpreadsheetOptions = GroupDocs.Viewer.Options.SpreadsheetOptions.ForOnePagePerSheet();
options.SpreadsheetOptions.RenderGridLines = true;
options.SpreadsheetOptions.RenderHeadings = true;
hidden table header.zip (9.4 KB)
Column C is hidden and row 5 is hidden.
The values of column C are not rendered, which is correct, but the table heading “C” is still visible.
For rows it works. The data of row 5 is hidden, as well as the table heading “5”.