desktop-packages team mailing list archive

[Rb-henschel <264345@xxxxxxxxxxxxxxxxxx>]

The problem has been discussed in OOo too;
https://issues.apache.org/ooo/show_bug.cgi?id=37129

If you will keep rule a^(r*s) = (a^r)^s you cannot allow negative basis
a.

Excel does not allow arbitrary fractions but tests only for unit
fraction. That is not difficult. The highest such converted number is
1/(2^31-3) in Excel; 1/(2^31-1) fails.

So the question is, whether LO should implement Excels behavior for
easier converting from Excel. ODF1.2 says "POWER(a,b), where a<=0 and
INT(b)!=b, is implementation-defined." in chapter 6.16.46. So the
standard allows such solution.

If you want to use arbitrary fractions, the class TOOLS_DLLPUBLIC
Fraction from fract.hxx in tools might be useful.

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