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

[Ron G <ronmlgaw yahoo com>]

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).

RG


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?
>
> RG
>
> 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.
> >
> > M.