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 7.0.2.2? (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 7.0.2.2, and I tested it with version 6.4.7.2 that is not affected by this bug.