Results 1 to 3 of 3

Thread: openoffice calc cell formatting

  1. #1
    Join Date
    Jul 2006
    Location
    Stanford, CA
    Beans
    114
    Distro
    Ubuntu 7.10 Gutsy Gibbon

    openoffice calc cell formatting

    Hi,

    does anyone know how to control openoffice calc? oo seems to insist on having the number of decimal places set. Say I want to enter the numbers

    0.5
    0.55
    0.555

    oo defaults to two decimal places, and it formats the cells to be

    0.50
    0.55
    0.56

    If I set it to three decimal places, I get

    0.500
    0.550
    0.555

    But, I want it to only print exactly what I write! Anyone know how to do this? As a second question, does anyone know how to change the default cell formatting? So that I don't have to play with it every time I start a new spreadsheet?

    Alternatively, is there a better spreadsheet program out there? One that lets you do what you want, instead of forcing you to do what it thinks you want?

  2. #2
    Join Date
    Oct 2005
    Location
    Wyoming, USA
    Beans
    484
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: openoffice calc cell formatting

    Quote Originally Posted by shoagun View Post
    Alternatively, is there a better spreadsheet program out there? One that lets you do what you want, instead of forcing you to do what it thinks you want?
    I personally prefer gnumeric. It is basically an excel clone, but actually works better for statistical tasks. However, it can be a real pain in the @$$ to print from... at least that's my experience. It might be worth your time to give it a go.

    Code:
    sudo aptitude install gnumeric
    This looks nothing like my signature...
    My Page

  3. #3
    Join Date
    Apr 2006
    Location
    in the dark
    Beans
    1,513

    Re: openoffice calc cell formatting

    Another vote for gnumeric here but Id say you will get the same result. You will have to set the formatting as text rather then a number format.
    Imagination is more important than knowledge

Bookmarks

Posting Permissions

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