html read : formulas almost work
Consider the following example of HTML tables. If you
ssconvert gnumeric-html-short.html gnumeric-html-short.gnumeric everything works fine. Cells B4 and C4 contain working formulas. So far so good.
Open the HTML file directly in gnumeric. Observe that B4 and C4 appear blank. If you go to a new cell and enter a formula that references these cells, they behave as empty cells. OTOH if you select either of the cells and look at the formula bar, the correct formula is visible. If you go to the formula bar and hit enter, the formula now starts to function normally. Furthermore, saving and re-opening the spreadsheet results in working formulas.
This is 100% reproducible chez moi. It is observed in a very recent gnumeric version '1.12.53' compiled from freshly-pulled git sources. It is also observed in an older gnumeric version '1.12.38' from the ubuntu "focal" distro.
:; uname -srmo Linux 5.15.0-46-generic x86_64 GNU/Linux :; lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 22.04.1 LTS Release: 22.04 Codename: jammy