A calculation module for spreadsheet
npm install @oglabs/calcA calculation module for spreadsheet
1. Runs asynchronously
1. Able to run on web workers
1. Able to return multiple results based on cell-dependency
1. Able to run multiple calculations (batch)
1. Able to run single calculation
1. Ability to run in cloudflare workers (Todo)
``
import { CalcEngine } from '@oglabs/spreadsheet'
// Initialize
const calcEngine = new CalcEngine()
// Optional - Dump all sheets to calculation engine during initial load
const changes = calcEngine.initialize(changes, getCellConfig)
// Single cell calculation
const results = await calcEngine.calculate(value, sheet, cell, getCellConfig)
// Multiple batch
const results = await calcEngine.calculateBatch(changes, getCellConfig)
``