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

Free Support Forum - aspose.com

IsRowColumnHeadersVisible setting is not preserved when saving to SpreadsheetML

After setting the IsRowColumnHeadersVisible to false and saving the Workbook as SpreadsheetML, the Row and Column Headers are still visible when opening the file in Excel.

The bug can be seen with the following sample code…

var workbook = new Workbook();
workbook.Worksheets[0].IsRowColumnHeadersVisible = false;
workbook.Save(“RowAndColumnHeaders.AfterSave.xml”, FileFormatType.SpreadsheetML);


Harry

Hi Harry,

Thanks for pointing it out.

Yes, we can reproduce the issue you have mentioned. We will figure it out soon.

Thank you.

Is there a fix for this issue yet?

Hi,

Thank you for considering Aspose.

We are working on this issue and we will provide you with a fix soon.

Thank you for your patience.

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

Thank you for considering Aspose.

Please try the attached latest fix of Aspose.Cells. We have fixed the issue regarding “IsRowColumnHeaderVisible in SpreadsheetML".

Thank You & Best Regards,

Thanks.

The fix appears to be working. I will let you know if there are any issues.