[Solved] ODS Can't be written

Discuss the spreadsheet application
Post Reply
THEBookMan
Posts: 107
Joined: Wed Sep 30, 2015 10:03 pm
Location: Houston, TX area

[Solved] ODS Can't be written

Post by THEBookMan »

Just did some work on my ODS.
Tried to Save/Saveas(changed name) and message returned "File can't be written".
Anyone help?
TNX,
⌡im
Last edited by THEBookMan on Wed Jun 20, 2018 12:36 am, edited 1 time in total.
Open Office 4.1.3 Win 10
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: ODS Can't be written

Post by John_Ha »

It's probably caused by a W10 upgrade. Ensure AOO is given write privilege in Windows Defender.

Try File > New > Spreadsheet. Add a few characters. File > Save ... What happens?

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
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.
THEBookMan
Posts: 107
Joined: Wed Sep 30, 2015 10:03 pm
Location: Houston, TX area

Re: ODS Can't be written

Post by THEBookMan »

Saved w/ no problems.
No other ODS is continuously trying to save and things have frozen.
Open Office 4.1.3 Win 10
THEBookMan
Posts: 107
Joined: Wed Sep 30, 2015 10:03 pm
Location: Houston, TX area

Re: ODS Can't be written

Post by THEBookMan »

Saved w/ no problems.
No other ODS is continuously trying to save and things have frozen.

Windows defender is set to "WARN" on all apps.
Open Office 4.1.3 Win 10
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: ODS Can't be written

Post by John_Ha »

If I understand you, you are saying:

1. One .ods file does not save
2. All other files save OK.

If so, it sounds like that spreadsheet file is corrupted.

1. Copy the contents of the spreadsheet and paste them into a new, empty document. Does it save?
2. Try saving the original file with a different name.
3. You could repeatedly try Undo to see if you can undo whatever is causing the problem - it is presumably something which happened since opening the file.
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.
User avatar
RoryOF
Moderator
Posts: 34610
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ODS Can't be written

Post by RoryOF »

This thread _may_ give a solution (I haven't tried it).
https://ask.libreoffice.org/en/question ... in-10-why/
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: [Solved] ODS Can't be written

Post by John_Ha »

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.
Post Reply