1. Feedback
  2. React
  3. 12372

Welcome to the React feedback portal. We’re happy you’re here! If you have feedback on how to improve the React, 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!

4
Votes

Support for LEFT and INDIRECT Formulas in Spreadsheet

Need to provide support for the LEFT and INDIRECT formulas in the spreadsheet component to enhance its capabilities for text manipulation and dynamic cell referencing.


LEFT Formula

The LEFT function returns a specified number of characters from the beginning of a string.

  • Formula Syntax:

=LEFT(text, [num_chars])

  • Parameters:
    • text: The string or cell reference containing the text you want to extract characters from.
    • [num_chars]: The number of characters you want to extract. If omitted, it defaults to 1.
  • Example:
    • Extract the first 3 characters from the string in cell A1:

=LEFT(A1, 3)

    • Extract the first 4 characters from the string in B2:

=LEFT(B2, 4)

INDIRECT Formula

The INDIRECT function returns the reference specified by a text string. This allows you to create dynamic cell references.

  • Formula Syntax:

=INDIRECT(ref_text, [a1])

  • Parameters:
    • ref_text: The reference to a cell or range of cells, given as a text string (e.g., "A1", "B2").
    • [a1]: Optional. A boolean value indicating the style of reference:
      • TRUE or omitted: refers to the cell in A1 style (e.g., "A1").
      • FALSE: refers to the cell in R1C1 style (e.g., "R1C1").
  • Example:
    • Use INDIRECT to reference the value in cell A1 dynamically:

=INDIRECT("A1")

    • Use INDIRECT to reference a range from another sheet:

=INDIRECT("Sheet2!A1:B5")

Additional case for INDIRECT formula:

  • When implementing support for INDIRECT in formulas, we need to ensure that if the INDIRECT formula is used as the source for List data validation, the validation list is correctly filled using the named range referenced by the INDIRECT function.