Ask Your Question
0

Stop cell from recalculating itself [closed]

asked 2014-03-12 12:37:19 +0200

marexposed gravatar image

updated 2015-09-11 01:56:15 +0200

Alex Kemp gravatar image

Hello, I'm using Libreoffice 3.5.7.2, English, Calc on Ubuntu 12.04, also English language I want to daily record the value of certain cell, so I created a particular sheet with a list of consecutive dates (column A) and the following formula in column B (copied from row 1 onwards)

=IF($A1=TODAY();$AnotherSheet.$H$21;B1)

This works perfectly recording distinct values of $AnotherSheet.$H$21 every day as long as I have set tools/options/Libreoffice Calc/Calculate/iterations to true. But for some reason it clears all the values from time to time, perhaps months before it happens, clearing all the values it's been storing for months. I don't know if this is a bug or I'm doing something wrong, can anyone help, please, with this issue or suggesting a better way of storing daily values of cells? I'm experiencing this problem every few months since the times of OpenOffice, I've been using this sheet and calculations (and then missing the data stored) for years, only now I decided to ask for help.

Thanks a lot.

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 07:29:41.586422

1 Answer

Sort by » oldest newest most voted
0

answered 2014-03-12 13:42:24 +0200

erAck gravatar image

TODAY() is a volatile function and gets recalculated with every change of the document, so does any expression depending on that result. I don't know why with iterations enabled things seemed to work for you most times, but it sounds odd if they did and you're using a side effect that doesn't always do what you expect and without knowing the document all one could say would be speculation.

edit flag offensive delete link more

Comments

Thanks for your answer, but TODAY() works fine changing the corresponding cell B as long as TODAY() equals the value on the column A (which is a date). When the system date changes, that cell B is not changing anymore. This is a link to the document as you requested: link text

marexposed gravatar imagemarexposed ( 2014-03-12 14:20:04 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-03-12 12:37:19 +0200

Seen: 280 times

Last updated: Mar 12 '14