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+unsubscr...@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
