Quantcast

(Win7/LibO-Calc) Bug in tool Multiple operations?

classic Classic list List threaded Threaded
4 messages Options
Pertti Rönnberg Pertti Rönnberg
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

(Win7/LibO-Calc) Bug in tool Multiple operations?

Hello, LibO folks,

In LibO-Calc there is a very interesting and useful tool "Data/Multiple
operations"  -- at least as useful as "Pivot Table".

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.

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.

I cannot think that that negative change has been done deliberately in
LibO-Calc -- normally every cell in a spreadsheet can refer to and can
be referred to from remote cells no matter if these cells have a formula
or not.

Is it a bug or what is the explanation? Can I correct this in any way?
    My PC is a Win7Prof/32bit.

Thanks in advance

regards

Pertti Rönnberg



--
For unsubscribe instructions e-mail to: [hidden email]
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

Cor Nouws Cor Nouws
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: (Win7/LibO-Calc) Bug in tool Multiple operations?

Hi Pertti,

Pertti Rönnberg wrote (12-04-12 15:01)

> In LibO-Calc there is a very interesting and useful tool "Data/Multiple
> operations" -- at least as useful as "Pivot Table".
>
> 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.
> [...]
> Is it a bug or what is the explanation? Can I correct this in any way?
> My PC is a Win7Prof/32bit.

Thanks for writing. I never used the function, but from what I read from
your description, I would say that it is a bug.

Could you pls write a bugreport (& if possible first check if there
already is one)?
Info is here: http://wiki.documentfoundation.org/BugReport

Best regards,

--
  - Cor
  - http://nl.libreoffice.org


--
For unsubscribe instructions e-mail to: [hidden email]
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

Regina Henschel Regina Henschel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: (Win7/LibO-Calc) Bug in tool Multiple operations?

In reply to this post by Pertti Rönnberg
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: [hidden email]
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

Pertti Rönnberg Pertti Rönnberg
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: (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: [hidden email]
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

Loading...