This reminds me of a bug in Excel: entering a number as text it keeps
displaying it as a concatenated number (um, some scientific notation that
shortens it's length, I'm 46, I forgot my math, ok! ;-) ) until the field is
"touched" by clicking on the edit bar and hitting return! Format as text
fails!
It's one of the million reasons I'm "dumping" MS Office for OO.
In Excel: CELL(yada, yada) is something really different. I don't know the
object open in cell command as yet (something like "=FILE(??)" ?)
Randy Garrett
El Sobrante, CA USA (North of Berkeley / East of San Francisco)
-----<---{(@
-----Original Message-----
From: James E. Lang [mailto:[EMAIL PROTECTED]
Sent: Friday, August 04, 2006 6:54 PM
To: [email protected]
Subject: [users] Behavior of CELL("filename") in a calc document
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
