To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100639 Issue #|100639 Summary|Calc: formulas referring to table name are not updated Component|Spreadsheet Version|1.0.0 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|quantentunnel
------- Additional comments from [email protected] Sun Mar 29 09:15:20 +0000 2009 ------- Formulas referring to table name are not updated (neither automatically nor manually) when the table is renamed. To reproduce error: create a new calc file, rename the first table to 'Tab', save the file as test.ods. Enter in cell A1 a formula referring to the table name (in my German version: '=ZELLE("filename")'). This cell now displays something like 'file:///C:/Dokumente und Einstellungen/.../test.ods'#$Tab. Rename the table to 'renamedTab' (i.e., right click on table name then choose rename). Now the bug is apparent: cell A1 still shows .../test.ods'#$Tab' instead of .../test.ods'#$renamedTab. Function key F9 does not help, nor the corresponding menu command (in German: Extras|Zellinhalte|Neu berechnen). Workaround 1: save file, close file, reopen file. Workaround 2: pseudo-modify ("touch") the formula, e.g., replace the closing bracket by a closing bracket; then press Enter. --------------------------------------------------------------------- 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]
