New worksheet in a long-existing (and working) file changes expression to string after saving and closing (and then reopening)
- From: Ron G <ronmlgaw yahoo com>
- To: gnumeric-list gnome org
- Subject: New worksheet in a long-existing (and working) file changes expression to string after saving and closing (and then reopening)
- Date: Mon, 12 Sep 2022 22:49:54 -0400
I have a gnumeric spreadsheet with about 30 worksheets, many using the 
dsum expression.  However, a newly created worksheet is exhibiting 
unusual behavior (everything else but the new worksheet works normally) 
: it works fine when the file is open, but when I save the file, close 
it, and then re-open it, all the dsum expressions in only that new 
worksheet are converted to a string... e.g. =dsum(expression) becomes 
'=dsum(expression)
I can do a "find/replace" using the advance button to shut of 'Keep 
strings as string', replacing = with =, and limiting it to the range 
within the sheet (probably could just let it replace all in the current 
worksheet just as easily).
I'm using Windows version 10.16 (I know, ancient, but... I just can move 
so much faster in Gnumeric than Excel or Libre Calc, and haven't been 
able to resolve the compile errors when trying to build it myself in MSYS2).
Regards, RG
[Date Prev][
Date Next]   [Thread Prev][
Thread Next]   
[
Thread Index]
[
Date Index]
[
Author Index]