Page 1 of 1
Freeze panes in excel report.
Posted: Fri Aug 31, 2012 4:14 pm
by vella
Hello,
is it possible to freeze panes in excel report?
Re: Freeze panes in excel report.
Posted: Mon Sep 03, 2012 5:59 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.
Re: Freeze panes in excel report.
Posted: Thu Sep 13, 2012 4:33 pm
by vella
Hello,
I tried to do all this things for my excel report header, but it didn't work for me. What's wrong in my mrt?
Thank you.
Re: Freeze panes in excel report.
Posted: Fri Sep 14, 2012 8:26 am
by HighAley
Hello.
Did you set the AllowFreezePanes static option?
It's not necessary to do both. You could either set Lock property or set Tag value.
You could set it in the Begin Render event of the report.
Thank you.
Re: Freeze panes in excel report.
Posted: Fri Sep 14, 2012 3:00 pm
by vella
Hello,
I set this option, but it didn't help.
Re: Freeze panes in excel report.
Posted: Mon Sep 17, 2012 9:55 am
by HighAley
Hello.
Could you specify the assembly's version and what component do you use?
How did you set next options?
Code: Select all
StiOptions.Export.Excel2007.AllowFreezePanes = true;
StiOptions.Export.ExcelXml.AllowFreezePanes = true;
Thank you.
Re: Freeze panes in excel report.
Posted: Mon Sep 17, 2012 2:32 pm
by vella
Hello,
version 2012.1.1300.0.
Code: Select all
StiOptions.Export.Excel.ShowGridLines = false;
StiOptions.Export.Excel2007.AllowFreezePanes = true;
StiOptions.Export.ExcelXml.AllowFreezePanes = true;
var exportExcel = new StiExcelExportService();
exportExcel.ExportExcel(report, outStream);
Thank you.
Re: Freeze panes in excel report.
Posted: Tue Sep 18, 2012 6:42 am
by HighAley
Hello.
You are exporting in the format that don't support freezing of cells.
AS we wrote before:
Aleksey Andreyanov wrote:Yes, you could do it in the Excel2007 and ExcelXml exports.
You should to use Stimulsoft.Report.Export.StiExcel2007ExportService.
Thank you.