Re: [libreoffice-users] (Win7/LibO-Calc) Bug in tool Multiple operations? Issue SOLVED!

Regina,
Thank you for your kind interest and for your help: your questions 
forced me to study my "problem" once again.
Obviously I am getting old -- I had done some bad thinking and caused 
circular references.

To other readers I want to recommend that tool "Multiple operations" in 
LibO-Calc/Data.

I have a feeling that people does not know about it, as you said, it is 
sort of hidden and forgotten. This is a shame because it really is very 
handy for simulating or studying changes by using 1-2 variables.
E.g. estimating how the monthly payments of a loan changes with rate and 
loan length (time) as variables.
It is easy and rather straight forward to use after a little training.
Best regards
Pertti Rönnberg


To others

On 16.4.2012 23:35, Regina Henschel wrote:
> Hi Pertti,
>
> Pertti Rönnberg schrieb:
> > Hello, LibO folks,
> >
> > In LibO-Calc there is a very interesting and useful tool "Data/Multiple
> > operations" -- at least as useful as "Pivot Table".
>
> Yes, it is hidden and cannot be written with the function wizard. But 
> it is possible to write the function manually, you do not need Data > 
> Multiple.Operations.
>
> > When I recently updated an old calculation process created some 3-4
> > years ago in OpenO and recreated it in LibO-3.4.5, I noticed that one of
> > the tool's flexible features had vanished.
> >
> > In the 'new' Calc the first cells of both "row input cell" E5 (of E5,
> > F5, G5,..etc.) and "column input cell" D6 (of D6, D7, D8, ..etc.)
> > require a manually inserted absolute value -- the next values
> > (increasing or decreasing by a difference) can be formulas calculating
> > from the value before.
>
> Please provide a small reduced spreadsheet document. It should contain 
> nothing more than those things needed to trigger the error.
>
> Please post the content of a cell with the generated 
> Multiple.Operations formula and please post the content of the formula 
> cell, which will be the first parameter in the Multiple.Operations.
>
> > In the "old" calculation these first cells (E5 and D6) could refer to
> > formulas ina remote cells which increases the flexibility and the
> > usability of the tool remarkably.
>
> What is a "remote cell". Do you try to use a cell from a different 
> spreadsheet document?
>
> I have not found a regression. But I have difficulties to understand 
> your explanation and therefore might miss something.
>
> Kind regards
> Regina


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted