“With LAMBDA, Excel has become Turing-complete. According to Microsoft, these functions can call other LAMBDA functions, even recursively. LAMBDA allows users to define new functions. The second shortcoming is addressed by the LAMBDA programming language, which was first introduced in December 2020. According to Microsoft, at the 2019 ACM SIGPLAN Symposium on Principles of Programming Languages, it introduced two new developments: data types that allow cells to contain first-class records, and dynamic arrays that allow ordinary formulas to compute whole arrays that spill into adjacent cells, Microsoft explained. The project is aimed at transforming “spreadsheet formulas into a full-fledged programming language,” Andy Gordon, senior principal research manager at Microsoft, and Simon Peyton Jones, senior principal researcher at Microsoft, wrote in a post. The first shortcoming is addressed by Microsoft’s Calc Intelligence project, which was developed at Microsoft Research Cambridge. With new developments from Microsoft, both of these issues are being addressed. The second is that Excel doesn’t let users define new functions. One shortcoming is that the Excel language only supported scalar values like numbers, strings, and Booleans. It is the world’s most powerful programming language, but it has two main shortcomings. According to the company, Excel formulas are written by a significantly larger number of people than all C, C++, C#, Java and Python developers combined. Microsoft is attempting to make Excel a more powerful application.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |