Bug 146222 - Color formatting is not saved in XLSX when fileopen in MS Excel
Summary: Color formatting is not saved in XLSX when fileopen in MS Excel
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.4.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Corrupted
  Show dependency tree / graph
 
Reported: 2021-12-14 09:04 UTC by Sergey
Modified: 2022-09-06 15:01 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
ODS example (19.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-12-14 13:53 UTC, Roman Kuznetsov 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Sergey 2021-12-14 09:04:34 UTC 
Description:
Faced the problem that my highlighted rows in my table open in MSO with an error and a prompt to restore the file. After restoration all color-coded lines disappear - all lines are completely white.
Is it possible to install some kind of converter (plugin) that would allow you to save xlsx without errors losing Styles in MSO, or is it enough to just save to xls?

Steps to Reproduce:
1. Plugin install
2. Advice on how to save files correctly while fixing
3. New release, may be paid add-on (version)

Actual Results:
1. Create the file and color the rows with any color;
2. Save in XLSX;
3. Open the file by using MSO 365
Bingo! No one row is colored. All rows are white

Expected Results:
I have not tested, but I hope, that saving in XLS could help


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.4.1 (x64) / LibreOffice Community
Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9
CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL
Comment 1 Roman Kuznetsov 2021-12-14 13:53:52 UTC 
Created attachment 176928 [details]
ODS example

I saved problem XLSX that bug reporter sent to our Russian forum to ODS.

Open it in LibreOffice, save to XLSX, then try open XLSX in MS Excel (I tried 2019 version). You'll see some error about non correct file format
Comment 2 m_a_riosv 2021-12-14 15:24:38 UTC 
Log with excel
"
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error069920_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\MARV\Downloads\_Test\146222 Þÿûðтð_ò÷ýþÑÂþò_2022.xlsx'</summary><removedParts><removedPart>Removed Part: /xl/styles.xml part.  (Styles)</removedPart></removedParts><repairedRecords><repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet1.xml part</repairedRecord><repairedRecord>Repaired Records: Column information from /xl/worksheets/sheet1.xml part</repairedRecord></repairedRecords></recoveryLog>
"