OOVirg – A Comma with OpenOffice.org

Download ! (sources included)(If needed, supplementary DLLs : here, and older version here)
Windows 95 users only : Download the special Win95 version (If needed, MFC42’s DLL win95 version.

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.

 

Latests news

04/12/2004

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.

 

25/04/2004

  • 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.

 

07/03/2004

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.

 

21/06/2003

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.

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.

Download the latest version!
You may need these extra DLL : redistributables DLLs Microsoft VC.

Debug version (if you encounter some problems)
Please download theses debug DLL : Debug redistributables DLLs Microsoft.

Installation

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.

Configuration

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.

Screenshot

 

 

 

Licence

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 : remi+ooovirg@via.ecp.fr.

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 C:WindowsSystem32.

The program does not appear to function.

Go in the configuration panel, check the “Actif sur toutes les fenetres” item, and restart the program.

Another solution

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.

 

A free Microsoft Keyboard Layout Creator is available from Microsoft, for Windows 2000 / XP / 2003. It allows you to create an installable custom keyboard. Here is some help.

 

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 :

 

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 :

Launch loadkbdhood.exe.

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Close Menu