TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Excel Labs, a Microsoft Garage Project

104 点作者 wlkr将近 2 年前

8 条评论

bambax将近 2 年前
Some things in Excel have not improved since 2003, that should be fixed before toying with &quot;AI&quot; . For example, when importing a CSV:<p>- Excel cannot guess the encoding of the file, and relies on the user selecting it from a list that has maybe a hundred values (?!); the most common encoding, UTF-8, is neither at the top or at the bottom of that list, but somewhere near the end, and is called &quot;65001 : Unicode (UTF-8)&quot; (the preceding value is &quot;65000 : Unicode (UTF-7)&quot;). There is little chance non-technical users will get this right the first time, or any time thereafter, and the result is files that are circulated with garbled encoding and wrong values.<p>- Excel cannot guess the separators either! (How hard can it be?)<p>That&#x27;s probably the reason why one cannot &quot;open&quot; a CSV file directly in Excel and having it displayed properly; one has to go through the whole &quot;import&quot; process. Yet Windows insists all CSVs should automatically open in Excel.<p>Yes, it&#x27;s a minor thing, but it should be so easy to fix; instead of that, recent versions of Office have brought incredibly annoying animations that take 2-3 screens to disable.
评论 #36084156 未加载
评论 #36084818 未加载
评论 #36084183 未加载
评论 #36085186 未加载
评论 #36086868 未加载
评论 #36085993 未加载
评论 #36087883 未加载
评论 #36085600 未加载
评论 #36099251 未加载
评论 #36085689 未加载
评论 #36085317 未加载
heisenzombie将近 2 年前
There’s something unbeatable about the purity of a spreadsheet. For certain kinds of problem, it’s one of the most understandable ways to communicate a program.<p>But there are the obvious problems, as formulas get inscrutable and you really want some more powerful data types.<p>So I’ve been playing with the new Excel features - lambdas and the new kind of array formulas. And they’re kind of great! I ported some non-trivial analysis algorithms from numpy to excel and it makes for a highly shareable and havkable programming environment for non-coders.<p>There’s all sorts of crazy excel warts (I’m doing maths with complex numbers, and the handling of those is a true “WAT”)<p>It’s kind of almost-great. I can’t put my finger on it but I feel like it’s close to a really winning programming environment for certain kinds of algorithms-transforming-data programs. I think Excel probably has too much baggage to get there, but these experiments are still really interesting.
评论 #36082647 未加载
评论 #36082550 未加载
lindbergh将近 2 年前
Yes Excel lately is turning into a really compelling product, using functions such as sequence (dynamic arrays), lambda (pure functions) and let (defining sub-variables). You&#x27;d think you&#x27;re coding in a pure functional language, and that&#x27;s great! Now, ff only Excel had a convolution function! But nonetheless it&#x27;s a great GUI, everybody knows how to use it and sharing it is dead simple.<p>The one downside I can find is the lack of a good plotting library. And yes comments as well is something I miss a lot.
评论 #36087105 未加载
2Gkashmiri将近 2 年前
I&#x27;m one of the libreoffice gang and I rely on =regex as a part of my work on a daily basis.<p>Eventually we &#x27;might&#x27; get therein terms of new features but for the time being, I am fine.<p>Macros are slowly improving in libreoffice but it still ways off anyway.
jbullock35将近 2 年前
Most of us who use Excel are still using it as though it were 2013. Are there any good tutorials about the major features, like lambdas and dynamic arrays, that have been introduced in the last few years?
rickdeckard将近 2 年前
Oh, I need to check that out. The universal language and portability of a spreadsheet is really hard to beat.<p>Seeing how people often read xls-sheets by backtracking formulas, it would be great if MS could add support for comments within formulas (multiline formulas being a thing for many years now)<p>That wouldn&#x27;t blow up the whole complexity of formulas, but still allow at least to explain some of these huge formulas people have to deal with on a daily basis.
评论 #36083530 未加载
评论 #36083335 未加载
Closi将近 2 年前
The advanced formula environment is great, I&#x27;ve been using it for about a year now and it makes LAMDA so much more useful.
null_shift将近 2 年前
I’m assuming the generative AI functions are not running purely locally and would be sharing your data to Microsoft&#x2F;OpenAI ?