very strange failure: formula with quoted quote in .csv file
Desired and expected behavior:
Being able to enter formulas via .csv files is exceedingly desirable. Consider the following two-line .csv file:
The first line is just a number, slightly goofy but harmless. The second line contains a formula that evaluates to a string. This works exactly as desired and expected. So far so good.
Consider the following seemingly-similar one-line .csv file:
It parses as if it were
or some such. I cannot begin to understand this.
This is observed with the standard gnumeric that came with my distro, and also with a version compiled from recently-pulled git sources.
:; uname -srmo Linux 5.7.1+ x86_64 GNU/Linux :; lsb_release -a LSB Version: core-11.1.0ubuntu2-noarch:cxx-3.0-amd64:cxx-3.0-noarch:cxx-3.1-amd64:cxx-3.1-noarch:cxx-3.2-amd64:cxx-3.2-noarch:cxx-4.0-amd64:cxx-4.0-noarch:cxx-4.1-amd64:cxx-4.1-noarch:graphics-2.0-amd64:graphics-2.0-noarch:graphics-3.0-amd64:graphics-3.0-noarch:graphics-3.1-amd64:graphics-3.1-noarch:graphics-3.2-amd64:graphics-3.2-noarch:graphics-4.0-amd64:graphics-4.0-noarch:graphics-4.1-amd64:graphics-4.1-noarch:printing-11.1.0ubuntu2-noarch:security-11.1.0ubuntu2-noarch Distributor ID: Ubuntu Description: Ubuntu 20.04.1 LTS Release: 20.04 Codename: focal :; /usr/src/gnome/gnumeric/src/gnumeric --version gnumeric version '1.12.49' datadir := '/usr/src/gnome/install/share/gnumeric/1.12.49' libdir := '/usr/src/gnome/gnumeric' :; git log commit aee6c73db1a05229b8039416476bc64be98fc72d Date: Wed Oct 7 11:05:07 2020 -0700