Lost File

classic Classic list List threaded Threaded
8 messages Options
JW
Reply | Threaded
Open this post in threaded view
|

Lost File

JW
I’ve been using Open Office for quite awhile and it seemed to be working well.

A few weeks ago, I tried to open one of my spreadsheets and it wouldn’t open, my computer kept trying to open it in Excel.  Tried again today, same thing, so I reinstalled Open Office.

I am still unable to open this file.  However, I am able to open an older file.

Question:  Is there a a way to retrieve the file I’m trying to open from a previous save?  Or am I out of luck and it is gone forever?

Thank you in advance for the assist.

JW

Sent from Mail for Windows 10



---
This email has been checked for viruses by AVG.
https://www.avg.com
Reply | Threaded
Open this post in threaded view
|

Re: Lost File

W. Robert J. Funnell, Prof.
On Fri, 23 Aug 2019, JW wrote:

> I’ve been using Open Office for quite awhile and it seemed to be working well.
>
> A few weeks ago, I tried to open one of my spreadsheets and it wouldn’t open, my computer kept trying to open it in Excel.  Tried again today, same thing, so I reinstalled Open Office.
>
> I am still unable to open this file.  However, I am able to open an older file.
>
> Question:  Is there a a way to retrieve the file I’m trying to open from a previous save?  Or am I out of luck and it is gone forever?

Have you tried right-clicking on the file? When you do that, does a
menu pop up which includes 'Open with'? If you click on that you
should be able to select OpenOffice as the application to open your
file with. You should also be able to check a box so that OpenOffice
is used by default to open your file in the future.

- Robert

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Lost File

Brian Barker-2
In reply to this post by JW
At 15:58 23/08/2019 -0500, Jonly Wonly wrote:
>I've been using Open Office for quite a while and it seemed to be
>working well. A few weeks ago, I tried to open one of my
>spreadsheets and it wouldn't open, my computer kept trying to open it in Excel.

Your operating system keeps "associations" by which it remembers
which application it thinks you want it to use by default for files
of certain types when you double-click these outside any application.
You have kept your operating system a secret, but you appear to be
using Windows 10. Microsoft's updates have sometimes been known to
modify these associations to point some file types back to Microsoft
Office products instead of what you are used to. You may have a trial
version of Microsoft Office (including Excel) installed - or vestiges
of it - that came with your system when supplied.

You can very easily open a document file in any application you
choose that is capable of handling it. If you wish to open your
existing document in OpenOffice, first start OpenOffice - using a
desktop icon you may have or certainly the programs list obtainable
from the Start button (bottom left corner of screen). From *within*
OpenOffice, use File | Open... to browse to and open your document
file. If this doesn't work, your document file is corrupted.

>Tried again today, same thing, so I reinstalled Open Office.

Since your problem is with your operating system attempting to use an
inappropriate application, the problem cannot be with OpenOffice. So
no need for or purpose in reinstallation.

>I am still unable to open this file.

Try from within OpenOffice, as explained above.

>Question: Is there a way to retrieve the file I'm trying to open
>from a previous save?

Go back to your most recent back-up copy of your document and
continue working from there. Because problems can happen at any time,
you need to keep regular, reliable back-up copies of all your files
on some external device - perhaps a flash drive or an external drive
or somewhere in the cloud. Put simply, any document of which you have
only one copy you don't really have at all. You may want to keep
hard-copy back-ups too, so that any document could be reconstructed
if absolutely necessary.

But try this:
o In OpenOffice, go to Tools | Options... | OpenOffice | Paths.
o Make a note of the path shown for Backups.
o Outside OpenOffice - using your operating system's facilities (File
Explorer in Windows 10) - navigate to that folder.
o Is there a file with the same name as your document file but with
the .bak extension?
o If so, *make a copy of this in one of your own folders*, rename the
copy to change its extension to the original (.ods?), and open this
file in OpenOffice. Continue working from there.

If there is no back-up file present, it may be that you do not have
this option selected. Go to Tools | Options... | Load/Save | General
| Save, and tick "Always create a backup copy". That will be no help
for the present problem, of course, but might help in the future.

If I'm right and your problem is with changed associations, you can
reset them easily:

Either:
o Right-click a file of the relevant type and choose Open with >.
o Select OpenOffice (or browse to it if necessary).
o Before clicking OK, tick the "Always use this app ..." box.

Or:
o Go to Start | Settings | Apps | Default apps | Choose default apps
by file type.
o Select your preferred application for each relevant file type -
identified by its file name extension.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Lost File

Steven Ahlers
In reply to this post by JW
JW,

Right click on the file, chose “Open With...”, chose “OpenOffice Calc” (you may have to search in “More apps ⬇️”), chose “OK” it should open in Calc. You can tick the “Always use this app to open [extension] files” box if you only want this file type to open in Calc.

You can also accomplish this by right clicking on the file, chose “Properties” click on “Change” and chose “OpenOffice Calc” as above.

Please respond to:
[hidden email]
to let us know if you were successful or not.

Steve

Sent from my iPhone

> On Aug 23, 2019, at 3:58 PM, JW <[hidden email]> wrote:
>
> I’ve been using Open Office for quite awhile and it seemed to be working well.  
>
> A few weeks ago, I tried to open one of my spreadsheets and it wouldn’t open, my computer kept trying to open it in Excel.  Tried again today, same thing, so I reinstalled Open Office.
>
> I am still unable to open this file.  However, I am able to open an older file.
>
> Question:  Is there a a way to retrieve the file I’m trying to open from a previous save?  Or am I out of luck and it is gone forever?
>
> Thank you in advance for the assist.
>
> JW
>
> Sent from Mail for Windows 10
>
>
>
> ---
> This email has been checked for viruses by AVG.
> https://www.avg.com
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Lost File

Steven Ahlers
Forwarding to users group

Sent from my iPhone

> On Aug 25, 2019, at 3:36 PM, [hidden email] wrote:
>
> Thank you Steve.
>
> I was able to open the file by right clicking on Open Office Calc by choosing “Open With”.
>
> The file opened, but all the data is gone. Is there a way to pull the data from an older saved date and populate the spreadsheet with it?  Could it be in the Cloud?
>
> JW
>
> Sent from my iPhone
>
>> On Aug 23, 2019, at 6:06 PM, Steven Ahlers <[hidden email]> wrote:
>>
>> JW,
>>
>> Right click on the file, chose “Open With...”, chose “OpenOffice Calc” (you may have to search in “More apps ⬇️”), chose “OK” it should open in Calc. You can tick the “Always use this app to open [extension] files” box if you only want this file type to open in Calc.
>>
>> You can also accomplish this by right clicking on the file, chose “Properties” click on “Change” and chose “OpenOffice Calc” as above.
>>
>> Please respond to:
>> [hidden email]
>> to let us know if you were successful or not.
>>
>> Steve
>>
>> Sent from my iPhone
>>
>>> On Aug 23, 2019, at 3:58 PM, JW <[hidden email]> wrote:
>>>
>>> I’ve been using Open Office for quite awhile and it seemed to be working well.  
>>>
>>> A few weeks ago, I tried to open one of my spreadsheets and it wouldn’t open, my computer kept trying to open it in Excel.  Tried again today, same thing, so I reinstalled Open Office.
>>>
>>> I am still unable to open this file.  However, I am able to open an older file.
>>>
>>> Question:  Is there a a way to retrieve the file I’m trying to open from a previous save?  Or am I out of luck and it is gone forever?
>>>
>>> Thank you in advance for the assist.
>>>
>>> JW
>>>
>>> Sent from Mail for Windows 10
>>>
>>>
>>>
>>> ---
>>> This email has been checked for viruses by AVG.
>>> https://www.avg.com
>>>
>>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Lost File

Steven Ahlers
In reply to this post by Steven Ahlers
JW,

In windows you can backtrack on your timeline to an older backup to restore all files. Or you could go directly to your backups and restore that file.

Please respond to:
[hidden email]
so that ALL users can assist you.

Sent from my iPhone

> On Aug 25, 2019, at 3:36 PM, [hidden email] wrote:
>
> Thank you Steve.
>
> I was able to open the file by right clicking on Open Office Calc by choosing “Open With”.
>
> The file opened, but all the data is gone. Is there a way to pull the data from an older saved date and populate the spreadsheet with it?  Could it be in the Cloud?
>
> JW
>
> Sent from my iPhone
>
>> On Aug 23, 2019, at 6:06 PM, Steven Ahlers <[hidden email]> wrote:
>>
>> JW,
>>
>> Right click on the file, chose “Open With...”, chose “OpenOffice Calc” (you may have to search in “More apps ⬇️”), chose “OK” it should open in Calc. You can tick the “Always use this app to open [extension] files” box if you only want this file type to open in Calc.
>>
>> You can also accomplish this by right clicking on the file, chose “Properties” click on “Change” and chose “OpenOffice Calc” as above.
>>
>> Please respond to:
>> [hidden email]
>> to let us know if you were successful or not.
>>
>> Steve
>>
>> Sent from my iPhone
>>
>>> On Aug 23, 2019, at 3:58 PM, JW <[hidden email]> wrote:
>>>
>>> I’ve been using Open Office for quite awhile and it seemed to be working well.  
>>>
>>> A few weeks ago, I tried to open one of my spreadsheets and it wouldn’t open, my computer kept trying to open it in Excel.  Tried again today, same thing, so I reinstalled Open Office.
>>>
>>> I am still unable to open this file.  However, I am able to open an older file.
>>>
>>> Question:  Is there a a way to retrieve the file I’m trying to open from a previous save?  Or am I out of luck and it is gone forever?
>>>
>>> Thank you in advance for the assist.
>>>
>>> JW
>>>
>>> Sent from Mail for Windows 10
>>>
>>>
>>>
>>> ---
>>> This email has been checked for viruses by AVG.
>>> https://www.avg.com
>>>
>>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Lost File

Lucetta
Another low tec suggestion for the future.

When I open a data file, any data file, I save as with the same name but the current date in my Documemts folder. It’s is just another process but  manual & glitch proof. It has come in handy several times.

Also low tec and not sure if it will  answer you question. You can go to your older version highlight everything then control c, go to a new spreadsheet, click on top left cell and control v to paste your old copied data into your new blank spreadsheet. Then check to see if the formulas are still intact. If not manually insert them into a new inserted column or row as necessary.

Good luck!
Lucetta





> On Aug 25, 2019, at 7:58 PM, Steven Ahlers <[hidden email]> wrote:
>
> JW,
>
> In windows you can backtrack on your timeline to an older backup to restore all files. Or you could go directly to your backups and restore that file.
>
> Please respond to:
> [hidden email]
> so that ALL users can assist you.
>
> Sent from my iPhone
>
>> On Aug 25, 2019, at 3:36 PM, [hidden email] wrote:
>>
>> Thank you Steve.
>>
>> I was able to open the file by right clicking on Open Office Calc by choosing “Open With”.
>>
>> The file opened, but all the data is gone. Is there a way to pull the data from an older saved date and populate the spreadsheet with it?  Could it be in the Cloud?
>>
>> JW
>>
>> Sent from my iPhone
>>
>>> On Aug 23, 2019, at 6:06 PM, Steven Ahlers <[hidden email]> wrote:
>>>
>>> JW,
>>>
>>> Right click on the file, chose “Open With...”, chose “OpenOffice Calc” (you may have to search in “More apps ⬇️”), chose “OK” it should open in Calc. You can tick the “Always use this app to open [extension] files” box if you only want this file type to open in Calc.
>>>
>>> You can also accomplish this by right clicking on the file, chose “Properties” click on “Change” and chose “OpenOffice Calc” as above.
>>>
>>> Please respond to:
>>> [hidden email]
>>> to let us know if you were successful or not.
>>>
>>> Steve
>>>
>>> Sent from my iPhone
>>>
>>>> On Aug 23, 2019, at 3:58 PM, JW <[hidden email]> wrote:
>>>>
>>>> I’ve been using Open Office for quite awhile and it seemed to be working well.  
>>>>
>>>> A few weeks ago, I tried to open one of my spreadsheets and it wouldn’t open, my computer kept trying to open it in Excel.  Tried again today, same thing, so I reinstalled Open Office.
>>>>
>>>> I am still unable to open this file.  However, I am able to open an older file.
>>>>
>>>> Question:  Is there a a way to retrieve the file I’m trying to open from a previous save?  Or am I out of luck and it is gone forever?
>>>>
>>>> Thank you in advance for the assist.
>>>>
>>>> JW
>>>>
>>>> Sent from Mail for Windows 10
>>>>
>>>>
>>>>
>>>> ---
>>>> This email has been checked for viruses by AVG.
>>>> https://www.avg.com
>>>>
>>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Lost File

Rory O'Farrell
On Mon, 26 Aug 2019 08:43:18 -0400
Lucetta <[hidden email]> wrote:

> Another low tec suggestion for the future.
>
> When I open a data file, any data file, I save as with the same name but the current date in my Documemts folder. It’s is just another process but  manual & glitch proof. It has come in handy several times.
>
> Also low tec and not sure if it will  answer you question. You can go to your older version highlight everything then control c, go to a new spreadsheet, click on top left cell and control v to paste your old copied data into your new blank spreadsheet. Then check to see if the formulas are still intact. If not manually insert them into a new inserted column or row as necessary.
>
> Good luck!
> Lucetta
>

There is an extension to do this, at
https://extensions.libreoffice.org/extensions/timestamp-backup
which runs on OpenOffice.

This gives a toolbar button to make a timed/dated backup of the current file.  Note that it does not replace /File /Save, but if one was familiar with toolbar editing, it could be made do so.


--
Rory O'Farrell <[hidden email]>

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]