Bug 131166 - if Excel .xlsx spreadsheet FILESAVE to .ods file some FORMATTING is changed rendering spreadsheet unusable
Summary: if Excel .xlsx spreadsheet FILESAVE to .ods file some FORMATTING is changed r...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.1.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells XLSX-Conditional-Formatting
  Show dependency treegraph
 
Reported: 2020-03-05 18:11 UTC by Juha Ahtiainen
Modified: 2024-03-11 05:28 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Excel spreadsheet (28.76 KB, application/octet-stream)
2020-03-05 18:21 UTC, Juha Ahtiainen
Details
screencapture (108.06 KB, image/png)
2020-03-05 18:22 UTC, Juha Ahtiainen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Juha Ahtiainen 2020-03-05 18:11:58 UTC
Description:
I have old Excel spreadsheet (a bit complicated formatting in spreadsheet). Used it fo many years. if Excel .xlsx spreadsheet saved to .ods file some formatting is changed rendering spreadsheet ugly. If I am very careful and don't modify spreadsheet formatting and save it to its original format (xls) then it is usable! Some other random changes appears if I modify first (common) page!

Se attachement

Sorry my bad English :(

Steps to Reproduce:
1.open spredsheet and look pages
2.save to .ods and quit
3.open .ods and you see what happened

Actual Results:
Spredsheet is bad visual look 

Expected Results:
original visual appearance


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Versio: 6.4.1.2
Koontiversion tunnus: 4d224e95b98b138af42a64d84056446d09082932
CPU-säikeet: 4; Käyttöjärjestelmä: Mac OS X 10.15.4; Käyttöliittymän piirtäminen: oletus; VCL: osx; 
Maa-asetus: fi-FI (fi_FI.UTF-8); Käyttöliittymän kieli: fi-FI
Calc: threaded
Comment 1 Juha Ahtiainen 2020-03-05 18:21:48 UTC
Created attachment 158419 [details]
Excel spreadsheet

open ... and save to .ods
Comment 2 Juha Ahtiainen 2020-03-05 18:22:56 UTC
Created attachment 158420 [details]
screencapture
Comment 3 m_a_riosv 2020-03-06 22:31:08 UTC
Repro
Version: 6.4.2.1 (x64)
Build ID: c92dba0b4728c0ec26c4b83e2c0fbf3284425375
CPU threads: 4; OS: Windows 10.0 Build 19569; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL

At saving as ods, the font for the styles Conditionalformat3/4 changes, from what they have before save as ods.

Editing this styles after reload as ods, seems to save fine.
Comment 4 m_a_riosv 2020-03-06 22:34:36 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2022-10-09 03:49:39 UTC Comment hidden (obsolete)
Comment 6 ady 2023-05-06 14:03:11 UTC
Still a problem in 7.6.alpha.