using Infragistics.Documents.Excel;
Creating a new Excel 2007 file.
What is the command to Freeze (aka want to fix a header so I can Scroll without losing the headers).
What is the command to Split?
In Excel -> Windows Split / Freeze. I am not certain of the commands required to do this in infragistics.
OK,
sheet.DisplayOptions.FrozenPaneSettings /
sheet.DisplayOptions.PanesAreFrozen solves the Freezing so only need to know how to split.
The FrozenPaneSettings class has properties named FrozenColumns and FrozenRows. There are ingeters which represents the number of frozen columns/rows. If you want two rows frozen at the top of the worksheet, set sheet.DisplayOptions.FrozenPaneSettings.FrozenRows to 2.
Thanks, I figured this out. I still haven't figured out Splitting which is different. Under Excel, there is a menu Windows->Split to go with Windows Freeze Panes.
So Freeze Panes is resolved but still trying to figure out the command for Window->Split.
You can set DisplayOptions.PanesAreFrozen to False and then use the DisplayOptions.UnfrozenPaneSettings to controls how the window is split. This object has the following properties:
With these properties, you can set the splits, their dimensions, and the scroll positions in each pane.