Spreadsheet-Format of existing xlsx gets destroyed

3 posts, 0 answers
  1. Markus
    Markus avatar
    2 posts
    Member since:
    Jul 2016

    Posted 28 Jul 2016 Link to this post

    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. Markus
    Markus avatar
    2 posts
    Member since:
    Jul 2016

    Posted 29 Jul 2016 in reply to Markus Link to this post

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

    I hope that this helps solving the problem.

  3. Nikolay Demirev
    Nikolay Demirev avatar
    136 posts

    Posted 02 Aug 2016 Link to this post

    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.

    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.
Back to Top