Created attachment 125118 [details]
wi 10 64 bits
Versie: 220.127.116.11.alpha1 (x64)
Build ID: 902b28a39528b6c92602e9b521a1d0861be1caf9
CPU Threads: 8; Versie besturingssysteem:Windows 6.19; UI Render: standaard;
Locale: nl-NL (nl_NL)
In the test file there is wrong conditional formatting for cell A1:
Condition 1: Cell value is - equal to - text
The cell value is a text and must with a string -> "Text"
so the right Condition 1 must:
Cell value is - equal to - "Text"
In LO there is no mention and you can save as ods.
When you save the file as *.xslx and open the file in excel there is a error present.
Giving text without quotes could be a cell named 'text' (or a column or row name, which LO actually points out when entering text without quotes) which Excel also allows. The actual difference (i.e. one of the additional attributes of the cfRule element we write) that causes Excel to complain must be something else. Btw, tested with Excel2010.
@moggi: an idea about this one?
*** Bug 99947 has been marked as a duplicate of this bug. ***
Might be the same problem as Bug 99866.
I can't reproduce the error here when I export the file myself. Excel imports the file correctly and also treats it as a label/named range that is not defined.
I currently only have master builds so it would be nice if someone can check if that still affects current master.
I have test in
Build ID: 7b704dfbdb23540ff6366fa60c73474bbda9dc26
CPU Threads: 8; OS Version: Windows 6.19; UI Render: default;
TinderBox: Win-x86@39, Branch:master, Time: 2016-05-20_05:45:40
Locale: nl-NL (nl_NL)
and there isn't a error message.
Now i test again in 5.1.3 and now there isn't a message...
I think it is the same bug as 99866 when i do it with the steps in comment 6 there is a error present.
Created attachment 125222 [details]
save file as XSLX LO 5.2.0 with error
(In reply to vlb from comment #7)
> Created attachment 125222 [details]
> save file as XSLX LO 5.2.0 with error
I'm still unable to reproduce any problems on the Excel side after saving this file in LibreOffice. The file itself looks ok except for the column/row label which seems to be just not imported by Excel at all.
Basically my advice is not to use column/row labels in conditional format formulas. They are most likely not portable across all formats. (same might apply for range names).
I have test in the latest LO 18.104.22.168/22.214.171.124beta2 (x64)and there isn't still a error present. I think it is solved.