To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=68188
Issue #|68188
Summary|Lack of Save as... impact on CELL("filename")
Component|Spreadsheet
Version|OOo 2.0.3
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|jelang
------- Additional comments from [EMAIL PROTECTED] Sat Aug 5 15:19:40 -0700
2006 -------
Saving a spreadsheet to a new file (Save as... on the File menu) does not force
a formula that contains CELL("filename") to be evaluated freshly. To the best
of
my knowledge, there are three ways to get evaluated but all three involve a
manual process:
1) CTRL+SHIFT+F9
2) ALT+F L
3) Code the formula with something variable concatenated with the function call
{(e.g. T(A1)&CELL("filename")} and change that variable item after the Save as.
..
I believe this is caused by the fact that there is nothing variable in the
format of the CELL("filename") function call i.e. "filename" is a constant
string. Thus there is nothing to force a fresh evaluation of the formula.
It appears to me that what is needed is a flag associated with the formulae
that
identifies that a formula contains this particular construct exists and when
Save as... is invoked formulae should be checked for this flag.
Here is how you can perform a test of this problem:
1) Create a new spreadsheet.
2) In cell A1 enter =CELL("filename")
3) Select Save as... from the file menu and give the file a name.
4) Look at A1 and you will see that its value is unchanged.
5) Either perform CTRL+SHIFT+F9 or select Reload from the file menu to see that
this value should indeed have changed.
For a designer of a spreadsheet application to have to tell the "great
unwashed"
user community that they need to perform one of these extra steps is not
satisfactory.
--
Jim
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
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]
