Issue 68188 - Lack of Save as... impact on CELL("filename")
Summary: Lack of Save as... impact on CELL("filename")
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 127283 (view as issue list)
Depends on:
Reported: 2006-08-05 23:19 UTC by jelang
Modified: 2017-01-13 17:04 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description jelang 2006-08-05 23:19:40 UTC
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:

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 

Comment 1 frank 2006-09-13 12:43:49 UTC

not a defect, as we work as the whole Excel community expect. But maybe an
enhancement request. Changed the Issue type and re-assign to requirements.

Comment 2 oooforum (fr) 2017-01-13 17:04:56 UTC
*** Issue 127283 has been marked as a duplicate of this issue. ***