Adding the Visible Property to the Name Class

Aspose.Cells Product Family
1

We can retrieve a Name from the list in Worksheets and change it’s value which is great.



var name = workbook.Worksheets.Names[“NamedRangeValue”];



name.RefersTo = “=“MICHAEL””;



The Name object has Text and RefersTo Properties.



However, we would like Aspose to add a Visible property to the Name class, which hide it in excel (and can be done with excel VBA e.g. activeworkbook.Names(1).Visible = False)



Can you please add this property to the name class?



Thanks,

-Steve

2

Hi,

Well, currently we do not support to manipulate (create, run) vba/macros. Could you elaborate how could you do this (hiding a Named range) manually in MS Excel.

Thank you.

3

Sorry for the confusion.



The hiding of named range can only be done through VBA (as far as I know) and not through the Excel GUI.



The Visible property is a property of the Name object (http://msdn.microsoft.com/en-us/library/aa174251(office.11).aspx).



And through the Spreadsheet ML, we can see how NameRanges can be hidden by the ss:Hidden attribute (also see attached):













It will be great to have this property supported since we have hundreds of named ranges and if some of them can be hidden, it will solve users some headaches.



Thanks!

-Steve

4

Hi Steve,

Well, we have incorporated Name.IsVisible property for your requirement, hopefully it will suit you. We will soon attach a new hotfix here for you.

For supporting vba/macros, we have a plan to start working on it next year.

Thank you.

5

Hi Steve,

Please try the fix in http://www.aspose.com/community/forums/147457/insertcolumns-does-not-update-named-ranges/showthread.aspx#147457