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:
0000
"=""0000"""
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.
Observed behavior:
Consider the following seemingly-similar one-line .csv file:
0000,"=""0000"""
It parses as if it were
0,=,"0000"""
or some such. I cannot begin to understand this.
Platform:
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