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]