Libreoffice basic function "cdbl" ignores decimal numbers
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
libreoffice (Ubuntu) |
Invalid
|
Undecided
|
Unassigned |
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
ProcVersionSign
Uname: Linux 2.6.38-8-generic x86_64
NonfreeKernelMo
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=
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to natty on 2011-06-22 (13 days ago)
Changed in libreoffice (Ubuntu): | |
status: | Incomplete → New |
Changed in libreoffice (Ubuntu): | |
status: | New → Confirmed |
Fabio Muzzi, thank you for reporting this bug and helping make Ubuntu better. Could you please attach a Calc document that demonstrates this problem?