Apache OpenOffice (AOO) Bugzilla – Issue 68188
Lack of Save as... impact on CELL("filename")
Last modified: 2017-01-13 17:04:56 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: 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
Hi, 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. Frank
*** Issue 127283 has been marked as a duplicate of this issue. ***