https://bugs.documentfoundation.org/show_bug.cgi?id=154852
Bug ID: 154852 Summary: The cell formula does not reflect the updated result Product: LibreOffice Version: 7.5.1.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: kenjfzh...@163.com Description: The cell formula does not reflect the updated result. Steps to Reproduce: 1.In the B1 of sheet "S1" add the fomula "=CELL("address",S2.$B$1)". 2.and then change the name of sheet "S2" as "S3" 3.but the formula result is not been updated. Actual Results: The correct formula result should be "$S3.$B$1" instead of the previous result "$S2.$B$1" Expected Results: The correct formula result should be "$S3.$B$1" Reproducible: Always User Profile Reset: No Additional Info: Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: en-US (en-US); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.