11–20 of 45 posts
I've done some VBA for work. If I build an Excel file with SharpCells and send them to someone who doesn't have it. What happens when they open it? From what I understand, .NET is pretty easy to decompile. Is it possible to make a SharpCells F# to VBA translation before saving?
I agree that the non-portability of such Excel extensions is a showstopper for many use cases.
Call me when Excel “programs” don’t silently give corrupted output when a formula or critical input is accidentally clobbered by a keypress.
I work on Excel and this is really cool and I’ll share it with the rest of the engineers.
https://learn.microsoft.com/en-us/office/client-developer/ex...
https://learn.microsoft.com/en-us/office/troubleshoot/excel/...
I work with data warehouses, but I'm really jealous of the way our Finance team uses some abysmal plugin to directly query our GL from inside Excel - building something like that the can make the contents of a modern data warehouse available to Excel users has always been a holy grail for me.
My hunch is that exposing free-form SQL in Excel doesn't work, but something more like structured metrics (something roughly like dbt metrics) could potentially work? And tooling like this is probably what I'd want to prototype with.
Call me when Excel “programs” don’t silently give corrupted output when a formula or critical input is accidentally clobbered by a keypress.
Call me when Excel doesn't randomly insist that things are dates.
Why is this a subscription?