Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Hi James,

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.

Kind regards

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.