Author: Taiji Endo

OpenSolver for Google Sheets 2.3.1

Hello everyone,

We are pleased to announce a new release of OpenSolver for Google Sheets. This fixes bugs in the GLPK solver and NEOS-Cbc solver options which made them unavailable. These engines should now be working and available.

Errors which stopped the GLPK solver from running were related to local variables in scriptlets not being defined before Html template objects ‘glpkWorkerJs’ and ‘glpkRunnerJs’ were evaluated and ran these scriptlets. Errors such as “ReferenceError: gmplModel not defined” should now go away since local copies of these variables are initialised inside these scriptlets.

As of January 8, 2021, NEOS requires that an email address be submitted with every job. The NEOS-Cbc bug was related to this – originally we did not include a user email address in the xml file sent to the NEOS server.

Since NEOS now requires that each job contain an email address, we include the user’s email address in the xml file. This email address is only sent to NEOS when the model is being solved and only if the user selects NEOS-Cbc as the solver engine.

We have updated our privacy policy and information about OpenSolver for Google Sheets to reflect these changes.

As always, we welcome your feedback. Please comment below if it works ok, or if you encounter issues, or if you have any questions regarding the new release. Thanks!

OpenSolver 2.9.4 Beta Release

Hello everyone,

We’ve released OpenSolver 2.9.4 for beta testing! You can download this new version of OpenSolver from: https://sourceforge.net/projects/opensolver/files/.

Below are the release notes that cover the changes made in this new version of OpenSolver:

V2.9.4 – 2021-01-15

  • Extended support for special characters in sheet names
  • Removed support for Satalia Solver Engine since Satalia no longer offers an online service
  • Added fix for NEOS email validation
  • Added support for value-seeking models with no constraints

V2.9.3 – 2020-03-01

  • Added support for using Gurobi 9.0
  • Added a temp fix for running consecutive operations on Excel64bit

As always, we welcome your feedback. Please comment below if it works ok, or if you encounter issues, or if you have any questions regarding the new release. Thanks!

OpenSolver for Google Sheets working for new users

Hello everyone,

We have implemented a fix so that OpenSolver for Google Sheets should now be accessible and working again.

It seems that some of the comments in our code were causing an OAuth scope /auth/script.scriptapps – which we do not need or use – to be detected. These comments have now been removed, so we expect error messages like “Sign-in with Google temporarily disabled for this app” to stop appearing.

We’d greatly appreciate it if you could test that it now works. Please comment below if OpenSolver for Google Sheets works for you, or if you encounter any issues, or if you have any other questions.