Download it now!
Bug 123428 - FILESAVE XLSX Saving as xlsx in Calc creates new styles from the default ones
Summary: FILESAVE XLSX Saving as xlsx in Calc creates new styles from the default ones
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
: 82654 (view as bug list)
Depends on:
Blocks: Calc-Styles XLSX
  Show dependency treegraph
 
Reported: 2019-02-13 09:00 UTC by NISZ LibreOffice Team
Modified: 2019-03-23 16:47 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Xlsx created in Calc with some cell styles. (14.29 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-02-13 09:01 UTC, NISZ LibreOffice Team
Details
Screenshot of the original and exported document side by side in Calc. (216.34 KB, image/png)
2019-02-13 09:01 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-02-13 09:00:02 UTC
Description:
Cells that have the styles that are built in to Calc and get saved as xlsx in Calc create new style with the name of the original one plus a number. This can happen multiple times to cells with the default cell styles before a new save.

Steps to Reproduce:
    1. Open Calc.
    2. Set some of the cell’s styles to for example Good.
    3. Save as xlsx.
    4. Reload.
    5. The cells that had Good style now have Good 1 ( if you now change some of the cells to Good and repeat the steps they will have Good 2 and so forth)

Actual Results:
The cells now have a custom cell style.

Expected Results:
The cells should keep their original cell style.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-02-13 09:01:11 UTC
Created attachment 149249 [details]
Xlsx created in Calc with some cell styles.
Comment 2 NISZ LibreOffice Team 2019-02-13 09:01:31 UTC
Created attachment 149250 [details]
Screenshot of the original and exported document side by side in Calc.
Comment 3 mulla.tasanim 2019-03-12 00:44:34 UTC Comment hidden (obsolete)
Comment 4 mulla.tasanim 2019-03-12 00:49:01 UTC
Need Additional Steps to Reproduce Bug:

    1. Open Calc.
    2. Set some of the cell’s styles to for example Good.
    3. Save as xlsx(Styles are not changed).
    4. Reload.
    5.To check Cell Style
      Click on Style-->Click Manage Style-->Style window will appear
      Select cell to verify Style.
    6. The cells that had Good style now have Good 1 ( if you now change some of the cells to Good and repeat the steps they will have Good 2 and so forth)
Comment 5 Buovjaga 2019-03-23 16:46:05 UTC
*** Bug 82654 has been marked as a duplicate of this bug. ***
Comment 6 Buovjaga 2019-03-23 16:47:19 UTC
This is inherited (tested with 3.3.0). As you can see from the older dupe, the naming used to be different.