I am using the Worksheet:DisplayOptions:PanesAreFrozen property in conjunction with the FrozenPaneSettings and that works fine when viewing the worksheet. How would I go about setting this for when printing the worksheet so my FrozenPanes will always print?
This is GREAT!!
Thank You.
Support for print titles has been added and will be available in the 11.2 version.
I think I need the "Printtitles" support from Excel. In another post I was told this was not yet available and to submit an enhancement request which I have done.
Hello RBlanchard,
I try to reproduce your scenario in a small sample. Maybe one possible approach could be to hide the rows / columns, which you don’t want to be shown in the excel, before selected FrozenPane. In my sample I have three rows and I set property worksheet.DisplayOptions.FrozenPaneSettings.FirstRowInBottomPane = 2;so I hide all rows before the selected one. Could you please take a look at the attached sample for more details. Please let me know if you think that I misunderstood your scenario or if you have any questions.
Regards