https://bugs.documentfoundation.org/show_bug.cgi?id=104097
--- Comment #2 from [email protected] <[email protected]>
---
After additional tests I have found that error also occurs in sheet documents
without conditional formatting but with formulas using cell contents from more
than one sheet or from cells in other sheet as this where the formula is
placed.
>From my original big sheet document, where I have seen the problem first, I
have removed with LO 5.2.3 all conditional formattings and - to make the
document smaller - much of the contents. When I open this document with LO
5.3.0 and save or save as it without changes, after close and reopen also
several cells are displayed not correctly.
In the newly attached zip-file 2 "LO-Test_#2.zip" one can find as in the first
zip file a pair of sheet documents - one created with LO 5.2.3 and the other
opened and saved as with LO 5.3.0
Version: 5.3.0.0.alpha1+ (x64)
Build-ID: 883024d657fb45c7da459017d2f936aac5644bfb
CPU-Threads: 4; BS-Version: Windows 6.19; UI-Render: Standard; Layout Engine:
new;
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2016-11-21_22:11:37
Gebietsschema: de-DE (de_DE); Calc: group
In all sheets of the documents are formulas using cells also from other sheets.
- in the first 3 sheets in columns AB and AC, these formulas are used for
conditional formatting in the original document and not used in this reduced
document
- in the 4th sheet in cells B3 and B510
- in the 5th sheet in columns B, G and I
- in the 6th and 7. sheet in upper section in columns C, E, F, H, J, K, M and
in many cells of the statistics sections behind the "Summe"-lines (starting in
line 253 resp. 172
When one opens both file one can see the differences:
- 1st, 3rd and 4th sheet: OK
- 2nd sheet: I find only one missformatted cell (AE188)
- 5th and 6th sheet: many missformatted cells in both upper sections and
statistics sections (wrong font style, missing backgrond color, wrong
alignment)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
