The NOW()function updates the value when the file is opened - not when the document recalculates as is documented. You can tell this be switching off the "autocalculate". Earlier versions of LibreOffice worked as documented (V3.x, and I think the earlier V4.x).
At least in 4.0.4rc2 (Linux), F9 updates the field ...
Hi Cor, same behaviour here, F9 update the value, with: Win7x64 Ultimate LibreOffice Version 4.0.4.2 (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2)
NOW should both be calculated when the file is opened and every time it is recalculated. There are a set of functions that are marked as RECALC_ONLOAD and NOW is one of them. I doubt that it was not calculated during import in the 3.X series as we had to calculated the whole document at least once to show values while in 4.X it is explicit because we now use cached values and we don't want the cached value for RECALC_ONLOAD functions.
Thank you for this Markus. Until relatively recent releases (within the last 6 weeks), calc did not recalculate if the file was loaded in ods format. If the same file was converted to xls it was recalculated when the file was loaded. The documentation says the following: Returns the computer system date and time. The value is updated when your document recalculates. NOW is a function without arguments. It would be useful to revert to its previous functionality, or was there a definite decision to change it? Yours Archie Archie J. Shaw Stewart Tel: 01786-850227 Mobile: 07769-837188 skype: drummore_archie email:archie@pancontrols.com ------------------------------------- On 23/06/2013 19:02, bugzilla-daemon@freedesktop.org wrote: > > *Comment # 3 <https://bugs.freedesktop.org/show_bug.cgi?id=65891#c3> > on bug 65891 <https://bugs.freedesktop.org/show_bug.cgi?id=65891> from > Markus Mohrhard <mailto:markus.mohrhard@googlemail.com> * > NOW should both be calculated when the file is opened and every time it is > recalculated. There are a set of functions that are marked as RECALC_ONLOAD and > NOW is one of them. > > I doubt that it was not calculated during import in the 3.X series as we had to > calculated the whole document at least once to show values while in 4.X it is > explicit because we now use cached values and we don't want the cached value > for RECALC_ONLOAD functions. > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. > > No virus found in this message. > Checked by AVG - www.avg.com <http://www.avg.com> > Version: 2013.0.3345 / Virus Database: 3199/6434 - Release Date: 06/23/13 >
(In reply to comment #4) > Thank you for this Markus. > > Until relatively recent releases (within the last 6 weeks), calc did not > recalculate if the file was loaded in ods format. If the same file was > converted to xls it was recalculated when the file was loaded. > > The documentation says the following: > > Returns the computer system date and time. The value is updated when > your document recalculates. NOW is a function without arguments. Your document is recalculated when you open the file. Either explicitly when you have the setting "Always Recalc" or implicitly the RECALC_ONLOAD functions like macro functions, NOW(), ... after the import. > > > It would be useful to revert to its previous functionality, or was there > a definite decision to change it? > The decision is final.
@ all: thanks for reporting, testing, explaining. Marking as WORKSFORME since it can not be reproduced.