Issue 16435 - Automatic row/column names in NLF functionality differs
Summary: Automatic row/column names in NLF functionality differs
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows 2000
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-04 09:28 UTC by Unknown
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
File with sample of described errors - .xls packed with WinRAR (10.24 KB, application/octet-stream)
2003-07-04 09:32 UTC, Unknown 		no flags Details
So here it is - just .xls (31.50 KB, application/octet-stream)
2003-07-08 11:25 UTC, Unknown 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-07-04 09:28:16 UTC 
When using .xls made under M$, I have found, that this is not functional:
VLOOKUP('name_of_cell_with_serch_criterion';name_of_array;2)
M$ take this without problem, in OO for correct functionality should id be:
VLOOKUP(name_of_cell_with_serch_criterion;name_of_array;2)

Something similiar is with SUMIF when range of RANGE and SUM_RANGE are not the 
same - example:
working under M$, but not under OO:
SUMIF($O15:$O19;DPHA;$P15:$P18)
working under OO - correctly written:
SUMIF($O15:$O18;DPHA;$P15:$P18)

I`m not sure if this are bugs, or just something like autocorrection of wrong 
given parameters under M$. But it will be more comfortable if OO can repait this 
automaticly. From first error I get only #VALUE!, from secon error code 504. (I 
presume that M$ does not taking definition of functions and their parameters so 
strictly how it should be)

-=MaRcUs=-
Comment 1 Unknown 2003-07-04 09:32:46 UTC 
Created attachment 7398 [details]
File with sample of described errors - .xls packed with WinRAR
Comment 2 con.hennessy 2003-07-08 00:59:50 UTC 
Hi, do you mind adding the excel file as a normal excel file as not every one has the tools 
to extract rar files :) 
Thanks
Comment 3 Unknown 2003-07-08 11:25:06 UTC 
Created attachment 7476 [details]
So here it is - just .xls
Comment 4 oc 2003-07-09 14:24:56 UTC 
Hi Eike,
please have a look
Comment 5 ooo 2003-09-09 20:54:46 UTC 
The problem is the automatic column header 'mena' used in the formulas
of cells I16:I18, there are differences between Xcl and Calc in how
those so-called Natural Language Formula features work. Need to elaborate.

As for the difference between the imported 'mena' and a mena without
quotes: the one without quotes on recompilation of a formula is taken
as the defined named range (as it may be seen with Ctrl-F3) and then
works ok. A defined range always takes precedence over an automatic
column header.
Comment 6 ooo 2003-09-29 11:33:54 UTC 
Developer notes: later.
2.0 only if time permits.
Comment 7 oc 2003-10-02 11:52:31 UTC 
According to the OpenOffice.org roadmap
(http://tools.openoffice.org/releases) this issue was retargeted to
OOo Later.
Comment 8 ooo 2005-12-15 02:04:01 UTC 
Adapting summary.
Comment 9 Marcus 2017-05-20 11:13:51 UTC 
Reset assigne to the default "issues@openoffice.apache.org".