Ask Your Question
1

After updating to libre office 4.2.1.1 calc stopped performing correctly [closed]

asked 2014-03-13 13:46:33 +0200

martin gravatar image

updated 2015-08-25 11:12:54 +0200

Alex Kemp gravatar image

In a simple table that was working just fine before the update, calc stopped updating cell content (a formula) after a row is deleted!?? If you just delete the data in a cell, the formula updates the result but if you delete the whole row (there are no references to this row in the formula. it's just a row in a sum formula) then, the fornula does NOT update but just gives the old result with the row that was present. I can e-mail you the table

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:37:53.563910

3 Answers

Sort by » oldest newest most voted
1

answered 2014-03-13 22:33:24 +0200

m.a.riosv gravatar image

Please verify if hard recalc [Ctrl+Shift+F9] solves the issue.

edit flag offensive delete link more
0

answered 2014-03-15 15:14:10 +0200

Rugslug gravatar image

updated 2014-03-15 17:01:29 +0200

Does it update when you save, close and re-open the file? Currently, when I paste in data, the other calculation cells are not updated correctly. When I save and re-open the calculations are displayed correctly. Ctrl+Shift+F9 (recalculate) doesn't solve the issue for me. I thought there was a bug with 4.2.0 and was to be fixed with 4.2.2. but not sure.

Update: if I paste from a tab copied webpage, it pasted and calculated ok. But when the numbers were pasted as a csv, then used TextToColumns, the numbers are not recalculated properly. They were left with #VALUE (since you can't have 3,4,2 in a number cell -- I use a dot as decimal separator). After TextToColumns, the calculating cells kept #VALUE instead of displaying numbers. Save, Close and Re-open and the correct numbers are displayed. And now, as I test this LO is crashing after I click okay for the data import/txttocolumns process.

Update: F9 recalculate didn't do anything, but ctrl+shift+F9 had it properly recalculate. As for the crashing, fixed that by pasting my data into the correct cells. The TextToColumns was causing the third piece of data to go into a formula cell, and maybe LO didn't like that. It shouldn't have crashed though.

I think I should have stayed in bed today!! I don't think I helped anyone but myself.

edit flag offensive delete link more

Comments

A similar thing happened to me after an update last year, except it continues to do calculations okay. In my case, it suddenly failed to create the graph correctly, but only after a specific date. I may have failed to make the chart work correctly in the formula past that date, but I really don't think so. I've looked at my data, and doesn't appear so. It really seems telling that my chart began to fail immediately after an update.

gr33nmind gravatar imagegr33nmind ( 2014-06-16 20:10:31 +0200 )edit
0

answered 2014-03-20 10:08:40 +0200

martin gravatar image

Thank you very much for your help. Ctrl+shift+F9 recalculated the cells correctly but this should have been done automatically, like in the previous versions of Calc!??

edit flag offensive delete link more

Comments

There were some bugs in dependency calculation in 4.2.0 and 4.2.1 that were fixed for 4.2.2

And please don't submit such comments as answer, use the comment function instead.

erAck gravatar imageerAck ( 2014-03-20 10:48:09 +0200 )edit

Hello, I just ran into this problem on 4.2.3.3 I have a column with some IF calculations. When I autofill from the top cell downwards, I expect the calculation to be done. What it actually does is copy the result from the top cell. Saving, reopening and retrying the autofill does not recalculate as it should. F9 recalculates correctly, but I shouldn't need to do that.

edit: 'Stable' 4.1.6.2 doesn't automatically recalculate either. edit: if it makes you feel better, OO 4.1 doesn't work either.

Toby gravatar imageToby ( 2014-05-15 14:46:41 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-03-13 13:46:33 +0200

Seen: 1,435 times

Last updated: Mar 20 '14