Ask Your Question
0

Formulas copied are sometimes not recomputed - known issue? [closed]

asked 2013-10-28 04:40:08 +0100

hernan gravatar image

updated 2015-11-12 14:46:42 +0100

Alex Kemp gravatar image

This is difficult to reproduce, but I've experienced it many times with a Calc spreadsheet (4.1.2.3) with several sheets; most sheets were initially created via a copy-paste (formulas included) from a "mother" sheet. Now, when I change the sheet data, the formulas are (sometimes) not updated, even if I turn off "autorecalc" and I run a explicit "recalculate".

Here's a video I made: http://www.youtube.com/watch?v=xc9-nF8UBik

Notice how the calculated cell should display 0 (it shows that result if I copy the formula verbatim into another cell), but it sticks to the original value, even after I change the cell format, or reference the cell in another cell; it recalculates the correct value only when I make some trivial change to the formula (eg, append "+ 0")

This is extremely annoying, it basically means you cannot trust your data in the spreadsheet. Is this a known issue? Is there some workaround?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 14:46:56.381074

Comments

This is very, very strange! Try to reset the user profile

JohnSUN gravatar imageJohnSUN ( 2013-10-28 09:29:06 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2013-10-28 22:38:21 +0100

m.a.riosv gravatar image

Some functions needs a hard recalc Ctrl+Shift+F

Please take a look to this link: http://markmail.org/thread/vggjlicfxgpvi2xy

edit flag offensive delete link more

Comments

while autocalculate is on results shouldn't need manual recalc, if they do domething is odd, see comment there: comment to first answer about 'hard-recalc-crutch'

newbie-02 gravatar imagenewbie-02 ( 2020-07-25 12:08:20 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2013-10-28 04:40:08 +0100

Seen: 253 times

Last updated: Oct 28 '13