ExportAllVisibleSheets

Hi,


When I export an excel file all rows in pdf has the same height even if a row has multiline cell. In excel file such line has a correct, biger height. Is it possible to achieve export with a correct height in pdf.

TIA and best regards
Branko

Hi,


FlexCel by default doesn't autofit rows: http://www.tmssoftware.biz/flexcel/doc/vcl/guides/api-developer-guide.html#autofitting-rows-and-columns

So you need to do it manually. Try calling:
xls.AutofitRowsOnWorkbook(false, true, 1.1);

before exporting the file

see http://www.tmssoftware.biz/flexcel/doc/vcl/api/FlexCel.XlsAdapter/TXlsFile/AutofitRowsOnWorkbook.html

Adrian, thank you. We can always rely on your help!