Problem description: 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: https://twitter.com/jneves/status/166820816263184385 https://twitter.com/h_ingo/status/166889128871460864 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?
http://help.libreoffice.org/Calc/Applying_Multiple_Operations
(In reply to comment #3) > http://help.libreoffice.org/Calc/Applying_Multiple_Operations 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?!