Calc bug query

users
#1

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.

#2

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
Regina