https://bugs.documentfoundation.org/show_bug.cgi?id=154852
--- Comment #7 from ady <[email protected]> --- (In reply to Eike Rathke from comment #3) > For this to work, the formula cell containing CELL() would have to listen at > a sheet rename event. Which currently isn't broadcasted as a data change at > all, and also shouldn't in general except for CELL() and probably INDIRECT(). * FWIW (OT), INFO() doesn't even react to recalculation (e.g. INFO("recalc") when going from Automatic to Manual is not updated by recalc hard). * FWIW, Google Sheets works in the same way as LO (i.e. CELL() doesn't listen at sheet rename event). (In reply to kenjfzhong from comment #5) > formula := =CELL("address",S3.$B$2) > result := "$S2.$B$2" Simple workaround: 1. In $Sheet2.$A$1, use the (volatile) function =NOW() 2. Wherever you want, use =CELL("address",$Sheet2.$A$1) 3. Rename the worksheet Sheet2 to whatever else you want. Result: since you have autocalculate ON, when you rename the worksheet the volatile function NOW() gets updated, and so the dependent CELL() function will get updated too. -- You are receiving this mail because: You are the assignee for the bug.
