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?
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
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.
Support for print titles has been added and will be available in the 11.2 version.
This is GREAT!!
Thank You.