[Libreoffice-bugs] [Bug 137541] External links in Calc via INDIRECT() always require an update
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sun Dec 6 23:34:32 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=137541
m.a.riosv <miguelangelrv at libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |miguelangelrv at libreoffice.o
| |rg
--- Comment #7 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Hi @Eike, would be nice some way to avoid this. The better I think could be a
nonvolatile INDIRECT, also it could help to make less slow spreadsheets.
It's an annoying situation, and it doesn't allow even to take a view to the
spreadsheet without update the links, and when update take several minutes or
linked files are not available, it's really annoying, and gives a very bad
impression to persons who don't know the issue or don't have access to the
linked files, making unusable this files without the linked files.
The only solution that I have found it's to disable Autocalculate before save.
Here is a macro to do it.
Sub DesactivarAutocalculo()
ThisComponent.enableAutomaticCalculation(False)
End Sub
Adding it to Menu/Tools/Customize/Evens - Save file
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201206/5f3f9f65/attachment-0001.htm>
More information about the Libreoffice-bugs
mailing list