Issue 89546 - =MAX(0,+range) should import as =MAX(0;0+range)
Summary: =MAX(0,+range) should import as =MAX(0;0+range)
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-05-16 08:58 UTC by jpginn
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description jpginn 2008-05-16 08:59:35 UTC
In both Excel and Calc, some functions accept both numbers and ranges, e.g. MAX,

Named ranges can be used in both Excel and Calc to provide parameters for these
functions, and you use a slightly different syntax depending on whether yuo want
to pass the range or a single number from the range.

In Excel:
  to pass a range, use:  =MAX(1,2,3,RangeName)
  to pass a number, use: =MAX(1,2,3,+RangeName)

In Calc:
  to pass a range, use:  =MAX(1;2;3;RangeName)   (i.e. the same)
  to pass a number, use: =MAX(1;2;3;0+RangeName) (i.e. an extra zero is required)

Importing the Excel formula =MAX(1,2,3,+RangeName), Calc receives
=MAX(1;2;3;+RangeName).  The + is ignored by Calc, and behaviour reverts to
passing the whole range.

I believe this is a serious error because (unless you get a resulting
circularity) it does not show up to the end user.  I only found this problem
because of the circularity it caused.

Comment 1 jpginn 2008-05-20 09:05:39 UTC
I can confirm that this behaviour is the same in Calc 3.0 Beta.
Comment 2 ooo 2008-05-29 18:40:10 UTC
Quite unusual, but ... somehow consistent with MAX(1;-RangeName)
Grabbing issue.
Comment 3 Marcus 2017-05-20 11:11:45 UTC
Reset assigne to the default "".