Free Support Forum - aspose.com

Hiding Worksheets in Aspose.Grid.Desktop

Is it possible to hide individual worksheets on the GridDesktop control?

I’m using the ExportExcelFile feature, and it would be very helpful if some of the worksheets could be hidden in the newly created Excel file.

Hi,

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

Hiding worksheet feature is not supported yet.

We will look into this feature and get back to you next week.

Thank you.

Hi,

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

Please try the attachment version. In this version we add:

1. New property Comment.Width and Comment.Height to get/set the comment’s width.

2. New method CommentCollection.Add (Int32, Int32, String, Int32, Int32) and CommentCollection .Add (String, String, Int32, Int32) to specify the comment’s size when adding a comment.

3. New property Worksheet.IsVisiable to unhide/hide a worksheet.

4. New property GridDesktop.CommentDisplayingFont to get or set the default displaying font of comment text.

Thank you.

Hi,

Sorry, we missed to attach the new version here, we will attach it soon.

Thanks for being patient!

Hi,

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

Here’s the new version. Thank you.