← Back to team overview

desktop-packages team mailing list archive

[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers

 

** Changed in: df-libreoffice
       Status: Confirmed => New

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

Title:
  [upstream] Calc precision error subtracting 3 integers

Status in LibreOffice Productivity Suite:
  New
Status in The OpenOffice.org Suite:
  In Progress
Status in “libreoffice” package in Ubuntu:
  Triaged
Status in “openoffice.org” package in Ubuntu:
  Won't Fix

Bug description:
  Binary package hint: openoffice.org

  1)  lsb_release -rd
  Description:	Ubuntu 11.04
  Release:	11.04

  2) apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:3.3.2-1ubuntu5
    Candidate: 1:3.3.2-1ubuntu5
    Version table:
   *** 1:3.3.2-1ubuntu5 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
          100 /var/lib/dpkg/status
       1:3.3.2-1ubuntu4 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

  3) What is expected to happen in LibreOffice Calc via the Terminal:

  cd ~/Desktop && wget
  https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/340051/+attachment/486207/+files/openoffice.summation.bug.ods
  && localc openoffice.summation.bug.ods

  is that cell A1=806515533049393 cell B1=1 cell C1=806515533049393 and
  cell D1=A1-B1-C1=-1.

  4) What happens instead is cell D1 is 0.

  WORKAROUND: Use Gnumeric.

  apt-cache policy gnumeric
  gnumeric:
    Installed: 1.10.13-1ubuntu1
    Candidate: 1.10.13-1ubuntu1
    Version table:
   *** 1.10.13-1ubuntu1 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
          100 /var/lib/dpkg/status

  WORKAROUND: If the contents of B1 and C1 are swapped, the correct
  answer of -1 is given.

  Original Reporter comments: OpenOffice 2.4.1 on x86 Ubuntu 8.10
  Intrepid Ibex. This error did not occur when performing the same
  numerical calculation in the bash shell: echo $((a-1-a)).

  ProblemType: Bug
  Architecture: i386
  DistroRelease: Ubuntu 8.10
  NonfreeKernelModules: nvidia
  Package: openoffice.org-core 1:2.4.1-11ubuntu2.1
  ProcEnviron:
   PATH=/usr/lib/openoffice/program:/home/username/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/real/RealPlayer
   LANG=en_CA.UTF-8
   SHELL=/bin/bash
  SourcePackage: openoffice.org
  Uname: Linux 2.6.27-11-generic i686

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions