| Summary: | FORMATTING: Incorrect formatting text and colors of cells when opening in xlsx-files in Calc | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | mikhail.v.gavrilov |
| Component: | Calc | Assignee: | Noel Power <nopower> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | CC: | cno, kaktebyavirubit, maximi89, mikhail.v.gavrilov, pje335-lo, sberg.fun |
| Priority: | medium | Keywords: | regression |
| Version: | 4.1.0.0.beta1 | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | interoperabillity | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 60270 | ||
| Attachments: |
Example document
screenshot LibreOffice Calc screenshot MS Office Excel An other file that has this problem good file loading on 4.0.4 bad file loading in 4.1 b1+b2 Test file with the example Test file with the example .ODS file saved with LO 4.0.4 to XLSX file saved with LO 4.0.4 to XLS and looks fine with LO 4.1 pdf with results of xlsx in two versions |
||
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. *** |
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.