1. Feedback
  2. Angular
  3. 61699

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

Support for VALUE, ROW, and LINEST formulas in Spreadsheet Component

We need to consider the addition of support for the following formulas in the Syncfusion Spreadsheet component. These formulas are essential for enhancing the functionality and accuracy of data processing within the component.

Requested Formulas:

  1.   VALUE – Converts text that appears in a recognized number format (such as a number, date, or time) into an actual numeric value.
  2.   ROW – Returns the row number of a reference.
  3.   LINEST – Returns statistical information about a best-fit straight line using the least squares method. It provides coefficients like slope and intercept, along with standard error values.

Use cases:

  1. The VALUE function ensures that text-formatted numbers can be automatically converted into numerical values for further calculations.
  2. The ROW function simplifies row identification, which is useful for dynamic calculations and table manipulations.
  3. The LINEST function is critical for statistical and regression analysis, providing insights into trends and data relationships.