Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

On 29-11-2014 16:28, Carlo Strata wrote:
> Hi Everyone,
>
> I recently deal with a supplier catalog/price list spreadsheet xlsx file.
>
> That file use the "LOOKUP()" function (in Italy "RICERCA()") in many
> places. In one of those occurrences, the first LOOKUP() parameter
> (Search Criterion) was missed, but on Microsoft Excel this was ok (no
> errors in the cell), in LibreOffice was ko (Err:511, missing
> variable/parameter)! I think this difference was yielded by different
> assumed values of the missing parameter and/or different validation rules.
>
> So compliance depends not only on file format, but also on function
> behaviour/validation on different program.
>
> This is a Vendor Lockin trouble?
> http://en.wikipedia.org/wiki/Vendor_lock-in
>
> What do you think about? Is this a known issue?
>
> The work environment is:
> - Microsoft Windows 8.1, 64 bit, Ita gui, daily full updated;
> - LibreOffice 4.3.5.1, win32, Ita gui and local help;
> - Microsoft Office 2013 Professional Plus trial version (I had installed
> and then uninstalled in my notebook some weeks ago).
>
> Have All a nice weekend,
>
> Carlo


I do not see a difference, besides a language difference (i have Dutch 
version of Excel, en LO in English)
(in Excel is see '#N/B', when LOOKUP did not found, in LO is see '#N/A')

I uploaded my testfile here:
http://wikisend.com/download/402228/zoeken.xlsx

(LOOKUP, in Dutch "ZOEKEN")




--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted