Bug Hunting Session
Bug 45765 - : Feature request: Function to generate input values for calculation based on spreadsheets
Summary: : Feature request: Function to generate input values for calculation based on...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Master old -3.6
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2012-02-08 04:24 UTC by Georg Greve
Modified: 2017-07-23 22:43 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Georg Greve 2012-02-08 04:24:38 UTC
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.
Comment 1 sasha.libreoffice 2012-05-15 07:32:29 UTC
Thanks for new idea
But why Data->Multiple operations not enough? It's functionality very resembles described in this bugreport.
Comment 2 Hashem Masoud 2012-09-27 08:23:21 UTC
(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?
Comment 4 Hashem Masoud 2012-09-28 08:45:09 UTC
(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?!