We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Saving Open office files

2»

Comments

  • [Deleted User]
    [Deleted User] Posts: 4,466 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    Except Microsoft Office.

    All versions can open .odt :confused:

    Some might require a plug in to be installed, but Office 2007 SP2 can open it without such need.
  • -TangleFoot-
    -TangleFoot- Posts: 4,673 Forumite
    Part of the Furniture Combo Breaker
    anewhope wrote: »
    Some might require a plug in to be installed, but Office 2007 SP2 can open it without such need.
    Specifically, this plugin. Quite typically it deals with OpenDocument stuff better than MS Office itself!
    ...going back to my test spreadsheets from all of the various ODF applications, how do these applications encode formulas with cell addresses:
    • Symphony 1.3: =[.E12]+[.C13]-[.D13]
    • Microsoft/CleverAge 3.0: =[.E12]+[.C13]-[.D13]
    • KSpread 1.6.3: =[.E12]+[.C13]-[.D13]
    • Google Spreadsheets: =[.E12]+[.C13]-[.D13]
    • OpenOffice 3.01: =[.E12]+[.C13]-[.D13]
    • Sun Plugin 3.0: [.E12]+[.C13]-[.D13]
    • Excel 2007 SP2: =E12+C13-D13
    I'll leave it as an exercise to the reader to determine which one of these seven is wrong and does not conform to the ODF 1.1 standard.
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 352.2K Banking & Borrowing
  • 253.6K Reduce Debt & Boost Income
  • 454.3K Spending & Discounts
  • 245.3K Work, Benefits & Business
  • 601K Mortgages, Homes & Bills
  • 177.5K Life & Family
  • 259.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.