Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

How do I open an Open Office document in Excel?

  • 11-11-2008 8:47pm
    #1
    Da Funky Munky
    Closed Accounts Posts: 186 ✭✭


    I hope this is in, roughly, the right forum. Please move if its not.

    How do I open an Open Office document in Excel? And can I open them in batches?


Comments

  • #2
    PaddyTheNth
    Registered Users, Registered Users 2 Posts: 605 ✭✭✭PaddyTheNth


    Da Funky Munky wrote: »
    I hope this is in, roughly, the right forum. Please move if its not.

    How do I open an Open Office document in Excel? And can I open them in batches?

    It needs to be saved as an xls file (Microsoft Excel 2003 I think is what they call it in the Save As dialog) when you're in Open Office.


  • #3
    Berty
    Registered Users, Registered Users 2 Posts: 26,157 ✭✭✭✭Berty


    PaddyTheNth wrote: »
    It needs to be saved as an xls file (Microsoft Excel 2003 I think is what they call it in the Save As dialog) when you're in Open Office.

    + 1


  • #4
    Da Funky Munky
    Closed Accounts Posts: 186 ✭✭Da Funky Munky


    PaddyTheNth wrote: »
    It needs to be saved as an xls file (Microsoft Excel 2003 I think is what they call it in the Save As dialog) when you're in Open Office.

    Cheers, Im aware of that but I have dozens of them here and Id rather the person at the other end just click on a filter in Excel as re-saving them all will take me ages :)

    Is there such a filter?


  • #5
    Jonathan
    Moderators, Education Moderators, Home & Garden Moderators Posts: 8,260 Mod ✭✭✭✭Jonathan


    There is but I do not have the link to hand unfortunately. I'll have a look, but I remember getting rid of it because it was crap.


  • #6
    Da Funky Munky
    Closed Accounts Posts: 186 ✭✭Da Funky Munky


    jmccrohan wrote: »
    There is but I do not have the link to hand unfortunately. I'll have a look, but I remember getting rid of it because it was crap.

    Please do.

    Or Im looking at a couple of hours of head numbing work :)


  • Advertisement
  • #7
    butts
    Registered Users, Registered Users 2 Posts: 509 ✭✭✭butts


    Does Open Office have a scripting facility that would allow it to open all the spreadsheets it finds in a given folder and save them as Excel 2003 type files in another folder? I have not used Open Office so maybe someone else can say if it does, and give you the few lines of code that will do the job.


  • #8
    Jonathan
    Moderators, Education Moderators, Home & Garden Moderators Posts: 8,260 Mod ✭✭✭✭Jonathan


    Da Funky Munky wrote: »
    Please do.

    Or Im looking at a couple of hours of head numbing work :)
    http://odf-converter.sourceforge.net/download.html


Advertisement