Ask Your Question

Outcome formula shows in ### [closed]

asked 2015-06-06 05:08:31 +0100

axioma gravatar image

updated 2015-06-06 06:25:12 +0100

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?


edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by axioma
close date 2015-06-06 06:53:25.989915

1 Answer

Sort by » oldest newest most voted

answered 2015-06-06 05:17:23 +0100

horst gravatar image

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.

edit flag offensive delete link more


Just tried that but it does not solve the problem.

axioma gravatar imageaxioma ( 2015-06-06 05:28:21 +0100 )edit

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!

axioma gravatar imageaxioma ( 2015-06-06 06:52:59 +0100 )edit

Question Tools

1 follower


Asked: 2015-06-06 05:08:31 +0100

Seen: 57 times

Last updated: Jun 06 '15