Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 31 Dec 2020 21:26:43 +0100Calc ver. 7.0 displays 0.00 when cell contains =34https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-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.[C:\fakepath\MBC Profit and Loss Class.xlsx](/upfiles/16093679158804593.xlsx)Wed, 30 Dec 2020 23:42:02 +0100https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/Comment by LeroyG for <p>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.<a href="/upfiles/16093679158804593.xlsx">C:\fakepath\MBC Profit and Loss Class.xlsx</a></p>
https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/?comment=285178#post-id-285178In tdf#137248[#c13](https://bugs.documentfoundation.org/show_bug.cgi?id=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.Thu, 31 Dec 2020 21:26:43 +0100https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/?comment=285178#post-id-285178Comment by Opaque for <p>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.<a href="/upfiles/16093679158804593.xlsx">C:\fakepath\MBC Profit and Loss Class.xlsx</a></p>
https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/?comment=285046#post-id-285046@quailr
> 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](https://bugs.documentfoundation.org/show_bug.cgi?id=137248) - *Calc - AutoCalculate malfunction, always F9 (ReCalculate) necessary*Thu, 31 Dec 2020 01:06:19 +0100https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/?comment=285046#post-id-285046Comment by quailr for <p>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.<a href="/upfiles/16093679158804593.xlsx">C:\fakepath\MBC Profit and Loss Class.xlsx</a></p>
https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/?comment=285033#post-id-285033Opaque: data not entered, present in downloaded report from QuickBooks Online.
LeroyG: thanks for the tip. Works great.Wed, 30 Dec 2020 23:57:59 +0100https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/?comment=285033#post-id-285033Comment by Opaque for <p>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.<a href="/upfiles/16093679158804593.xlsx">C:\fakepath\MBC Profit and Loss Class.xlsx</a></p>
https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/?comment=285031#post-id-285031Why do you enter numeric values using `=`? Just use `275`, `40`, `175`, `11.06` (leave off `=`).Wed, 30 Dec 2020 23:46:37 +0100https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/?comment=285031#post-id-285031Comment by LeroyG for <p>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.<a href="/upfiles/16093679158804593.xlsx">C:\fakepath\MBC Profit and Loss Class.xlsx</a></p>
https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/?comment=285032#post-id-285032Works with menu `Data` - `Calculate` - `Recalculate Hard` (the same that `Ctrl+Shift+F9`).
Extrange currency format. And excess of parentheses in formulas.Wed, 30 Dec 2020 23:49:41 +0100https://ask.libreoffice.org/en/question/285030/calc-ver-70-displays-000-when-cell-contains-34/?comment=285032#post-id-285032