We’d like to be able to detect if a Worksheet is set to visibility of xlSheetVeryHidden. After looking at the Aspose.Cells API (version 22.214.171.124) I can’t see this functionality.
Can this be added? If so, what is the likely turn around time for having this available? We only need to detect (and not set) the visibility, if that will make the implementation quicker.
I’ve attached a sample workbook with 3 worksheets: 1 visible, 1 hidden, and 1 very hidden.
Many thanks in advance,
I am afraid, this feature is not available in Aspose.Cells for .NET, it is there in Aspose.Cells for Java though.
I have logged your feature request into our issue tracking system with an issue id: CELLSNET-15431.
We will look into it and get back to you soon.
Please try the attached latest version and you may use the following sample code for your need.
worksheet.VisibilityType = VisibilityType.VeryHidden