Name.IsVisible Limitation - Can it be supported at the Cell API level?

Aspose.Cells Product Family
1

Hi there, while the Name.IsVisible property will work with a range that spans 1 row by 1 column, many named ranges span multiple rows and columns. How would I know if only one cell of a large range were hidden?

Thx
Shan

2

Hi,

Thank you for considering Aspose.

We will get back to you regarding your query.

Thank You & Best Regards,

3

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

If you want to check whether a cell is hidden, simply check whether its respective row or column is hidden. Please check the following code:

Cells cells = workbook.Worksheets[0].Cells;

int row = 0;

int column = 0;

if (cells.Rows[row].IsHidden || cells.Columns[column].IsHidden)

{

//the cell is hidden.

}

Thank You & Best Regards,

4

Beautiful - user training issue here. I’ll try it out.
Shan

5

Nausherwam, it looks like Rows.IsHidden is available in the API, but Cells.IsHidden doesn’t exist. So I can only look up visibility only at the row level. I have Aspose.Cells 4.8.2.3…

6

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells for .NET. We have supported Column.IsHidden property in this version.

Thank You & Best Regards,

7

Thanks - it’s in the API and looks like its working. Much appreciated
Shan