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

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

--
ing. Carlo Strata
-
via Botticelli 1/4
30031 Dolo - VE
Italia - Italy
-
tel. +39.041.822.0665
cell. +39.347.85.69.824
Skype carlo.strata
Google carlo.strata.69
-
carlo.strata@tiscali.it
PEC: carlo.strata@ingpec.eu


--
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