OpenOffice spreadsheet tries to use Excel
OpenOffice spreadsheet tries to use Excel
i had a spread sheet in Open Office that somehow without my approval that was converted to Excel and now i can't access it unless i buy Microsoft software.
Last edited by MrProgrammer on Sat Nov 09, 2024 7:40 pm, edited 1 time in total.
Reason: Edited topic's subject
Reason: Edited topic's subject
OpenOffice 4.1.5 Windows 10
- LastUnicorn
- Posts: 667
- Joined: Sat Mar 29, 2008 2:41 am
- Location: Scotland
Re: Open Office conversion to Excel
I would try installing LibreOffice instead and see if that solves your immediate issue. LibreOffice has better support for Microsoft Office file types. There are several good reasons for making the switch anyway, some of which are mentioned here: [Tutorial] Considering a Switch from OpenOffice to LibreOffice? Some Useful Information
P.S. I don't see how the file could have been converted without your deliberate, though perhaps accidental, involvement in making it so.
P.S. I don't see how the file could have been converted without your deliberate, though perhaps accidental, involvement in making it so.
LibreOffice (Still) 24.2.7.2 (x64) installed to Windows 11 Pro.
Apache OpenOffice Portable 4.1.15 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.
Apache OpenOffice Portable 4.1.15 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.
Re: Open Office conversion to Excel
it is almost as if Microsoft pirated my Open office spread sheets. i notice other posts with the same problem. Horrible way to force people to pay Microsoft for Excel.
OpenOffice 4.1.5 Windows 10
- LastUnicorn
- Posts: 667
- Joined: Sat Mar 29, 2008 2:41 am
- Location: Scotland
Re: Open Office conversion to Excel
You should always be saving your spreadsheet as .ods file type. You would only ever need to save a copy as a Microsoft file type if you intended passing that copy of the spreadsheet file to someone who was using Microsoft Office. If you're not doing that then you should have no occasion at all for ever saving it as a Microsoft file type. As it stands I believe recent versions of Microsoft Office can open .ods files anyway, so no need for you to convert to Microsoft file type.
The same rule applies to all of OpenOffice/LibreOffice file types. Always save in the native ODF file types and treat those files as your master documents and only work in them.
The same rule applies to all of OpenOffice/LibreOffice file types. Always save in the native ODF file types and treat those files as your master documents and only work in them.
LibreOffice (Still) 24.2.7.2 (x64) installed to Windows 11 Pro.
Apache OpenOffice Portable 4.1.15 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.
Apache OpenOffice Portable 4.1.15 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.
Re: Open Office conversion to Excel
This is probably caused by a Windows update resetting the default applications. I believe it can and has done so several times in the past. It may be necessary to reset the File Associations to tell computer to use OpenOffice to open such files.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Open Office conversion to Excel
Last edited by DiGro on Fri Nov 08, 2024 11:16 am, edited 2 times in total.
____________
DiGro
AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)
DiGro
AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)
- LastUnicorn
- Posts: 667
- Joined: Sat Mar 29, 2008 2:41 am
- Location: Scotland
Re: Open Office conversion to Excel
If you do try LibreOffice then I would suggest you read chapter 10 of the Getting Started Guide — Working with File Formats, Security, and Exporting. In that chapter there are clear explanations of what file types LibreOffice can handle.
LibreOffice (Still) 24.2.7.2 (x64) installed to Windows 11 Pro.
Apache OpenOffice Portable 4.1.15 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.
Apache OpenOffice Portable 4.1.15 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.
Re: OpenOffice conversion to Excel
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: OpenOffice conversion to Excel
As others said, most likely nothing happened to your files, but your system suddenly assumes that MS Office is the default suite for opening OpenOffice files.
Possible quick fix: try to repair the OpenOffice install.
Possible quick fix: try to repair the OpenOffice install.
- Open the Settings app and go to apps
- Scroll down to the OpenOffice entry and select modify, then repair.