3 ms·
I am not talking about per cell formulas like in Excel. I am talking about a basic expression language that operates on the entire column, more like a database.
by replwoacause 4y ago
I am not talking about per cell formulas like in Excel. I am talking about a basic expression language that operates on the entire column, more like a database. Modern CSV already has some basic data transformation facilities, I'm only suggesting a few more in the same vein that make it a more potent data editing tool.
- jerf 4y agoPossibly the most efficient and effective method here would be to integrate Lua into the internal data structure used for cells, and let replwoacause do whatever they like with a scripting language. I can definitely see how that would be useful to people. I would actually be wary of trying to make this too much like a spreadsheet, even in appearance. You'll be pulled into that strange attractor, but you can't hope to compete in that space. Whatever oxygen isn't consumed by Excel itself is long gone between LibreOffice and online spreadsheets. Another possibility would be integrating with SQLite via CSV export and giving people an SQLite console: https://www.sqlitetutorial.net/sqlite-import-csv/ https://www.sqlitetutorial.net/sqlite-import-csv/