Results 1 to 6 of 6
  1. #1
    New Lounger English Bob's Avatar
    Join Date
    Dec 2013
    Location
    Cambridge, UK
    Posts
    15
    Thanks
    5
    Thanked 1 Time in 1 Post

    Switching from OpenOffice to LibreOffice Calc - with difficulty

    At the moment I prefer to use OpenOffice Calc since it basically works as I expect (speaking as an ex-Excel user); but I'd like to migrate to LibreOffice since it's still being actively supported, and also because I prefer LibreOffice Writer. It seems wasteful to maintain two office suites.

    One example: when I import a bank statement in CSV format, my bank includes the currency symbol in the appropriate fields. LibreOffice Calc can't do calculations on those cells; I have to do a search and replace to get rid of the currency symbol, then format those cells as currency if I want to proceed.

    OpenOffice, on the other hand, correctly identifies the file format, performs calculations on cells which include a currency symbol, and even formats the result cells as currency.

    I can't find anything in the LibreOffice options to deal with these issues. Am I doomed to using two office suites?

  2. #2
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,725
    Thanks
    147
    Thanked 156 Times in 149 Posts
    When importing, click the 'detect special numbers' field; this converts the currency column correctly (at least it did when I tried it!).

  3. The Following User Says Thank You to access-mdb For This Useful Post:

    English Bob (2014-06-03)

  4. #3
    Silver Lounger
    Join Date
    Oct 2012
    Posts
    2,335
    Thanks
    13
    Thanked 267 Times in 260 Posts
    I believe Open Office classic is being supported again, now called Apache OpenOffice v.4.1.0.

  5. The Following User Says Thank You to F.U.N. downtown For This Useful Post:

    English Bob (2014-06-03)

  6. #4
    New Lounger English Bob's Avatar
    Join Date
    Dec 2013
    Location
    Cambridge, UK
    Posts
    15
    Thanks
    5
    Thanked 1 Time in 1 Post
    Quote Originally Posted by access-mdb View Post
    When importing, click the 'detect special numbers' field; this converts the currency column correctly (at least it did when I tried it!).
    A-ha! That does get me most of the way there, thanks. One small niggle remains: although the import preview correctly shows the GBP symbol that's in my CSV, the imported spreadsheet renders currency fields as USD until I re-format them. No biggie, I can do that easily enough.

    Quote Originally Posted by F.U.N. downtown View Post
    I believe Open Office classic is being supported again, now called Apache OpenOffice v.4.1.0.
    Thanks, I had seen that Apache had taken up the baton. I'll wait to see what happens with it. I should maybe have said that I'm using the PortableApps versions of these suites, and Apache OpenOffice hasn't made it to full release status as a portable app yet.

  7. #5
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    132
    Thanks
    1
    Thanked 19 Times in 18 Posts
    There is a portable version of 4.1 here http://www.openoffice.org/porting/

  8. The Following User Says Thank You to thomasjk For This Useful Post:

    English Bob (2014-06-03)

  9. #6
    New Lounger English Bob's Avatar
    Join Date
    Dec 2013
    Location
    Cambridge, UK
    Posts
    15
    Thanks
    5
    Thanked 1 Time in 1 Post
    Thanks to all. I intend to stick to LibreOffice for now.

    While it's a good thing that OpenOffice is still alive, it does muddy the waters somewhat when trying to choose.

Tags for this Thread

Posting Permissions

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