Enforce calculation of all cells: Ctrl+Shift+F9
Same with changed locale settings: =VALUE("3,14") vs VALUE("3.14")
Unlike RAND() =RANDBETWEEN(from;to) is triggered by hard recalc, which
is useful for testing calculation models with dummy-data.
James E. Lang wrote:
[...]
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 don't have easy access to Excel neither, but it knows hard
recalculation through Ctrl+Shift+F9(and there is come button in the
options dialog).
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."
Some named references (Ctrl+F3) from my default template:
cFilename =CELL("FILENAME")
FilePath =RIGHT(FileURLPath;LEN(FileURLPath)-7)
FileURL =MID(cFilename;2;SEARCH("'#";cFilename)-2)
FileURLPath =MID(cFilename;2;SEARCH("/[^/]+'#";cFilename)-1)
shSep =MID(ADDRESS(1;1;1;"Foo");4;1)
ThisSheet =MID(cFilename;FIND("#$";cFilename)+2;256)
As you can see they are based on the same function CELL("filename").
shSep returns "!" with Excel and "." with Calc.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
