Page 1 of 1

Freeze panes in excel

Posted: Fri Aug 31, 2012 4:54 pm
by vella
Hello,
is it possible to freeze row and cells in excel report?

Re: Freeze panes in excel

Posted: Mon Sep 03, 2012 5:58 am
by 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.