Issue 89546 - =MAX(0,+range) should import as =MAX(0;0+range)
=MAX(0,+range) should import as =MAX(0;0+range)
 Status: CONFIRMED None Calc Application programming (show other issues) OOo 3.0 Beta All All P3 Trivial (vote) --- AOO issues mailing list

 Reported: 2008-05-16 08:58 UTC by jpginn 2017-05-20 11:11 UTC (History) 1 user (show) issues DEFECT --- ---

Attachments

 Note You need to log in before you can comment on or make changes to this issue.
 jpginn 2008-05-16 08:59:35 UTC ```In both Excel and Calc, some functions accept both numbers and ranges, e.g. MAX, MIN, AVERAGE, SUM, COUNT, etc. 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. Jason``` jpginn 2008-05-20 09:05:39 UTC `I can confirm that this behaviour is the same in Calc 3.0 Beta.` ooo 2008-05-29 18:40:10 UTC ```Quite unusual, but ... somehow consistent with MAX(1;-RangeName) Grabbing issue.``` Marcus 2017-05-20 11:11:45 UTC `Reset assigne to the default "issues@openoffice.apache.org".`