xlsx-calc
xlsx-calc copied to clipboard
fabiooshiro
javascript nodejs excel formula parser
Hi, I found an error in your calculation logic. Please find attached file for an easy example: - Result 1 = Value 1 / Value 2 - Result 2 =...
I have a protected worksheet that has been formatted to print to PDF from excel.. I am updating the values of other sheets using SheetJS. When I read the workbook...
when calculate formula referenced empty cell, the result is not correct. this pr try to fix it.
I am adding support for dynamic array in basic operators and the `IF` function. Multiple test cases have been added for this. ## Basic examples ### Plus | | A...
I am adding [`ROW`](https://support.microsoft.com/en-us/office/row-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d) and [`COLUMN`](https://support.microsoft.com/en-us/office/column-function-44e8c754-711c-4df3-9da4-47a55042554b) functions to `formulas-raw.js`. They cannot be implemented as regular functions or be handeled by formulajs because they rely on reading the cell references instead...
Bumps [json5](https://github.com/json5/json5) from 1.0.1 to 1.0.2. Release notes Sourced from json5's releases. v1.0.2 Fix: Properties with the name __proto__ are added to objects and arrays. (#199) This also fixes a...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
Greetings Oshiro san, First I'd like to thank you for this great js lib, it's awsome. I encountered some unexpected results from xlsx-calc. It seem that xlsx-calc does not perform...
It doesn't seem like `xlsx-calc` can handle [structured references](https://support.microsoft.com/en-us/office/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e) yet. See some of the errors that I am getting when the `exec/check_variable` function is ran (in the Exp.js file): ```...
