[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-comment] Filling numbers & dates
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 > spreadsheet cells. > 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]