at work I am dealing with a strange issue.
I am trying to convert a spreadsheet using the good old jodconverter into a PDF.
This works, except for one minute detail.
Unfortunately, the locale settings for number conversion are not taken into consideration.
E.g.: I have a number 10.90. The spreadsheet file (LibreOffice 5, OpenOffice 3 and Microsoft Excel) displays this as "10,90" (this is what I expect, since this corresponds with the locale setting within the file and even the Operating System). After converting it with the jodconverter the displayed value in the PDF is 10.90.
TL;DR: Number value in spreadsheet: 10.90, Displayed as (in spreadsheet): 10,90 (this is expected), JodConverter PDF export: 10.90 (this not expected)
On another installation [1] this works as expected.
I installed a different language for OpenOffice3, this did not help.
I have set the locale as explained here, this did not help. https://wiki.openoffice.org/wiki/Docume ... e_settings
I suspect that somewhere the locale settings are not loaded as expected.
TL;DR: Looked through wiki / web to find the common places to change Locale/Language settings to no avail.
During debug I can see that this process is running:
Code: Select all
/opt/openoffice.org3/program/soffice.bin -accept=socket,host=127.0.0.1,port=2002;urp; -env:UserInstallation=file:///tmp/.jodconverter_socket_host-127.0.0.1_port-2002 -headless -nocrashreport -nodefault -nofirststartwizard -nolockcheck -nologo -norestore
* I suspect that these have to come either from the program settings itself, but changing the language/locale settings did not fix my issue.
* Thus I suspect it loads those from somewhere else (I suspected the OS, but I was not able to prove this).
* Is there something like a config file/registry where this is stored?
TL;DR: Where is OpenOffice loading its Locale Settings from?
[1] (Microsoft Windows, OpenOffice 3, JodConverter, Windows Locales + language are/is set to German)