https://bugs.freedesktop.org/show_bug.cgi?id=45134
Bug #: 45134
Summary: Error in the INDIRECT function
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.5 release
Platform: All
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 56046
--> https://bugs.freedesktop.org/attachment.cgi?id=56046
Fragment of original file creating error
On "Facturation" tab, line 17, Indirect function calling a named range
generates an error 502 since moving to LibreOffice. The spreadsheet opens
correctly in OpenOffice 3.3 and in Excel when saved as ".xls".
Formula in error
=IF(ISNUMBER($A17);VLOOKUP($A17;INDIRECT($K17);B$15;FALSE());"")
Result
Err :502
where $K17 is the name of the range
If INDIRECT is replaced by its result (here "FRANCE")
=IF(ISNUMBER($A17);VLOOKUP($A17;France;B$15;FALSE());"")
the formula computes properly.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
