I believe that I understand what is happening here. I just don't like it.
I have the following formula is one of my document's cells:
=CELL("filename")
It displays what is expected until such time as I save the file as another file
name. After that operation, it still reports the original file name in spite of
the fact that that has changed. Performing a "Reload" from the File menu
updates the displayed file name. I have also found that I can concatenate a
reference to other cells to that function.
=CELL("filename")&T(SUM(AX1:AX37))
This permits me to force the update of the displayed file name by then do
something that causes evaluation of the content of any numeric cell in the
range AX1 through AX37 once again. Neither technique is automatic.
What I believe is happening is that since the function CELL("filename") has a
constant argument calc sees no need to evaluate a cell solely based on that
function call. This is in spite of the fact that "Save as..." changes the name
of the file and CELL("filename") fetches that name. I have not checked to see
whether renaming the sheet causes this function to be evaluated again. In other
words, I may be simply reporting the tip of the iceberg.
In any case, the *current* value of CELL("filename") is not evaluated without
specific manual intervention. Can't OOo calc be coded to recognize the
existence of a CELL("filename") function call within a formula as a special
case that requires that the formula be reevaluated whenever "Save as..." is
invoked?
BTW: Does anyone know how Excel handles something like this? I presume that
CELL("filename") is not unique to OOo but I don't have access to Excel.
I imagine that this is a very rarely utilized function call but it is one that
I have found would be very useful in my application. If there is a better way
to obtain the name of the file that contains the calc document I am "all ears."
--
Jim
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
