Bug 124282 - FILESAVE: Conditonal Formatting with 'Formula is' is not saved when saving as xlsx
Summary: FILESAVE: Conditonal Formatting with 'Formula is' is not saved when saving as...
Status: RESOLVED DUPLICATE of bug 113013
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: dataLoss, filter:xlsx
Depends on:
Blocks: XLSX-Conditional-Formatting
  Show dependency treegraph
Reported: 2019-03-22 21:56 UTC by elske.we
Modified: 2019-05-09 14:14 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Example File created with Excel (9.58 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-03-22 21:57 UTC, elske.we
Example File saved with LO (5.27 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-03-22 22:02 UTC, elske.we
Before Saving (78.56 KB, image/png)
2019-03-22 22:03 UTC, elske.we
Excel Error Message (8.15 KB, image/png)
2019-03-22 22:03 UTC, elske.we
After Saving (62.49 KB, image/png)
2019-03-22 22:03 UTC, elske.we

Note You need to log in before you can comment on or make changes to this bug.
Description elske.we 2019-03-22 21:56:33 UTC
Conditional Formatting with a 'Formula is' rule is not preserved when saving to xlsx

Steps to Reproduce:
1. Create a new workbook in excel and add some conditional formatting rule with an 'Formula is' rule, e.g. '=$C1="true"', with some formatting
2. Save the file as xlsx and open it in LO
3. Save the file in LO as xlsx
4. Open the file in Excel

Actual Results:
Excel says 'We found a problem with some content'. If you choose to recover the workbook, the conditional formatting is still there, but only the rule without the formatting. When opening the file in LO the formatting is lost, too.

Expected Results:
The conditional formatting is preserved or at least the xlsx is still readable by Excel

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 elske.we 2019-03-22 21:57:36 UTC
Created attachment 150210 [details]
Example File created with Excel
Comment 2 elske.we 2019-03-22 22:02:57 UTC
Created attachment 150211 [details]
Example File saved with LO
Comment 3 elske.we 2019-03-22 22:03:20 UTC
Created attachment 150212 [details]
Before Saving
Comment 4 elske.we 2019-03-22 22:03:37 UTC
Created attachment 150213 [details]
Excel Error Message
Comment 5 elske.we 2019-03-22 22:03:50 UTC
Created attachment 150214 [details]
After Saving
Comment 6 Xisco Faulí 2019-03-27 11:46:28 UTC
--- Comment #6 from mulla.tasanim at gmail.com ---
Thank you for reporting the bug.

I can not reproduce the bug in

Version: (x64)
Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: CL

Version: (x64)
Build ID: 91cdf22b88a4f7bec243c8fb187627e766d3294c
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
TinderBox: Win-x86_64 at 42, Branch:master, Time: 2019-03-08_00:38:10
Locale: en-US (en_US); UI-Language: en-US
Calc: CL

I am not getting Error popup in Excel when I am trying to open file saved as
.xlsx in LO

Message lost during the BZ outage -> https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176608.html
Comment 7 elske.we 2019-03-29 07:50:02 UTC
My version:

Version: (x64)
Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: CL

With Excel I'm using Excel 2016 with the latest version installed.

One additional observation: The condition itself is retained in LO as well as in Excel (after restoring), but the formatting is lost, making it look like the whole rule was deleted.
Comment 8 Fran 2019-05-08 17:27:04 UTC
I'm having the same problem.

When opening with Excel 2010 the attached example file saved with LO 'Conditional Formatting Test LO.xlsx', I get the reported error message. If I say Yes to try to recover, there is another message window that informs that Excel has validated and repaired the file, and shows the repaired records:

Registros reparados: Formato condicional de /xl/worksheets/sheet1.xml parte

(Repaired records: Conditional formatting of /xl/worksheets/sheet1.xml)

Also, I've opened with LO the example file created with Excel (Conditional Formatting Test.xlsx), I've added some text in a cell and saved it.

If I open that modified file with Excel 2010, it shows the try to recover message. If I click Yes, the repaired records message is the same.

The version of my LO:
Id. de compilación: aecc05fe267cc68dde00352a451aa867b3b546ac
Subprocs. CPU: 4; SO: Windows 6.1; Repres. IU: predet.; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
Calc: threaded

Thank you
Comment 9 Gabor Kelemen (allotropia) 2019-05-09 14:14:45 UTC

*** This bug has been marked as a duplicate of bug 113013 ***