Created attachment 80133 [details]
Incorrect formatting in LibreOffice Calc
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: 18.104.22.168.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. ***
(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 22.214.171.124 (Build ID: 7fdd5ee61c1c7379dd088f5d50265f0adbccf53)) these black fields are shown the correct collor.
ps: tested it again with Version: 126.96.36.199.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)
> 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. ***