Poor Performance with LibreCalc

[atudela]

Hi Team,

I have an environment with LibreOffice and Microsoft Office 2013.

All users are working fine with this environment, but some files that we’re saving with ods standard have a poor performance in LibreCalc. In a fact, Librecalc needs 1 Gbyte of RAM for soffice.bin process, instead, in Excel we need 190 Mbytes. The ods file have 10 Mbytes and it’s builded without graphics. Also Cells has a simple MULT operation (with floating point).

Do you know a correct way for configure LibreOffice with best performance?

[atudela]

I opened the same ask on a Spanish forum and just we have found a possible solution (For Windows Environment):

Fichero con un consumo de RAM elevado

Tenemos un entorno de trabajo de test mixto entre MSoffice 2013 y LibreOffice 5.2.1. Hemos trabajado en la conversión de ficheros OOXML a formato ODF pero aun así seguimos teniendo problemas de consumo de RAM con libreCalc. Con algunos ficheros el proceso asociado a sOffice.bin se dispara hasta llegar a 1 Gbyte, en cambio ese mismo fichero abierto desde Excel consume 250 Mbytes. Las opciones que hemos configurado en LibreOffice son: Options → Memory → Use for LibreOffice 256 Mb Memory per O…

Summary:

• Delete de old profile in %APPDATA%/Libreoffice
• Install LibreOffice with minimal capabilities (without all dictionaries or OpenGL).
• Configure Memory following last link.

I hope that this steps can help you if you have the same issue.