You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by JW <ab...@gmail.com> on 2019/08/23 20:58:00 UTC
Lost File
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
Re: Lost File
Posted by Brian Barker <b....@btinternet.com.INVALID>.
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: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Lost File
Posted by "W. Robert J. Funnell, Prof." <ro...@mcgill.ca>.
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: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Lost File
Posted by Rory O'Farrell <of...@iol.ie>.
On Mon, 26 Aug 2019 08:43:18 -0400
Lucetta <lu...@lucetta.ca> 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 <of...@iol.ie>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Lost File
Posted by Lucetta <lu...@lucetta.ca>.
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 <sa...@yahoo.com.invalid> 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:
> users@openoffice.apache.org
> so that ALL users can assist you.
>
> Sent from my iPhone
>
>> On Aug 25, 2019, at 3:36 PM, abbydakotagold@gmail.com 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 <sa...@yahoo.com> 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:
>>> users@openoffice.apache.org
>>> to let us know if you were successful or not.
>>>
>>> Steve
>>>
>>> Sent from my iPhone
>>>
>>>> On Aug 23, 2019, at 3:58 PM, JW <ab...@gmail.com> 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: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Lost File
Posted by Steven Ahlers <sa...@yahoo.com.INVALID>.
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:
users@openoffice.apache.org
so that ALL users can assist you.
Sent from my iPhone
> On Aug 25, 2019, at 3:36 PM, abbydakotagold@gmail.com 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 <sa...@yahoo.com> 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:
>> users@openoffice.apache.org
>> to let us know if you were successful or not.
>>
>> Steve
>>
>> Sent from my iPhone
>>
>>> On Aug 23, 2019, at 3:58 PM, JW <ab...@gmail.com> 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: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Lost File
Posted by Steven Ahlers <sa...@yahoo.com.INVALID>.
Forwarding to users group
Sent from my iPhone
> On Aug 25, 2019, at 3:36 PM, abbydakotagold@gmail.com 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 <sa...@yahoo.com> 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:
>> users@openoffice.apache.org
>> to let us know if you were successful or not.
>>
>> Steve
>>
>> Sent from my iPhone
>>
>>> On Aug 23, 2019, at 3:58 PM, JW <ab...@gmail.com> 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: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Lost File
Posted by Steven Ahlers <sa...@yahoo.com.INVALID>.
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:
users@openoffice.apache.org
to let us know if you were successful or not.
Steve
Sent from my iPhone
> On Aug 23, 2019, at 3:58 PM, JW <ab...@gmail.com> 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: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org