GetViewInfo returns the wrong (hidden) worksheet names for this file:
Classeur1.zip (6.1 KB)
We are using GroupDocs.Viewer 21.5.0 with this code:
using (var viewer = new Viewer(documentPath))
{
var infoOpts = ViewInfoOptions.ForHtmlView();
infoOpts.SpreadsheetOptions = ViewOpts.SpreadsheetOptions.ForOnePagePerSheet();
infoOpts.SpreadsheetOptions.RenderHeadings = true;
infoOpts.SpreadsheetOptions.RenderGridLines = true;
var info = viewer.GetViewInfo(infoOpts);
The viewing info contains information about sheet 1 and 2 (feuil1 and feuil2)
When adding this line, all sheets are shown correctly:
infoOpts.RenderHiddenPages = true;
Basically RenderHiddenPages is not working as expected if set to “false”.
As we don’t want to render hidden pages, the hidden worksheets should not appear, only the visible ones.