hyperformula
hyperformula copied to clipboard
Published
20 hours ago •
handsontable
handsontable
Does not support reference operators
Description
HyperFormula does not support reference operators for union and intersection.
⚠️ Because there are differences in syntax it might be necessary to add configuration #58 options.
Differences in implementations
Excel
| Reference operator | Meaning | Example |
|---|---|---|
| : (colon) | Range operator, which produces one reference to all the cells between two references, including the two references | B5:B15 |
| , (comma) | Union operator, which combines multiple references into one reference | SUM(B5:B15,D5:D15) |
| (space) | Intersection operator, which returns a reference to the cells common to the ranges in the formula. In this example, cell C7 is found in both ranges, so it is the intersection. |
Libre Calc
| Operator | Name | Example |
|---|---|---|
| : (Colon) | Range | A1:C108 |
| ! (Exclamation point) | Intersection | SUM(A1:B6!B5:C12) Calculates the sum of all cells in the intersection; in this example, the result yields the sum of cells B5 and B6. |
| ~ (Tilde) | Concatenation or union | Takes two references and returns a reference list, which is a concatenation of the left reference followed by the right reference. Double entries are referenced twice. |
Google Spreadsheet
Not supported.
