https://bugs.documentfoundation.org/show_bug.cgi?id=94196
Bug ID: 94196
Summary: FILESAVE, FILEOPEN: .xlsx: TRANSPOSE formula is
corrupted after saving and reopening file.
Product: LibreOffice
Version: 4.4.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 118678
--> https://bugs.documentfoundation.org/attachment.cgi?id=118678&action=edit
Test file with TRANSPOSE() example
Hello,
I've found a bug with the TRANSPOSE function in Calc for the .xlsx file (with
.ods this bug is not present). I've attached the file "Test_TRANSPOSE.ods". You
can see the original array D2:H2 and transposed array B4:B8.
Let's try to save this file to .xsls, close the file, and then open .xlsx file
again. At first sight, the transposed array is in place, with the correct
values. But look at the formulas in the cells B4:B8 :
Must be: "{=TRANSPOSE(D2:H2)}" for all cells B4:B8
Really are: "=TRANSPOSE(D2:H2)" for B4; "=B4" for B5:B8
I've noticed the values of the original array are saved correctly in the
transposed array in spite of the formulas that are now corrupted. You can save
the file and open it again many times - the values of the original array will
be displayed correctly. This makes the bug rather dangerous, because you will
not be able to see the bug until..
..until you won't make change to the original array. Let's edit the cell E2:
enter "6" instead of "2". Look at the transposed array: all 5 cells are updated
with the value "1" (as per corrupted formulas).
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
