Hello, A have a sheet with a macro with many "Data -> Goal seek" functions that used to work on LibreOffice_24.2.6 calc. In this new release 24.8.1 it doesn't work. Had to re-install LibreOffice_24.2.6 calc and my sheet worked again. Best, Bruh
Can you share a sample file where the problem is happening? Please remove all personal data before uploading the file.
Or maybe simply share the code for your macro, so we can test and verify the issue.
Created attachment 196594 [details] Macro using Visual Basic on calc
Ok. Please mind you I can't really code and I believe it could be done better using "for" loops.
Please can you share sample file with macro?
Created attachment 196600 [details] Sample
Hello, Did the macro/spreadsheet freeze with you too?
(In reply to Bruh from comment #7) > Did the macro/spreadsheet freeze with you too? When I run the "Macro0" in your document, my whole machine freezes completely. But the freeze happens both in 24.2 and 24.8. Tested with Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 4:24.2.5-0ubuntu0.24.04.2 Calc: threaded And With Version: 24.8.2.1 (X86_64) / LibreOffice Community Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13 CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL threaded No idea why it is freezing. How long does it usually take to run this macro on your machine?
(In reply to Rafael Lima from comment #8) > (In reply to Bruh from comment #7) > > Did the macro/spreadsheet freeze with you too? > > When I run the "Macro0" in your document, my whole machine freezes > completely. > > But the freeze happens both in 24.2 and 24.8. > > Tested with > > Version: 24.2.5.2 (X86_64) / LibreOffice Community > Build ID: 420(Build:2) > CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) > Locale: pt-BR (pt_BR.UTF-8); UI: en-US > Ubuntu package version: 4:24.2.5-0ubuntu0.24.04.2 > Calc: threaded > > And With > > Version: 24.8.2.1 (X86_64) / LibreOffice Community > Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13 > CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) > Locale: pt-BR (pt_BR.UTF-8); UI: en-US > Calc: CL threaded > > No idea why it is freezing. > > How long does it usually take to run this macro on your machine? Heu, I'm using Libreoffice on Windows 10. The macro takes around 7-8min to finish on 24.2.6.2.