Yeah, I’ve dumped all mikroshite from my devices for FOSS software. Only my work laptop has it and I never do anything personal with that. Libre Office, Thunderbird, Notesnook. Also considering Obsidian and Joplin.
LibreOffice Calc. I think it still has some performance issues vs Excel with extremely large files, and it can only do 1024 columns. Also LibreOffice Basic can do a lot of what VBA could but the syntax is different and I don’t think it integrates well with the rest of the system like VBA’s COM integration (as unsafe as that was)
If you aren’t pushing Excel to its absolute limits then it’s more than enough.
What about tables, pivot tables, power query, grouping of rows and columns , and how is formula/function parity (xlookup, index, match, sumproduct, etc)?
I’ve made some truly Frankenstein sheets that I’m not sure could be stitched together elsewhere.
Yeah, I’ve dumped all mikroshite from my devices for FOSS software. Only my work laptop has it and I never do anything personal with that. Libre Office, Thunderbird, Notesnook. Also considering Obsidian and Joplin.
Which one is the Excel replacement and how does it compare? We all know companies buy office mostly just for excel…
LibreOffice Calc. I think it still has some performance issues vs Excel with extremely large files, and it can only do 1024 columns. Also LibreOffice Basic can do a lot of what VBA could but the syntax is different and I don’t think it integrates well with the rest of the system like VBA’s COM integration (as unsafe as that was)
If you aren’t pushing Excel to its absolute limits then it’s more than enough.
What about tables, pivot tables, power query, grouping of rows and columns , and how is formula/function parity (xlookup, index, match, sumproduct, etc)?
I’ve made some truly Frankenstein sheets that I’m not sure could be stitched together elsewhere.