https://bugs.documentfoundation.org/show_bug.cgi?id=154852
--- Comment #5 from [email protected] --- (In reply to ady from comment #2) > There is one detail that should be noted: The formula in the formula bar > gets updated instantly without the need to force recalculate, so there is no > problem there. > > The CELL() function is considered volatile, depending on its arguments. I tried to reset below formula again ,and I also checked the Data> Calculate> AutoCalculate is on ,and I confirmed that formula result is not be recalculated again. formula := =CELL("address",S3.$B$2) result := "$S2.$B$2" -- You are receiving this mail because: You are the assignee for the bug.
