View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default International Bug in Excel Solver

Solver is an addin developed by Front Line Systems

You can contact them at their web site:

http://www.solver.com/

Perhaps Microsoft didn't coordinate the advanced feature you describe and
introduced in xl2002 with them.

--
Regards,
Tom Ogilvy




"Michael" wrote in message
...
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