<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Calc is taking several seconds to switch between tabs" href="https://bugs.documentfoundation.org/show_bug.cgi?id=107357#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Calc is taking several seconds to switch between tabs" href="https://bugs.documentfoundation.org/show_bug.cgi?id=107357">bug 107357</a> from <a class="email" href="mailto:robert@tachez.com" title="robert@tachez.com">robert@tachez.com</a> <pre>(In reply to m.a.riosv from <a href="show_bug.cgi?id=107357#c1">comment #1</a>) > 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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>