Page 1 of 1

ARGH! All data in 2 files replaced with # signs!!!

PostPosted: Tue Apr 09, 2019 9:39 pm
by fig4159
I've been using OpenOffice for a long time - but this seems to be the only forum I can post in without choosing a specific program.

A few minutes ago, something VERY strange happened: the program turned 2 of my files (1 Writer, 1 Calc) and turned the ENTIRE CONTENTS into #' signs! I'm in full freak out mode, because that Calc file holds (and I HOPE it still does!) ALL my personal financial data.

I'm not sure what caused it. My PC was lagging but I properly and successfully shut Office down BEFORE I rebooted my computer. When it restarted, I opened Office, and it asked me for my name! That was confusing, but since it wouldn't let me ignore it, I re-entered it. But, when I re-opened the fles, ALL DATA in both files has been changed to POUND (#) signs!, and the spreadsheet, which had multiple pages, looks like a text document!

HOW CAN I FIX THIS? I didn't save the new documents, but I also wasn't given an option to.

Thank you SO MUCH in advance!

.

Re: ARGH! All data in 2 files replaced with # signs!!!

PostPosted: Tue Apr 09, 2019 10:02 pm
by Hagar Delest
Hi and welcome to the forum!

Sorry, see: [Tutorial] The Dreaded Pound Signs: file reduced to ####.
Good luck.

I hope you had backups.

Re: ARGH! All data in 2 files replaced with # signs!!!

PostPosted: Tue Apr 09, 2019 10:42 pm
by RoryOF
You may have been over hasty between the close down of OpenOffice and the reboot, not leaving sufficient time for the files to be flushed to disk from the internal budffering of the hard drive; or perhaps the lag of the computer abnormally slowed up the disk writing, leading to the files not being fully written. The process of writing the files is complex and the archive that is the OO file is built, with space reserved for the actual content, which is last to be written - hence the ### placeholders.

Look at [Tutorial] How to find and un-delete AOO temporary files
for methods of recovering deleted anbd temporary copies of your files. Do this soonest. You may, or may not, find such files containig some, all, or none of your data.

Re: ARGH! All data in 2 files replaced with # signs!!!

PostPosted: Wed Apr 10, 2019 6:55 am
by Zizi64
HOW CAN I FIX THIS?

There is not any way.

But you must ask this - for your future works:
HOW CAN I prevent THIS?

The answer:
Make often backup files with timestamped file name. Then you will able get the last working version from the backup directory.
You can use the timeStamp Backup extension:
https://extensions.libreoffice.org/exte ... amp-backup.