Package: gnumeric Version: 1.12.18-2 Severity: normal I am very pleased to see that gnumeric has named cell references now - very handy, and lets it load some fancy sheets from elsewhere it could not handle last time I looked.
However there seems to be a problem saving and reloading such references in ODF:
If I have a function which refers to two named cells (housedepth and
housewidth) like this:
=housedepth*housewidth
everything is good.
But if I save as .ods and reload the sheet all the cells with such
references in say '#NAME'. And the functions now look like:
=[]housedepth*[]housewidth
(when they were entered as =housedepth*housewidth )
Removing the square brackets makes everything work again, but clearly
there is some kind of problem with these being reformatted on
save/reload, and apparently an empty name not working as 'this sheet'.
I tested these formats:
ODF 1.2 extended conformance
ODF 1.2 strict conformance
ISO/IEC 29500
Gnumeric
The last two will correctly save and reload named cells
The first two will add '[]' to all name references, and then complain on reload
that
'name does not exist in workbook':
e.g. Unable to parse '[]floorarea*2.25' ('Name 'floorarea' does not exist in
workbook')
Now floorarea does exist in workbook 'Calcs' (sheet3), but not in sheet <empty
string>.
I'm not sure if this is a save or reload problem.
Is there something I can do to fix this behaviour or do I just need to
avoid using ODF with named references?
-- System Information:
Debian Release: 8.2
APT prefers stable
APT policy: (990, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 3.16.0-4-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_GB.utf8, LC_CTYPE=en_GB.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: sysvinit (via /sbin/init)
Versions of packages gnumeric depends on:
ii debconf [debconf-2.0] 1.5.56
ii gnumeric-common 1.12.18-2
ii gsfonts 1:8.11+urwcyr1.0.7~pre44-4.2
ii libatk1.0-0 2.14.0-1
ii libc6 2.19-18+deb8u1
ii libcairo2 1.14.0-2.1
ii libgdk-pixbuf2.0-0 2.31.1-2+deb8u3
ii libglib2.0-0 2.42.1-1
ii libgoffice-0.10-10 0.10.18-1
ii libgsf-1-114 1.14.30-2
ii libgtk-3-0 3.14.5-1+deb8u1
ii libpango-1.0-0 1.36.8-3
ii libpangocairo-1.0-0 1.36.8-3
ii libxml2 2.9.1+dfsg1-5
ii procps 2:3.3.9-9
ii zlib1g 1:1.2.8.dfsg-2+b1
Versions of packages gnumeric recommends:
ii evince 3.14.1-2
ii gnumeric-doc 1.12.18-2
ii lp-solve 5.5.0.13-7+b1
Versions of packages gnumeric suggests:
ii fonts-liberation 1.07.4-1
pn gnumeric-plugins-extra <none>
-- debconf information:
gnumeric/existing-process-title:
* gnumeric/existing-process: true
Wookey
--
Principal hats: Linaro, Debian, Wookware, ARM
http://wookware.org/
signature.asc
Description: Digital signature
