https://bugs.freedesktop.org/show_bug.cgi?id=59293
Priority: medium
Bug ID: 59293
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FILEOPEN: .ods: error values in array formula result
not preserved when cached
Severity: major
Classification: Unclassified
OS: All
Reporter: er...@redhat.com
Hardware: All
Status: UNCONFIRMED
Version: 4.0.0.0.beta2
Component: Spreadsheet
Product: LibreOffice
Similar to bug 59039 when loading an .ods document with an array formula that
in one of it's cells has an error result, that result is not preserved until
the formula is recalculated. Steps to reproduce:
1. A1: 1
2. A2: =1/0
3. enter array formula in A3:A4 {=A1:A2}
=> result in A4 is #DIV/0!
4. save as .ods
5. reload
6. notice error in A4 is displayed left justified as string
7. in some cell enter =ISERROR(A4)
=> result FALSE, should be TRUE
Is correct only after formula in A3:A4 was forced to recalculate, e.g. Ctrl+F9
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
