How to know if one column is referenced by another column?

Aspose.Cells Product Family
1

Hi,
I got two questions here:

  1. Do we have a method to get all the hidden rows/columns?(without loop all the rows/columns)
  2. How to know whether any cells in one column is referenced by other cells?

we use the version 17.6.0.0 for now, please feel free to answer the questions, thanks

2

@985664960,

No, there is no other way or specific method but to loop through the rows/cols to check if any row/column is hidden or not.

You may try using Precedents and Dependents feature for your requirements.