We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

Openoffice Help

hjb123
hjb123 Posts: 32,002 Forumite
in Techie Stuff
Am having problems with open office and have set up a spreadsheet but cant seem to see how to set up a formula - I knew how to do it in excel as there was a sum button - is there not one in open office?

thanks
Weight Loss - 102lb

Comments

  • espresso
    espresso Posts: 16,448 Forumite
    Part of the Furniture 10,000 Posts Combo Breaker
    I don't use Open Office but just type the formula into the cell. Click on Help, you should be able to customise your displayed toolbars etc.
    :doh: Blue text on this forum usually signifies hyperlinks, so click on them!..:wall:
  • bat999
    bat999 Posts: 1,951 Forumite
    Part of the Furniture 1,000 Posts Name Dropper Combo Breaker
    Hi
    There is a sum button with OpenOffice spreadsheet.
    Never interrupt your enemy when he is making a mistake.
  • kevsan
    kevsan Posts: 238 Forumite
    Under view there is an option to display the formula bar, and one of the buttons on it is the function wizard - or you can just type the formula in like excel
    2014 running challenge 471.95 km / 1000 km.
  • hjb123
    hjb123 Posts: 32,002 Forumite
    thanks for that, never thought of looking at the help section on open office:D just immediately thought of the techies forum on MSE:D

    the sum button (that funny looking E symbol) is missing from the toolbar in open office
    Weight Loss - 102lb
  • hjb123
    hjb123 Posts: 32,002 Forumite
    ooooops, I think Ive been looking at it all the time, have spotted it now:D

    thanks for the help:D
    Weight Loss - 102lb
  • fermi
    fermi Posts: 40,542 Forumite
    Part of the Furniture 10,000 Posts Combo Breaker Rampant Recycler
    hjb123 wrote: »
    ooooops, I think Ive been looking at it all the time, have spotted it now:D

    thanks for the help:D

    Yep.

    2wm1ic5.png
    Free/impartial debt advice: National Debtline | StepChange Debt Charity | Find your local CAB

    IVA & fee charging DMP companies: Profits from misery, motivated ONLY by greed
  • hjb123
    hjb123 Posts: 32,002 Forumite
    it was so obvious I just couldnt see it:D
    Weight Loss - 102lb
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353.5K Banking & Borrowing
  • 254.1K Reduce Debt & Boost Income
  • 455K Spending & Discounts
  • 246.6K Work, Benefits & Business
  • 602.9K Mortgages, Homes & Bills
  • 178.1K Life & Family
  • 260.6K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture