I am using XL Export Library and I cannot seem to get sheet.SplitPosition to take effect.
Even if I try something simple like:
Visual Basic' Freeze the first column and the first row
sheet.SplitPosition = New XlCellPosition(1, 1)
inside the Using sheet scope, the scroll bar in the window of the create Excel file still allows me to scroll all rows and columns off the screen…none are "frozen" as I expect them to be.
What might I be doing wrong?
Thanks!
Yes, the answer is that in order to get the SplitPosition property to work correctly in the XL Export Library, you must use the SplitPosition property BEFORE creating columns, rows and cells for the .XLSX document.
Thank you for informing us that the issue has been resolved. Please do not hesitate to contact us in case of any difficulty. We will be happy to help you!
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.
Hello Bob,
I tried the XL Export API - Examples Code Example and could not replicate the problem (see the attached video). Would you please provide us with a small sample that shows the problem? We will research your code on our side and do our best to find the cause of the issue.
I look forward to your response.
Just a follow-up. We have checked our source code and found a possible cause of the behavior you described. Please 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.
Yes thank you! I noticed that in your code and was going to check mine later tonight and move the location of the SplitPosition *before* my row and column creation to see if it worked before I replied. However, I feel pretty confident that this is the answer. I will check later tonight and respond back with my findings. Thanks for the follow-up.
Thank you for your feedback, Bob. I look forward to your results. Let me know if I can be of more help.