I’m using LibreOffice Calc’s Solver feature to find the unity gain frequency of a two-pole system. The equation for gain of the system at a frequency is =B1/(SQRT(1+B4^2/B2^2)*SQRT(1+B4^2/B3^2)), where B1 is DC gain, B2 is frequency of pole 1, B3 is frequency of pole 2, and B4 is the frequency to find the gain at. I have this equation in B5. I’m using solver to find the value of B4 for which B5 is one. When I run solver, it finds a solution very quickly and populates it in the spreadsheet, but then continues iterating for a couple seconds only to claim “No solution was found”, then populates the cell with what it had before, wiping the solution.
The solver settings to reproduce this are a target cell of $B$5, targetting a value of 1, a limiting condition of $B$4 < 1e9, and “Assume Non-Negative Variables” checked. It happens with both solvers (DEPS and SCO) on all configurations I’ve tried. I’ve also attached the minimal example .ods sheet. Anyone know why this is happening or how to resolve this? To me it feels like a bug but I thought I’d post here first.
I’m using LibreOffice 25.8.1.1 580(Build:1) on Arch linux, package libreoffice-fresh version 25.8.1-3.
solver-bug-example.ods (11.2 KB)