How to record daily values of a cell [closed]

asked 2014-03-14 13:09:12 +0100

marexposed gravatar image

updated 2015-09-10 23:33:59 +0100

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 after a number of months, it will clear all stored values setting them to 0.

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.

Here is a link to a sample document.

Thanks a lot.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-20 07:38:18.713460