← Back to team overview

desktop-packages team mailing list archive

[Bug 656575] Re: [Upstream] Calc help does not mention when Err:502 caused by SQRT(-1) use IMSQRT

 

Launchpad has imported 6 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=34952.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2011-03-03T04:27:40+00:00 Christopher M. Penalver wrote:

Downstream bug may be found at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/656575

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

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.1-1ubuntu3~maverick1
  Candidate: 1:3.3.1-1ubuntu3~maverick1
  Version table:
 *** 1:3.3.1-1ubuntu3~maverick1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
        100 /var/lib/dpkg/status

3) What is expected to happen is when one opens a new spreadsheet, and
types in first row, first column:

=sqrt(-1)

and it displays Err:502 pressing F1 for help on this error presents
information regarding how this can be caused by a negative under a
square root.

4) For LibreOffice wiki
http://help.libreoffice.org/Calc/Error_Codes_in_Calc this is not
displayed. It would be nice if it did.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/656575/comments/11

------------------------------------------------------------------------
On 2011-03-03T14:19:25+00:00 Cedric-bosdonnat-ooo wrote:

Sophie, can you have a look at this?

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/656575/comments/12

------------------------------------------------------------------------
On 2011-03-03T18:18:42+00:00 Christopher M. Penalver wrote:

Regarding Error Code 502 Explanation at:
http://help.libreoffice.org/Calc/Error_Codes_in_Calc

currently it is:

"Function argument is not valid, for example, a negative number for the
root function."

It would be nice if it was:

"Function argument is not valid. For example, a negative number for the
SQRT() function, for this please use IMSQRT()."

Sorry for not putting this in the description.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/656575/comments/13

------------------------------------------------------------------------
On 2011-03-03T19:33:27+00:00 sophie wrote:

I'll take of it. Thanks for reporting - Sophie

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/656575/comments/14

------------------------------------------------------------------------
On 2011-03-03T20:10:39+00:00 Christopher M. Penalver wrote:

Updating Summary from:

[Update HC2] Calc help does not mention Err:502 caused by sqrt(-1)

to:

Calc help does not mention when Err:502 caused by SQRT(-1) use IMSQRT

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/656575/comments/15

------------------------------------------------------------------------
On 2011-11-22T14:34:13+00:00 timar wrote:

Used the suggested text in master (-> LibreOffice 3.5). Thanks.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/656575/comments/18


** Changed in: df-libreoffice
       Status: In Progress => Fix Released

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

Title:
  [Upstream] Calc help does not mention when Err:502 caused by SQRT(-1)
  use IMSQRT

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

Bug description:
  Binary package hint: libreoffice

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

  2) apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:3.3.1-1ubuntu3~maverick1
    Candidate: 1:3.3.1-1ubuntu3~maverick1
    Version table:
   *** 1:3.3.1-1ubuntu3~maverick1 0
          500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
          100 /var/lib/dpkg/status

  Binary package hint: openoffice.org

  1) lsb_release -rd
  Description:	Ubuntu 10.04.1 LTS
  Release:	10.04

  2) apt-cache policy openoffice.org-calc
  openoffice.org-calc:
    Installed: 1:3.2.0-7ubuntu4.1
    Candidate: 1:3.2.0-7ubuntu4.1
    Version table:
   *** 1:3.2.0-7ubuntu4.1 0
          500 http://us.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
          500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
          100 /var/lib/dpkg/status
       1:3.2.0-7ubuntu4 0
          500 http://us.archive.ubuntu.com/ubuntu/ lucid/main Packages

  3) What is expected to happen is when one opens a new spreadsheet, and
  types in first row, first column:

  =sqrt(-1)

  and it displays Err:502 pressing F1 for help on this error presents
  information regarding how this can be caused by a negative under a
  square root.

  4) For LibreOffice Error Code 502 Explanation at:
  http://help.libreoffice.org/Calc/Error_Codes_in_Calc

  currently is:

  "Function argument is not valid, for example, a negative number for the root
  function."

  It would be nice if it was:

  "Function argument is not valid. For example, a negative number for the SQRT()
  function, for this please use IMSQRT()."

  For OOo Error Code Explanation at:
  http://wiki.services.openoffice.org/wiki/Calc_Error_Codes

  currently is:

  "A function argument has an invalid value, e.g. a negative number for
  the root function."

  It would be nice if it was:

  "Function argument is not valid. For example, a negative number for the SQRT()
  function, for this please use IMSQRT()."

  ProblemType: Bug
  DistroRelease: Ubuntu 10.04
  Package: openoffice.org-calc 1:3.2.0-7ubuntu4.1
  ProcVersionSignature: Ubuntu 2.6.32-25.44-generic 2.6.32.21+drm33.7
  Uname: Linux 2.6.32-25-generic i686
  Architecture: i386
  Date: Thu Oct  7 18:33:17 2010
  EcryptfsInUse: Yes
  InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100429)
  ProcEnviron:
   LANG=en_US.utf8
   SHELL=/bin/bash
  SourcePackage: openoffice.org

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