This bug has sat incomplete for 6 months. Marking invalid.
** Changed in: libreoffice (Ubuntu)
Status: Incomplete => Invalid
--
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:
Invalid
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 : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
