Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Koen Piller
  Where is Koen Piller?
 Koen Piller
 To: Cesar
  Where is Cesar?
Subject: RE: FoxyPreviewer Excel formatting
Thread ID: 373879 Message ID: 373896 # Views: 48 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Classes and Objects
Date: Thursday, March 28, 2013 4:59:18 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


any clue which property I should call to change the value of 'Strech with overflow' when saving / transforming the report into Excel with FP?

A test prg + frx attached to show the empty rows in Excel.



** The coding in VFP without using mDot should be qualified as recreational **


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