In Libre Office Calc, do a conditional formatting where the background will change colors. No do an export to an .xls or .xlsx format and the formatting disappears.
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter!
Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.
To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement
Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.
I am having an issue which matches this description. I have changed the version and hardware to refelct my system. For reference the original report was in 3.4.3 on linux.
I will redescribe the issue:
When saving a document in xlsx (office open version) format with conditional formatting that changes the style of cells based on their text content (contains string), then opening the document in MS Excel (tested with 2007 and 2010), the conditional formatting is not shown.
If the user creates conditional formatting in msxl and opens it in calc the formatting is shown correctly. If the user changes anything on this page in calc and then saves, then opens again in msxl the formatting is gone again.
In the msxl conditional formatting 'manage rules' menu all the rules are present as normal, but none of them are working. If the edit rule screen is opened for each rule and then closed again with the 'ok' button (no actual changes necessary), the formatting reappears and shows correctly.
Saving in msxl and opening in calc does not result in any issue.
This feels like a microsoft bug to me but if it is then I am out of luck so here's hoping.
Created attachment 122435 [details]
Conditional formatting example saved with LibreOffice
Opening this in MS Excel does not show any conditional formatting
Created attachment 122436 [details]
Conditional formatting example saved with MS Office
Opening this in either office program shows the formatting correctly
I updated to the newest stable (18.104.22.168 (x64)) and was still able to reproduce the issue as described
I checked inside the save files to see what differences there are in the way the conditional formatting is saved. Here is the result:
The excel version is from both 2007 and 2010 versions, I was unable to test with a less messed up version of MSO because I dont have access to one
Possibly related to #65371
(In reply to Duncan from comment #7)
> Created attachment 122435 [details]
> Conditional formatting example saved with LibreOffice
> Opening this in MS Excel does not show any conditional formatting
Opening this in LibO shows the colors. It has named the styles to ConditionalStyle_X
I tried saving it to ods in Libo and then to xlsx. Now the colors were not shown in LibO.
I tried doing a simple condition from scratch (if contains "a", change style to Heading). Saving as .xlsx and opening in LibO, it doesn't show the heading formatting (again a ConditionalStyle_1 was created).
Confirmed that MSO doesn't show the formatting either.
It seems something went worse after attachment 122435 [details] was created, as now even LibO doesn't preserve the formatting in a way that it would understand.
Let's keep this one open for now.
Win 8.1 32-bit
Build ID: a6f876d45bd4e41a7143594a6cb11b6893a0f620
CPU Threads: 4; OS Version: Windows 6.29; UI Render: GL;
TinderBox: Win-x86@39, Branch:master, Time: 2016-02-11_00:07:38
Locale: fi-FI (fi_FI)
This seems to be related to a bug in the OOXML specification.
§22.214.171.124 says for the operator attribute: "The operator in a "cell value is" conditional formatting rule. This attribute is ignored if
type is not equal to cellIs"
but checking §18.18.15 there are at least 4 attribute values that are not related to cellIs. I have added them now but need to test that this really helps.
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":
try to generate more excel compliant files, tdf#41722
It will be available in 5.3.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Is this bug fixed?
If so, could you please close it as RESOLVED FIXED?