Bug#662877: gnumeric: IFERROR saved in formats that do not recognise it

[Andreas J. Guelzow]

Gnumeric does not write OpenOffice files. We write files in Open
Document Format version 1.2 and IFERROR is defined in that standard.
OpenOffice may only implement a subset of ODF 1.2.

In any case, ODF 1.2 also defines how to save additional functions and
we are doing that according to the standard for any functions not
defined there.

Moreover IFERROR(X,Y) is not equivalent to IF(ISERROR(X),Y,X). Since the
latter evaluates X twice, potentially yielding different values.

Andreas

-- 
Andreas J. Guelzow, PhD, FTICA
Mathematical  Computing Sciences
Concordia University College of Alberta




-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Bug#662877: gnumeric: IFERROR saved in formats that do not recognise it

[Francesco Potortì]

Package: gnumeric
Version: 1.10.17-1+b2
Severity: normal

The IFERROR function is known only by Excel 2007 anf Gnumeric.  However,
it is saved as such even in formats where it is unknown, that is, Excel
2003, Excel 97 and Openoffice.

When saving in those formats, each IFERROR(X,Y) call should be
translated to IF(ISERROR(X),Y,X).

-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'testing-proposed-updates')
Architecture: amd64 (x86_64)

Kernel: Linux 3.0.0-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.ISO-8859-15, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages gnumeric depends on:
ii  debconf [debconf-2.0]  1.5.41
ii  gconf2 3.2.3-3
ii  gnumeric-common1.10.17-1
ii  gsfonts1:8.11+urwcyr1.0.7~pre44-4.2
ii  libatk1.0-02.2.0-2
ii  libc6  2.13-26
ii  libcairo2  1.10.2-6.2
ii  libgdk-pixbuf2.0-0 2.24.1-1
ii  libglib2.0-0   2.30.2-6
ii  libgoffice-0.8-8   0.8.17-1
ii  libgsf-1-114   1.14.21-2
ii  libgtk2.0-02.24.10-1
ii  libpango1.0-0  1.29.4-2
ii  libxml22.7.8.dfsg-7
ii  procps 1:3.3.2-3
ii  zlib1g 1:1.2.6.dfsg-1

Versions of packages gnumeric recommends:
ii  evince3.2.1-1
ii  lp-solve  5.5.0.13-7

Versions of packages gnumeric suggests:
ii  epiphany-browser   3.2.1-2
ii  fonts-liberation [ttf-liberation]  1.07.2-1
ii  gnumeric-doc   1.10.17-1
ii  gnumeric-plugins-extra 1.10.17-1+b2
ii  ttf-liberation 1.07.2-1
ii  ttf-mscorefonts-installer  3.4

-- debconf information:
* gnumeric/existing-process: true
  gnumeric/existing-process-title:



-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org