xlsx-calc
xlsx-calc copied to clipboard
fabiooshiro
javascript nodejs excel formula parser
If i use a formula of `FLOOR(IF(ISERROR(AVERAGE(Sheet1!D2:D)),0,AVERAGE(Sheet1!D2:D)),1)` , IE floor of average of a column, or zero if column is an error, the result I get after running the calculation...
I am modifying one worksheet of a spreadsheet and then recalculating the values. Some of the other sheets have some erroneous formulas and the recalculation aborts as soon as an...
Cir Ref
Hi again thanks for your work and your help in advance. I have the following Object `{ "B4": { "t": "s", "v": "A", "r": "A", "h": "A", "z": "General", "w":...
```js const express = require('express'); const XLSX = require('xlsx'); const XLSX_CALC = require('xlsx-calc'); const formulajs = require('@formulajs/formulajs'); const db = require('../db'); const Vehicles = require('../db/repo/Vehicles'); const router = express.Router(); XLSX_CALC.import_functions(formulajs,...
Hi, I understand that we can register new functions in formulas.js. I am having issues trying to implement the INDIRECT function. Any tips would be greatly appreciated ? Probably just...
Hi, thank you so much for your effort you put into this project!! First time, I am opening an issue, so I hope to do it correctly. My script errors...
In Excel, `=0=""` is FALSE `=0""` is TRUE In xlsx-calc, `=0=""` is TRUE `=0""` is FALSE See: https://github.com/fabiooshiro/xlsx-calc/blob/e303d2096d1a1ffb127e26a8212212d5d1ce3f2f/src/Exp.js#L164 https://github.com/fabiooshiro/xlsx-calc/blob/e303d2096d1a1ffb127e26a8212212d5d1ce3f2f/src/Exp.js#L179
Hello, I am trying to calculate next formula: =6^4-4^4 it is failing (return wrong value)  
Hi there, Great library, I'm a big fan. I've got to the stage where I'de like to implement a few UDF which equate to restful API requests. Now ideally I'de...
Fixes the operator for difference to a strict difference as before this change 0 would be considered as equal to an empty string which should be false. A test has...
