Freeze panes in excel

[vella]

Hello,
is it possible to freeze row and cells in excel report?

[HighAley]

Hello.

Yes, you could do it in the Excel2007 and ExcelXml exports.
At first you should set on of the next properties or both:

Code: Select all

StiOptions.Export.Excel2007.AllowFreezePanes = true;
StiOptions.Export.ExcelXml.AllowFreezePanes = true;

Then you should choose the component which bottom left conner will be frozen and set one of next properties:

• The Lock property should be set to True.
• The Tag property should be set to excelfreezepanes.

Thank you.