+ Post New Thread
Results 1 to 5 of 5
How do you do....it? Thread, How do you insert a formulae on open office in Technical; on open office database i'm making a simple... annoying ...database for our orders etc and i though i know lets ...
  1. #1
    stu
    stu is offline
    stu's Avatar
    Join Date
    Sep 2007
    Location
    Plymouth Uni
    Posts
    436
    Thank Post
    31
    Thanked 7 Times in 7 Posts
    Rep Power
    17

    Angry How do you insert a formulae on open office

    on open office database i'm making a simple... annoying ...database for our orders etc and i though i know lets have a simple X x Y=XY sorta formula for item cost, quantity, total. shouldn't be difficult but i cant find the tools that allow u to insert the formula, this is realy getting on my wick cus it should only have taken seconds and is bogging me down on the whole having to learn Bean to write a macro

    so any help would be greatly appreciated!

    Thx
    Stu

  2. #2

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168
    Where are you trying to insert this formula?

  3. #3
    stu
    stu is offline
    stu's Avatar
    Join Date
    Sep 2007
    Location
    Plymouth Uni
    Posts
    436
    Thank Post
    31
    Thanked 7 Times in 7 Posts
    Rep Power
    17
    so that when making orders it becomes a little more automated and saves us some time

  4. #4

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168
    As far as I know/can find out this can only be done with a macro attached to the changed event of one of the other fields...

  5. #5
    stu
    stu is offline
    stu's Avatar
    Join Date
    Sep 2007
    Location
    Plymouth Uni
    Posts
    436
    Thank Post
    31
    Thanked 7 Times in 7 Posts
    Rep Power
    17
    cheers i guess its back to learning bean then was hoping there was a way of using excel/ calc sort of layout in the background or some thing
    thanks
    stu

SHARE:
+ Post New Thread

Similar Threads

  1. Open Office on RM CC3
    By juno1 in forum Educational Software
    Replies: 2
    Last Post: 2nd July 2007, 07:38 AM
  2. Deploy Open office through GPO to certain PC's
    By tosca925 in forum Educational Software
    Replies: 4
    Last Post: 8th May 2007, 08:59 AM
  3. Replies: 6
    Last Post: 28th September 2006, 07:06 PM
  4. Open Office compatability with MS Office
    By alan-d in forum Educational Software
    Replies: 10
    Last Post: 4th May 2006, 01:50 PM
  5. Open Office
    By ninjabeaver in forum Downloads
    Replies: 1
    Last Post: 13th June 2005, 08:41 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •