Open office Calc - boards.ie
Boards.ie uses cookies. By continuing to browse this site you are agreeing to our use of cookies. Click here to find out more x
Post Reply  
 
Thread Tools Search this Thread
10-07-2012, 16:13   #1
killaspec
Registered User
 
killaspec's Avatar
 
Join Date: Mar 2010
Posts: 51
Open office Calc

Not sure if this is the right place to ask this question. I am building a budget Calc sheet at the moment for home. I have a daily expense list which I input totals from the day.

Now I have recurring items i.e Cigs and coffee which I always buy the same brand and pay the same amount. I have all my recurring items on a sheet in the file and was wondering if there was a way to type say just Cigs and the price for it will show up in the total column?

Any help will be appreciated as at the moment I have to click on the sheet to add the amount.

Hope fully I aint confused you all.

Matthew
killaspec is offline  
Advertisement
10-07-2012, 16:53   #2
PrzemoF
Registered User
 
Join Date: May 2010
Location: Corcaigh
Posts: 1,375
Something like that?

(It's zipped because boards.ie uploader doesn't like ods files )
Attached Files
File Type: zip list.zip (7.3 KB, 9 views)
PrzemoF is offline  
Thanks from:
10-07-2012, 20:16   #3
croo
Moderator
 
Join Date: Aug 2006
Location: Westmeath
Posts: 1,107
Another option is
=VLOOKUP(A5,G6:H8,2,0)
In the B cells of PrzemoF's example.
croo is offline  
Thanks from:
14-07-2012, 12:45   #4
Stuxnet
Registered User
 
Stuxnet's Avatar
 
Join Date: Jan 2005
Location: /etc
Posts: 3,376
openoffice is well dead,

for a better supported office suite, should use LibreOffice
Stuxnet is offline  
14-07-2012, 23:09   #5
Johnboy1951
Registered User
 
Johnboy1951's Avatar
 
Join Date: Feb 2009
Posts: 3,650
Open Office is now in the hands of the Apache Foundation so is hardly dead .....
Johnboy1951 is offline  
Advertisement
28-07-2012, 21:17   #6
Ste_JDM
Registered User
 
Join Date: Jun 2012
Location: Dublin/Waterford
Posts: 186
Quote:
Originally Posted by Johnboy1951 View Post
Open Office is now in the hands of the Apache Foundation so is hardly dead .....
Well yes and no. Look at it this way. Majority of the developers of OpenOffice left during the fork in 2010 to LibreOffice. And ever since then OpenOffice has made very little progress and was nearly killed off but apache saved it. In those 2 years though, Libre has released roughly 3 or 4 updates and enhancements improving the program. I find Libre to be alot faster and more lightweight then OpenOffice because of this. Libre and Open are twins. Whatever name you want to call it has the same appearance. Just one is now faster and has grown up more then the other.

But I do hope to see Apache do something good with OpenOffice.
Ste_JDM is offline  
28-07-2012, 23:35   #7
Johnboy1951
Registered User
 
Johnboy1951's Avatar
 
Join Date: Feb 2009
Posts: 3,650
Quote:
Originally Posted by Ste_JDM View Post
Well yes and no. Look at it this way. Majority of the developers of OpenOffice left during the fork in 2010 to LibreOffice. And ever since then OpenOffice has made very little progress and was nearly killed off but apache saved it. In those 2 years though, Libre has released roughly 3 or 4 updates and enhancements improving the program. I find Libre to be alot faster and more lightweight then OpenOffice because of this. Libre and Open are twins. Whatever name you want to call it has the same appearance. Just one is now faster and has grown up more then the other.

But I do hope to see Apache do something good with OpenOffice.
There was some talk of a merge ..... no idea how that could be done or if it would be workable ....

Either way the comment "openoffice is well dead" is not accurate
Johnboy1951 is offline  
29-07-2012, 20:17   #8
Ste_JDM
Registered User
 
Join Date: Jun 2012
Location: Dublin/Waterford
Posts: 186
We will have to see what Apache does with it. Alittle competition between them wont do any harm
Ste_JDM is offline  
Thanks from:
Post Reply

Quick Reply
Message:
Remove Text Formatting
Bold
Italic
Underline

Insert Image
Wrap [QUOTE] tags around selected text
 
Decrease Size
Increase Size
Please sign up or log in to join the discussion

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Share Tweet