<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#c6">Comment # 6</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:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> m.a.riosv</a> <pre>With sample file switch between sheets it's instantaneous form me, even a hard recalc [Ctrl+F9] has no delay. Version: 5.3.2.2 (x64) Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1 CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine: new; Locale: es-ES (es_ES); Calc: group Versión: 5.3.2.1 Id. de compilación: 7f6693c08cc110b9721245fc4bd4f1712e0c086c Subpr. de CPU: 4; SO: Windows 6.2; Repr. de IU: predet.; Motor de trazado: HarfBuzz; TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-3, Time: 2017-03-25_13:52:57 Configuración regional: es-ES (es_ES); Calc: group Please test your original file after deleting the conditional formats, on some situations they can slowdown the spreadsheets. By the way some calculations can be simplified a bit. =IFERROR(ROUND((A3*$A$1+B3*$B$1+C3*$C$1+D3*$D$1+E3*$E$1)/F3;2);0) x =IF(F3;ROUND(SUMPRODUCT(A$1:E$1;A3:E3)/F3;2))</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>