How do I convert Excel BASIC Solver API calls to be compatible with LibreOffice ?

asked 2019-08-05 00:55:23 +0200

I'd like to make an XLS file that contains BASIC code so that it works on LibreOffice Calc. I'm getting a BASIC Runtime Error 35 SolverOk from the following line:

SolverOk SetCell:="$C$42", MaxMinVal:=1, ValueOf:="0", ByChange:= _

My guess is that the Solver API in LibreOffice does not contain the function SolverOk.

This won't be the last problem of this nature that I run into as I attempt to get this file to work with LibreOffice. Is there a conversion guide ??? Thanks

edit retag flag offensive close merge delete