https://bugs.documentfoundation.org/show_bug.cgi?id=145560
Bug ID: 145560
Summary: VLOOKUP does not work when calc file is imported from
Lotus 1-2-3 release 4 for windows
Product: LibreOffice
Version: 7.1.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
VLOOHUP ( search criterion; ARRAY; index)
index in 1-2-3 column number 0,1,2,etc
Libre calc appears to want column number 1,2,3,etc
in other words the number returned in Libre Calc is off by one column because
it starts counting as 1 while the Louts 1-2-3 file starts at 0.
--
You are receiving this mail because:
You are the assignee for the bug.
