Solver options: a strange error

%3CLINGO-SUB%20id%3D%22lingo-sub-303232%22%20slang%3D%22en-US%22%3ESolver%20options%3A%20a%20strange%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303232%22%20slang%3D%22en-US%22%3E%3CP%3EOffice%20365%2C%20Excel%3A%20when%20I%20try%20to%20modify%20any%20option%20of%20the%20Solver%20(for%20example%20the%20constraint's%20approximation%2C%20or%20the%20integer%20optimization)%26nbsp%3B%20I%20get%20the%20error%20%22The%20approximation%20must%20a%20small%20positive%20number%22.%20In%20the%20top%20cell%26nbsp%3Byou%20see%20something%20like%3C%2FP%3E%3CP%3E%22%22%220%2C001%22%22%22%3C%2FP%3E%3CP%3Ethat%20does%20not%20have%20any%20sense.%20Note%20that%20I%20use%20the%20decimal%20point%2C%20not%20the%20decimal%20comma.%3C%2FP%3E%3CP%3EHere%20are%20two%20screenshot%20(sorry%2C%20in%20Italian).%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20suggestion.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-303232%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303235%22%20slang%3D%22en-US%22%3ERe%3A%20Solver%20options%3A%20a%20strange%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303235%22%20slang%3D%22en-US%22%3EMake%20sure%20to%20post%20this%20in%20the%20excel%20forum%20ss%20well%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Office 365, Excel: when I try to modify any option of the Solver (for example the constraint's approximation, or the integer optimization)  I get the error "The approximation must a small positive number". In the top cell you see something like

"""0,001"""

that does not have any sense. Note that I use the decimal point, not the decimal comma.

Here are two screenshot (sorry, in Italian).

Thank you for any suggestion.

1 Reply
Highlighted
Make sure to post this in the excel forum ss well :)