https://bugs.freedesktop.org/show_bug.cgi?id=46818
Bug #: 46818
Summary: VLOOKUP Formulas Mangled
Classification: Unclassified
Product: LibreOffice
Version: unspecified
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Formula Editor
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: ch...@barnesconsultants.com
Sorry if this is a duplicate !
When an XLSX or XLSX file containing the following formula is imported into
Calc:
=VLOOKUP($A12,'RAW MATERIALS'!$B$9:'RAW MATERIALS'!$E$220,4,0)
It gets turned into:
=VLOOKUP($A12,'RAW MATERIALS'!$B$9:B9,4,0)
Which produces an Err:502
As a temporary fix, we've reverted the original Excel file to XLS format which
is thankfully imported into LibreOffice without a hitch.
It's not ideal, but it prevents a complete show stopper.
Many thanks
Chris
--
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
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
