Fix columns and/or rows

FLX TMS FlexCel for VCL & FMX
1

Hello,

i couldn't find the function to fix rows or columns in a sheet.

Thanks in advance,
Lothar

2

Hi,
By fixing you refer to autofitting? If so, the functions are:

https://doc.tmssoftware.com/flexcel/vcl/api/FlexCel.Core/TExcelFile/AutofitCol.html
https://doc.tmssoftware.com/flexcel/vcl/api/FlexCel.Core/TExcelFile/AutofitRow.html
https://doc.tmssoftware.com/flexcel/vcl/api/FlexCel.Core/TExcelFile/AutofitRowsOnWorkbook.html

Make sure to also read: FlexCel API Developer Guide | FlexCel Studio for VCL and FireMonkey documentation

If you were referring to something else, please let me know.

3

Hi,

thanks for your fast response.

I mean fix Coumns, which you can see also if you scroll.

best regards,
Lothar

4

Ah, you are looking for TXlsFile.FreezePanes Method | FlexCel Studio for VCL and FireMonkey documentation

But remember, for all this stuff the simplest way is to use APIMate. Just create an empty file in Excel, freeze the panes, then save the file and open it in APIMate (search for APIMate in the start menu). It will tell you the commands you need to do in FlexCel to do the same as you did in Excel. Just use APIMate with simple files with the feature you want, or you will get a lot of code.

5

Oh, that's helpful
Thanks a lot,
Lothar

6

APIMate is Flexcel's magic feature. Even with Adrian's speedy response to questions, it's the best and quickest place to look for answers.