[Libreoffice-bugs] [Bug 86321] EDITING, FORMATTING: diagram didn't automatic update when change variable (steps in comment 28)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=86321

--- Comment #93 from VLB <vlb1 at vlbnu.nl> ---
(In reply to Dimitris Kallipolitis from comment #91)
> I have found a solution to this problem:
> Go to Tools->Options->LibreOffice→Advanced→Open Expert Configuration→ Search
> for ‘cache’→ Change org.openoffice.Office.Common→Cache→Drawing Engine
> (OLE_Objects) to e.g. 40 (default value 20). This value should be greater
> than your maximum number of charts in any spreadsheet that you use. A lower
> value causes some charts not to be updated when spreadsheet data is updated.
> It's a cache issue.
> 
> Verified with:
> Version: 7.1.2.2 / LibreOffice Community
> Build ID: 10(Build:2)
> OS: Linux 5.8; UI render: default; VCL: gtk3
> Ubuntu package version: 1:7.1.2~rc2-0ubuntu0.20.04.1~lo3
> Calc: threaded

Thanks for the feedback on the issue!

I have adjusted the value as indicated to a value of 90 (in connection with a
sheet with 88 graphs) and tested it. I can conclude that this solves the
problem for 1 sheet. Only I also have more of these shets open with
miscellaneous adjustments (so maybe more than 4 * 88 graphs) and then notice
that they are no longer updated. Can this value be increased indefinitely,
without causing problems elsewhere?
It would also be great if this problem could be solved in the source code, as
already indicated in comment 92.

Version: 7.1.2.2 (x64) / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 16; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: CL

-- 
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/20210419/dbe79492/attachment-0001.htm>