desktop-packages team mailing list archive

[Markus-mohrhard <264345@xxxxxxxxxxxxxxxxxx>]

Hm after an additional thought I'm not sure if it is really that simple
to implement. At the point where we calculate the power we no longer
have the information that we had a fraction as exponent.

I wonder how excel solves this problem. I suspect that we would have the
same problem with ixion.

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

Title:
  =(-8)^(1/3)

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

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

  2) apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:3.3.3-1ubuntu2
    Candidate: 1:3.3.3-1ubuntu2
    Version table:
   *** 1:3.3.3-1ubuntu2 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 is when one types in a cell:

  =(-8)^(1/3)

  one gets -2 as the answer.

  4) What happens instead is one receives #VALUE! as the answer.

  WORKAROUND: Use Excel in WINE.

  Microsoft Office Excel 2003 (11.5612.6505)

  apt-cache policy wine1.3
  wine1.3:
    Installed: 1.3.28-0ubuntu1~ppa1~natty1
    Candidate: 1.3.28-0ubuntu1~ppa1~natty1
    Version table:
   *** 1.3.28-0ubuntu1~ppa1~natty1 0
          500 http://ppa.launchpad.net/ubuntu-wine/ppa/ubuntu/ natty/main i386 Packages
          100 /var/lib/dpkg/status
       1.3.15-0ubuntu5 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages

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