You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Looking to make a more useful tool in general. The parsing logic pretty crude and the js conversion is a bit hacked together. I'll take a look! Thanks for the tip
Cute website!
You are not properly parsing range intersections:
The formula is evaluated as
=SUM((B2:C3))
If you want to see the formula building blocks, consult
MS-XLS Ptg*
records. XLS files don't store the string version of the formulas, which is why the formula spec is laid out. Relevant code block from js-xls: https://github.com/SheetJS/js-xls/blob/master/bits/68_fparse.js#L114-L337The text was updated successfully, but these errors were encountered: