I call these two lines.
var spreadsheetObj = ej.base.getComponent(document.getElementById('spreadsheet3'), 'spreadsheet');
spreadsheetObj.sheets.frozenColumns = 3;//(2);
Every Columns after three is not aligned to the first three.
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.
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.
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.
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.
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.
Added new scripts and added refresh function. Still an issue attached is the code and a screen shot. Please scroll down.
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.
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.
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.”
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.
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.
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.