← Back to team overview

desktop-packages team mailing list archive

[Bug 806403] Re: Libreoffice basic function "cdbl" ignores decimal numbers

 

You are right. I have tried like this:

kurgan@budell:~$ LANG=it_IT libreoffice

(process:4101): Gdk-WARNING **: locale not supported by C library

(soffice:4101): Gtk-WARNING **: Locale not supported by C library.
	Using the fallback 'C' locale.

and it works despite the errors.


What I really DON'T like is the fact that on the Openoffice bugzilla the bug got closed because basically they cannot understand it. I don't like openoffice at all, but there are no alternatives. And so we have to stick with buggy software, incomplete and buggy macro language, and so on.

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