Bug 113561 - In LO CALC it is not possible to integrate the SOLVER into a macro by recording a macro
Summary: In LO CALC it is not possible to integrate the SOLVER into a macro by recordi...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Macro-Recording Solver
  Show dependency treegraph
Reported: 2017-10-31 21:22 UTC by Justin Gray
Modified: 2022-06-01 18:37 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Justin Gray 2017-10-31 21:22:57 UTC
Hi, when I record a macro through Tools -> Macros -> Record Macro and use the Solver (Tools -> Solver) while recording the macro, the solver is not properly recorded as part of the macro. If I execute the macro afterwards, the solver is not used in any way, eventhough I used it while recording the macro. Thanks alot for your time and help!

Steps to Reproduce:
1.Record a new macro
2.Use the SOLVER while recording the macro
3.Save the macro
4.Execute the macro

Actual Results:  
The SOLVER operation used while recording the macro is not reproduced by replaying the macro

Expected Results:
The same SOLVER operation used while recording the macro (including the solver settings) should have been performed again by replaying the saved macro.

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Version: (x64)
Build-ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4
CPU-Threads: 4; Betriebssystem:Windows 6.19; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: group

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:56.0) Gecko/20100101 Firefox/56.0
Comment 1 raal 2017-11-01 18:36:52 UTC
I can confirm with Version:
Build ID: e90329ff3896cf33528b47830f49fcd05590bd6a
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
Comment 2 QA Administrators 2018-11-02 03:51:16 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2020-11-02 04:36:19 UTC Comment hidden (obsolete)
Comment 4 Rafael Lima 2022-06-01 18:37:24 UTC
This bug is still valid in LO 7.4.

Although the API to write macros that call the solver are available, it's not possible to automate the solver through Macro Recording.