Thanks for the tips, Morten. I will do some work in the next few days to
compile current Git versions of Goffice, GSL (suggested by Andreas) and
Gnumeric together.
In the meantime, I got distracted by your suggestion of using Python
scripting to address the problem which also seems like a viable
To build Gnumeric from github you will need Goffice from github.
You could probably hack around it ("#define go_format_has_year(fmt)
0") if you don't mind potential problems with text import.
Search and replace never sees empty cells so it won't do what you need.
Python scripting -- see