https://bugs.documentfoundation.org/show_bug.cgi?id=154852
--- Comment #6 from kenjfzh...@163.com ---
(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().
>
> The reference appears updated because it refers only to the sheet number and
> when being viewed that is resolved to the current name.
Hi, Eike, the cell() function is what I needed.
I use 'CELL("address",S1!$B$2)' in MS office, and it works fine, but it not
work right in libreoffice.
--
You are receiving this mail because:
You are the assignee for the bug.
