OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-formula] IMSUM

Hi Patrick,

On Thursday, 2009-12-10 09:23:57 -0500, Patrick Durusau wrote:

> We say for IMSUM:
>> Sum (add) a set of complex numbers, including all numbers in ranges
> What does "...including all numbers in ranges." mean?

Same in the summary of SUM.

Should probably had been "sequences" instead of "ranges", as the
function works on a list of ComplexSequence (IFSUM) respectively
NumberSequence (SUM) arguments.

Or better omit ", including all numbers in ranges" completely, since the
conversion to ComplexSequence respectively NumberSequence is defined.

> Hmmm, while writing this post, it occurs to me that a range of numbers  
> could be expressed by two complex numbers.
> Would this function add all the complex numbers between those two  
> complex numbers? If so, are the ranges inclusive or exclusive of the  
> numbers at either end of the range?

No, this is not related to a range of numbers.


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]