James E Lang schrieb:
I have not seen the latest LO versions but the last version I tested
this on failed my test.
The problem is that cells that contain or are dependent on cells that
contain the function call CELL("filename") do not get recalculated
automatically based on performance of "Save as …" even though that
action changes what that function is supposed to return.
There exist more functions, that do not recalculate automatically, for
example RANDBETWEEN. That is not an error.
Has this been corrected in or before the newest version? Is there
even a confirmed bug report regarding this behavior? It makes the
function call rather meaningless.
A simple "Calculate Hard" will do. Press Ctrl+Shift+F9.
It is not a bug. But you might want to write an enhancment request, to
make the function CELL recalculate immediately.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy