Page 1 of 1

TFileXLS

Posted: Fri Sep 29, 2023 1:37 am
by oliveiros junior
Hey guys,

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

+------------------------------+------------------------------+-------------------------------------+
| XXXXXXXXXXXXXXXXXX | ............................. |.................................... |
| XXXXXXXXXXXXXXXXXX | ............................. |.................................... |
+------------------------------+------------------------------+-------------------------------------+
| .............................|............................. |.................................... |
+------------------------------+------------------------------+-------------------------------------+

Thank you in advance for your help.

Oliveiros Junior

Re: TFileXLS

Posted: Fri Sep 29, 2023 5:40 am
by Natter
What means ?
break within a cell
Change cell properties or programmatically enter text with a line break ?

Re: TFileXLS

Posted: Fri Sep 29, 2023 11:05 am
by oliveiros junior
Hi Natter,

Enter text, by programming, with a line break.

regards

Re: TFileXLS

Posted: Fri Sep 29, 2023 12:30 pm
by Natter
Cell property .WrapText = .T.
.value:={"Text"+chr(10)+"text"}

Re: TFileXLS

Posted: Fri Sep 29, 2023 5:01 pm
by oliveiros junior
Thanks Natter.