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

[Wowbat]

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

[schiavinatto]

The file was created in LibreOffice ?

[Wowbat]

Yes, each time.

[Wowbat]

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

[mikekaganski]

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.