|
View Poll Results: Is Excel formula a programming language?
|
No
|
|
1 |
12.50% |
No, but indented
|
|
2 |
25.00% |
no;
|
|
2 |
25.00% |
(NO)
|
|
1 |
12.50% |
{no}
|
|
2 |
25.00% |
10 NO
|
|
3 |
37.50% |
Noland
|
|
2 |
25.00% |
Planet No
|
|
2 |
25.00% |
Dr. No
|
|
4 |
50.00% |
04-24-2021, 07:44 PM
|
|
Solipsist
|
|
Join Date: Jul 2004
Location: Kolmannessa kerroksessa
Gender: Male
|
|
The world’s most widely used programming language get custom functions!
Yes, Microsoft really called this the world’s most widely used programming language.
I guess in the same sense that Excel is a robust enterprise-class database.
We're talking about Excel formulas, you know, the stuff you write directly in cells: =IF(A2="Bob",B2*1.15,B2).
xkcd this week alerted me to the news:
And here's the Microsoft announcement from December:
Announcing LAMBDA
Quote:
Today we are releasing to our Beta customers a new capability that will revolutionize how you build formulas in Excel. Excel formulas are the world’s most widely used programming language, yet one of the more basic principles in programming has been missing, and that is the ability to use the formula language to define your own re-usable functions.
=LAMBDA
Simply put, LAMBDA allows you to define your own custom functions using Excel’s formula language. Excel already allows you to define custom functions, but only by writing them in an entirely different language such as JavaScript. In contrast, LAMBDA allows you to define a custom function in Excel’s own formula language.
|
The nightmare is real: 'Excel formulas are the world's most widely used programming language,' says Microsoft • The Register
Widely used, I'll accept. I've seen what accountants and sales managers do with Excel formulas, and it's scary. But a programming language?
|
04-24-2021, 08:16 PM
|
|
Adequately Crumbulent
|
|
Join Date: Jan 2005
Location: Cascadia
Gender: Male
|
|
Re: The world’s most widely used programming language get custom functions!
Your poll is missing "No"
|
04-24-2021, 09:27 PM
|
|
Solipsist
|
|
Join Date: Jul 2004
Location: Kolmannessa kerroksessa
Gender: Male
|
|
Re: The world’s most widely used programming language get custom functions!
Yes, it isn't
|
04-24-2021, 09:55 PM
|
|
puzzler
|
|
Join Date: Aug 2004
Location: UK
|
|
Re: The world’s most widely used programming language get custom functions!
Also 'No
The apostrophe (usually) prevents Excel from mangling what you type using its dreaded "smart formatting" Programmers who've flirted with FORTH in the dim and distant past pronounce it as tick-No.
__________________
|
04-25-2021, 08:15 AM
|
|
California Sober
|
|
Join Date: Jul 2004
Location: Silicon Valley
Gender: Bender
|
|
Re: The world’s most widely used programming language get custom functions!
The apostrophe is also how you do SQL injections, too. So there's that.
|
04-25-2021, 10:13 AM
|
|
Solipsist
|
|
Join Date: Jul 2004
Location: Kolmannessa kerroksessa
Gender: Male
|
|
Re: The world’s most widely used programming language get custom functions!
Quote:
Originally Posted by Ensign Steve
The apostrophe is also how you do SQL injections, too. So there's that.
|
|
04-25-2021, 10:35 AM
|
|
mesospheric bore
|
|
Join Date: Jul 2005
Location: New Zealand
Gender: Male
|
|
Re: The world’s most widely used programming language get custom functions!
Not really having a problem with calling it a programming language. I'm generally more interested in whether particular qualities make something useful or interesting than I am in demarcation. That said, while Excel's lambda makes the language Turing complete, is Excel really any more useful for anything other than relatively simple computations now?
Not to rag on Excel, I've used it plenty, but mostly as a quick and dirty way of performing the same computations on lots of different inputs with quick visual feedback.
|
04-25-2021, 10:59 AM
|
|
Solipsist
|
|
Join Date: Jul 2004
Location: Kolmannessa kerroksessa
Gender: Male
|
|
Re: The world’s most widely used programming language get custom functions!
Well yes. If I still had to do things where Excel is a given - existing systems produce Excel-formatted outputs (done well ... or not), other people producing ever-so-important weekly or monthly management reports needs inputs in Excel style - I would be right on this.
But have you ever seen "Excel formulas" as one of the categories in the many "most popular / most widely used programming language" lists?
|
04-26-2021, 07:32 AM
|
|
mesospheric bore
|
|
Join Date: Jul 2005
Location: New Zealand
Gender: Male
|
|
Re: The world’s most widely used programming language get custom functions!
No, but but aren't those are generally compiled from coder self-report or lines on GitHub or some other thing where Excel formulas wouldn't show up? Besides, I've seen CSS on such lists.
As an aside while looking into this I ran across a page of things which turn out to be Turing complete. Including an Excel spreadsheet prior to this lambda thing as well as Apache mod_rewrite, SQL and Magic: The Gathering.
|
04-27-2021, 12:10 AM
|
|
liar in wolf's clothing
|
|
Join Date: Feb 2005
Location: Frequently about
|
|
Re: The world’s most widely used programming language get custom functions!
Turns out I've been a programmer all along
|
04-27-2021, 01:09 AM
|
|
Shitpost Sommelier
|
|
|
|
Re: The world’s most widely used programming language get custom functions!
Them Visual Basic macros. Gateway drug to coding.
__________________
Peering from the top of Mount Stupid
|
04-27-2021, 05:21 AM
|
|
A Very Gentle Bort
|
|
Join Date: Jan 2005
Location: Bortlandia
Gender: Male
|
|
Re: The world’s most widely used programming language get custom functions!
__________________
\V/_ I COVLD TEACh YOV BVT I MVST LEVY A FEE
|
04-27-2021, 09:47 PM
|
|
Forum Killer
|
|
|
|
Re: The world’s most widely used programming language get custom functions!
This would have been seriously useful in 1983. As is, this feature has been absent so long they've built several entire languages to work around it.
|
04-27-2021, 11:11 PM
|
|
Solipsist
|
|
Join Date: Jul 2004
Location: Kolmannessa kerroksessa
Gender: Male
|
|
Re: The world’s most widely used programming language get custom functions!
EXACTLY.
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT +1. The time now is 05:35 AM.
|
|
|
|