Page 1 of 1

Lost spreadsheet (###)

Posted: Sat Nov 14, 2015 6:46 pm
by marks1
I moved my computer and the spreadsheet that was using has been lost. How can I get it back?

Re: lost spreadsheet

Posted: Sat Nov 14, 2015 6:51 pm
by floris v
That's very little information to go on. How do you mean it was lost? Did OO Calc crash? Didn't you save it? If there is a file, in what shape is it? Please help us help you.

Re: lost spreadsheet

Posted: Sat Nov 14, 2015 7:51 pm
by marks1
The spreadsheet auto saves everytime I close it. Nothing crashed. When opening the spreadsheet I retrieve it from "file" tab and then "recent docs". I restored the computer back to the day before I moved the computer, and the template is there titled as I usually see it, but it is not current. There is a spreadsheet in that spot , but when it opens, a filter set up titled "ASC II " pops up, and then when I ok the filter the file opens with "#######" in every spot. This could be it , but I don't know how to fix the "####" problem.

Re: lost spreadsheet

Posted: Sat Nov 14, 2015 8:00 pm
by floris v
Your file is lost, sadly. See 22 pages term paper replaced with pound signs.

Re: Lost spreadsheet (###)

Posted: Sun Nov 22, 2015 9:45 am
by angeltrex
Try increasing the width of the cells that are showing #### instead of what was originally in them.

When one of the cells is selected, does it also show #### in in the input line (the long bar up the top of the screen where you can type in data.)

Re: Lost spreadsheet (###)

Posted: Sun Nov 22, 2015 10:27 am
by RoryOF
If the ### shows up in cells on the sheet, then widening the columns will help. If one gets ASCII filter message on opening and a display of ### then the file is damaged and most probably lost. This may have been caused by overhasty closure of the file and/or the computer.