Bug 85986 - CELL() Function does not re-evaluate a change in sheet name.
Summary: CELL() Function does not re-evaluate a change in sheet name.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 117459 121422 (view as bug list)
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2014-11-07 04:21 UTC by klsu
Modified: 2020-04-14 19:20 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description klsu 2014-11-07 04:21:02 UTC
Steps to reproduce:

1. Create a spreadsheet worksheet named "MMM".
2. In cell B1 enter the formula:
=RIGHT(CELL("filename",B1),LEN(CELL("filename",B1))-FIND("$",CELL("filename",B1)))
The formula evaluates to MMM (the sheet name).
3. Copy the worksheet to the same workbook. LibreCalc names the new sheet "MMM_2" and cell B1 on the new sheet evaluates to MMM_2 (the new sheet name).
4. Double-click on the new sheet tab and rename the sheet "HD". Cell B1 still displays MMM_2, and entering something on the sheet to cause the sheet to be recalculated does not cause cell B1 to be updated.
5. Copy Cell B1 to an empty cell on the same sheet. The copy evaluates to HD.
6. Repeat from step 4. as often as you like.

Saving, closing and reopening the workbook will cause CELL("filename",rc) to be recalculated correctly.
Comment 1 raal 2014-11-07 18:27:17 UTC
I can confirm with Version: 4.4.0.0.alpha1+
Build ID: 04ea7b24ec1b5a027efa0b850f2bc3ac7116c52e
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-11-06_00:02:40

ctrl+shift+F9 recalculate the formula.
Comment 2 QA Administrators 2015-12-20 16:14:26 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2017-01-03 19:48:54 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2019-12-03 14:25:26 UTC Comment hidden (obsolete)
Comment 5 Eike Rathke 2020-04-14 19:17:00 UTC
*** Bug 121422 has been marked as a duplicate of this bug. ***
Comment 6 Eike Rathke 2020-04-14 19:20:02 UTC
*** Bug 117459 has been marked as a duplicate of this bug. ***