1. Blame Microsoft for not conforming to their own standard. There's a reason the EU uses ODF instead of the mess that is OOXML. Different versions of MS Office aren't even fully compatible with each other. Also nowadays, you can use Office 365 in a web browser. For desktop, there is LibreOffice and OnlyOffice, which have okay compatibility. MS Office can also open ODF files, as is legally mandated by the EU, since it would be considered anticompetative if they didn't.

2. I don't use those functions of Excel, so I can't comment. Also to be clear, are you asking if you can program without a Terminal? I'm not even sure what the question is. VBA is a proprietary Microsoft-specific scripting language, so of course there won't be native support for that in non-Windows OSs, although there might be a reverse engineering effort I'm not familiar with.

Blaming Linux for a problem that Microsoft caused and won't solve due to anticompetative practices is just dumb. Microsoft basically invented the concept of Embrace, Extend, extinguish, and Office is a prime example of that.