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

# office-comment message

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

Subject: Re: [office-comment] Filling numbers & dates

• To: office-comment@lists.oasis-open.org
• Date: Fri, 31 Oct 2008 20:15:10 +0200

```Hello Eike,

Eike Rathke wrote:
> Hi Leonard,
>
> On Friday, 2008-10-31 01:15:08 +0200, Leonard Mada wrote:
>
>> This is a proposal to enhance ODF with a FILL() function. I planed to
>> post it long ago, but never got the time for it.
>> [...]
>> Spreadsheets notably lack such a construct.
>>
>
> For a very good reason: a function should never modify the content of
>

How is this different from *EVERY* other function in a spreadsheet?

I did sought of many possible responses, but this one baffled me
completely. Well, a function *WELL CHANGES* the content of the cell.
Doesn't SUM() do the same? Or an IF(), or MMULT() or anything else?

So, how would the FILL() be different?
It would change exactly the contents of the cells as all the functions
mentioned above.

Lets say the user writes in A1:
{ =REPEAT(1, 20) }

This would then populate A1:A20 with values of 1. A perfectly valid
array formula.

I tested this in Calc:
{ =MMULT(A1:B20;D1:E2) }

And guess what? It did change cells D6:E25 (I entered the formula in
D6). I could almost swear that any other formula does change the content
of the cell.

Well, there may be a rationale behind such functions when more prominent
languages (like S+, Mathematica and many other) have such functions and
operators.

Sincerely,

Leonard

>   Eike
>

```

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