Search found 24 matches

by Rob Davies
1 week ago
Forum: Bugs
Topic: Search in Studio
Replies: 2
Views: 428

Re: Search in Studio

Thanks as usual, Fritz. I have also noticed that when I am at the top of the list file and do a search, the first thing it jumps to is wrong. After that it is fine. For example I search for "TAXPAR" and it first highlights QX. I have tried attaching the list file here but am unable to. Bes...
by Rob Davies
2 weeks ago
Forum: Bugs
Topic: Search in Studio
Replies: 2
Views: 428

Search in Studio

Hi I am using Studio 17.3. If I search for an item in one file, and then go to another file (leaving the search dialogue open) and search again, it takes me back to the original file. Although I noticed this Studio 17.2, I don't recall it happening in earlier versions. It does not matter whether the...
by Rob Davies
2 months ago
Forum: Bugs
Topic: gdxxrw error
Replies: 8
Views: 8524

Re: gdxxrw error

Hi. I am afraid the same error persists after reinstalling Office. So it has to be a problem in GAMS. This afternoon I got an error message suggesting there is a problem in gdxxrw: GDXXRW 45.6.0 2eadeefd Jan 4, 2024 WEI x86 64bit/MS Window Input file : C:\Users\Rob Davies\Desktop\RwandaPrep\SA_templ...
by Rob Davies
3 months ago
Forum: Wishes
Topic: GDX Export in studio
Replies: 1
Views: 7236

GDX Export in studio

Scott MacDonald alerted me to the Export Button in GDX view in Studio. It is very useful. Can I wish for two tweaks? 1. At present the data selected are exported in table format, regardless of which view is being used in GDX. It would be nice to be able to export lists, since this makes pivots in Ex...
by Rob Davies
3 months ago
Forum: Bugs
Topic: GDX Export in Studio
Replies: 2
Views: 13342

GDX Export in Studio

Hi
The Export Button in GDX in Studio is very helpful. But there seems to be a bug. The export window sort by entry treats the numbers as text, sorting as 1, 10,100, 101, ...109,11,110 etc.
Best
Rob
by Rob Davies
4 months ago
Forum: Bugs
Topic: A concern with Studio
Replies: 2
Views: 6993

Re: A concern with Studio

Thanks Fred.
I have taken to using checkerrorlevel with the call so I am sure it is not reading in a different gdx.
Much appreciated.
Kind regards
Rob
by Rob Davies
4 months ago
Forum: Bugs
Topic: gdxxrw error
Replies: 8
Views: 8524

Re: gdxxrw error

Hi Fred
I restarted and ran the model again. Now there is only one instance of Excel shown in Task Manager Details.
And when I close the workbooks down manually, those instances disappear.
Clearly something wrong with my Excel. Maybe I need to reinstall.
Thanks for your help.
Best
Rob
by Rob Davies
4 months ago
Forum: Bugs
Topic: gdxxrw error
Replies: 8
Views: 8524

Re: gdxxrw error

Dear Fred I appreciate your help. I also feel it is more an Excel issue than a GAMS one. In fact I have been trying to see if it is related specifically to the Excel workbook I am trying to read. But I cannot find anything. For what it is worth I use Microsoft® Excel® for Microsoft 365 MSO (Version ...
by Rob Davies
4 months ago
Forum: Bugs
Topic: gdxxrw error
Replies: 8
Views: 8524

Re: gdxxrw error

Dear Fred Apologies for that. Yes - run 1modOLC.gms first, with a save in the command line (s=1mod) Then 2simOLC.gms with a restart (r=1mod) You can turn off most of the simulations, which are activated/deactivated on the "Main" sheet of 2simOLC.xlsx. At the end of 2simOLC.gms is $INCLUDE ...
by Rob Davies
4 months ago
Forum: Bugs
Topic: A concern with Studio
Replies: 2
Views: 6993

A concern with Studio

Hi I have noticed a slightly worrying occurrence using Studio. I run some code that successfully creates a gdx file that is used in a gdxin statement. Everything works fine. I then make some changes and rerun the code, which is intended to create a gdx with the same name. If the altered code has an ...