topic-43753

Posts: 148

Joined: Tue Mar 20, 2007 03:13 PM

TFileXLS
Posted: Fri Sep 29, 2023 01:37 AM

Hey guys,

This is a query about TFileXLS. How do I force the text to break within a cell.

+------------------------------+------------------------------+-------------------------------------+

| XXXXXXXXXXXXXXXXXX | ............................. |.................................... |

+------------------------------+------------------------------+-------------------------------------+

| .............................|............................. |.................................... |

+------------------------------+------------------------------+-------------------------------------+

Thank you in advance for your help.

Oliveiros Junior

Posts: 1392

Joined: Mon May 14, 2007 09:49 AM

Re: TFileXLS
Posted: Fri Sep 29, 2023 05:40 AM

What means ?

break within a cell

Change cell properties or programmatically enter text with a line break ?

Posts: 148

Joined: Tue Mar 20, 2007 03:13 PM

Re: TFileXLS
Posted: Fri Sep 29, 2023 11:05 AM

Hi Natter,

Enter text, by programming, with a line break.

regards

Posts: 1392

Joined: Mon May 14, 2007 09:49 AM

Re: TFileXLS
Posted: Fri Sep 29, 2023 12:30 PM

Cell property .WrapText = .T.

.value:={"Text"+chr(10)+"text"}

Posts: 148

Joined: Tue Mar 20, 2007 03:13 PM

Re: TFileXLS
Posted: Fri Sep 29, 2023 05:01 PM

Thanks Natter.

FiveTech Support Forums