Spreadsheet data lost, changed to XXXXX…

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
mem5113
Posts: 1
Joined: Wed Jan 22, 2020 3:26 am

Spreadsheet data lost, changed to XXXXX…

Post by mem5113 »

Been using spreadsheet for about a year now to record all my purchases and expenses for a new house build. I have not had any problems, till today. I opened as usual and went up to recents and chose my spreadsheet file. It opened a page not in spreadsheet format but was had all fields as XXXXXXXXXXXXXXXX. I closed without getting a prompt to save or discard. I went back to the home page and specifically chose the spreadsheet option and went to open, found my spreadsheet file and opened it again to again all XXXXXXXXXXXXXXX. how do I get my old file back? (There are over 286 entries on the spreadsheet) What might I have done wrong to cause this?
Last edited by MrProgrammer on Wed Jan 22, 2020 10:25 pm, edited 1 time in total.
Reason: Changed title, Was: Problem with spreadsheet
Windows 10 open office 4.1.1_WIN_x86
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Problem with spreadsheet

Post by RusselB »

Welcome to the Forums.
While the character you are reporting (X) is different from the one usually reported, namely #, I suspect that you have the same problem.
Please see The Dreaded Pound Signs as well as How to un-delete AOO temporary files
The usual cause for this is a hasty or unexpected system shutdown. The file format that AOO saves in requires more time than others.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Post Reply