[Libreoffice-bugs] [Bug 117459] recalculate not done when worksheet renamed

2018-05-07 Thread bugzilla-daemon 
https://bugs.documentfoundation.org/show_bug.cgi?id=117459

Eike Rathke  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #2 from Eike Rathke  ---
The CELL() function lacks dependencies on events that are not cell content
changes. For "filename" that is renaming a sheet and saving to a different file
name. For "format" and related that is changing the applied number format.

-- 
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

[Libreoffice-bugs] [Bug 117459] recalculate not done when worksheet renamed

2018-05-06 Thread bugzilla-daemon 
https://bugs.documentfoundation.org/show_bug.cgi?id=117459

m.a.riosv  changed:

   What|Removed |Added

 CC||er...@redhat.com,
   ||miguelangelrv@libreoffice.o
   ||rg

--- Comment #1 from m.a.riosv  ---
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