We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date


snycfusion columns align.JPG 

I call these two lines.

var spreadsheetObj = ej.base.getComponent(document.getElementById('spreadsheet3'), 'spreadsheet');

spreadsheetObj.sheets[0].frozenColumns = 3;//(2);

Every Columns after three is not aligned to the first three.

9 Replies

SP Sangeetha Priya Murugan Syncfusion Team February 13, 2023 07:43 AM UTC

Hi Stephen,

We have applied the frozen columns based on your provided codes in a button click event, and the alignment issue won’t occur in our end. Please find the sample link below.

Sample Link: https://stackblitz.com/edit/esqryw?file=index.js,index.html

Script reference for all controls: https://cdn.syncfusion.com/ej2/20.4.48/dist/ej2.min.js

Style reference for all controls: https://cdn.syncfusion.com/ej2/20.4.48/material.css

We suggest you to use our latest version for both CSS for scripts and if you are still getting the same issue. Please replicate your issue in the above sample and send it back to us, based on that we will check and provide you with a better solution quickly.

SW Stephen Welborn February 14, 2023 05:57 PM UTC

I have added a sample project.  Created with Visual studio 2022.  It also has all the updated css and libraries from Syncfusion.    The first 4 columns are frozen in the excel file and the rest are not.  Line up issue occurs around line 41-end.  Please advise.  Excel file is located under wwwroot/uploads.

Attachment: Syncfusion_Display_1a9d386.zip

SP Sangeetha Priya Murugan Syncfusion Team February 16, 2023 11:18 AM UTC

Hi Stephen,

Your provided file has already frozen the four columns; after loading the sheets, you have revised the frozen applied column count to three, so only the UI is not refreshing properly. We suggest you use the refresh method after applying the frozen column, as shown below.

Application, table

Description automatically generated

And you have referred to the old script and CSS, so we suggest to use latest version for both scripts and CSS. And we have modified the sample based on our suggestion, please find the link below.

Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Synfusion_Display2110722543

SW Stephen Welborn February 16, 2023 03:03 PM UTC

Added new scripts and added refresh function.  Still an issue attached is the code and a screen shot.  Please scroll down.

Attachment: Syncfusion_Display_6f87e75.zip

SP Sangeetha Priya Murugan Syncfusion Team February 20, 2023 11:39 AM UTC

Hi Stephen,

We need to validate your reported issue more thoroughly; the provided file contains a large number of formatted cells and a freeze pane has been applied. Therefore, we need to find the exact cause of the selection issue on our end and we will update you with further details on February 22nd, 2023.

VR Vasanth Ravi Syncfusion Team February 22, 2023 03:36 PM UTC

Hi Stephen,

We were facing difficulties while validating your reported issue. As the file contains large data it takes time to find the root cause for the issue to provide a solution. We need some more time to validate your issue. We will update you further details on February - 24, 2023. We appreciate your patience until then.

VR Vasanth Ravi Syncfusion Team February 28, 2023 07:12 AM UTC

Hi Stephen,

We have confirmed the issue as "Exception throws while importing a file" and logged a bug report and it will be available in our upcoming March 15th , 2023 patch release. You can track the status of the issue via the feedback link below.

Feedback link for tracking purpose: https://www.syncfusion.com/feedback/41598/exception-throws-while-importing-a-file-into-spreadsheet

You will be informed regarding this once the fix is published.

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works re prioritization.”

VR Vasanth Ravi Syncfusion Team March 15, 2023 11:16 AM UTC

Sorry for the delay, Stephen.


Your reported issue, "Exception throws while importing a file" has been fixed and is in the testing phase. It will be available in our Volume 1 release, which is to be expected at the end of March. We appreciate your patience until then.

VR Vasanth Ravi Syncfusion Team March 28, 2023 03:14 PM UTC

Hi Stephen,

We are glad to announce that our Essential Studio 2023 Volume 1 Main release v21.1.35 is rolled out and is available for download under the following link. And we have included the fix for the reported issue (Exception throws while importing a file) in this release.

Essential Studio 2023 Volume 1 Main Release v21.1.35 is available for download | Announcements Forums | Syncfusion

Feedback Link: https://www.syncfusion.com/feedback/41598/exception-throws-while-importing-a-file-into-spreadsheet

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.


Vasanth R

Live Chat Icon For mobile
Up arrow icon