How can I reset all settings?

Hi all!

I have a question. How can I reset all settings and toolbars to defaults in LibreOffice? I already tried to unistall and reinstall LibreOffice and yes I restarted PC after unistalling but it didn't work. I still have non-default settings. I use Windows 7 (64-bit).

Sincerely

Jan Parttimaa

Download and install Revo Unistaller: http://www.revouninstaller.com/revo_uninstaller_free_download.html
Run Revo and use the 4th option to unistall LO. You will have the option to delete any and all registry links to LO and any other little "cyber-bits of info left. When you re-install LO you should have defaults.
Roxy

Hi all!

I have a question. How can I reset all settings and toolbars to defaults in LibreOffice? I already tried to unistall and reinstall LibreOffice and yes I restarted PC after unistalling but it didn't work. I still have non-default settings. I use Windows 7 (64-bit).

Sincerely

Jan Parttimaa

Message du 17/06/11 21:23
De : "Jan Parttimaa"
A : users@global.libreoffice.org
Copie à :
Objet : [libreoffice-users] How can I reset all settings?

Hi all!

I have a question. How can I reset all settings and toolbars to defaults in LibreOffice? I already tried to unistall and reinstall LibreOffice and yes I restarted PC after unistalling but it didn't work. I still have non-default settings. I use Windows 7 (64-bit).

Sincerely

Jan Parttimaa

Reset your user profile : http://user.services.openoffice.org/en/forum/viewtopic.php?p=58401#p58401

Gérard

Hi Jan,

Hi all!

I have a question. How can I reset all settings and toolbars to defaults in LibreOffice? I already tried to unistall and reinstall LibreOffice and yes I restarted PC after unistalling but it didn't work. I still have non-default settings. I use Windows 7 (64-bit).

Sincerely

Jan Parttimaa

Uninstalling in Windows may have left some user customization files on
the hard disk. During the reinstall they were not written over unless
specifically made to do it.

Are they any specific setting you want to reset to the original
default?

And change all 'openoffice.org' to 'libreoffice.org' in those instructions.

Dear Jan

I had a similar problem where I needed an as-new clean re-install

I spent many hours on this including editing the registry (never a good idea).

I wish that I had posted this first, as Roxy's idea of using Revo-Uninstall does the same (if not better) in a matter of minutes. There were other cleaners suggested, but this is the one I chose to try.

However, just out of interest, the configuration files are held in >>docs &settings/your user-name?/application data/LibraOffice << which is not deleted with the standard windows un-install (bad dog!).

If you say (do as I do in Options), change the rulers in Write to inches and the background colour to blue(chart12), you will find that 4 files are changed in this directory. I have absolutely no idea what does what and will probably never need to know.

All the best

John B

Hi :slight_smile:
There are 2 advantages to NOT un-installing users configurations when the
package is un-installed.
1. When you reinstall again later on everything is set-up the way you like it.
2. You might have templates, dictionaries, even images in the gallery that might
be painful to lose
Both can be a huge advantage when upgrading or reinstalling.

Being able to rename the config folder so that you get back to "factory
defaults" for LO saves the hassle of having to reinstall just because something
went a bit wonky. It can be an excellent quick-fi and can also be used to
trouble-shoot down to exactly where a problem occurred.

I wonder if it's possible to copy&paste the config to different machines (eg in
a corporate network) so that they all have some good settings? I might play
around with that on Wednesday (if i remember).

It does seem a bit dumb, untidy or geeky at first but allows you a lot of
finesse and control.

Regards from
Tom :slight_smile:

Hi

The standard for many years for Database files was >> *.dbf (dBase) and I have many.

It is very strange that in LibreOffice this opens up in Calc and not Base, no matter how I try to force it.

Calc is simply not good enough to handle Database files.

This is also confirmed in the File Open lists:- dBase(.dbf) is listed in Calc and it is absent from Base

Is this a bug - have I missed something ?

regards

John B

Windows XP Pro Sp3
LibreOffice 3.4

While it may be counter intiutive, it is not a bug. There is only one
Java class library which does something close to an adequate job when it
comes to DBF files, and that is the xBaseJ class library which I wrote a
book about. Despite calling dbf a "standard" there IS ABSOLUTELY NO
XBASE STANDARD. While there are some overlapping similarities due to
the fact they all stole code from the Jet Propulsion Lab to start with,
each flavor has different limitations, defaults, and characteristics.
This is especially true with indexes and memo fields.

http://www.free-ebooks.net/ebook/The-Minimum-You-Need-to-Know-About-Java-and-xBaseJ

The book is completely free. Pull it down and read up. This class
library was also the only "active" project on SourceForge, so
LibreOffice may want to include it to get DBF access for BASE.

Don't quote me, but, as I remember, BASE had to have a Java plug-in to
connect to a database entity. java-postgres-blah-blah
java-mysql-blah-blah etc. There is no java-dbf-blah-blah because there
is no dbf server.

I don't think it is a bug.

Microsoft Excel opens (imports) *.dbf files too.

There is not much that Base opens directly. Is there a jDBC connector for *.dbf that you could use?

Microsoft Access 2007 opens dBase III, IV, 5 I see (and it is the only one I have lying around that I can check). And, much to my surprise, dBase is still in production, but I guess you don't want that product.

- Dennis

Hi John,

It is very strange that in LibreOffice this opens up in Calc and not
Base, no matter how I try to force it.

Calc is simply not good enough to handle Database files.

This is also confirmed in the File Open lists:- dBase(.dbf) is listed
in Calc and it is absent from Base

Is this a bug - have I missed something ?

I don't think you have missed anything, and it may indeed be a bug,
although I can't remember for sure, and quite possibly was introduced
with the OpenOffice.org 3.3.x development line.

1) File > New > Database > Open an existing database
Navigate to your dbf file.

2) Connect to an existing database. Choose dBase from the dropdown list,
and then navigate to your dbf file.

3) A workaround is to use the Wizard for the AddressBook datasource

Define Address Book. You should see in the list of supported

db's that be default the wizard selects dBase. You can actually name
your db anything you like, all the wizard does it attribute the fields
of the Writer application to the corresponding source db fields.

Beware : there are several issues with field/value type import of the
data, depending on which version of the dBase format you are using.

Alex

...

3) A workaround is to use the Wizard for the AddressBook datasource
>>Define Address Book. You should see in the list of supported
db's that be default the wizard selects dBase. You can actually name
your db anything you like, all the wizard does it attribute the fields
of the Writer application to the corresponding source db fields.

...
Unless you are using linux... it does work in Windows.
https://bugs.freedesktop.org/show_bug.cgi?id=32948
[Address Book Data Source Wizard Doesn't Work]
Still doesn't work w/LibreOffice 3.4.1
OOO340m1 (Build:101)

Hi can anybody help

Having had excellent help from [libreoffice-users] to load a dBase file into Base, I cannot get started in the Create Form in Design View.

This is where you layout a single record for say printing the data into boxes on standard pre-printed form or as a layout to make it easier to add/ edit / phone just one record.

Usually (or what I am used to) is that on opening the Design form for the 1st time, all the Fields are automatically loaded onto the form from the current database, so I can then decide what shows (what to delete) and where on the page they go.

However, when I open the Design form in LO (3.3.3 & 3.4) it is blank and it has defeated me so far, as to how you load in all the field names.

The LO Design Form is a quite complex (powerful!) in any case (even Radio buttons), is there a tutorial on LO Base Design Forms?

thanks

John B
Windows XP Pro Sp3
LO 3.3.3 & 3.4

Hi John,

Rather than start with a blank form, use the wizard to help you create
one. After opening your ODB file, click on the Form icon on the left. In
the uppermost pane, you should see the possibility to create a new form
using the wizard. Choose this option. The wizard will give you the
possibility to add the fields that you want to your form, one, several,
or all of them. The default settings proposed can be changed once the
form has been created.

Be warned that there are currently bugs in the wizard that prevent the
user from setting the background colour, or anything other than a
background colour, and personalising the styles of the presentation of
the fields in the form, but again, you should be able to correct these
once the form has been created.

Alex

Hi Alex

I am hopeless. I tried the wizard in 3.3.3, sure enough the fields were added but displayed as a spreadsheet (as is data) instead of a re-designable format for just one record, AND the design /edit button is greyed out (as are most of the other buttons) and at the top, the wizard says "read only". There is also no matrix.

So bearing in mind what you said about creating / saving I did that in the hope that when I re-loaded it, I could edit it, but no, it opens in Word and not the Design module of Base.

It makes no sense ! - its hard work!

Also on some of my larger databases, on attempting to load, the software froze (repeatable), the cure is to delete "soffice.exe" (Ctrl-Alt-Del) and away it goes (it unfreezes) - I was so surprised.

Grrrrr

John B

No... good dog... just because I uninstall a program doesn't mean I want
my settings deleted.

But you are correct - the easiest way to 'start over' is to simply move
or delete this directory (best to move it, then if it doesn't fix your
problem, you can move it back and not lose all of your settings)...

Hi all,
just to mention it explicitly: you don't need to uninstall and
re-install if you've renamed the user profile directory. It is
already mentioned in the tutorial
(http://user.services.openoffice.org/en/forum/viewtopic.php?p=58401#p58401),
and most of the posts here did imply that. I just wanted to state it
clearly, in case there is someone reading this thread that might get
the wrong impression and think that it's required to rename the user
profile *and* re-install LibO.

Just renaming is sufficient, LibO will create a new user profile
directory the next time you launch it. The renamed user profile will
not be modified.

Regards
Stephan

Correct - and you need to rename it without the quickstarter running (if
you use it)...

Dear Tastaafl

Well said, it also made me laugh

Maybe there should be 2 levels of un-install called "un-install all" or "un-install all all"

However, just out of interest by renaming the file extension of the file:-

registrymodifications.xcu to say >> *.xcc (this file is in Dos & settings/user?/Application Data/3/user)

When I opened LO, registrymodifications.xcu was re-created and reset LO to default settings.

I then deleted this new file and renamed the old *.xcc back to *.xcu and my old settings were thankfully returned.

I think this also neatly resolves this issue of "how do I reset all settings" and without having to de & re-install LO

Thanks

John B

If you use Revo Uninstaller, you - the user - have that option.
Roxy

Dear Tastaafl

Well said, it also made me laugh

Maybe there should be 2 levels of un-install called "un-install all" or
"un-install all all"

However, just out of interest by renaming the file extension of the file:-

registrymodifications.xcu to say >> *.xcc (this file is in Dos &
settings/user?/Application Data/3/user)

When I opened LO, registrymodifications.xcu was re-created and reset LO
to default settings.

I then deleted this new file and renamed the old *.xcc back to *.xcu and
my old settings were thankfully returned.

I think this also neatly resolves this issue of "how do I reset all
settings" and without having to de & re-install LO

Thanks

John B