Ticket T830252
Visible to All Users
Duplicate

We have closed this ticket because another page addresses its subject:

sheet.SplitPosition in XL Export does not seem to work

SplitPosition does not work in Excel Export library

created 5 years ago

Setting IXLSheet.SplitPosition succeeds in code but has no effect on the exported spreadsheet. Have tried with various values without success.

The SplitPosition value persists right up to the moment the sheet goes out of scope (End Using) but the exported spreadsheet never has frozen columns or rows. I am simply trying to freeze the top few rows.

Answers approved by DevExpress Support

created 5 years ago

Hello,

Note that the SplitPosition property should be set before  creating columns, rows and cells if you create an .XLSX document. In the opposite case, this setting will be ignored. Please check where in your project you initialized the SplitPosition property value.

    Comments (2)

      Thanks for the prompt response. Yes, that fixes it but I don’t see those instructions in the documentation and it’s not really something anybody could be expected to guess.

      DevExpress Support Team 5 years ago

        I already informed our technical writers of your inquiry. We will add the corresponding note into the IXlSheet.SplitPosition Property help topic.

        Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

        Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.