We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Adding the Visible Property to the Name Class

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?




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.

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.



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.

Hi Steve,

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