To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=86743
Issue #|86743
Summary|CELL("filename") doesnt update on sheet rename
Component|Spreadsheet
Version|OOo 2.3.1
Platform|PC
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|xrxca
------- Additional comments from [EMAIL PROTECTED] Wed Mar 5 17:14:40 +0000
2008 -------
If a cell is using the CELL("filename") function and the sheet is renamed, the
cell does not update to display the new name. Pressing F9 (recalculate) does
not update the cell, the only two ways I've found to update the cell is to
save/close/reopen the spreadsheet, or edit the cells formula (no change is
required, pressing F2, Left Arrow, Enter updates the Cell (F2, Enter doesn't))
To duplicate, start a new spreadsheet, set any cell to =CELL("filename") then
rename the current sheet (right click on tab and select "Rename Sheet...", or
use "Format|Sheet|Rename..." menu)
I've also tested this under Windows and get the same results.
---------------------------------------------------------------------
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]
