hyperformula

hyperformula copied to clipboard

Call `runFunction` internally so it's easier to create custom functions

1

### Description Currently each function calls `runFunction` with a callback. It does a lot of useful things and reduces the boilerplate (ie. argument validation) so it's natural that most implementations...

wojciechczerniak

INDEX return CYCLE error when ranges overlap

6

### Description I'm trying to refer to columns by index within the current row. Usually in Excel, I would use `INDIRECT(ADDRESS(ROW(); column))` to do this. I tried to use `INDEX(A1:ZZ99;...

beikov

### Description There are several issues about it: - API reference for dateFormats and parseDateTime is not clear enough about what is possible - `'.'` is also a valid date...

sequba

HyperFormula 2.0.0 is here! This version adds support for reversed ranges, lets you expand the scope of whitespace characters allowed, drops the GPU.js dependency, and improves the behavior of the...

AMBudnik

### Description By starting the cell content with `'` character (apostrophe) our parser treats the rest of it as string. I cannot find any docs that mention this feature. ###...

sequba

### Description HyperFormula supports 3D range references (ranges spanning across multiple sheets). This is useful in many ways, as presented in multiple advanced Excel tutorials found online, e.g.: - https://www.ablebits.com/office-addins-blog/2015/12/09/excel-3d-reference-formula/...

warpech

### Description The automatic tests that we have are of 2 types: e2e tests that uses the public API only and the low-level unit tests for all the "internal" classes....

sequba

Memory leaks in unit tests

1

### Description When running unit tests we can see that the heap size increases with every spec file. There must be a memory leak somewhere. It might be related to...

sequba

Add support for inferring return types of a custom function

1

### Description As described in #875 by MartinDawson: > Consider any formula that you do not know the exact return type of or the return type is too large and...

sequba

[Research/Spike]: Ability to parse formulas for highlighting

13

So I'm doing formula syntax highlighting in my spreadsheet like this example:  Currently hyperformula does formula parsing internally however there's no way to access it and the indexes in...

MartinDawson