https://bugs.freedesktop.org/show_bug.cgi?id=61908
Priority: medium
Bug ID: 61908
Assignee: [email protected]
Summary: FILESAVE: mmult array function not saved correctly in
.xlsx format
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Created attachment 76026
--> https://bugs.freedesktop.org/attachment.cgi?id=76026&action=edit
xlsx file showing incorrect array formula
My test case (see attached file) was created in LibreOffice 3.5.7.2 running
under Ubuntu 10.04. However, a friend has confirmed it also happens with the
most recent versions of LibreOffice and Ubuntu.
Steps to reproduce:
1. Enter a 2x3 array in cells A1:B3.
2. Enter a 3x1 array in cells E1:E3.
3. Enter array formula MMULT(A1:B3;E1:E3) in cells E5:E6.
4. Save as test.ods. Reopen, and everything is fine.
5. Save as test.xlsx. Reopen, and the entries in cells E5:E6 are incorrect.
The value in E5 is correct, but it is no longer an array formula. The value in
E6 is incorrect, since it is just =E5. The test.xlsx file is attached below.
--
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
