This is a migrated thread and some comments may be shown as answers.

CopyFrom styled worksheet

1 Answer 28 Views
SpreadProcessing
This is a migrated thread and some comments may be shown as answers.
Oscar
Top achievements
Rank 1
Oscar asked on 09 Jun 2017, 01:54 PM

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

Sort by
0
Tanya
Telerik team
answered on 14 Jun 2017, 01:02 PM
Hi Oscar,

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

Tags
SpreadProcessing
Asked by
Oscar
Top achievements
Rank 1
Answers by
Tanya
Telerik team
Share this question
or