WARNING **: Unparsable expression ... cannot copy-and-paste with defined names
Submitted by John Denker
Created attachment 330530 trivial spreadsheet to help demonstrate "unparseable expression"
Rationale: The overall objective is to cut-and-paste a sheet from one workbook to another.
Start one instance of gnumeric looking at both of the attached files: :; gnumeric blank.gnumeric uncopyable.gnumeric
Copy all the non-blank cells from the source. Paste them into the destination. Observe everything seems more-or-less normal at this point, if you don't look too closely. Save the destination workbook as unparseable.gnumeric. Quit out of gnumeric.
My version of unparseable.gnumeric is also attached.
- Open the new file: :; gnumeric unparseable.gnumeric
Observe some very strange cell contents, i.e. equations converted to strings. Observe scary messages on the controlling window:
** (gnumeric:26536): WARNING **: Unparsable expression for A5: ='multi-bit'!eps
** (gnumeric:26536): WARNING **: Unparsable expression for B5: ='multi-bit'!eps*2
** (gnumeric:26536): WARNING **: Unparsable expression for A6: ='multi-bit'!eps*3
** (gnumeric:26536): WARNING **: Unparsable expression for B6: ='multi-bit'!eps*4
No matter what else is going on, gnumeric should not write unparseable files.
This is presumably related in some way to "Defined Names". Copy-and-paste seems to have multiple issues with Defined Names.
This is a big problem for me, because I really need to copy-and-paste some sheets from one workbook to another, and many of my sheets use Defined Names.
:; gnumeric --version gnumeric version '1.12.31' datadir := '/usr/local/share/gnumeric/1.12.31' libdir := '/usr/local/lib/gnumeric/1.12.31'
:; git log commit e86ea314 Date: Tue Jun 28 13:46:58 2016 -0400
:; uname -a Linux asclepias 3.18.0+ #4 SMP Mon Jul 6 15:51:42 MST 2015 x86_64 x86_64 x86_64 GNU/Linux
:; lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 16.04 LTS Release: 16.04 Codename: xenial
Attachment 330530, "trivial spreadsheet to help demonstrate "unparseable expression"":
Version: git master