Created attachment 80133 [details] Example document Incorrect formatting in LibreOffice Calc for example: 1) rows 64-69 have red ink. 2) rows 70-75 have yellow paper. 3) rows 76-79 have green ink. 4) all borders are thin.
Created attachment 80134 [details] screenshot LibreOffice Calc
Created attachment 80135 [details] screenshot MS Office Excel
Thank you for your bug report, I can reproduce this bug running libreoffice Version: 4.1.0.0.beta1 Build ID: 3a2c2d2417101e45fe07cfd8358acf2204a98f3 on Mac osx 10.8.3 I have an other file that has the same problem I will add it.
Created attachment 80164 [details] An other file that has this problem
*** Bug 65183 has been marked as a duplicate of this bug. ***
Hi thomas, (In reply to comment #4) > An other file that has this problem Can you pls update the summary of the issue, so that is clear immediately what is wrong and possibly when/in which circumstances ? Would be lovely :) thanks - Cor
@Cor, Wenn you open the file your will see black fields with with text in them, wenn you opens it with 4.0.X (Version 4.0.4.1 (Build ID: 7fdd5ee61c1c7379dd088f5d50265f0adbccf53)) these black fields are shown the correct collor. ps: tested it again with Version: 4.1.0.0.beta2 Build ID: 33224f4f11a05cfad2249e812fcc2975fbb61f6 and stil got the problem ps2: I think this is serieus and might be a MAB bug!
Created attachment 80400 [details] good file loading on 4.0.4
Created attachment 80401 [details] bad file loading in 4.1 b1+b2
Created attachment 80412 [details] Test file with the example this file is related to the problem of formatting, it's just a formatting problem or probably interpretation because I have saved it in ODS and opened with LO 4.1 beta 1 and it show the rigths colors so I guess the problem might be from formatting.
Created attachment 80415 [details] Test file with the example .ODS This file works fine with LO 4.1 beta but with ODS.
Yes I think it might be .xsl(x) files only. because that .ods opens with out a problem and the xslx has to problem.
Created attachment 80437 [details] file saved with LO 4.0.4 to XLSX This file comes from the file who looks bad in LibreOffice 4.1 but looks ok in LO 4.0.4 I saved it using the XLSX from the LO 4.0.4 and it looks terrible...
Created attachment 80438 [details] file saved with LO 4.0.4 to XLS and looks fine with LO 4.1 This file were save with LO 4.0.4 and looks fine in LO 4.1
Created attachment 80566 [details] pdf with results of xlsx in two versions
can't reproduce with latest build of 4.1 branch :-/ ( will check master also ) most likely this has been fixed
(In reply to comment #16) > can't reproduce with latest build of 4.1 branch :-/ ( will check master also > ) most likely this has been fixed strangely I see the same problem on master ( perhaps some patch got reverted then on 4.1 )
I'll take it
aha ( and I should really have twigged this ) http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-1&id=9bf6c83367cedb7be81bf67f30d2147d26c7a8 fixes this, Stephan has planned a different fix for this in master
(In reply to comment #19) > http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4- > 1&id=9bf6c83367cedb7be81bf67f30d2147d26c7a8 fixes this, Stephan has planned > a different fix for this in master master fix is <http://cgit.freedesktop.org/libreoffice/core/commit/?id=3af0114a295d2a6c600117adb5bcd6689c0c787e> "Introduce O[U]String::toUInt32"
*** Bug 65706 has been marked as a duplicate of this bug. ***