Richard
If you are correct, then the following should be a workaround ?
IF FILE("GRIDEXCEL.XLS")
DELETE FILE gridexcel.xls
ENDIF
*m.lcXLSFile = This.GetMyDocumentsPath() + SYS(2015) + ".xls"
*m.lcXLSFile = PUTFILE("Export to Excel:", m.lcXLSFile,
"XLS;XLSX;XLSM;XLSB")
m.lcXLSFile=SYS(5)+CURDIR()+"GRIDEXCEL.XLS"
But the spreadsheet is still empty ...........
Sytze
On Fri, Aug 7, 2009 at 7:57 AM, Richard Kaye <[email protected]> wrote:
> Hi Sytze,
>
> Very cool indeed! Yes, I did run into that problem where the Excel export
> said it completed and yet it appeared to do nothing. The problem as I found
> it is that the export method does not allow overwriting existing files even
> though it prompts you about replacing. (Actually it does do something. It
> adds blank rows into the file that you selected. So if you're picking an
> existing file with nothing in it, you just get more nothing...) I haven't
> had a chance yet to figure out a proper workaround. I also found another
> minor issue if you use the preview report option in that it only deletes
> half of the temporary report that it creates. For the latter, here's my fix.
> At approximately line 242 of the CopyToReport method, I changed this line:
>
> ERASE (m.tcFRXName)
>
> to this:
>
> ERASE ADDBS(JUSTPATH(m.tcFRXName))+JUSTSTEM(m.tcFRXName)+[.fr?]
>
> Finally, I've made some changes in the applysort and getsortexpression
> methods. I added the COMPACT keyword to the INDEX ON statement in the former
> and I increased the expression length as appropriate in the latter. (If your
> controlsource is longer than 99 characters, the index creation will fail
> using a standard IDX. This one also fails silently in that it does not
> notify you of any problem and the header indicates that you are changing the
> order when there is actually no tag to go with that column. It's wrapped in
> a try..catch so I changed that to throw the exception object up the chain
> which allows it to set the header image to the no sort available instead of
> the arrows.)
>
> I've reported all this stuff to Craig and at least in one instance, he
> indicated that he would integrate my changes into the next update he does.
> But that's one busy guy so who knows when that will be. (If you're lurking,
> Craig, thanks again for all your efforts...)
>
> There are 7 properties that all start with "allow". To turn off the various
> options, just change those as desired.
>
> rk
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]]
> On Behalf Of Sytze de Boer
> Sent: Thursday, August 06, 2009 3:23 PM
> To: [email protected]
> Subject: Re: GridExtras fun
>
> Hi Richard
>
> Your post prompted me to try this class
> It is so cool.
>
> One problem I hav ewith it is that I can't get the Copy to Excel to work
> It brings up an empty Excel worksheet no matter what I try
> Do you have this working ?
>
> Also, how do you disable the template function in bottom right corner ?
>
> Sytze
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
