← Back to team overview

desktop-packages team mailing list archive

[Bug 264345] Re: =(-8)^(1/3)

 

** Description changed:

  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
+   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: SIGN(X)*ABS(X)^(1/3)
+ 
  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
+   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

-- 
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:
  Unknown
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: SIGN(X)*ABS(X)^(1/3)

  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