edit: I realize there is Office web and it’s good but it has nowhere enough features. Also, do you guys think (Open, Libre, Only) office has as many features as Microsoft Excel?
I am taking business studies this year and you really do need excel for that. I can obviously use OnlyOffice Suite which is quite good and will get most of the jobs done, but it’s not equivalent to MS Office suite and in business you use what’s used most frequently, so yes, MS Office it is. But as much as I realize what a key role Microsoft plays in the Business, I DO NOT WANT TO PAY for it and I certainly DO NOT want to pay a subscription for it, but I want to learn it and the best way to learn is by doing it, so, I want to install MS Office Suite on Linux without actually paying for it, so how can I do it?
Skip this rant: Every freaking thing is a subscription right now, I mean, there’s positives to that, but you feel like you own nothing. Don’t want to be a conspiracy theorist or anything, but it feels like every company took “You will own nothing and be happy” to heart. Again, subscription model has it’s advantages, but I don’t want to subscribe to something I know I am going to need for the foreseeable future.
I really can’t think of anything that excel can do that libre can’t in a business setting. Libre office has a lot of functionality. I haven’t touched Ms office in two years now.
vba macros on excel is not good on Libreoffice
I like almost everything in Libre Suite except for the God awful Libre Calc
Indeed they are not. LibreOffice docs claim VBA support is “mostly complete”. Apparently that’s a relative term because in my experience, VBA macros in Calc barely work at all.
it’s more about cross compatibility for me and there are many things I think. It lacks many of the advanced features that Excel has. But still, even if it did have it, I have to collaborate and I just can’t take chances of in compatibility (one of the reasons I am edit:not even going to use OnlyOffice which has greater compatibility. )
LibreOffice Calc is great but in the spreadsheet world, Excel is still the gold standard. One of the reasons I’m still paying for a Office 365 subscription. That and a handful of custom integrations I have with Exchange that I don’t currently have time to find alternatives for.
Can excel do regex in search and replace yet? Because libreoffice calc can.
I Love FOSS but trust me, you can’t compare MS Excel to Libre Calc, it’s far far ahead. Even the web version which is worse than the actual Excel version is better than Libre Calc. Libre Calc can’t hold a candle to Microsoft Sheets when it comes to features.
Good to know, but does it have the feature I need? Because the last time someone tried to find it, they couldn’t. That was after i told them “sure, just go to search and replace and look for the regex option which surely is there.”
I see. That does seem troubling. I have a login with access to excel. If you’d like I can dm you he login info.