search

Digital-Defiance / OpenBook

Enhance organizational transparency by indexing structured Markdown files into Excel & API queryable views, enabling detailed tracking such as membership or grant usage through transactional records, while maintaining data in a version-controlled, queryable system.
MIT License
0 stars 1 forks source link

feature: Views with excel formulas no longer have usable data when not viewed in excel, consider formula.js #5

Open JessicaMulein opened 11 months ago

JessicaMulein commented 11 months ago

As a consequence of enabling excel formulas, now the view data for non-excel routes has less meaningful data. Is it worth trying to support and calculate basic formulas or is that too big a can of worms?

Consider emulating Excel formulas and other support in views without excel so that views with excel make sense, such as a transaction with a computed total based on a quantity and amount, or a _bottom.md with a sum or other totaling mechanism. They render well in Excel, but when queried through the API, they are less useful. Formula.js for example might be used.

JessicaMulein commented 6 months ago

Work currently in progress with HyperFormula and XLSX/SheetJS to do formulas and HTML rendering