3.6 Calc Problem

users
#1

I am having a problem with Calc in 3.6.
The program locked up while I was using it. The only way I could
get it to start again was to shut the computer off. However, now
when I try to call up an existing spreadsheet or try to start a new
one the program tries to recover the old file. I go through the
recovery steps. The old file is recovered, it appears on
the screen for an instant and then disappears. The program reverts
to the initial screen for LO. This only happens with Calc and, as I
said, happens when I try to use both new and existing files. If I reject trying to recover the old file the program reverts to LO's initial screen. I have uninstalled and reinstalled the
program three times ( twice using the uninstall function in Windows,
once when I downloaded a new copy of LO and elected the "Remove" option. It did not help. I also used CCleaner to remove the
temp files, etc. after I uninstalled LO. I have also used the search function in Windows to find all of the "Untitled" Calc files and deleted them to no avail. The other LO functions (Writer, Presentation, etc.)
seem to be working normally. I should also report that when the
problem first appeared I had a problem with Windows 7 at the same
time. The Windows problem was corrected before I started to
uninstall/install the program to try to correct the above problem. It would seem that there is a temporary
files somewhere that remains in the computer even if LO is
uninstalled. I shut the computer off after an "uninstall" so I assume the file isn't in memory. All suggestions will be appreciated. Thanks.Jeff

#2

This is not a typical Windows program so re-installing it might not change anything at all. Reset your user profile instead.
Unfortunately, it tries to look like a real Windows program. Turn off the nasty quick starter for ever (disable it in a custom installation) so you can be sure that the program does not keep on running after you closed the last window.

http://user.services.openoffice.org/en/forum/viewtopic.php?f=6&t=55644&p=244227&hilit=ccleaner#p244227

Am 25.08.2012 05:40, Jeff Hahn wrote:

#3

Hi :slight_smile:
This guide about user-profiles and "getting back to factory defaults" is adapted from the original one written for OpenOffice.org by Hagar Delest and he kindly checked it for accuracy
https://wiki.documentfoundation.org/Documentation/UserProfile
Regards from
Tom :slight_smile:

#4

Hi :slight_smile:
Has this problem been fixed yet? There might be a hidden file in the same
folder the original document was in and has a name with ~lock in it
somewhere. Deleting that file should get things back to normal. Usually
there is a ~lock file in the UserProfile somewhere so hopefully renaming
your user profile to force LO to generate a new one should have done the
trick.
Regards from
Tom :slight_smile:

#5

Hi,

how to find out the FilterName of a loaded document?
(other than try to "save under" and look what is marked)
I would like to find it by a Basic Makro, but didnt find a hint even in Andrew
Pitonyaks marvellous guide.

a sequelae: Does anybody know, how a document is stored in memory? Is it
different i.e. for a Word.doc and an vnd.oasis Dokument?

Thanks for your help

Walther

#6

Hi :slight_smile:
My guess is that it is very different.  The formats are very different from each other.
Regards from
Tom :slight_smile:

#7

you can find the file extention at the endof the location url (Thiscomponent.location)

Hope it helps

fernand

#8

Am 29.08.2012 17:00, Walther Koehler wrote:

Hi,

how to find out the FilterName of a loaded document?
(other than try to "save under" and look what is marked)
I would like to find it by a Basic Makro, but didnt find a hint even in Andrew
Pitonyaks marvellous guide.

a sequelae: Does anybody know, how a document is stored in memory? Is it
different i.e. for a Word.doc and an vnd.oasis Dokument?

Thanks for your help

Walther

menu:File>Properties... (first tab, Type)

#9

Am 29.08.2012 17:00, Walther Koehler wrote:

Hi,

how to find out the FilterName of a loaded document?
(other than try to "save under" and look what is marked)
I would like to find it by a Basic Makro, but didnt find a hint even in Andrew
Pitonyaks marvellous guide.

a sequelae: Does anybody know, how a document is stored in memory? Is it
different i.e. for a Word.doc and an vnd.oasis Dokument?

Thanks for your help

Walther

com.sun.star.frame.XModel.getArgs() [array of c.s.s.beans.PropertyValue] includes a property "FilterName"

#10

Yep, thats the one.... I think that it is in AndrewBase...