hyperformula

hyperformula copied to clipboard

Add unit tests for apostrophe operator

1

### Context ### How has this been tested? ### Types of changes - [ ] Bug fix (non-breaking change which fixes an issue) - [ ] New feature or improvement...

sequba

Does not support reference operators

1

### 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...

wojciechczerniak

Support 3D references

2

### Description Since we're supporting Worksheets it would be cool to support all features. ``` =SUM(Sheet1:Sheet4!B3) ```  We need to support all CRUD operations on Worksheets: - Add sheet...

wojciechczerniak

### Description This is a part of the #126 Named Expressions Epic. #### Goals Finish the Structured References syntax to the point of full compatiblity with XL. It should be...

wojciechczerniak

Named Expressions and Structured References

9

### TL;DR; Sometimes columns (and rows) have customized names. Using the A1 or R1C1 addressing in this context is very confusing for the end-user. We need a way to translate...

wojciechczerniak

### Description From working on Custom Functions #317 looks like it's useful to have functions and languages registered globally (static) and locally (instance) so we can have both, shared registry...

wojciechczerniak

Named Expressions: structured references (aka Stage 3)

3

### Description This is a part of the #126 Named Expressions Epic. #### Goals - [ ] Add support for #131 array type named expressions `=A1:C22` - [ ] Add...

wojciechczerniak

Named Expression returns #CYCLE! in changes

1

### Description When Named Expression is added the changes are calculated. With an absolute address, the changes will be calculated for real values that are part of the workbook. But...

wojciechczerniak

#CYCLE! shouldn't occur when the IF condition is not met

6

### Description If we have an IF function where the conditions that lead to #CYCLE! error isn't met we will get an error anyway. All other spreadsheets I've checked, GS,...

wojciechczerniak

Add cellAddress to "Value of the formula cell is not computed." error message

2

### Description We should add a cell address to the error message so we can trace the source of this error more easily. https://github.com/handsontable/hyperformula/blob/508e4e4d9961473a35686354f46e3162be2cd53e/src/DependencyGraph/FormulaCellVertex.ts#L74 A simple `JSON.stringify` should do. ie:...

wojciechczerniak