> 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

Hi,

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.

Regards,
Koen



https://www.foxite.com/uploads/1f31fe33-f08a-40e2-99b1-52ea70e9601c.zip


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