[Solved] ODS file opened as Writer/Word Processor

Discuss the spreadsheet application

[Solved] ODS file opened as Writer/Word Processor

Postby san_antonio_user » Fri Apr 23, 2021 3:23 pm

I have a spread sheet file that I had working on Windows 7. I have copied it onto a thumb drive and am trying to open it with Open Office on my Mac. It opens as a Writer file with nothing but 'X' in the text.

What are the steps I need to do convert?
Last edited by san_antonio_user on Fri Apr 23, 2021 9:55 pm, edited 1 time in total.
OpenOffice: 4.1.9
macOS Big Sur 11.2.3
san_antonio_user
 
Posts: 2
Joined: Fri Apr 23, 2021 3:02 pm

Re: ODS file opened as Writer/Word Processor

Postby Hagar Delest » Fri Apr 23, 2021 3:30 pm

Hi and welcome to the forum!

There is no conversion needed. It means that the file has been corrupted somewhere. You should check that the file is OK on the source computer, then copy it again on your thumb drive and try again on your Mac.
LibreOffice 7.0.5 on Xubuntu 21.04 and 7.0.5 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 29745
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: ODS file opened as Writer/Word Processor

Postby RoryOF » Fri Apr 23, 2021 4:04 pm

And be certain to observe the USB removal protocols appropriate to your operating system. Premature removal of a USB key can cause problems such as you report, but that is not the only cause of these problems.
Apache OpenOffice 4.1.9 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32523
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ODS file opened as Writer/Word Processor

Postby san_antonio_user » Fri Apr 23, 2021 5:35 pm

I copied the file from the PC to the USB drive. I was able to open the file from the USB drive on the PC. I could never open the file on the Mac. I did this multiple times, so I figured maybe there was a conversion that had to happen. So, I tried another USB and was able to open the copied file to the USB on the PC as well as on the Mac.

Being that I was able to open it on the PC every time, I didn't suspect it was the USB. Thank y'all for your help. Excuse the lack of thoroughness on my part.
OpenOffice: 4.1.9
macOS Big Sur 11.2.3
san_antonio_user
 
Posts: 2
Joined: Fri Apr 23, 2021 3:02 pm

Re: ODS file opened as Writer/Word Processor

Postby John_Ha » Fri Apr 23, 2021 5:57 pm

See Why is my Writer file full of #####? for an explanation of files full of null characters which Writer displays as ######.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 8372
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Calc

Who is online

Users browsing this forum: No registered users and 21 guests