Spreadsheets are great, but quite often one wants to see how the results of a calculation from the spreadsheet turns out for certain value ranges, e.g. "from 1 to 1000".
While the "1 to 1000" seems to be generally worked around in cludgy "copy & increment" ways, as demonstrated here:
This does not really work for situations where the value can run to larger numbers, or where stepping should be adjusted without redoing everything.
In short, I want a "COUNT(FROM, TO, STEPSIZE)" function that can also act as the X-axis on diagrams and drawings and serve as the input for a spreadsheet based calculation on the Y (and perhaps also Z) axis.
Thanks for new idea
But why Data->Multiple operations not enough? It's functionality very resembles described in this bugreport.
(In reply to comment #1)
> Thanks for new idea
> But why Data->Multiple operations not enough? It's functionality very
> resembles described in this bugreport.
Can you please detail the steps on how to do this?
(In reply to comment #3)
In my opinion, this solution doesn't work. Because you still have to drag all the way down to the last required cell. This defeats the purpose. The reporter is asking for a function.
I'm not sure if this can be done through scripting or macros?!