handsontable / handsontable/hyperformula
Does not support reference operators
Open
Nobody has claimed this yet.
Feature
ODFF Conformance
ODFF MGE
ODFF SGE
Verified
- Dominant language
- TypeScript
- Stars
- 2.8k
- Forks
- 171
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 7
Description
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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing the reference-operator differences listed for Excel and LibreOffice Calc, then inspect configuration options related to issue #58. Done means defining the supported syntax and implementing union and intersection references consistently with the chosen configuration.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- typescript
- Domain
- backend
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100