1. Home
  2. Forum
  3. JavaScript - EJ 2
  4. Problem with formulas and hidden columns

Problem with formulas and hidden columns

Please watch the screen capture attached to see an issue with hidden columns.  If I hide a column which contains a formula, the adjacent column begins to update with the formula results.

In my test, I set A5=1, B5=2, C5=A5+B5, D5=C5.  Then, I hid column C.  Now, if I modify A5, the value for B5 changes, even though B5 does NOT contain a formula!


<script src=https://cdn.syncfusion.com/ej2/20.1.50/dist/ej2.min.js  type="text/javascript"></script>


I see similar related issues when I load a file (from JSON) which has hidden columns with formulas.  The related formulas don't work until I unhide the column. I suspect the two issues are related.



Attachment: hidden_formulas_error_76acb854.zip

3 Replies
SP Sangeetha Priya Murugan Syncfusion Team May 25, 2022 04:04 PM UTC

Hi John,


We need to validate more on your reported issue, so we will update you the further details on May 27th, 2022.


Regards,

Sangeetha M



SP Sangeetha Priya Murugan Syncfusion Team May 27, 2022 12:00 PM UTC

Hi John,


We have checked your reported issue and confirmed this as defect and the fix will be available in our June 15th, 2022 patch release, we appreciate your patience until then. You can track the status of this defect using below link from our feedback portal, 


Feedback Portal Link:  https://www.syncfusion.com/feedback/35195/adjacent-column-cells-getting-updated-with-the-formula-results-for-hidden-formula


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.”

Regards,

Sangeetha M


SP Sangeetha Priya Murugan Syncfusion Team June 16, 2022 10:26 AM UTC

Hi John,


We are glad to announce that our weekly patch release (20.1.60) is rolled out. And we have included the fix for the reported issue in this release. So, kindly upgrade your script and CSS versions to the latest to avail of these changes (20.1.60).


Script Link: https://cdn.syncfusion.com/ej2/20.1.60/dist/ej2.min.js


Feedback link:  https://www.syncfusion.com/feedback/35195/adjacent-column-cells-getting-updated-with-the-formula-results-for-hidden-formula


Release Notes: https://ej2.syncfusion.com/documentation/release-notes/20.1.60/?type=all#spreadsheet


Please let us know if you need further assistance on this.


Regards,

Sangeetha M


Loader.
Up arrow icon