https://bugs.documentfoundation.org/show_bug.cgi?id=132136
--- Comment #7 from Wolfgang Jäger <j...@psilosoph.de> ---
(In reply to Eike Rathke from comment #6)
> Adding a new SHEETNAME() function would be possible, but that would have to
> listen to sheet rename events to be recalculated when a sheet name changes,
> where currently such recalc dependency isn't implemented at all, so it's not
> just "let's add a new spreadsheet function". The sheet rename event
> listening would be needed also for CELL("filename") though, see bug 85986.
I actually thought I had valid reasons to assume SHEET_RENAME LISTENING to be
implemented.
Create a Calc doumcnetr with 2 sheets (Sheet1, Sheet2). Enter =Sheet2.A1. into
cell Sheet1.B1. Now rename Sheet2 to Sheet2Renamed. Look at Sheet1.B1 again.
>From my experience: Concerning renaming sheets, moving referenced sheets/ranges
by dragging with the mouse, moving referencing cells ... everything seems to be
the same for sheets, rows, column with the exception that there is no indexing
reference to sheets. Formulas referencing renamed sheets are updated
automatically.
Now I am pushed to believe that the DISPLAYED formulas per cell/array are
generated from the tokens. But then it should also be efficient enough to make
the new SHEETNAME() function volatile. What do I understand wrong?
--
You are receiving this mail because:
You are the assignee for the bug.
