Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.