[Libreoffice-bugs] [Bug 121422] New: The CELL function does not change the result after changing the name of the sheet.

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: yestok at yestok.pl

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181114/7b7570dd/attachment.html>