Calc ver. 7.0 displays 0.00 when cell contains =34

asked 2020-12-30 23:42:02 +0200

quailr gravatar image

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.C:\fakepath\MBC Profit and Loss Class.xlsx

edit retag flag offensive close merge delete


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

Opaque gravatar imageOpaque ( 2020-12-30 23:46:37 +0200 )edit

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

Extrange currency format. And excess of parentheses in formulas.

LeroyG gravatar imageLeroyG ( 2020-12-30 23:49:41 +0200 )edit

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

quailr gravatar imagequailr ( 2020-12-30 23:57:59 +0200 )edit


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

Opaque gravatar imageOpaque ( 2020-12-31 01:06:19 +0200 )edit

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.

LeroyG gravatar imageLeroyG ( 2020-12-31 21:26:43 +0200 )edit