Hey HN, I'm Matt, I founded Jog with Nathan. We spent 50K/month on CI at our last company. Agents are writing a ton of code and making the problem worse so we wanted to fix it from first principles. Jog runs on dedicated hardware - Zen 4/5 chips - in the US and EU. Happy to answer any questions.
Yeah we think there is an opportunity to really open up the xlsx runtime. There are a lot of smart people in the world - and we're excited for them to build on top.
Ok, I see it now, thanks! I was able to reference columns after adding the table as a defined name manually. You've already mentioned that it's not yet fully featured, but just to catalog a few things:
- In Excel, when you format a range as a table, usually they become a defined/named range by default (Table_1). If that's happening in the background, it's not apparent to me as a user
- Named ranges should get suggested in autocomplete when typing formulas
- The cell name box in the top left corner should reflect range selections (e.g. A1:B4) and likewise table references when selected
- The cursor should transform to a down arrow and allow the selection of entire table columns when hovering over header cells
- Should likewise be able to select table data range when hovering over the top left corner
openpyxl is great at what it does, but it’s a file-format library rather than a workbook runtime.
It can insert columns, for example, but it doesn’t maintain dependencies such as formulas, tables, charts, or defined names when doing so. It also doesn’t evaluate formulas.
Nobie runs the workbook like Excel would: it evaluates formulas, maintains workbook semantics through edits, renders the result, and reads and writes the file.
Roughly speaking, Nobie is to an Excel workbook what V8 is to JavaScript. openpyxl is closer to a parser and serializer.
agents do a lot better when they can "run" the excel workbook and understand the impact of inputs, and how pixels look when layering on things like conditional formats.
That's fair, we don't support the functions tied to custom DLL loading xD
To be more precise, we support the entire "modern" function library in excel, that can be implemented without dependencies on Microsoft products/services. So if it can run locally, and isn't platform dependent, we run it. We, for example, support https://support.microsoft.com/en-us/excel/functions/filterxm... , so in some ways, we support more of excel than excel on non-windows platforms :P
We also support what-if scenarios, arrays, spills, cycles, all the non-cloud / non-DLL excel functions, data tables, conditional formatting, charts (though we don't allow creating / editing at the moment, that's coming very soon, there's a lot of configuration surface in those things, and we want the experience to be really good), etc. If you haven't tried it, maybe take it for a spin, I think you'll be pleasantly surprised with how much functionality we have.
Our biggest deficiency right now (in my opinion) is pivot tables, we don't let you create / edit / recalc them (though you can still build formulas on them). Our engine supports them, but we're still doing a bunch of testing on it to make sure it's rock solid before we turn them on for people.
reply