asked 2012-07-09 16:45:46 +0200
Anonymous
After having trouble in 3.4, I upgraded to latest release (3.5.4.2). 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.
Careless me.
Try:
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
"###" 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.
You may have selected "Display Formulas" (TOOLS/OPTIONS/CALC/VIEW display)?
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-18 00:20:09 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
It could sometimes happens if you put TEXT format for those cells.
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.
Further suggestions?
Thank you.
Emabarrased and confused.
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.
=SUM(D5*D6)
Any further thoughts?
Thank you for your efforts.
Emabarrased, Careless me.
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 3.5.4.2
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?
Thank you,
Embarrased
And when I checked again, the display formulas had been turned on again after the update.
Problem solved.
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
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
