[Libreoffice-bugs] [Bug 107357] Calc is taking several seconds to switch between tabs

[bugzilla-daemon at bugs.documentfoundation.org]

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>