Bug 74777 - Other: error command VLOOKUP () in file created with previous version of libreoffice
Summary: Other: error command VLOOKUP () in file created with previous version of libr...
Status: RESOLVED DUPLICATE of bug 74558
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-10 09:39 UTC by bfede
Modified: 2014-02-10 10:14 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
error with file in libreoffice version 3.6.5 - 4.2.0 (717.52 KB, image/jpeg)
2014-02-10 09:39 UTC, bfede 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description bfede 2014-02-10 09:39:43 UTC 
Created attachment 93748 [details]
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
Comment 1 bfede 2014-02-10 09:42:34 UTC 
errore nella scrittura

LibreOffice versione 4.2.0 = CERCA.VERT (D15, C2: I23, 3) ...

I wanted to write

LibreOffice versione 4.2.0 = CERCA.VERT (D15, C2: I23, 3,0) OK

I repeat the whole sample

Versione LibreOffice 3.6.5 = CERCA.VERT (D15, C2: I23, 3) OK 
LibreOffice versione 4.2.0 = CERCA.VERT (D15, C2: I23, 3) (# N / A) 
LibreOffice versione 4.2.0 = CERCA.VERT (D15, C2: I23, 3,0) OK
Comment 2 m_a_riosv 2014-02-10 10:14:11 UTC 
Seems a duplicate, please if you are not agree reopen it.

*** This bug has been marked as a duplicate of bug 74558 ***