Nothing compares to the foolish audacity of excel to switch numbers to scientific notation by default. This can't possibly be the most commonly desired outcome. Its the most annoying "feature" they have that has existed forever.
this post was submitted on 23 Sep 2025
758 points (98.6% liked)
Microblog Memes
9290 readers
3465 users here now
A place to share screenshots of Microblog posts, whether from Mastodon, tumblr, ~~Twitter~~ X, KBin, Threads or elsewhere.
Created as an evolution of White People Twitter and other tweet-capture subreddits.
Rules:
- Please put at least one word relevant to the post in the post title.
- Be nice.
- No advertising, brand promotion or guerilla marketing.
- Posters are encouraged to link to the toot or tweet etc in the description of posts.
Related communities:
founded 2 years ago
MODERATORS
Hey. Look at that column of dates you got. Would be a shame if they got converted to random numbers.
Hey that's a cool sequence of genes. Would be a shame if we converted a few into date format when you try to save as .csv
Sure but at the same time they shouldn't be using Excel as a database.
Nobody does that?
In the example you're talking about the scientists were using it as a database. A Microsoft executive even came out and told them that you shouldn't use it as a database.
Occasionally there's even articles in scientific journals explaining why you shouldn't use Excel as a database and suggesting alternatives. But for some reason people still turn to their favourite not database database software.
This isn't a live or massive dataset. It's a table of data from the samples that were sequenced.
CSV is a perfectly adequate format for the work being done. Actually, Excel's bug-as-a-feature is the only reason you wouldn't want to use it.
Im sorry, the auto date formating is by far the worst. Just leave my numbers the fuck alone man, numbers are supposed to be precise, judt dont fucking touch em. Rant over lol
I hope the EU sues the shit out of MS some time for this "feature". Write protection is one of the few things Libreoffice can't handle well, and from my perspective, that is the entire reason they have it. Also, funny enough, Office 362, their own fucking product, also can't handle it. So you need a computer where you can install the desktop version, just to untick the fucking "write-protected" box and do your job.
In academic research, you often have to apply for money from funding agencies, using write-protected templates. If you don't use the exact template or if it looks distorted in some way, you're out (of consideration for the funding, and long-term out of your job).
This behavior is annoying as hell, but I also think it's for the best. Excel specifically was way too trusting, has a full development environment with the ability to auto-run macros, and has become a convenient vector for delivering malicious code.
I once made an xlsx with a VBA module and put it in my often-late coworkers' startup folder. It would check log-on time and if it was between 9:01am and 9.59am it would send an email to the rest of the team apologizing for being late that day.
Stunning that I could do that on what was supposedly a locked-down internal system.
what an incredible jackass
What in the actual fuck.
I once used VBA to script and automate 90% of my old desk job. I just needed a way to automate keyboard input and some basic conditional controls.
I couldn't install python or run batch scripts as the machine was heavily locked down, but luckily MS provided all the tools I needed inside excel. System admins hate this one trick, thanks microsoft!
haha yeah same. We had this terrible internal CMS that I would automate the hell out of.
LOL pls say more
You just enable the VB script to check the system time on launch and auto close silently if outside those times.
Excel integrates with all Microsoft products so it can access Outlook and send an email. You populate the email fields as you want and put it inside an if loop of the times and exit. Even without outlook I think it might be able to send emails with some plug-ins or via a browser window, navigate to mail, and do basic webscraping and clicking like you'd do with Beautiful Soup or AHK.
The whole setup can just be worked out with some googling and stack exchange threads.
It was a running joke he was always late and it wasn't exactly the best run company so there was no negative outcomes really, just harmless fun.
My workplaces malwarebyte's settings end the excel process tree if it tries to run a script that accesses other M$ products.
Was super annoyed when I discovered that while trying to script in an email template for the form I was making, since at the time staff never cc'd the correct people and would then bitch out finance for not paying them.
I mean, if people weren't desensitized to warnings like this by getting them constantly, I think you'd be right
In IT we have to consider the signal to noise ratio of warning users.
There is malware that can infect you simply by opening an office document. One of the cooler security trainings I've been through was a recorded demo of it. Opened a doc on one computer, enabled editing, then another computer was able to extract credentials from ram or something.
Well before it people were getting hacked by VBS macros so yeah it makes sense..
More profitable to sell the disease and the cure!
Yeah, better to gut Excel from usefull features because they can be abused /s
Just TODAY I generated a text file via a bash script, and when attempting to open it in Notepad++ Windows insisted on warning me about potential hazards because it couldn't verify who created the file. A text file! Heavens. I wonder how long I'll last in that blasted Windows centric environment.
Not so far-fetched when you realize that Windows crams AI into everything and the text file might contain malicious instructions.
It was a text file with 80 rows of `username="username username@example.com" mappings (for an svn to git conversion). Nothing nefarious.
Yeah, but honestly it wouldn't even need AI to have this issue with the kind of bloated spaghetti code that MS seems to produce.
load more comments
(5 replies)
Instead of asking why your word processor should have the ability to run arbitrary code, you just inconvenience everyone else on the chance it might. What even.
Yep.
A constant stream of creating problems and then creating solutions for those problems, which cause more problems....ad infinitum.
Go back and fix the root cause?
Impossible!
Then our 2nd and 3rd tier 'solutions' would have all the 'solutions' based on them not work!
Yup, it's a shit bandaid to mitigate a shit design. The MS specialty.
Scripting is great in Excel, but I've never encountered or heard of a use for it in Word.
I used to work at a place where one of their test machines generated a cert in Microsoft Word with test results. They were having their lab technicians manually type in something like eight fields of information to flesh put the cert. I managed to hack together a Word VBA plus Python script to interface with the OpenOffice database I had set up so the techs only had to type in one field, and the script filled in the rest.
It was kind of a monstrosity under the hood, but it worked pretty slickly, and given the available tools I was glad the option existed.
That's partly because the API for manipulating word docs with VBA is incredibly awful.
VBA for Word is bad, but VBA for Excel graphs is worse. At small companies that can't justify the cost of any software outside Office, people will go to great lengths to get Excel to support data analysis. Not being in that situation anymore is one of my top satisfaction items with having changed jobs from a small to a large company.
As someone who doesn't use microsoft stuff.. anyone here have an explanation? lol
For me, when I open an Excel file from our business partner, it will always open in protected view which limits the functions the document can do. I then have to tell it to open in regular view which closes the doc and reopens it, wasting my time.
But sometimes even doing that won't solve the problem. It will say I have to go into the doc's properties and mark it as "safe". That requires closing it yet again. Right clicking it in file explorer, and checking a box in the properties tab. Then I get to reopen it yet again.
And I have to do this nearly every single time. Fun stuff.
I then have to tell it to open in regular view which closes the doc and reopens it,
How can you know if a document is safe to open in this "regular view"?
Microsoft office documents not running in protected mode can run arbitrary code on your computer. Given VBA that arbitrary code can pretty much access anything any installed application can.
There's a load of Office malware written that can infect all the documents on your system with keyloggers and password scrapers.
It's a pain in the ass yeah, but it exists to mitigate a very real risk.
It doesn't mitigate anything when it pops every single time. Microsoft on its own has rendered scary messages useless with how often they use them.
load more comments
(1 replies)
load more comments
(2 replies)
Microsoft managed to build a file format for spreadsheets, text documents and such, which can be used to run arbitrary code on the PC where it's opened (via VBA). In a move that no one could have predicted, this is used to distribute malware.
And their bandaid fix is this "Protected Mode", which is entered when you receive a document from another organization. In Protected Mode, it does not run VBA code until you exit it.
Unfortunately, their solution has conditioned users to basically always exit Protected Mode.
load more comments
(2 replies)
load more comments
(1 replies)
view more: next ›