1. Feedback
  2. JavaScript
  3. 42091

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

Need to include the listed unsupported formula into Spreadsheet component

Need to include the unsupported formula into the spreadsheet component. The formula to be included are listed below.

  1. =STDEV() -- Standard Deviation formula.
  2. =SQRT() -- Calculate the square root of the value.
  3. =RSQ() -- 
     
     Square of the Pearson product moment correlation coefficient.

  4. =TRANSPOSE --Transpose is used to switch the orientation of an array.

  5. =NOT -- Returns the opposite of a given logical or boolean value.

  6. =ROUNDDOWN() -- Rounds a number down, toward zero.

  7. =EOMONTH -- Returns the end of the month for the given date by adding a specified number of months (=EOMONTH(A2,1)).

  8. =XIRR -- To calculate the internal rate of return for a series of periodic cash flows.

  9. =RIGHT -- To extracts a specified number of characters from the right side of a provided text content.

  10. =LEFT -- To extracts a specified number of characters from the left side of a provided text content.

  11. =MID -- To extracts a specified number of characters from the middle of a
    provided text content.

  12. =IFNA -- If a formula returns the #N/A error value, this function returns the value you specify; otherwise, it returns the formula result.

  13. =ISNA -- Returns TRUE if a cell contains the #N/A error and FALSE for any other value or error type

  14. -ISERR() -- Checks if a value results in an error. 

  15. =WORKDAY() -- Returns a date that is a given number of working days before or after a start date, excluding weekends and optional holidays.

  16. =RANK.EQ() -- Returns the rank of a specified value within a list of numbers as an integer. It compares the value to others in the range, assigns consecutive ranks (starting from 1), and handles ties by giving them the same rank without skipping subsequent ranks.


  17. =DATEDIF -- To calculate the difference between two dates in years, months, or days, based on the specified unit.