1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Help With Open Office

Discussion in 'All Other Software' started by wrenie, Nov 1, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. wrenie

    wrenie Thread Starter

    Joined:
    Jan 20, 2003
    Messages:
    370
    I am trying to work on a spreadsheet in Open Office. I can't get it to let me put a header title on or get it to do a grand total. It will let me have a subtotal but not the grand total. Also when I put in the item number that begins with a 0 it keeps deleting the 0. Can someone please help me with this? I am using Windows 7 and Open Office 3. Thank you....Wrenie
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,191
    First Name:
    Wayne
    which version of open office

    apache or libre ?

    you will need to format to accept the leading 0 - do you want to use the input as a number using the leading zero

    use the format
    "0"#
    that will add a leading zero

    in apache open office (openoffice.org) and libre open office (http://www.libreoffice.org) - its user defined
     
  3. wrenie

    wrenie Thread Starter

    Joined:
    Jan 20, 2003
    Messages:
    370
    I am using apache open office. Sorry I am kinda lame when it comes to this. How do i do the "0" #? Also any ideas about the totals?
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,191
    First Name:
    Wayne
    you got to format cells
    and then scroll down to user defined and enter the value

    have a look at the attached screen shot

    re the totals - probably need to see the dummy data in a spreadsheet - as i'm not sure what you are trying to do or how the spreadsheet is laidout
     

    Attached Files:

  5. wrenie

    wrenie Thread Starter

    Joined:
    Jan 20, 2003
    Messages:
    370
    Thank you so much. Got the 0 to show up. What I am trying to do is have a series of $ amounts sub totaled then add a shipping amount to get a grand total. Is there anyway that I can do this?
     
  6. wrenie

    wrenie Thread Starter

    Joined:
    Jan 20, 2003
    Messages:
    370
    Sorry now that I re-read your message I see that you want a dummy spreadsheet to look at. I can make the spreadsheet but how to I get it to you?
     
  7. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,191
    First Name:
    Wayne
    how are you subtotaling ?

    To upload to the forum, open the full reply window ("Go Advanced" button) and use the Manage Attachments button to upload it here.
     
  8. wrenie

    wrenie Thread Starter

    Joined:
    Jan 20, 2003
    Messages:
    370
    It keeps telling me that it is an unknown file?????
     
  9. wrenie

    wrenie Thread Starter

    Joined:
    Jan 20, 2003
    Messages:
    370
    And I don't see anywhere that says advanced. Sorry to be so lame.
     
  10. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,191
    First Name:
    Wayne
    heres some screen shot

    then choose file - goto the spreadsheet and upload
     

    Attached Files:

  11. wrenie

    wrenie Thread Starter

    Joined:
    Jan 20, 2003
    Messages:
    370
    Thank you so much for your help. Ok I now know where to look, and what to do, but now it is telling me that is is an invalid file. Now what do I do?
     
  12. wrenie

    wrenie Thread Starter

    Joined:
    Jan 20, 2003
    Messages:
    370
    I don't know if this will help or not, but it says it is Dummy Spreadsheet.ods.
     
  13. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,191
    First Name:
    Wayne
    i dont think that file type is valid - save as excel xls 2003 or you will need to zip the file up
     
  14. wrenie

    wrenie Thread Starter

    Joined:
    Jan 20, 2003
    Messages:
    370
    That might be a problem because I no longer have excel on my computer.
     
  15. AtlasG

    AtlasG Banned

    Joined:
    Oct 12, 2012
    Messages:
    291
    I haven't used OpenOffice in a while, but I think you can save spreadsheets with the XLS (Excel) format even if you don't have Excel installed.
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1075007

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice