| Summary: | FILEOPEN: Some Text Colors Reset Cell Formatting to Default in .XLS | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Scott M. Sanders <ssanders> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | LibreOffice |
| Priority: | medium | ||
| Version: | 3.4.0 Beta2 | ||
| Hardware: | x86 (IA32) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
The smaller text in col A, rows 3+ should be Arial 12 green.
Test kit, see Comment 1 |
||
[Reproducible] with reporter's sample document "LibreOffice 3.4Beta2 – WIN7 Home Premium (64bit) German UI [DEV300m103 (Build:1)]": some cells are shown withArial 10 black instead of Arial 12 green MS EXCEL viewer shows correct colors (pls. see my attahced screenshots), so it seems to be a LibO bug and not a problem with the document. Document looks fine with OOo-dev 3.4 But: Documents having been created by opening with OOo-dev 3.4 and saving as new .xls or .ods look fine in LibO Further Test results, pls see test kit: - Created new Document "MytestfromOOodev340.xls" with OOo-dev3.4 -- All green text Arial12 will be shown Arial 10 black in LibO -- MS EXCEL Viewer will show everything correctly -- "MytestfromOOodev340.ods": text shown correctly in LibO - Created new Document "MytestFromLibo.xls" with LibOBeta2 -- All green text Arial12 will be correctly in LibO -- All Magenta(!) text Arial12 will be shown Arial 10 black in LibO -- MS EXCEL Viewer will show everything correctly -- "MytestFromLibo.ods": text shown correctly in LibO My conclusion: formatting in document seems to be correct, but during fileopen and conversion formatting will be misinterpreted. @Scott M. Sanders: How (with what software) has your sample document been created? @Kohei: Can you please check? Created attachment 45986 [details] Test kit, see Comment 1 It was made in Excel 2000. I close this bug report as RESOLVED WORKFORME because it is no longer reproducible. Tested again on: - Libreoffice 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 - Libreoffice 4.2.1.1 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b - Libreoffice 4.3.0.0.alpha0 ID: 20b8944cd4771f75564277a5144e96b7d9c3d616 Feel free to open this bug report again if you find that the bug is still reproducible under some special circumstances, etc. |
Created attachment 45960 [details] The smaller text in col A, rows 3+ should be Arial 12 green. New to 3.4 (beta 2), some text colors do not display and instead reset the entire cell's formatting to Arial 10 with automatic color. I don't know the exact criteria for "some" colors, but in the attached example, where you see the smaller text in column A (rows 3 and after, specifically 6 and 25), those should appear as a green in Arial 12, as they correctly do in other apps.