[Libreoffice-bugs] [Bug 107357] Calc is taking several seconds to switch between tabs
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sat Apr 22 22:59:07 UTC 2017
https://bugs.documentfoundation.org/show_bug.cgi?id=107357
--- Comment #2 from robert at tachez.com ---
(In reply to m.a.riosv from comment #1)
> Have you conditional formats, charts, or using intensively INDIRECT() or
> OFFFSET) functions.
There were conditional formats, however, I just recreated the problem with a
new spreadsheet. It only took 4 pages of 800 x 8 formula to start to see the
problem start to present itself.
formula are very basic
+, a, b, c, d, e, f, g, h
1, 5, 4, 3, 2, 1, v, s, d
2, 0, 0, 0, 0, 0, =SUM(A2:E2),
=IFERROR(ROUND((A2*$A$1+B2*$B$1+C2*$C$1+D2*$D$1+E2*$E$1)/F2,2),0), =F2-J2
3, a2+1, =b2+0, =c2+0, d2+0, e2+0, =SUM(A3:E3),
=IFERROR(ROUND((A3*$A$1+B3*$B$1+C3*$C$1+D3*$D$1+E3*$E$1)/F3,2),0), =F3-J3
copy last row down to 800 and copy Sheet1 to Sheet2,3,4
--
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/20170422/0c2b8452/attachment.html>
More information about the Libreoffice-bugs
mailing list