https://bugs.freedesktop.org/show_bug.cgi?id=74777
Priority: medium
Bug ID: 74777
Assignee: [email protected]
Summary: Other: error command VLOOKUP () in file created with
previous version of libreoffice
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 93748
--> https://bugs.freedesktop.org/attachment.cgi?id=93748&action=edit
error with file in libreoffice version 3.6.5 - 4.2.0
Problem description:
I apologize for the English, translated automatically.
When you open a file made with an old version of libreoffice that has VLOOKUP
(), in case there is given the option either True or False to indicate whether
the numbers in the table are sorted in ascending or less, the command in
version 4.2.0.4 libreoffice from error (# N / A). Error disappears going and
enter the value, not first requested, then having to change all the sheets made
before.
Example
Libreoffice version 3.6.5 = VLOOKUP (D15, C2: I23, 3) OK
LibreOffice 4.2.0 version = VLOOKUP (D15, C2: I23, 3) (# N / A)
LibreOffice 4.2.0 version = VLOOKUP (D15, C2: I23, 3)...
Operating System: Windows 7
Version: 4.2.0.4 release
--
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
