First time here? Check out the FAQ!
asked 2012-07-09 16:45:46 +0200
After having trouble in 3.4, I upgraded to latest release (184.108.40.206). I changed something in 3.4, and continues in 3.5. No calculations occur, no matter how I enter them!
Does anyone have a hint for me? (I am so embarrased that I did not track the changes I made.)
Thank you in advance.
Ctrl+1 (or choose Format - Cells - Numbers tab), make sure the format is NOT text (set Number-Standard). Close this dialog, press F2, then space and Enter
answered 2012-07-09 18:01:38 +0200Pedro
"###" usually means that the cell width is not enough to display the results. Right click on the column header (A, B, C, etc) and choose Optimal Column Width and press OK.
answered 2012-08-24 14:01:12 +0200Edward
You may have selected "Display Formulas" (TOOLS/OPTIONS/CALC/VIEW display)?
answered 2012-08-24 10:26:29 +0200dsnillo
I did the update to 3.5.6 and an hour later to 3.6.0, and fixed the "Unhandled Exception" problem. The first page worked. But as soon as I opened the document I had been working on, the problem returned. I thought it has to be the template. I deleted the template, closed and reopened Calc, but the problem remains!
answered 2012-07-15 16:11:11 +0200LO User
As of 07-15-2012 I still cannot find the setting to allow formulas to calculate in the cell. Pedro was correct about the ### being too narrow a cell width. I actually knew that, but wondered if it was related to the problem, which it is not.
The cell shows the formula, but will not do the calculation.
Emabarrased and confused.
answered 2012-07-09 21:18:30 +0200LO User
JohnSUN: Thank you again for your response.
Following is an example of a formula, which is all that will show up in the active cell as well, rather than the "answer" to the formula.
Example - D5 contains a 5 D6 contains a 4 The following formula should give an answer of 20. Instead, it only returns the formula itself.
Any further thoughts?
Thank you for your efforts.
Emabarrased, Careless me.
answered 2013-02-25 04:18:29 +0200seasamin
Same problem. I just now got working when I used Cell Format to change the cells to Text and then bake to Numbers. I then edited the formula by adding a space and then deleting it in the formula and hitting enter. It worked but I do not know why. LibreOffice 220.127.116.11
answered 2012-07-09 17:27:46 +0200LO User
JohnSUN: Thank you for the answer to my question.
However, that has not solved what I have created! Calc knows it is a formula, but the answer is always "###". I cannot get it to show answers. In the upper area where we enter our formula, the formula shows as entered. However, the cell will not show any answer other than ###
Any other clues?
answered 2012-08-24 19:39:16 +0200dsnillo
And when I checked again, the display formulas had been turned on again after the update.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-07-09 16:45:46 +0200
Seen: 1,281 times
Last updated: Feb 25