Cross-file references
- From: Andrzej Wąsowski <wasowski data pl>
- To: gnumeric-list gnome org
- Subject: Cross-file references
- Date: Sat, 03 Sep 2011 00:18:23 +0200
Hello,
I was trying to use cross-references in gnumeric.
I have two files:
a.gnumeric
b.gnumeric
residing in the same directory.
I have some references from a to b, and from b to a (but not cyclic).
I use the following syntax
=[a.gnumeric]sheet!A1:B2
the referencing and recalculating works as long as I have both workbooks
open simultanously.
Then I save both, and close gnumeric (entirely but gracefully).
On reopening of any of the files (or even if both are given as command
line params to the same isntance of gnumeric on startup) the references
between workbooks are broken.
During loading I get errors like the following, seemingly for each
cross-ref cell:
** (gnumeric:23117): WARNING **: Unparsable expression for D26:
=[A.gnumeric]ass!M16
** (gnumeric:23117): WARNING **: XML-IO : Shared expression with no
expression ??
and the cross-refs are turned into text fields (quoted fields).
Needless to say this means that working with cross-references is
impossible in gnumeric (only works until first quit). Is that really
correct?
Or is my gnumeric version broken ? Or is there something I do wrongly ?
I use gnumeric 1.10.15 on Arch Linux with Gnome 3.
Thank you for helping,
Andrzej
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]