https://bugs.freedesktop.org/show_bug.cgi?id=47588
Bug #: 47588
Summary: Calc stops indexing VLOOKUP in xls format after 65536
rows
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.3.0 release
Platform: Other
OS/Version: All
Status: NEW
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Attached an ods spreadsheet with in
B3 =VLOOKUP(A4;Sheet2.$A$1:$B$65536;2)
and in
B4 =VLOOKUP(A4;Sheet2.$A$1:$B$65537;2)
Steps:
1 - Save document as xls (MS 97/2000/2003)
2 - Close and open document
> B3 shows correct value and B4 #REF!
The original .ods does not have this problem
--
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
