Issue 16435 - Automatic row/column names in NLF functionality differs
Summary: Automatic row/column names in NLF functionality differs
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:
Depends on:
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: ---

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

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:
M$ take this without problem, in OO for correct functionality should id be:

Something similiar is with SUMIF when range of RANGE and SUM_RANGE are not the 
same - example:
working under M$, but not under OO:
working under OO - correctly written:

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)

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 :) 
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 roadmap
( 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 "".