1. Home
  2. Forum
  3. ASP.NET MVC - EJ 2
  4. AllowEditing to false and calculated columns

AllowEditing to false and calculated columns

Hi,

We are seeing a strange behavior in the spreadsheet control, which doesn't look right. The version we're using is 18.4.0.43.

The thing is, In some cases we need the control to not be editable, to only show the data previously loaded, depending on permissions.

In those cases we are initializing the control like this:

Html.EJS().Spreadsheet("spreadsheet").Locale("pt-PT").AllowEditing(false)

And this is an example of what we get:


But as can be seen in the image, when the AllowEditing is set to false the calculated cells don't get calculated. What are we missing? Is this a normal behavior?

Thanks


3 Replies
SP Sangeetha Priya Murugan Syncfusion Team July 3, 2023 03:47 PM UTC

Hi ShareValue, 


Based on your provided details, we can replicate your reported issue at your version 18.4.0.43. Which is our too old version script, but we have included some important features, formula related improvements and bug fixes in our later releases. After updating the packages to the latest version (22.1.34), we haven’t noticed any issues as mentioned and attached the video for your reference. So, we suggest that you use our latest version for both scripts and assemblies to resolve your reported issue in your end.  

Please find the latest version scripts, CSS, and assembly’s links on below.



Attachment: editfalse_59ba6fb3.zip

SH ShareValue July 3, 2023 08:32 PM UTC

Hi,

We were actually on version 20.2450.0.36. Was looking at the wrong project.


We've updated to the latest version but it didn't fix the problem. But we found a solution, looking at the video you've sent. We removed the  .AllowEditing(false) from the spreadsheet constructor and added a this.allowEditing = false; to the spreadsheet_created event. That solved the problem.


Thanks


SP Sangeetha Priya Murugan Syncfusion Team July 4, 2023 10:12 AM UTC

Hi ShareValue,


Based on your provided details, we can be able to replicate your reported issue in your mentioned version 20.2.36. And we have included some editing related bug fixes in our latest version. So, as we suggested before, please use our latest version for both scripts and assemblies to resolve your reported issue in your end. We have attached the sample and video for your reference in latest version.


Please refer to the below latest version script and assembly’s links.


CDN Links:


https://cdn.syncfusion.com/ej2/22.1.34/dist/ej2.min.js


https://cdn.syncfusion.com/ej2/22.1.34/material.css


NuGet Link:


https://www.nuget.org/packages/Syncfusion.EJ2.Spreadsheet.AspNet.MVC5/


Could you please check the attached sample and ensure this with the latest version in your end. If you still getting the same issue, please replicate your issue in our provided sample and send back to us. Based on that we will check and provide you a better solution quickly.


Regards,

Sangeetha M



Attachment: SampleAndVideo_4bb51b55.zip

Loader.
Up arrow icon