Ask Your Question
1

Problems in Calc from PPA

asked 2020-11-08 05:17:47 +0100

Smurf gravatar image

updated 2020-11-08 05:18:59 +0100

Hi I'm using libreoffice from PPA 7.0.2.2 I found some problems as shown in this short video.

1) cells with formulas are not automatically calculated even if "Automatic calculation" is set

2) inserting a row before a SUM doesn't reset the SUM range.

Is this a bug or I make something wrong?

C:\fakepath\test_calc.ods

edit retag flag offensive close merge delete

Comments

1

2) inserting a row before a SUM doesn't reset the SUM range.

That never works/worked. Range in a SUM() formula gets adapted on inserting a row within the range of SUM() but never if adding a row at the end of (after) the range used in SUM()

Opaque gravatar imageOpaque ( 2020-11-08 10:31:02 +0100 )edit

Hi Opaque, Do you think this is correct? I mean that this behaviour is quite dangerous.

Smurf gravatar imageSmurf ( 2020-11-08 14:47:38 +0100 )edit
1

I think this is quite correct - yes. Why should SUM()'s range be adapted if you add a row outside of the range? This would be, what I'd call dangerous and unpredictable behavior. How would you programmatically determine something like "What could have been the idea of the creator of the formula?". What about a row inserted before the actual range? Should it also result in adaption of the range? But that's my personal opinion and I'm not a developer (but I'd assume that tracking status information of "what are adjacent cells of ranges referenced by formulas" would add unmanageable complexity).

Opaque gravatar imageOpaque ( 2020-11-08 16:20:37 +0100 )edit

Well , if I insert a row before the SUM range I will have to manage if it's or not part of the SUM (I'm not convinced 100%, but I can accept this), but if I insert a row between SUM total row and SUM cells I think that this new row must be considered part of the SUM. Obviously this is my opinion and probably is not shared from everyone, but in accounting practices a "Total" figure must include all the above figures: this is a "law".

Smurf gravatar imageSmurf ( 2020-11-09 04:21:57 +0100 )edit

I never disagreed that a "Total" figure needs to include all numbers, but it is your responsibility to assure that it is calculated as required. And there are two general approaches to this:

  1. Calculate above numbers (e.g. use: =SUM(A2:A1048576) in cell A1) and you never again will miss a number which needs to be taken into account
  2. Leave always one empty row between row containing Total but include the cell of the empty row within range of SUM(). This way you always insert within range, if you add a row after the last filled one.
Opaque gravatar imageOpaque ( 2020-11-09 12:54:44 +0100 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2020-11-08 06:20:58 +0100

PKG gravatar image

See here

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-11-08 05:17:47 +0100

Seen: 56 times

Last updated: Nov 08 '20