Re: New worksheet in a long-existing (and working) file changes expression to string after saving and closing (and then reopening)

Quick follow-up : it does work just fine once I moved the "Categories" worksheet ahead of the worksheet with the expression.

I did notice when I loaded the file in the Cygwin-X gnumeric 1.12 that this was not an issue.  Someday I'll figure out the compile time issues with MSYS2... but for now, I'm going to eek along with this version since the mouse scrolling is what I really haven't found an equivalent anywhere else (including in the Cygwin-X compiled version).


On 9/13/2022 12:11 PM, Ron G wrote:
Thanks for the direction.  I did run it from the command line, and this is the (repeated) error shown:

** (C:\Program Files (x86)\Gnumeric\1.10.16\bin\gnumeric.exe:219032): WARNING **: Unparsable expression for M50: =dsum(Tab1!$A$2:$O$126,8,Categories!NamedRange1)

yet I can paste that exact equation into the cell and it works, at least until I close the file and load it again.  Wondering if it's parsing the expression *before* the Named Ranges are loaded?  I'm going to try moving the "Categories" tab to earlier in the spreadsheet, perhaps the order matters?


On 9/13/2022 12:00 PM, Morten Welinder wrote:
That is indeed an ancient version.

Try running from the command line -- there might be error messages
with hints of what is going on.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]