https://bugs.documentfoundation.org/show_bug.cgi?id=104097
Bug ID: 104097
Summary: FILESAVE: Correct formatted sheet document is
miss-formatted displayed after save + reopen
Product: LibreOffice
Version: 5.3.0.0.alpha1+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: stefan_lange...@t-online.de
Created attachment 128931
--> https://bugs.documentfoundation.org/attachment.cgi?id=128931&action=edit
zip-file with several ods files to show the problem
A sheet document with more than one sheet ans with conditional formatting
created with LO 5.2.3 is opened with LO 5.3.0. Without changes it is saved or
saved as with new name. After the document is closed and reopened, several
cells are displayed incorrectly formatted.
IMHO this is caused by conditional formatting with formulas using cells not
only from one of the sheets.
In the attached zip-file one can find pairs of ods-files:
- the original file created with LO 5.2.3
- the same file opened with LO 5.3.0 and saved as with new name
Pairs:
- V5, V5a, V5b, V7: conditional formatted cells with formulas using cells not
only from one sheet, the documents saved with LO 5.3.0 are "corrupted"
When one opens both file of a pair one can see the differences:
V5: in shheets "Altix IV und V", columns E and M and in line 188, and "Altix n
und nb", column D ans cell F76
V5a: in sheet "Altix IV und V", cell M217
V5b: in sheets "Altix IV und V", column D and N, and "Altix n und nb", column L
V7: in sheets "Altix IV und V", column N, and "Altix n und nb", columns and
cells
- V6: conditional formatted cells with formulas using cells only from one
sheet, the document saved with LO 5.3.0 seems to be correct
I have tested with Windows10 x86 and x64. The results are the same.
Hint:
For contitional formatting are used cells with formulas in hidden columns. I
forgot the show them - Sorry! For better see them I have later shown these
columns in the document "Testtabelle_Formatierung_1_V5_created_LO_5.2.3.ods".
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
