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