Wojciech Czerniak

Create Excel compatibility page

4

### Description Would be cool to create a page that would explain which options should be used, and which values to configure full Excel compatibility. Explain each option and why....

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

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

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

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

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

Named Expressions: structured references (aka Stage 3)

2

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

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

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

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