https://bugs.documentfoundation.org/show_bug.cgi?id=121422
Bug ID: 121422
Summary: The CELL function does not change the result after
changing the name of the sheet.
Product: LibreOffice
Version: 6.1.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The CELL function with the "ADDRESS" option with a reference pointing to a cell
in another worksheet, eg named MYSHEET is written as =CELL("ADDRESS";
MYSHEET.A1) returns the result in the form $MYSHEET.$A$1. However, when you
change the name of this sheet, for example on YOURSHEET, the content of the
formula will be changed and looks like this: =CELL("ADDRESS";$YOURSHEET.A1) but
the result displayed in the cell does not change and still looks like the
previous $MYSHEET.$A$1.
The result change will not take place after the sheet has been recalculated.
This will happen only when the cell containing this formula is activated and
the F9 key is pressed or after saving the file and reloading.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
