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