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

idea: consider an alternate way to specify cell formatting #7

Open JessicaMulein opened 11 months ago

JessicaMulein commented 11 months ago

currently we have the support for = formulas and =$ formulas which are formatted as currencies.

consider something like inline JSON instead of =, so if the cell text starts/ends with curly or square brackets, interpret as json or perhaps some other indicator like a dollar sign or pipe

consider extending the view json to specify that certain rows (such as _bottom) or cells are formatted a certain way such as all of column X (less the header) is currency, then we could get rid of the =$ construct and only support plain excel formulas.

Basically we need a way to replace the =$ with something more intuitive.

I think I like the view.json approach better, but it needs some development.

JessicaMulein commented 6 months ago

in progress. !&&format&&=formula is now partially supported.