Popular functions missing from HyperFormula

[sequba]

22 most commonly used Excel functions that are missing from HyperFormula (in alphabetical order)

CELL: Returns information about a cell such as its format, location, or contents.
CONCAT: Concatenates (joins together) multiple text strings into one.
DATEADD: Adds a specified number of units to a date and returns the resulting date.
DATEIF: Calculates the difference between two dates in days, months, or years.
DAVERAGE: Calculates the average of values in a column of a database that match specified criteria.
DCOUNT: Counts the number of cells in a database that match specified criteria.
DSUM: Adds the numbers in a column of a database that match specified criteria.
ERROR.TYPE: Returns a number corresponding to the type of error in a cell.
FILTERXML: Extracts specific data from XML-formatted text using XPath queries.
FORECAST: Predicts future values based on existing data using linear regression.
GETPIVOTDATA: Retrieves data stored in a pivot table based on specific criteria.
INDEX-MATCH: Finds a value in a table or range by row and column headers.
INDEX-MATCH-MATCH: Finds a value in a table or range by matching two criteria.
INDIRECT: Returns the reference specified by a text string.
INFO: Returns information about the current operating environment.
MODE: Returns the most frequently occurring value in a dataset.
PERMUT: Calculates the number of permutations for a given number of objects.
RANDARRAY: Generates an array of random numbers between specified boundaries.
SORT: Sorts the contents of a range or array in ascending or descending order.
SORTBY: Sorts the contents of a range or array based on the values in another range or array.
TEXTJOIN: Joins together multiple text strings using a specified delimiter.
UNIQUE: Returns a list of unique values from a range or array, removing duplicates.

This list was produced by comparing the list of 130 most used Excel functions (according to ChatGPT) with the built-in functions in HyperFormula.

It could be concluded that, according to ChatGPT, HypeFormula includes 83% of 130 Excel's most used functions.

15 functions from OpenDocument Formula standard Small Group Evaluator that are missing from HyperFormula (in alphabetical order)

DAVERAGE: Calculates the average of values in a column of a database that match specified criteria.
DCOUNT: Counts the number of cells in a database that match specified criteria.
DCOUNTA: Counts non-empty cells in a database that match specified criteria.
DGET: Returns a single value from a database based on specified criteria.
DMAX: Returns the maximum value from a column in a database that match specified criteria.
DMIN: Returns the minimum value from a column in a database that match specified criteria.
DPRODUCT: Multiplies values in a column of a database that match specified criteria.
DSTDEV: Estimates the standard deviation based on a sample of values in a column of a database that match specified criteria.
DSTDEVP: Calculates the standard deviation based on all values in a column of a database that match specified criteria.
DSUM: Adds the numbers in a column of a database that match specified criteria.
DVAR: Estimates the variance based on a sample of values in a column of a database that match specified criteria.
DVARP: Calculates the variance based on all values in a column of a database that match specified criteria.
IRR: Calculates the internal rate of return for a series of cash flows occurring at regular intervals.
N: Converts a value to a number.
VALUE: Converts a text string that represents a number to a numeric value.

[adjenks]

You should really validate it yourself instead of just using chatgpt, but yes, I thought that it was compatible with excel, but I found myself here because I was trying to use CONCAT and it didn't work which was quite disappointing.

[AMBudnik]

Let's connect that topic for readability #1529