[Solved] ODS Can't be written

Discuss the spreadsheet application

[Solved] ODS Can't be written

Postby THEBookMan » Mon Jun 11, 2018 5:35 pm

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
THEBookMan
 
Posts: 80
Joined: Wed Sep 30, 2015 10:03 pm
Location: GB, WI (some sort of sport team lives around here)

Re: ODS Can't be written

Postby John_Ha » Mon Jun 11, 2018 5:46 pm

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.
AOO 4.1.6, Windows 7 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: 6866
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: ODS Can't be written

Postby THEBookMan » Mon Jun 11, 2018 5:58 pm

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: 80
Joined: Wed Sep 30, 2015 10:03 pm
Location: GB, WI (some sort of sport team lives around here)

Re: ODS Can't be written

Postby THEBookMan » Mon Jun 11, 2018 6:01 pm

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
THEBookMan
 
Posts: 80
Joined: Wed Sep 30, 2015 10:03 pm
Location: GB, WI (some sort of sport team lives around here)

Re: ODS Can't be written

Postby John_Ha » Mon Jun 11, 2018 6:04 pm

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.
AOO 4.1.6, Windows 7 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: 6866
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: ODS Can't be written

Postby RoryOF » Mon Jun 11, 2018 6:22 pm

Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29753
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] ODS Can't be written

Postby John_Ha » Tue Mar 26, 2019 1:36 pm

AOO 4.1.6, Windows 7 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: 6866
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Calc

Who is online

Users browsing this forum: appletreasures, MSN [Bot] and 25 guests