Test 't7000-goal-seek.pl' fails with datatype 'long', what may i be doing wrong?
since experimenting with 'long' datatype the test t7000-goal-seek.pl fails with: '
t7000-goal-seek.pl: Check that goal seeking works right.
| TRUE
... ...
| TRUE
| #VALUE!
| #VALUE!
Fail.
failing are the two last tests in row 15 and 16, where quadratic expressions are evaluated and no min-max limits are mentioned in the sheet.
with datatype double it holds, as well when opening the file in a sheet and starting the solver manually meaningful results are calculated ( solo per row as i didn't figure out how to set 'to' for multiple tasks ). i use -1e10 for min and 1e10 for max ( seen in code as default? ) and get meaningful results which also trigger the result flags in H15 and H16 to TRUE.
I assume a datatype mess-up somewhere, but couldn't yet find where ... setting min and max to 'xxxL' didn't help.