← Back to team overview

desktop-packages team mailing list archive

[Bug 691813] Re: "precision as shown" causes incorrect arithmetic

 

** Changed in: openoffice.org (Ubuntu)
       Status: Confirmed => Won't Fix

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

Title:
  "precision as shown" causes incorrect arithmetic

Status in “libreoffice” package in Ubuntu:
  Invalid
Status in “openoffice.org” package in Ubuntu:
  Won't Fix

Bug description:
  Binary package hint: openoffice.org-calc

  When the "Precision as shown" option is enabled in Calc, formulas
  performing arithmetic using cell references produce incorrect results.

  Steps to reproduce:

  1.  Under Tools->Options->OpenOffice.org Calc->Calculate, check the "Precision as shown" option.
  2. In cell A1, enter the number 3.
  3. In cell A2, enter the number 2.
  4. In cell A3, enter the formula =A1+A2.  Observe that the result is 0 instead of 5.

  Subtraction, multiplication, and division also produce incorrect
  results.

  ***
  2011-02-10 - cannot reproduce in Libreoffice 3.3, Maverick -- leighman
  ***

  ProblemType: Bug
  DistroRelease: Ubuntu 10.04
  Package: openoffice.org-calc 1:3.2.0-7ubuntu4.1
  ProcVersionSignature: Ubuntu 2.6.32-26.48-generic 2.6.32.24+drm33.11
  Uname: Linux 2.6.32-26-generic x86_64
  Architecture: amd64
  Date: Fri Dec 17 22:29:43 2010
  InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release amd64 (20091027)
  ProcEnviron:
   PATH=(custom, user)
   LANG=en_US.utf8
   SHELL=/bin/bash
  SourcePackage: openoffice.org

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/691813/+subscriptions