[Libreoffice-bugs] [Bug 65891] NOW() function

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=65891

Cor Nouws  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #6 from Cor Nouws  ---
@ all: thanks for reporting, testing, explaining.
Marking as WORKSFORME since it can not be reproduced.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 65891] NOW() function

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=65891

--- Comment #5 from Markus Mohrhard  ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 65891] NOW() function

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=65891

--- Comment #4 from arc...@pancontrols.com ---
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:arc...@pancontrols.com
-

On 23/06/2013 19:02, bugzilla-dae...@freedesktop.org wrote:
>
> *Comment # 3  
> on bug 65891  from 
> Markus Mohrhard  *
> 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 
> Version: 2013.0.3345 / Virus Database: 3199/6434 - Release Date: 06/23/13
>

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 65891] NOW() function

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=65891

--- Comment #3 from Markus Mohrhard  ---
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 are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 65891] NOW() function

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=65891

mariosv  changed:

   What|Removed |Added

 CC||mari...@miguelangel.mobi

--- Comment #2 from mariosv  ---
Hi Cor, same behaviour here, F9 update the value, with:
Win7x64 Ultimate
LibreOffice Version 4.0.4.2 (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 65891] NOW() function

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=65891

Cor Nouws  changed:

   What|Removed |Added

 CC||c...@nouenoff.nl

--- Comment #1 from Cor Nouws  ---
At least in 4.0.4rc2 (Linux), F9 updates the field ...

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs