https://bugs.freedesktop.org/show_bug.cgi?id=85553
Bug ID: 85553
Summary: Vlookup returns #N/A if save in .xls
Product: LibreOffice
Version: 4.2.6.3 release
Hardware: x86 (IA32)
OS: All
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 108570
--> https://bugs.freedesktop.org/attachment.cgi?id=108570&action=edit
Sample file
When using vlookup function in Calc and saving document in .xls it always
return #N/A. If you'll save it in .ods - function will became working. The
problem does not occur with 4.1.6.2 and earlier versions and occur in 4.2.6 and
4.3.2 on both Linux and Windows versions.
Earlier problem was described and fixed in in
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=75642 and
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=74451 but only for .ods.
P.S. Sorry for my poor English and thanks in advance :)
--
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
