Calc ver. 7.0 displays 0.00 when cell contains =34

XLSX spreadsheet downloaded from QuickBooks Online displays “0.00” when a cell contains “=99”, (equal sign and any number). The number is recognized as the correct number when the cell is referenced in a formula. Formulas work correctly. When the original cell is modified as “= 99” (equal sign, space, and any number) Calc displays the correct number in the cell and all references are correct. When uploaded and converted to a Google Sheet, the cells display correctly.MBC Profit and Loss Class.xlsx

Why do you enter numeric values using =? Just use 275, 40, 175, 11.06 (leave off =).

Works with menu Data - Calculate - Recalculate Hard (the same that Ctrl+Shift+F9).

Extrange currency format. And excess of parentheses in formulas.

Opaque: data not entered, present in downloaded report from QuickBooks Online.
LeroyG: thanks for the tip. Works great.


LeroyG: thanks for the tip. Works great.

Just for my curiosity: If that works, are you accidentally using LibreOffice version (If yes - you are affected by bug tdf#137248 - Calc - AutoCalculate malfunction, always F9 (ReCalculate) necessary

In tdf#137248#c13 Eike wrote that it is “a repaint problem, Pgdn and PgUp or Shift+Ctrl+R to redraw the grid displays the recalculated value”, since, and I tested it with version that is not affected by this bug.