4 ms·

By far the most popular programming language in the world is propriatary -- Excel.

catchclose8919 4y ago
There's many open-source alternatives to Excel. Rarely used, but it settles any fear of lock in. This also made the area palatable for other commercial competitors to enter the space - Google-sheets drive A TON of enterprise org work nowadays. You could say that open-source alternatives immensely popularized spreadsheets and resulted in the very nice ecosystem we have now. Sure, heave finance user stick to MS Excell because MS is pressured to cater very well to their needs, else they will move away to other free or paid alternatives. Also, there's a reason why multi-dimensional spreadheets are not more popular despite solving so many problems of regular spreadheets: all are proprietary and very different one from another - you probably pick smth like Quantrix (https://quantrix.com/products/quantrix-modeler/ https://quantrix.com/products/quantrix-modeler/), and you'd get insane prices and 100% lock-in... better stick to Excell and/or its open-source and/or free alternatives despite being a worse tool :)
- pjmlp 4y ago
  Since when is Google sheets not proprietary?
capableweb 4y ago
Excel is built with programming language and can certainly be used as one, but that doesn't mean it is one. It's also a bit anal to classify Excel as a programming language, most people would say spreadsheets are a tool, where you could write programs, but again, doesn't mean it's a programming language. At most, I'd give you that Excel is a tool that can do "visual programming", but that's far of from being a "programming language".
- zaphar 4y ago
  This is unfair and a far too narrow definition of programming language. Excel sits very squarely in the functional reactive language space. Just because most of it's users don't "know" they are programming and most of our common tools don't work with it doesn't change the fact that it has pretty much all of the building blocks that any programming language gives you. Are there domains where Excel is awkward to use? Absolutely. The same can be said about pretty much any programming language. Excel deserves to have the label of programming language even if it shuns that label due to it's target audience.
  - capableweb 4y ago
    I guess what I was trying to say that Excel as commonly known, is a programming environment, rather than a language. Where you can use the "Excel" programming language for performing most (if not all) tasks a general purpose programming language can. But it's still a bit like saying "Eclipse" is a programming language. You can do programming in Eclipse, that is true, but you can also do other things that are not programming, which makes Eclipse a programming environment. Just like with Excel.
    - zaphar 4y ago
      I don't think this is a true dividing line for a programming language. The Smalltalk language for instance combines both the programming environment and the language together. I don't think anyone seriously argues that smalltalk is not a programming language.
      - igouy 4y ago
        Seems like equivocation — Smalltalk is a programming language when we're using "Smalltalk" to mean Smalltalk the programming language and Smalltalk is a programming environment when we're using "Smalltalk" to mean Smalltalk the programming environment.
        zaphar 4y ago
        Either way it is still entirely valid to refer to Smalltalk as a programing language.
        igouy 4y ago
        As-long-as you actually mean a "narrow definition of programming language" otherwise you're saying one thing while meaning another.
  - igouy 4y ago
    The label of programming language goes to Visual Basic for Applications (VBA). https://docs.microsoft.com/en-us/office/vba/api/overview/excel https://docs.microsoft.com/en-us/office/vba/api/overview/exc...

There's many open-source alternatives to Excel. Rarely used, but it settles any fear of lock in. This also made the area palatable for other commercial competitors to enter the space - Google-sheets drive A TON of enterprise org work nowadays. You could say that open-source alternatives immensely popularized spreadsheets and resulted in the very nice ecosystem we have now. Sure, heave finance user stick to MS Excell because MS is pressured to cater very well to their needs, else they will move away to other free or paid alternatives. Also, there's a reason why multi-dimensional spreadheets are not more popular despite solving so many problems of regular spreadheets: all are proprietary and very different one from another - you probably pick smth like Quantrix (https://quantrix.com/products/quantrix-modeler/ https://quantrix.com/products/quantrix-modeler/), and you'd get insane prices and 100% lock-in... better stick to Excell and/or its open-source and/or free alternatives despite being a worse tool :)

pjmlp 4y ago
Since when is Google sheets not proprietary?

capableweb 4y ago

Excel is built with programming language and can certainly be used as one, but that doesn't mean it is one. It's also a bit anal to classify Excel as a programming language, most people would say spreadsheets are a tool, where you could write programs, but again, doesn't mean it's a programming language. At most, I'd give you that Excel is a tool that can do "visual programming", but that's far of from being a "programming language".

zaphar 4y ago
This is unfair and a far too narrow definition of programming language. Excel sits very squarely in the functional reactive language space. Just because most of it's users don't "know" they are programming and most of our common tools don't work with it doesn't change the fact that it has pretty much all of the building blocks that any programming language gives you. Are there domains where Excel is awkward to use? Absolutely. The same can be said about pretty much any programming language. Excel deserves to have the label of programming language even if it shuns that label due to it's target audience.
- capableweb 4y ago
  I guess what I was trying to say that Excel as commonly known, is a programming environment, rather than a language. Where you can use the "Excel" programming language for performing most (if not all) tasks a general purpose programming language can. But it's still a bit like saying "Eclipse" is a programming language. You can do programming in Eclipse, that is true, but you can also do other things that are not programming, which makes Eclipse a programming environment. Just like with Excel.
  - zaphar 4y ago
    I don't think this is a true dividing line for a programming language. The Smalltalk language for instance combines both the programming environment and the language together. I don't think anyone seriously argues that smalltalk is not a programming language.
    - igouy 4y ago
      Seems like equivocation — Smalltalk is a programming language when we're using "Smalltalk" to mean Smalltalk the programming language and Smalltalk is a programming environment when we're using "Smalltalk" to mean Smalltalk the programming environment.
      - zaphar 4y ago
        Either way it is still entirely valid to refer to Smalltalk as a programing language.
        igouy 4y ago
        As-long-as you actually mean a "narrow definition of programming language" otherwise you're saying one thing while meaning another.
- igouy 4y ago
  The label of programming language goes to Visual Basic for Applications (VBA). https://docs.microsoft.com/en-us/office/vba/api/overview/excel https://docs.microsoft.com/en-us/office/vba/api/overview/exc...