G
Guest
I'm using the Excel Solver in an application that we have developed.
However, there appears to be a bug in the solver handling the international
settings in Excel (2003).
If you change the decimal and thousands separator in Tools->Options
(International) to something other than the system separators, the solver
will fail with the error "Error in model. Please verify that all cells and
constraints are valid.".
I first noticed this on a non-English WinXP system running English Excel
2003. The user had changed the settings in Excel to display floating point
numbers as they would in English. However, the same problem can occur in
English systems if you change the decimal separator to "," and the thousands
separator to "." as in many non-English locales.
Is there any way around this problem without forcing the user to use
international settings he does not desire to make?
Sincerely,
Michael
However, there appears to be a bug in the solver handling the international
settings in Excel (2003).
If you change the decimal and thousands separator in Tools->Options
(International) to something other than the system separators, the solver
will fail with the error "Error in model. Please verify that all cells and
constraints are valid.".
I first noticed this on a non-English WinXP system running English Excel
2003. The user had changed the settings in Excel to display floating point
numbers as they would in English. However, the same problem can occur in
English systems if you change the decimal separator to "," and the thousands
separator to "." as in many non-English locales.
Is there any way around this problem without forcing the user to use
international settings he does not desire to make?
Sincerely,
Michael