Results 1 to 3 of 3

Thread: OpenOffice string formatting

Hybrid View

  1. #1
    Join Date
    May 2009
    Beans
    10

    OpenOffice string formatting

    Ok, so I've been beating my head against the wall trying to get this one sorted out. I have a spreadsheet in open office, I have a bunch of fields that are all 12 character alphanumeric strings. I want these fields to display with MAC address formatting something like: 12:34:46:78:AB:CD.

    If I go into Format -> Cells, I could do this if the field were just full of numbers (with format string ##:##:##:##:##:##) but that doesn't work on text fields.

    Looking around I've found that these formatting strings can be separated into sections with semicolons to get different formatting depending on the field content. Officially OO's documentation says these fields are:

    positive;negative;zero

    Investigating further suggests that excel allows one step further of:

    positive;negative;zero;text

    So I tried giving it the format string of:

    ;;;##:##:##:##:##:##

    which does format the cell, but instead of giving me my field formatted as a MAC address, I quite literally get the string:

    ##:##:##:##:##:##

    And I can't seem to find what open office might take for a wild card so that I can get my cell formatted. Any ideas? I'm really hoping I'm just missing something obvious and that this is indeed possible.

  2. #2
    Join Date
    Dec 2009
    Beans
    3

  3. #3
    Join Date
    Mar 2006
    Location
    Williams Lake
    Beans
    Hidden!
    Distro
    Ubuntu Development Release

    Re: OpenOffice string formatting

    A three year old thread is still three years old. Closed.

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
  •