1. Feedback
  2. JavaScript
  3. 39845

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!

3
Votes

Support Full Row and Full Column References in Formulas

Description


Enhance the Spreadsheet formula engine to support entire rows and entire columns as valid range references within formulas, providing behavior consistent with widely adopted spreadsheet applications. This enables users to reference complete rows or columns without specifying explicit start and end cell boundaries.


Examples:

  • =SUM(A:A)
  • =COUNTA(B:B)
  • =AVERAGE(1:1)
  • =MAX(2:5)
  • =VLOOKUP("Value", C:E, 2, FALSE)

Currently, formulas only accept bounded ranges such as A1:A100 or A1:D50. As a result, users must define arbitrary limits or continuously update formula ranges when data is added beyond the original boundaries. This introduces additional maintenance effort, increases the possibility of incomplete calculations, and creates compatibility gaps when working with spreadsheets that already contain full row or column references.


The proposed enhancement should allow the formula engine to recognize and evaluate the following reference patterns:

  • Full column references: A:A, B:B, A:C, AA:AC
  • Full row references: 1:1, 5:5, 1:10
  • Cross-sheet references: Sheet2!A:A, Sheet2!1:1

These references should be treated as dynamic ranges that automatically include all cells belonging to the referenced rows or columns. Formulas using such references should participate in standard calculation workflows and update automatically when data is added, modified, or removed within the referenced range.


The support should be available across all applicable built-in formula categories, including mathematical, statistical, logical, lookup, text, date/time, information, and financial functions, ensuring a consistent formula authoring experience.


Additionally, the Spreadsheet should preserve these references in formulas without converting them to bounded ranges, enabling seamless editing, loading, and saving of spreadsheets that contain full row and column references.


Expected Benefits

  • Improves compatibility with existing spreadsheets that use full row or column references.
  • Reduces formula maintenance for growing and dynamic datasets.
  • Eliminates the need to define artificial range boundaries.
  • Simplifies formula authoring and improves readability.
  • Ensures calculations automatically adapt as data expands.