Every time I use a formula in Calc, it only shows ###.
e.g. =FV(.07,10,0,500) gives ###
I may have changed some settings I was not aware of.
Does anybody have an idea what I may have done wrong?
Thx
the width of your cell is to short to display all digits of the result. You may increase the width or select a shorter display format.
Just tried that but it does not solve the problem.
After comparing the LO settings in an other Linux install, I realized I had accidentally ‘Formulas’ in the options settings checked. This makes that the formula instead of the answer is shown. In that case the cell size was indeed way to narrow.
So, learned something new today.
Thanks!