Hello,
Since updating to (I think) LibreOffice 3.5.0 (and now 3.5.1) on Mac OS X 10.6.8, all my Calc spreadsheet formulas continue to work, but their cells no longer show the results! Instead, the cells show the formula. I tried copy a paste special with numbers only from the formula into another cell, and the formula's output gets pasted.
This is very strange and frustrating, can anyone help with fixing this? Thanks!
You need to disable the checkbox in Options->LibreofficeCalc->View->Formula
Hi, see your cells format. Maybe they are formated as Text. In this case, formulas doesn't work. So, change it and try again.
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-03-16 03:23:15 +0200
Seen: 1,693 times
Last updated: Mar 16 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
