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



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.



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