FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour Fwh13.09 r2 - problem with excel button in rpreview
ORibeiro
Posts: 187
Joined: Mon Oct 20, 2008 06:33 PM
Fwh13.09 r2 - problem with excel button in rpreview
Posted: Mon Nov 18, 2013 10:45 AM

The "MS-EXCEL button" enables only after exporting the report to MS-​​Word.

To see this problem, use the c:\fwh\samples\testrpt4.prg.

Thanks.

Oscar Ribeiro

OASyS Informática

Fwh18.02 + xHarbour 1.2.3 + Bcc72
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Fwh13.09 r2 - problem with excel button in rpreview
Posted: Tue Nov 19, 2013 12:29 PM

Oscar,

Once that gets enabled, does it properly export to Excel ? thanks

regards, saludos

Antonio Linares
www.fivetechsoft.com
ORibeiro
Posts: 187
Joined: Mon Oct 20, 2008 06:33 PM
Re: Fwh13.09 r2 - problem with excel button in rpreview
Posted: Tue Nov 19, 2013 02:14 PM

Linhares,

Only after I trigger another button into preview, the excel button is released and so I can export to excel.

Oscar Ribeiro

OASyS Informática

Fwh18.02 + xHarbour 1.2.3 + Bcc72
lucasdebeltran
Posts: 1303
Joined: Tue Jul 21, 2009 08:12 AM
Re: Fwh13.09 r2 - problem with excel button in rpreview
Posted: Tue Nov 19, 2013 06:03 PM

Oscar,

Yes, the latest FWH reléase seems to have some bugs.

To fix this one, in the Rpreview.prg
In the Method Activate()

Insert the line
::oBar:AEvalWhen()

before the statement ACTIVATE window.

Muchas gracias. Many thanks.



Un saludo, Best regards,



Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]



Implementando MSVC 2010, FWH64 y ADO.



Abandonando uso xHarbour y SQLRDD.
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Fwh13.09 r2 - problem with excel button in rpreview
Posted: Tue Nov 19, 2013 07:08 PM

Lucas,

Mr. Rao is reviewing this issue. IMO It is not related to what you explain.

Thanks for your help anyhow :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
Roger Seiler
Posts: 223
Joined: Thu Dec 01, 2005 03:34 PM
Re: Fwh13.09 r2 - problem with excel button in rpreview
Posted: Tue Nov 19, 2013 09:57 PM

Antonio,

I haven't yet tested exporting to Excel with FWH 13.09 (just downloaded), but with the 13.08 version weird things would happen:

  • The export would start at the the top of the report, but with some columns of data jumbled.

  • The export would start a few pages into the printout, but with all columns of data showing corrrectly.

If you're not aware of this problem (maybe you are and it's already fixed), let me know and I'll post a couple of screenshots.

All the best,

  • Roger
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Fwh13.09 r2 - problem with excel button in rpreview
Posted: Tue Nov 19, 2013 10:14 PM

Roger,

Many thanks for your feedback. Mr. Rao implemented that code, I supervised it, and I am sure that Mr. Rao may be aware of those issues, if they are known to him.

As usual I prefer to know Mr. Rao opinion before making changing myself that all times are perfectly fixed by Rao :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Fwh13.09 r2 - problem with excel button in rpreview
Posted: Wed Nov 20, 2013 03:51 AM

The "MS-EXCEL button" enables only after exporting the report to MS-​​Word.

This is fixed in FWH 13.10 to be released.

For now we may apply the fix suggested above:

in the Rpreview.prg
In the Method Activate()

Insert the line
::AEvalWhen()

before the statement ACTIVATE window.


Next issue raised:

I haven't yet tested exporting to Excel with FWH 13.09 (just downloaded), but with the 13.08 version weird things would happen:

- The export would start at the the top of the report, but with some columns of data jumbled.

- The export would start a few pages into the printout, but with all columns of data showing corrrectly.


There should be no problem with the rpreview.prg. I had used the feature hunderds of times without any issues with text data ( no images, no binary data, etc )

Please ensure the following:

1) oReport:bInit codeblock should clearly indicate the Restart for commencing generation of Excel output.

Typically we may say oReport:bInit := { || (cOurAlias)->( DbGoTop() ) } or similar statement to reposition the record pointer to where the export to excel should start.

2) Normally no complications should arise in case of MODAL Repreview. But in case of NON-MODAl preview, we should also take care that before export to excel is started, the default alias or recordpointers or any alias used in the report are not disturbed by any action in any other window. If we want to use export to Excel feature, it is highly desirable to use MODAL preview.

If you are still facing any problem even after observing the above, please post a sample program to reproduce the problem using any DBF in FWH samples folder. In case any other DBF has to be used to reproduce the problem. the same may be sent by email to Mr. Antonio and we shall examine at the earliest.
Regards



G. N. Rao.

Hyderabad, India
Roger Seiler
Posts: 223
Joined: Thu Dec 01, 2005 03:34 PM
Re: Fwh13.09 r2 - problem with excel button in rpreview
Posted: Wed Nov 20, 2013 02:34 PM

Thanks for your advice. I'll try it and let you know the results. All the best. - Roger

Continue the discussion

Static archive · New replies & topics via GitHub Discussions