https://bugs.freedesktop.org/show_bug.cgi?id=71325
Priority: medium
Bug ID: 71325
Assignee: [email protected]
Summary: UI: INDEX function returns #VALUE error when optional
arguments are omitted.
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 88789
--> https://bugs.freedesktop.org/attachment.cgi?id=88789&action=edit
Screenshot of a Calc spreadsheet displaying errors for different combinations
of input arguments.
Problem description:
The INDEX function returns a #VALUE error when optional 'row' and/or 'column'
arguments are omitted.
Steps to reproduce:
1. Open an instance of Calc.
2. Enter some data into the range A1:C3. Text and number mix is ok.
3. Launch the Function Wizard and double-click the INDEX function.
4. In the first argument select the range with the data in it.
5. Enter the row number into the optional second argument.
6. Leave the remaining arguments blank and click OK.
Current behavior:
Returns the #VALUE error.
Expected behavior:
Should return a reference to the row determined by the value entered in the
second argument.
Operating System: Windows XP
Version: 4.1.3.2 rc
--
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
