Search code examples
excelfunctionlibreoffice-calc

Use cell-based calculation to create table

There's a feature in Excel which I can't find or figure out in LibreCalc.

Suppose that I have a calculation over a series of cells such that cell A1 is an input and cell A2 is the output, with a whole series of intermediate cell-based calculations being used to arrive at the value in A2. Thus, A1 --> A2 is conceptually a function, call it f().

I want to create a table by creating a column of input numbers, a1,...,an, then having Calc apply my function to them so that the values f(ai) appear to the right of the column of input numbers.

Solution

  • It turns out that this is the Data->Multiple Operations menu choice. Once you know which menu item, it's a matter of following your nose.