https://bugs.documentfoundation.org/show_bug.cgi?id=89133
Bug ID: 89133
Summary: Formula: INDEX formula in array function
missunderstoods text as 0
Product: LibreOffice
Version: 4.4.0.3 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 113139
--> https://bugs.documentfoundation.org/attachment.cgi?id=113139&action=edit
Test document
- Open test document
- delete range E3:J3 or replace text B* values with numerical values
- save document
- close LibreOffice
- open document again
Result: Array formula in AH3 / AH4 / AH6 shows ALL INDEX values. It understands
text "-" value as 0 number, and shows all values.
Expected: Since there are no expected fileds found in those rows, IF in formula
should default to FALSE and that's text "-". Text used in INDEX in place of
integer should produce formula error of some kind, so formula result should be
ERROR.
In short, text value placed in INDEX formula in place of row/column number is
understood by formula as 0. I'm not really sure that's intended behaviour since
it's integer field.
Windows 8.1
LibreOffice 4.4.0.3
--
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
