https://bugs.documentfoundation.org/show_bug.cgi?id=154852
--- Comment #9 from [email protected] --- (In reply to Eike Rathke from comment #6) > (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. Hi, Eike, thanks for your info, and it works. I just understood your message after the workaround explanation from ady. Thank you so much. Have a nice day! -- You are receiving this mail because: You are the assignee for the bug.
