Re: New worksheet in a long-existing (and working) file changes expression to string after saving and closing (and then reopening)
Thanks. Took another shot at building with mingw64 tool chain, made some progress but C is not my strength and the multiple declarations warnings/ errors have me stumped (the #ifdef / #define / # endif declaration blocks and use of extern in parse-until.h of version 1.12.x look just fine to me…). Someday I’ll resolve it R > On Sep 16, 2022, at 5:46 PM, Morten Welinder wrote: > > It's very likely a matter of sheet order. The version you're running > is so old I have no good feel for the bugs we've fixed in the > meantime. > > M. ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: New worksheet in a long-existing (and working) file changes expression to string after saving and closing (and then reopening)
It's very likely a matter of sheet order. The version you're running is so old I have no good feel for the bugs we've fixed in the meantime. M. ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
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). 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. ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
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. ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: New worksheet in a long-existing (and working) file changes expression to string after saving and closing (and then reopening)
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. ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list