The attached file is displayed "normally" in Excel, but in Calc all rows have a red background. Tested on Fedora and Windows.
Created attachment 49704 [details] example file The file was created in Calc with copy/paste from Excel
Reproduced on LibreOffice 3.4 340m1(Build:103) for OpenSuse Linux. Very strange. The cells have no color fill, yet appear red. I suppose this means that Excel displays the cells correctly.
(In reply to comment #2) > Reproduced on LibreOffice 3.4 340m1(Build:103) for OpenSuse Linux. > > Very strange. The cells have no color fill, yet appear red. I suppose this > means that Excel displays the cells correctly. Yes: first row has an yellow background, the rest of have no background color.
[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: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
re tested with 3.5 beta2. The problem is still present
Created attachment 78675 [details] excel condition
Created attachment 78676 [details] calc condition
This is because of the underlying condition in the excel document. But I don't understand the logic of this condition. Markus I assign this to you, feel free to change.
This is the condition: "Format only cells with" - "Cell value" - "unequal" =INDIRECT("Dummy_for_Comparison!"&ADRESS(ROW();COLUMN()))
Seems Markus is not working on this. Freeing the bug.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.