https://bugs.freedesktop.org/show_bug.cgi?id=85986
Bug ID: 85986
Summary: CELL Function does not re-evaluate a change in sheet
name.
Product: LibreOffice
Version: 4.1.3.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
