Ask Your Question
0

strange - wrong? - results in LO calc, autocalculate broken?

asked 2019-02-24 20:33:28 +0200

newbie-02 gravatar image

hello all,

i see a massive problem - massive problems - in LO calc,

this posting is very long, sorry, i'd spend the time to pinpoint to the fault (what i consider being a fault) because i think it's very critical, and i see that former question have been stopped with silly 'solutions' or workarounds,

many many thanks in advance to everybody who tries to understand the problem, does further research or gives any other help. i consider 'press ctrl-shift-F9' helpful in diagnosis, but not an option for daily work.

shortcut: >>> the shown value of dependent (referencing, calculating) cells is - in some rare cases - NOT! updated as needed / expected when referenced cells (cells that provide 'source' for the calculation) are changed <<<

the problem wasted a lot of my time, gave me headaches for more than 6 weeks now, and has the potential to render the work of years worthless.

i'm at the limit what i can do for / against it, so i kindly ask for help ...

example, concrete 'knock':

SUM(0 + -747,27) = -747,27

is correct, still showing

SUM(0 + 0) = -747,27

after deleting the second summand is not! correct, at least not when 'autocalculate' is on!

reg. its content i can't provide the original sheet, i've attached three screenshots 01_before.pdf, showing the screen with C319 in place, 02_deleted.pdf, showing the same sheet with C319 deleted, and 03_formula.pdf showing the formula in D319.

01_before

02_deleted

03_formula

this posting is not! intended to knock LO calc down, it's intended to catch this problem and get rid of it,

my talent is limited to be able to see a fault when i meet it, and to narrow down the circumstances,

programming is not my thing, at least not in 'c', and the time i can throw in is limited,

there is some hope, i found an old version of LO where some of these errors are gone,

the wrong behaviour shows up in plenty versions - e.g. 6 (.0.7) (x64), 5 (.4.7) (x64), 4 (.4.7.2) (x86) - most of it is 'gone' in 4.0.4.2 (x86) and 4.1.6.2 (x86) - first symptoms occur in 4.2.0.1, and it's still available in the actually newest version 6.2.0.3 (x64)

all tested under win 7 pro x64 SP1 on a Lenovo P70 Xeon E3-1505M v5 with ECC memory,

hurray!!!, the fact that there are! old versions with different - correct? - behaviour confirms to me that

  • there is! a fault, either the old or the new version must be wrong, i suspect the new one,

  • there is hope to find the source of it by comparing the versions,

  • me and my hardware can be considered to be ok,

  • there is a chance to find people to help because i can prove the fault,

let's start:

the 'error' is old, it may be more than one error (one can also have loeces and fleas), the unstable ... (plus)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2019-03-02 19:31:15 +0200

newbie-02 gravatar image

money against bugs,

i'm someway frustrated what some bugs do against the reliability of a software, i'd like to get them killed out as fast as possible,

i see at least two bugs affecting autocalculate and 'shared formulas', maybe it's only one but double faced,

i've described there:

https://ask.libreoffice.org/en/questi...

to be willing to pay 100 EUR to whoever unveils the problem(s) and brings up a solution,

the bugs are:

https://bugs.documentfoundation.org/s...

and

https://bugs.documentfoundation.org/s...

feel free to help ...

edit flag offensive delete link more
0

answered 2019-02-25 15:19:48 +0200

erAck gravatar image

This

how to handle references when the referenced source is moved (when single cells are addressed the formula in the referencing cell is changed on moves of the referenced cell, when ranges are referenced moving cells within them produces funny results)

makes me believe it is tdf#121002 that was recently fixed for upcoming 6.2.1 and 6.1.6

edit flag offensive delete link more

Comments

sorry, command back, something is fixed with the patch in dev 6.2.2.0.0, but other still broken, i think my impression 'all fixed' based on 4.1.6.2 still on my system, after cleanup and clean install of dev 6.2.2.0.0 the 'wrong sum after deletion' occurred again, also the test provided in https://ask.libreoffice.org/en/questi... failed, i created a minimum test sheet and will provide it in another thread

below is my old comment, only partially correct,

@erAck: many many thanks,

i think that made it,

tested with libo-62-64~2019-02-24_01.44.59_LibreOfficeDev_6.2.2.0.0_Win_x64 all 'errors' seem gone,

newbie-02 gravatar imagenewbie-02 ( 2019-02-25 18:33:01 +0200 )edit

OP has filed tdf#123714

Mike Kaganski gravatar imageMike Kaganski ( 2019-02-26 08:29:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-02-24 20:33:28 +0200

Seen: 80 times

Last updated: Mar 02