https://bugs.documentfoundation.org/show_bug.cgi?id=154852
--- Comment #8 from [email protected] --- (In reply to ady from comment #7) > (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. Ah! thanks for your workaround, it works! Thank you so much! Have a good day! -- You are receiving this mail because: You are the assignee for the bug.
