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.
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 _partial_ work around is to use the following construct:
IF(COUNT(range)>-1,CELL("filename"),"")
but even that fails until something changes within the referenced range (e.g.
enter zero and undo the entry).
All versions of the open office line (OOo, AOO, LO, and now AnOo {Android})
that I've seen share this flaw. I hope a universal fix for this will be created
by somebody and that it will be shared among the various projects.
--
Jim
"A man convinced against his will
is of the same opinion still."
— Unknown
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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
