1. Feedback
  2. JavaScript
  3. 20494

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

Need to provide Array Formulas support in Spreadsheet

Need to provide Array formulas support in spreadsheet.


Cases:

  • Enable support for array formulas in the Spreadsheet component.
  • Allow users to define a single formula for calculations across multiple cells or data ranges.
  • Support both single-cell and multi-cell array formulas for enhanced flexibility.
  • Ensure compatibility with standard spreadsheet applications like Excel.
  • Facilitate advanced calculations such as summation, multiplication, and logical operations on data arrays.
  • Optimize functionality for handling large datasets and repetitive tasks efficiently.
  • Currently, only single-cell arithmetic expressions (e.g., A1 * B3) are supported. Support for expressions involving multiple ranges (e.g., A1:B1 * C1:D1) should also be added to ensure consistent behavior with array formulas.
  • Additionally, cases to be covered:
    • Full support for all standard operators (+, -, *, /, etc.),
    • Updating adjacent cells automatically when a multi-cell formula is applied,
    • Tracking dependent cells and ensuring recalculation when input values change,
    • Preventing overwrite conflicts and handling error cases (like #REF!, #SPILL!) appropriately.