Call Solver.SolverAdd(CellRef:=sumcell, Relation:=2, FormulaText:=1)
After much experimentation I used instead:
Call Solver.SolverAdd(CellRef:=sumcell, Relation:=2, FormulaText:=0.999999999999999)Now I see:
How in the world can such a bug be introduced? Some bugs make sense, but the logic of this one is difficult to fathom. I cannot but think there must be a statement somewhere:
if rhs=1 and (not interactive) and (user=’Erwin.Kalvelagen’) thenSolver works correctly with a =1 equation when used from the GUI.
Well, found some more reports on this strange bug: