1. Feedback
  2. JavaScript
  3. 68422

Welcome to the JavaScript feedback portal. We’re happy you’re here! If you have feedback on how to improve the JavaScript, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Improving Formula Reference Handling During Cut-Paste Operations in Spreadsheet

When performing a cut and paste operation on a range that includes a formula cell, the formula does not update its references to reflect the new location. This behavior differs from a copy and paste operation, where references are updated as expected.


Example Scenario:

  • Cell F31 contains the formula: SUM(F2:F30)
  • Now cut the range F2:F31 and paste it into another column (e.g., column G)

Observation:

  • The formula in the pasted cell (now G31) still refers to the original range F2:F30 instead of updating to G2:G30

Expected Behavior:

  • The formula should automatically update to reflect the new location, just as it does during a copy and paste operation.

To better understand this behavior, try performing the same action using copy and paste instead of cut. You’ll notice that the formula updates correctly in that case.

Please refer to the attached screenshots for a comparison.

Expected Output:

image_4.png

Actual Output:
image_6.png