saving in odf

35 pts.
Tags:
editing excel spreadsheet
excel
ODF
Spreadsheets
if i save and excel spreadsheet into odf, will I be able to open and add to it just like normal? or do I have to save it in excel in order to edit or add to the document?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 10  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Since this is strikingly easy to test, it feels like there must be more to the question. What "Excel" version are you asking about? What OS/hardware platform is it running on? Has there been a problem in doing this?
    36,880 pointsBadges:
    report
  • pabdvm
    I’m always entertained by how simple regular people’s questions are for tech people. I am working with an old excel spreadsheet in windows 10. I was using a free app called neat office and was able to edit the spreadsheet etc. when I saved it asked if I wanted to save as old excel or odf. Not really knowing what an odf file was & thinking I would test it out, I tried it. Mistake. My computer tried to do some sort of extension and then locked me out of my document. I spent last night uninstalling neat office and installing a different app for windows 10 called ultra office. It allowed me to open my excel spreadsheet, but months of entries were lost. So, its not that easy to test. Now, when I try to close the ultra office (after making my edits) it is asking me the same thing. Save as old excel or save as odf. The choice for me seems obvious, but I thought the tech people could answer the question for me.....if I choose save as odf....am I able to go in and edit and still work on my spreadsheet? Other than the fact I’m working on a very old version of excel, I’m not sure what the advantage of saving as an odf may be?
    35 pointsBadges:
    report
  • Subhendu Sen
    As you mentioned odf format is used by Open Office/ Libre Office. You can edit/ add this file format as usual. In MS Excel can not open it normally till there is an add-on or app.
    142,210 pointsBadges:
    report
  • pabdvm
    Thank you for your help. Hope you are having a great holiday!
    35 pointsBadges:
    report
  • ToddN2000
    You should be able to open it the same app you saved in under. Sometimes apps use custom file extensions that other programs will not recognize or be able to use.
    136,290 pointsBadges:
    report
  • Jaideep Khanduja
    Better save as excel that all open office apps provide an option. That way you can open it on multiple office apps.
    19,805 pointsBadges:
    report
  • pabdvm
    Thank you. I did save it as excel. Better just to avoid the problems. Happy holidays!
    35 pointsBadges:
    report
  • Subhendu Sen
    Keep in mind, Open office/ Libre Office is a free to use software, while MS Office or MS Excel is expensive. Open Office/ Libre Office can open files which are created in MS Office.
    142,210 pointsBadges:
    report
  • TheRealRaven
    Testing would normally be done by first creating a new spreadsheet. Then see if it can be opened and modified. Using an 'important' document wouldn't be good start for a test. But saving a new format should at least keep the original document without any changes since the file extension should have changed.

    The question asks about "odf" which mostly means something like "open document format" in conversation. However, there can be multiple kinds of "odf" files. In Windows, the .ODF file extension is usually associated with text documents created for word processors, and .ODS is associated with spreadsheets. (A file extension does not directly determine the kind of file.)

    Normally, I wouldn't want to save a spreadsheet with an .ODF extension in Windows. However, because "odf" files should be created with XML, even as .ODF I'd be disappointed with a product that couldn't re-open what it saved.

    Whether or not Excel (or Word or whatever) can handle any open document format can depend on how old the product is or what add-ons have been added. Over time, Microsoft slowly learned that the capability ought to be included. We can't tell what any remote PC might handle.

    I only rarely use Excel and haven't done so for a few years, preferring Libre Office. But an .ODF format shouldn't seem appropriate for an Excel spreadsheet. I'd expect the .ODS format instead.

    Can "neat office" save spreadsheets and then re-open/modify in .ODF format? Your experience is the first I've known of, so you're now one of the 'experts' on that subject. Until more testing is done, the answer seems to be "No."
    36,880 pointsBadges:
    report
  • Subhendu Sen
    According to Microsoft, yes, it can possible to edit/ modify or re-create MS Office/ Open Office files formats. Please check this link here, https://www.microsoft.com/en-us/p/neat-office-word-excel-pdf-powerpoint-alternative/9p2htzq722v3?activetab=pivot:overviewtab
    142,210 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: