Why LibreOffice Calc Version: 6.1.5.2 (x64) macro become so unbearably slow?

asked 2019-05-05 10:31:22 +0200

Wowbat gravatar image

updated 2019-05-21 15:14:01 +0200

Exactly the same macro working on LibreOffice_6.0.7_Win_x64 big spreadsheet was more than 5 times faster.. For example, using all the time the same size large spreadsheet (the same number of columns and 200 000 of rows):

LibreOffice_6.0.7_Win_x64: .ods -> 8min .xlsx -> 10min 50sec

LibreOffice Calc Version: 6.1.5.2 (x64): .ods -> 47min .xlsx -> less than 25min.

With version 6.1.6_Win_x64 a bit better but still much slower than version 6.0.7_Win_x64. Results:

Version 6.0.7_Win_x64 - .ods -> 8min40sec ; .xlsx -> 7min55sec
Version 6.1.6_Win_x64 - .ods -> 18min15sec ; .xlsx -> 18min35sec
edit retag flag offensive close merge delete

Comments

The file was created in LibreOffice ?

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2019-05-05 22:57:36 +0200 )edit

Yes, each time.

Wowbat gravatar imageWowbat ( 2019-05-07 01:28:35 +0200 )edit

With version 6.1.6_Win_x64 a bit better but still much slower than version 6.0.7_Win_x64. Results:

  1. Version 6.0.7_Win_x64 - .ods -> 8min40sec ; .xlsx -> 7min55sec
  2. Version 6.1.6_Win_x64 - .ods -> 18min15sec ; .xlsx -> 18min35sec
Wowbat gravatar imageWowbat ( 2019-05-20 07:02:17 +0200 )edit

First of all, there's nothing to say without the macro itself. But anyway, this is a topic for a performance regression bug report, not for a question on Ask Other LibreOffice Users For Help site. And prior to filing it, please make sure you tested 6.2 if that's still a problem there.

Mike Kaganski gravatar imageMike Kaganski ( 2019-05-21 15:16:44 +0200 )edit