Outcome formula shows in ### [closed]

calc

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

axioma

11 ●1 ●3 ●4

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?

Thx

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

horst

5066 ●6 ●26 ●48

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

Comments

Just tried that but it does not solve the problem.

axioma ( 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 ( 2015-06-06 06:52:59 +0100 )edit

add a comment

Question Tools

1 follower

Stats

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

Seen: 57 times

Last updated: Jun 06 '15

Outcome formula shows in ### [closed] edit

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