It Took Many Years And Billions Of Dollars, But Microsoft Finally Invented A Calculator That Is Wrong Sometimes
-
There are things that could be done to improve Excel. For instance, fully integrate python and allow it to be used to create custom functions. Then, maybe one day, VBA can ride off into the sunset where it belongs.
Adding Copilot to Excel is not an improvement because Copilot and all other LLM based platforms frequently barfs out totally incorrect information about how to do something in Excel.
"You do that using <X> formula."
No, I can't, you worthless pile of shit because THAT FORMULA DOESNT EXIST.
Integrated python scripts in excel sounds like a malware developers dream.
-
Yea like what?
It's been a big increase in workflow for me.Lol you shared your personal experience and got downvoted... lmao even
-
Integrated python scripts in excel sounds like a malware developers dream.
Fair point. Of course that's already a problem with Excel. It would probably have to be disabled by default just like VBA macros.
-
Integrated python scripts in excel sounds like a malware developers dream.
And a nightmare for an application developer told to make some app with a spreadsheet for a database scale
-
And a nightmare for an application developer told to make some app with a spreadsheet for a database scale
Could result in some very cursed codebases.
"We dont use git, we just update the excel spreadsheet"
-
Integrated python scripts in excel sounds like a malware developers dream.
Yeah, no doubt.
Having access to visual basic is dangerous enough, let alone Python
-
Could result in some very cursed codebases.
"We dont use git, we just update the excel spreadsheet"
I've worked at places where they did that anyway lol
-
And a nightmare for an application developer told to make some app with a spreadsheet for a database scale
That's just called Access
-
Yea like what?
It's been a big increase in workflow for me.Increase in workflow? Like there are more steps to perform the same task? Because workflow isn't work volume or units if output. It's the process that gets the work done.
Did the increase in "workflow" get you more money or more work for the same money?
-
Integrated python scripts in excel sounds like a malware developers dream.
Surely there’s some sort of sandboxing that could be done? Like start by disallowing sys calls entirely
-
Integrated python scripts in excel sounds like a malware developers dream.
They foresaw that. That's because python on Excel doesn't run locally, but in the cloud and then returns the result to you: https://support.microsoft.com/en-us/office/introduction-to-python-in-excel-55643c2e-ff56-4168-b1ce-9428c8308545
-
Increase in workflow? Like there are more steps to perform the same task? Because workflow isn't work volume or units if output. It's the process that gets the work done.
Did the increase in "workflow" get you more money or more work for the same money?
I mean... they responded in agreement to a comment that said it's not an improvement. So it seems to me that it also would not increase the money they get out of it.
-
They foresaw that. That's because python on Excel doesn't run locally, but in the cloud and then returns the result to you: https://support.microsoft.com/en-us/office/introduction-to-python-in-excel-55643c2e-ff56-4168-b1ce-9428c8308545
Still sounds like you'd be shipping your data to the cloud, where it can be exfilled from there.
Would potentially be a great phishing tool, just need to trick someone into putting sensitive data into a precooked excel file, and it gets exfilled.
-
Surely there’s some sort of sandboxing that could be done? Like start by disallowing sys calls entirely
Definitely, but sandboxes can be escaped, and you can't protect everything via sandbox. Apparently its all cloud anyway, but if it were local and sandboxed, there are still exploits like rowhammer and spectre that may cause further risks.
Its taken years to get browser sandboxes to where they are, and even they get broken every so often.
-
Still sounds like you'd be shipping your data to the cloud, where it can be exfilled from there.
Would potentially be a great phishing tool, just need to trick someone into putting sensitive data into a precooked excel file, and it gets exfilled.
Currently only for business customers which probably use OneDrive or SharePoint anyways, so it's not that they need that to exfiltrate data. But for a phishing/hacking attempt? There are probably some nice possibilities.