- Latests news
- OpenOffice.org and the decimal separator
- First solution : ask OpenOffice.org to use a point as decimal separator
- Second solution : a small utility OOoVirg.
- Another solution
- Another good solution for Windows 2000 or higher.
- Older versions of this software
Possible solutions are :
Set up OpenOffice.org to use a point as decimal separator instead.
OOoVirg, a tool that will replace the dot by a comma only when using OpenOffice.org
Change permanently the decimal point by a comma in the registry.
Create a new keyboard with a comma with the Microsoft Keyboard Creator.
For Linux, or for an older version, please see this page.
I have received a feature request about the comma be replaced in dialogs. I have found a solution, which is in testing state. To help me to test, just download the oovirghk.dll file, replace your current version by it, and restart OOoVirg. Please let me known in case of problems.
- Problems have been reported with the exe name’s filter : conflicts with Win95 systems, and does not work with NT systems. It has been removed.
- Internationalization : the UI should have a default english langage on non french systems (should, because I have not been able to test it :-). Strings are now easy to translate, only the resources file has to be modified.
- Improved the iconisation system.
New version of OOoVirg, that solves :
- Conflicts with software using other keyboard hooks (iTouch de Logitech, Autocad,…)
- Traybar icon too similar with the one of the Quick Launch of OpenOffice.org (Thanks to Frédéric Vuillod)
- A Win95 problem (DLL not found), caused by the long name of the DLL.
OOoVirg is now under L-GPL license. It can now be directly integrated in OpenOffice.org. To contribute to this integration, or to have more information, please consult the issue 1820, IssueZilla on www.OpenOffice.org.
The package proposed to the OOo team is : ooovirg_integration.zip. It contains some remarks, a better solution for Windows, and a xmodmap solution for Linux.
So this piece of software should be soon obsolete.
OpenOffice.org and the decimal separator
In some languages (as french by instance), the decimal separator is a comma, but there is a point on the numpad. That is not very handy, as you cannot type a decimal number with the numpad. The goal of OOoVirg is to solve this issue, by replacing the point of the numpad by a comma, as Excel does.
First solution : ask OpenOffice.org to use a point as decimal separator
This is described in the french FAQ (http://fr.openoffice.org/FAQ/calc_fr/c25fr.html). Just choose the option “English” in the options
Format / Cellules / Nombres.<br></br>
Second solution : a small utility OOoVirg.
If you prefer to keep a comma as decimal separator, I wrote a small tool that will replace the numpad point by a comma, only in OpenOffice.org applications. Other applications will remain unaffected.
This program appears in the TrayBar, next to the clock : you will find the OpenOffice.org logo with a comma.
This program must be relaunched each time Windows reboots. I suggest you to put it in your Programs/Startup in the Start menu. Just drag and drop the executable in the menu.
The default configuration should be ok for 1.0.x and 1.1.x versions of OpenOffice.org. You can adapt it for other versions, or for StarOffice (versions 5 or 6) by double-clicking on the TrayIcon, modifying the configuration in the dialog, saving and relaunching the application.
The program has not been translated yet, so please find the meaning of the options below.
Methods to select if the numpad point should be replaced :
- “Actif sur toutes les fenêtres” (All) : all windows are affected.
- “Actif sur les fenetres ayant dans leur titre” (Title) : if this option is checked, the windows title must contain the provided text.
- “Actif sur les fenetres ayant dans le nom de classe” (ClassName) : if this option is checked, the class name of the window must contain the provided text.
- “Actif sur les fenetres de l’éxécutable” (Executable) : if this option is checked, the numpad point will be replaced only if the windows belongs to the provided executable name (Does not always works.)
If you combine several options (excluded the first one), the windows must satisfy all of them.
This software is free, and distributed under L-GPL licence. You can modify and improve it regarding your needs, as long as you respect the L-GPL licence.
More information : [email protected].
Support / FAQ
This program has been sucessfully used on Windows 2000 / XP, Windows 95 / 98SE / ME. But if you encounter a problem check the FAQ below :
Windows says “File not found : OOVirgHook.dll”
Copy this file (distributed in the zip package) in
The program does not appear to function.
Go in the configuration panel, check the “Actif sur toutes les fenetres” item, and restart the program.
With Windows 2000/XP, you can permanently change the behaviour of a key (regardless the application). I do not use this method, as this is not very handy, but if you are intersted, please go on this page where the principle is explained. Michel Bigle has done this for you, and here is mapcomma.reg, a simple registry file to map permanently the decimal separator of the numpad to a comma.
Another good solution for Windows 2000 or higher.
Here is an example made by Michel Bigle : mskc_decimal.zip will map the numpad decimal separator to a comma. What is very nice with this method is the facility to switch from a keyboard to another, as it is completly integrated in the Windows Keyboard management :
As you can see, you just have to click on the keyboard you want (Custom : with a comma, and France : with a decimal point)
Older versions of this software
KbdHook for StarOffice 5.2 :