Hello, I have the following situation:
My application has a set of actions defined by the adminsitrator, in this case I have two actions where the application extracts a single sheet from a given xlsx file, fills it with data. Later another action extracts the other sheet from the same xlsx file, fills it with data too. And then the application, as it notices that the file being modified is the same resulting file, tries to merge back both sheets in a single xlsx file.
My problem is, both sheets have some complex styling, and after trying to merge both sheets in a single file, everything stays in place except for some font styles/colors/... Is there any way to achieve a merge of both sheets without losing those styles?
I'm attaching some screenshots, in case you need the original file let me know how to send it.
Thanks
1 Answer, 1 is accepted
In case these styles are coming from a theme, the behavior you are observing is expected. As described in the Copy a Worksheet article, the theme information is preserved in the Workbook and is lost when copying the worksheet.
If this is your case, you can manually copy the workbook's theme. More information on how to deal with this is available in the Document Themes topic. Otherwise, if this is not helpful, you can open a ticket using our support ticketing system where you can attach archives so you can send us a sample file to test with.
Regards,
Tanya
Progress Telerik