Here is the nonlinear programming solver. NLP-Solver

Plugins
1

Hi everyone,

I noticed OnlyOffice was missing a nonlinear programming solver, so I built one.

GitHub: GitHub - Karl1b/only-office-nlp-solver: NLP Solver plugin for OnlyOffice Spreadsheet. Optimizes a target cell by adjusting parameter cells within bounds using numerical nonlinear programming (Go/WebAssembly). Keywords: NLP, solver, optimization, OnlyOffice plugin, spreadsheet, nonlinear programming, WebAssembly, Go, parameter fitting, minimization.

The repo includes an example spreadsheet with two real-world optimization problems and the Himmelblau function as a test case.

A and the download of course, I can not share the link directly here. Cause I am a new user :wink:

I’m planning to submit this to the plugin marketplace later, but still this year, and your feedback would really help shape the final version. Specifically, I’d love to hear:

  • What optimization problems are you solving? (Always looking for edge cases to test)
  • How does it compare to Excel Solver or LibreOffice Calc on your data?
  • What’s missing, broken, or could be better?

Looking forward to hearing what you think!

Karl karlbreuer.com
demo

3

The solver now supports side conditions and is basically ready for the store.

Just some polishing left.

Project page here:

demo-solver_550_1077

- Still open for feedback :crossed_fingers: :grinning:

1 Like