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

Spreadsheet-Format of existing xlsx gets destroyed

2 Answers 39 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Markus
Top achievements
Rank 1
Markus asked on 28 Jul 2016, 01:27 PM

If I import an existing xlsx-file (Excel 2013) with a special Formatting and export it afterwards, the formatting is destroyed.

The file has its rows colored in different kinds of grey. After processing it, the colors are from dark blue to dark green. Seems like this depends on the brightness of the grey color of the original file.

If I use a standard Excel-Formatting, it is removed while processing.

What can be the reason for this behaviour?

2 Answers, 1 is accepted

Sort by
0
Markus
Top achievements
Rank 1
answered on 29 Jul 2016, 10:24 AM

I could figure out, that the failure only appears for indexed-colors (in styles.xml).

I hope that this helps solving the problem.

0
Nikolay Demirev
Telerik team
answered on 02 Aug 2016, 08:17 AM
Hello Markus,

The XLSX files have document theme, which predefines some colors and fonts. If you change the active document theme all colors and fonts that are refered from the document theme are changed with the colors defined in the new document theme. Here you can read more about the Document Themes.

The default theme in the RadSpreadsheet have the color schemes and font schemes of the Excel 2010 which are slightly different from Excel 2013.

In order to indentify if this is the case with your document try to change the current theme. It can be done using the Ribbon View. Go to Page Layout tab and from the Themes dropdown select some theme. If the colors are changed then that is the reason for that issue.

You can predefine the themes using the information form the article above.

Regards,
Nikolay Demirev
Telerik by Progress
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
Tags
Spreadsheet
Asked by
Markus
Top achievements
Rank 1
Answers by
Markus
Top achievements
Rank 1
Nikolay Demirev
Telerik team
Share this question
or