Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cesar
  Where is Cesar?
 
 Brazil
 Cesar
 To: Koen Piller
  Where is Koen Piller?
 Santpoort-Zuid
 Netherlands
 Koen Piller
 Tags
Subject: RE: FoxyPreviewer Excel formatting
Thread ID: 373879 Message ID: 373888 # Views: 61 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Classes and Objects
Date: Thursday, March 28, 2013 3:24:02 PM         
   


Hi Koen,

> in case the length of a field exceeds the width of the report field and you have the option Strech with overflow activated, this will result in FP in preview and print out nicely a nRow content of that field, however when you save to Excel it will only show the content of the first row with extra Excel blank rows without content.

Please send me a PRG, DBF and FRX/FRT to reproduce the issue and apply a fix, if needed.


> Would it be possible to instruct FP to make use, when printing to Excel of an other report (in which the Strech with overflow is not activated)? So something like for preview use Report1 and for printing/formatting to Excel use Report2?

Nope, not in the simplified mode, because we can't run a report from inside another report instance. What you could do is to make some conditional formatting or contents, with contents to run in the preview differently from the exporting ones.


Regards,

m.Cesar
My Blog

ENTIRE THREAD

FoxyPreviewer Excel formatting Posted by Koen Piller @ 3/28/2013 1:07:13 PM
RE: FoxyPreviewer Excel formatting Posted by Cesar @ 3/28/2013 3:24:02 PM
RE: FoxyPreviewer Excel formatting Posted by Koen Piller @ 3/28/2013 4:59:18 PM
RE: FoxyPreviewer Excel formatting Posted by Koen Piller @ 3/29/2013 10:12:46 AM