https://bugs.documentfoundation.org/show_bug.cgi?id=117459
m.a.riosv <miguelange...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |er...@redhat.com,
| |miguelangelrv@libreoffice.o
| |rg
--- Comment #1 from m.a.riosv <miguelange...@libreoffice.org> ---
You can force it adding a volatile function like NOW() to the formula
=MID(CELL("filename");FIND("'#$";CELL("filename"))+3;99)&T(NOW())
which forces the recalculation of the formula with every change on the spread
sheet.
If I'm not wrong CELL function is calculate when the referenced cell(s) change
their value, which seems it's not the case after change the sheet name.
Please Eike can you take a look.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
