It is obviously a "localization" problem, I experience the same issue having this environment configuration: cristian@cristian-F5N:~$ echo $LANG it_IT.utf8 cristian@cristian-F5N:~$ echo $LANGUAGE it_IT:it_CH:it:en cristian@cristian-F5N:~$ echo $LC_MESSAGES it_IT.UTF-8
And having Italian set as default language in LibreOffice. My LibreOffice version is 1:3.4.5-0ubuntu1 on Ubuntu 11.10 It seems to be a long standing bug. Cristian -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/806403 Title: Libreoffice basic function "cdbl" ignores decimal numbers Status in “libreoffice” package in Ubuntu: Confirmed Bug description: I have some macros that worked in OpenOffice (ubuntu 10.10) and do not work properly in LibreOffice (Ubuntu 11.04). I have found that the "cdbl" function, that converts a string to a double, fails at converting a number with a decimal part, like "5.5". I have run some tests, also changed the locale setting, and found that: With an italian locale setting (decimal separator is comma) cdbl("5,5") equals 5 (and not 5,5 as it should) and cdbl("5.5") equals 55. With an english locale setting (decimal separator is dot) cdbl ("5,5" equals 55 and cdbl("5.5") equals 5. I suppose that cdbl simply ignores the numbers after the decimal separator. It still can "see" the proper decimal separator, since using different locales it behaves in different but consistent ways. I suppose, but I am not sure, that also the clng function is affected by the same bug. ProblemType: Bug DistroRelease: Ubuntu 11.04 Package: libreoffice-calc 1:3.3.2-1ubuntu5 ProcVersionSignature: Ubuntu 2.6.38-8.42-generic 2.6.38.2 Uname: Linux 2.6.38-8-generic x86_64 NonfreeKernelModules: nvidia Architecture: amd64 Date: Wed Jul 6 12:15:13 2011 InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release amd64 (20091027) ProcEnviron: LANGUAGE=en_GB:en LANG=it_IT.utf8 LC_MESSAGES=en_GB.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to natty on 2011-06-22 (13 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/806403/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
