Free Support Forum - aspose.com

Saving a Workbook locks cells with Named Styles that originally were not locked

Hello,

I have a workbook with named styles. Some of the styles have the 'Protection' turned off (this is so I can control which cells can be edited on a 'Protected' worksheet). When I open and save one of these files, all the Styles become protected, preventing all cells from being edited.

I'm using the code below:

// open the workbook

Workbook wb = new Workbook();

wb.Open("Book1.xlsx", FileFormatType.Excel2007Xlsx);

wb.Save("Book1.xlsx", FileFormatType.Excel2007Xlsx);

Please see attached Console application. Open the Book1.xlsx to see the behavior of the named style. Close the workbook, run the console appliation and open the workbook again. You cannot edit those cells anymore.

Appreciate any feedback.

-frank.

Hi,

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

Thank you for sharing the template file and sample application.

We have found your mentioned issue after an initial test. Your issue has been registered in our internal issue tracking system with issue id: CELLSNET-17442. We will look into it and get back to you soon.

Thank You & Best Regards,

Hi Frank,

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

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issue.

Thank You & Best Regards,

Thank you. That fixed it.

-frank

The issues you have found earlier (filed as 17442) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.

While trying to keep the API as straightforward and clear as possible, we have decided to recognize and honor the common development practices of the platform; we have re-arranged API Structure/ Namespaces.

With this release, we have reorganized the API classes for Aspose.Cells component. This change has some major aspects that we follow. We have added new namespaces. The entire API (classes, interfaces, enumerations, structures etc.) were previously located in the Aspose.Cells namespace. Now, certain sets of API have been moved to their relative namespaces, which make the relationship of classes (with their members) and namespaces clear and simplified. It is to be noted here, we have not renamed existing API (classes, enumerations etc.) but, I am afraid you still need to make certain adjustments in your existing projects accordingly.

For complete reference, please see the product's API Reference.