[Solved] Function/Formula not working

Discuss the spreadsheet application

[Solved] Function/Formula not working

Postby peterclothier » Fri Apr 18, 2008 2:58 pm

Solved, thanks !

:)

am sure I just checked show gridlines, must have hit that button by mistake

FormulaeWelcome beginner. Please answer all of the questions below which may provide information necessary to answer your question.
-----------------------------------------------------------------------------------------------------------
Which version of OpenOffice.org are you using? Open office calc 2.3
What Operating System (version) are you using? Vista
What is your question or comment?

Hi, the formulae boxes in some of my spreadsheets aren't working, they just show the formula but not the answer.

In other spreadsheets it works fine. It was working before, and I can't think what I have done wrong since then as I haven't adjusted the formula

Any help much appreciated !

Thanks

Peter
Last edited by peterclothier on Fri Apr 18, 2008 5:32 pm, edited 2 times in total.
peterclothier
 
Posts: 3
Joined: Fri Apr 18, 2008 2:52 pm

Re: Function/Formula not working

Postby Hagar Delest » Fri Apr 18, 2008 3:12 pm

Can you upload here a sample file?
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28998
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Function/Formula not working

Postby peterclothier » Fri Apr 18, 2008 4:47 pm

Hi, sample file attached, thanks
Attachments
a sample file.ods
(13.5 KiB) Downloaded 73 times
peterclothier
 
Posts: 3
Joined: Fri Apr 18, 2008 2:52 pm

Re: Function/Formula not working

Postby Hagar Delest » Fri Apr 18, 2008 5:11 pm

Works fine for me. Make sure that in Tools>Options>OOo Calc>View, the Display>Formula option is unchecked.

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.

NB: moved your thread in the Calc forum.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28998
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: Majestic-12 [Bot] and 15 guests