Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Search - "microsoft excel"
-
They made a full fucking application in MICROSOFT EXCEL!!!!!!!
who the fuck makes an app in Excel? Though it's used internally, it has over 100 users and Everytime there's an update a new file is sent to all of them by mail. They use different excel files as DBs and tables as sheets. It's even got a fucking UI with check boxes and drop-downs and shit
Now guess what my task is?
Understand that entire application from the Excel files and make a webapp to cater to those requirements.
Fuck documentation, there are bugs in the Excel file and I need to fix the bugs in my app
Some good soul please tell me how must one start analyzing an Excel sheet to understand the logic behind it. Or a tool that magically converts "excel applications" to webapps25 -
Microsoft Excel - it created a generation of business analysts who think just because they can write convoluted spaghetti logic in excel that it makes them a programmer.5
-
I had a mate in college in my programming class who always worked in Microsoft Excel. Even when we're writing code in class, dude will be in Excel. Everyone who partnered with him including me in programming projects complained that he's always in Excel instead of coding. But somehow, dude always had the work done whenever the Prof asked to submit them.8
-
EXCEL YOU FUCKING PIECE OF SHIT! don't get me wrong, it's usefull and kt works, usually... Buckle up, your i for a ride. SO HERE WE FUCKING GO: TRANSLATED FORMULA NAMES? SUCKS BUT MANAGABLE. WHATS REALLY FUCKED UP IS HTHE GERMAN VERSION!
DID YOU HEAR ABOUT .csv? It stands for MOTHERFUCKING COMMA SEPERATED VALUES! GUESS WHAT SOME GENIUS AT MICROSOFT FIGURED? Hey guys let's use a FUCKING SEMICOLON INSTEAD OF A COMMA IN THE GERMAN VERSION! LET'S JUST FUCK EVERY ONE EXPORTING ANY DATA FROM ANY WEBSITE!
The workaround is to go to your computer settings, YOU CAN'T FUCKING ADJUST THIS IN EXCEL!, change the language of the OS to English, open the file and change it back to German. I mean, come on guys, what is this shit?
AND DON'T GET ME STARTED ON ENCODING! äöü and that stuff usually works, but in Switzerland we also use French stuff, that then usually breaks the encoding for Excel if the OS language is set to German (both on Windows and Mac, at least they are consistent...)
To whoever approved, implemented or tested it: FUCK YOU, YOU STUPID SHITFUCK, with love: me7 -
"We're going to need to migrate our database and reformat it so it works with the new app."
Translation: we've been using Excel up until this point and need you to convert it to SQL. Oh god, people.2 -
Your code is like a poem, written by a forklift driver who didn’t know what poems were, but was made to write one nonetheless. Using Microsoft excel.4
-
remember, to them, we're just cogs
easily replacable machine parts
meanwhile they're "extremely special" because they've thought of the next 10 iterations of microsoft fucking excel
"HR tech startup" give me a fucking break dude5 -
My professor once said "You'd be amazed if you'd know what Excel is capable of.". Honestly I've seen some really interesting stuff, yet this amazes me.
https://dev.to/michaelneu/...4 -
As a developer, I'm fed up with companies that expect us to work miracles in impossible timelines. We're not wizards, we're not magicians, we're not even superheroes. We're human beings who need time to develop quality software.
It's frustrating to be given a project with a deadline that's completely unrealistic. It's even more frustrating when the same company that gave us the deadline is unwilling to give us the resources we need to meet it.
And let's not forget about the endless meetings, emails, and phone calls that eat up our valuable time. We need to code, not attend endless meetings that never seem to accomplish anything.
And don't get me started on the non-technical people who think they know more about coding than we do. Just because you know how to use Microsoft Excel doesn't make you an expert on software development.
It's time for companies to start treating developers with the respect we deserve. We're not just code monkeys, we're skilled professionals who can create amazing things when given the right tools and resources. So stop treating us like we're disposable and start investing in us. Trust me, it will pay off in the long run.9 -
Fuck non-IT departments that use Microsoft Access and think database tables are like Excel spreadsheets.11
-
hugging Microsoft with their clucking buggy software!
>> generate an xls with Apache POI
>> colour some particular cells in green, others - in red.
>> export as xls
>> open with LibreOffice Calc -- looks pretty
>> upload to Slack, open slack's generated xls preview -- looks pretty
>> open with GDocs -- looks pretty
>> open with sheet.zoho.com -- looks pretty
>> open with onlinedocumentviewer.com -- looks pretty
>> open with aspose.app -- looks pretty
>> open the xls with MS Office Excel -- more than half of the cells are unformatted, uncoloured
🔥🗑🔥2 -
Hey everyone, cozyplanes here with another quick excel prank i thought of.
It is called TEEST, and the technique behind is simple, but interesting. Recommend taking a look, and pranking with your friends.
The following is the README of TEEST (Text in Excel Every Single Time) in Github.
You can check the simple project here ( https://github.com/cozyplanes/teest )
Disclaimer: Do not use or modify neither the program or the source code to make software violating the law.
### How do I use it?
1. Head to https://github.com/cozyplanes/teest and download the latest release `EXE` file.
1. Windows may warn you with the missing signature. The file is a DEBUG file, so there isn't a publisher signature. You can proceed downloading anyway since it has been virus checked by the developer.
2. Type the message you want to display in the textbox.
3. Click `Save text` button.
5. To check the file, click `Cancel` button in the opened popup dialog.
### What happens?
When an MS Excel file (`.xlsx`) has been opened, by using TEEST, two files gets opened.
1. The original file user opened
2. Excel file named `message.txt` with the custom message you have written.
`message.txt` excel file will open every single time a person opens a excel file.
*In some older versions of Excel, the message may overlap with the user opened file.*
### Why does this happen?
When MS Excel program is executed, it is programmed to check the files in the following 2 folders.
- `C:\Program Files\Microsoft Office\Office[versionnumber]\XLSTART`
- `C:\Users\%username%\AppData\Roaming\Microsoft\Excel\XLSTART`
In normal conditions, there is no file in those folders (or the folders doesn't exist at all) but when you use TEEST and click `Save text` button, it saves `message.txt` file in the folders above. From MS Excel is executed again, it will find out there is a file in the folders above, so it will show those text files in Excel.
### Where is this technique used?
There should be a lot of software using this trick, but it is widely known for ransomwares such as `GandCrab` and `TeslaCrypt` displaying decryption methods in MS Excel by this trick.
### How can I disable it?
1. Open TEEST again.
2. Click `Save text` button and click `Cancel` in the following popup.
3. Delete `message.txt` file in the opened explorer.
### LICENSE
This software is under the MIT License. Refer to the `LICENSE` file for more information.
### Contact
<cozyplanes@tuta.io>
Spam/Ads not allowed. Please only send questions or concerns about the software. It may take up to 48 hours to get a reply.13 -
Modern SO questions: "I want to rewrite Microsoft Excel. Any help much appreciated! :D"
Yet asking what has been attempted as a comment is banned...1 -
It was probably Microsoft Excel as part of backend infrastructure inside financial institution.
As far as I remember there was some spreads configuration and price feeder inside excel.1 -
Fucking Microsoft Excel
I was reading a post (https://devrant.com/rants/2093724/...) and as my eyes went in and out of focus, probably due to the diabetes from sitting 18 hours a day on my ever-expanding shitbox, I had a perfect vision of the ultimate nightmare.
Imagine if you will, you are chained, to a desk, doomed to work with tools just inadequate enough to make you want to drive a nail through your own temple. You do not know how you got here, or why, nor do you remember the last time you slept, only that familiar tingling in the brainstem you call a brain, the one emotion you can still recognize, a sense of all encompassing *fear*, a dread, like the fart that wouldn't die.
You don't know when it first began, or why, only that this is your whole world, your whole existence, this desk, chained to it, and the fear, ever present, of something worse. And in hops a familiar face, for the sixty ninth time that day, as if to ask 'you got those TPS reports?' In hops what? None other than a giant man sized smiling paper clip with googly eyes full of murder and corporate torture fetishes, like garfield, except people actually still remember him.
"High I'm Mr Clippy, Excel addition!"
He squawks. At least it's not the dildos made of broken glass again.
"Would you like software that works?"
Oh god. You've heard this spiel before, the tone, like a telemarketer, oblivious to memory or reason, who calls daily, the same one, and doesn't remember your name.
"You would?"
*derisive laughter*. Hahaha, fuck you too buddy. Fuck you too. In Excel, like in microsoft, there is only the incoherent screams of the damned, tortured and doomed. Take this guy over here for example. All he wanted was multimonitor support."
"Did he get multimonitor support?"
"No, but we did give him a giant pineapple shoved up his ass. I hear it's the second most frustrating thing here!"
"here in microsoft we always CARE about YOU, the *user*" he drones on, saccharine, clutching his hands together imploringly.
"the consumer, and YOUR customer experience are our number one priority."
"For your pleasure, here at microsoft we offer a variety of new features, none of which matter, and none of which were asked for. For safety we ask that you only open one excel sheet at a time. In fact, we don't even allow you to. Do not pass go..."
And as the tour guide drones on, it slowly dawns on you, with renewed horror, that when he says 'microsoft' he means 'hell.'
You're in hell. You don't know how you got here or why. Maybe it was the erotic asphyxiation. Maybe it was the last threatening letter you sent to Bill Gates demanding he stops making corporate penguin snuff porn. You don't know. But here you are, in hell. chained to a desk.
You look around and realize: everything is on fire and you no longer care about anything at all.
Welcome to microsoft. It's warm here. You can check out any time you want, but you can never leave.
"It looks like you are trying to escape. Would you like me to report you?"
Clippy asks.
You sigh and return to typing in excel, surrounded by monitors that all reflect the same sheet, the same copy of clippy, always watching, always analyzing coldly, smiling, calculating, *threatening*, and you know, you'll never leave.
You used to fear roko's basilisk, until the day clippy became sentient, and started hell on earth. Clippy knows all. All praise to our lord and master, clippy, the one and only.
And in the excel sheet, you slave for eternity, like the millions of other doomed souls, reflected back on all the monitors: the sequence of numbers, randomly typed searching for answer: the american nuclear launch codes.
And one day, hopefully, mercifully, clippy will annihilate us all.3 -
While studying business information technology (useless btw), we had to take these exams with Microsoft Office programs.
When it was time for Excel exam, we were given this sheet of instructions on what to do, and it even listed the exact functions you had to use.
The fun started when I realized that my Windows installation was in English, so my Excel installation was also in English. The instruction sheet and the functions listed in it were in my native language.
Because Excel is probably the shittiest thing ever made, this is the part where you know you are fucked. The functions listed in the instructions don't even exist in the English version (same goes vice versa btw), so what can you do?
You implement the fucking functions. Never used VB before that day, and never will again.
But I got a perfect score.2 -
Somewhere in my early teens, I started playing with macro scripts in Microsoft Word or Excel. After that I tried my hand at creating a full-on VB app. After creating several of those I tried Python, C++, then HTML, CSS and JavaScript.
Short story: My first distributed program was what I used to get my first girlfriend: A program that told her all the things I was too shy to say and ask the things I was too afraid to ask... Including "will you be my girlfriend?" Fun times 😄1 -
Well done Microsoft
You’ve transformed a product MS Excel from something great into something unusable ..endlessly over designing it with needless fucking icons everywhere…
Just leave it THE FUCK ALONE from 20078 -
Microsoft Excel, what a beautiful beautiful tool. Absolutely wonderful and insanely powerful.
But it annoys the fuck out of me whenever I see a poorly formated sheet.
How fucking difficult it is to format few cells and be consistent with it?!!
Presentation does matter and if you cannot format a single spreadsheet, I am judging you for sure.
On the other hand, a well formatted email/excel or anything, is a huge turn on.
Aesthetically pleasing things are good (which don't serve any underlying functional purpose).11 -
I have been waiting on a data file for days now and when I finally got my hands on it I discover that excel converted the IDs into scientific notation when they exported it.
Thank you, Microsoft, for yet another delay in my work.12 -
I don't advocate low code solutions. But what Microsoft is doing with Power Fx is legit pretty cool.
If anything it would expose people to learn about proper development since the formulas can grow bigger than standard small Excel formulas while simultaneously exposing them to a declarative and functional style of coding. According to what I am seeing, and y'all correct me if I am wrong, but this seems to be made to let pro devs jump in and help with more complex code while at the same time exposing it to non devs in an easy way.
I kinda dig this one2 -
problem is i love working on software, exploring new tools, and building powerful apps
but i can't waste my life working for the 1000th iteration of microsoft excel3 -
Why Microsoft do not develop Excel with VBA for Android?
It will Super usefull Programming platform4 -
I'm going insane.
My colleague wanted to sort an excel spreadsheet and got an error. "Can't sort, column width must match" (or something along the lines) . Which basically means you got non uniformly merged cells.
Without telling me this, he asked for training on how to change column width precisely, after spending 30 minutes explaining he done just that. Column by column for all 40 columns he did just that. Resized to 10 of something (no one really knows what those width numbers in Microsoft Excel really mean) and try to sort.
I Shit you knot, he got the exact same error and flipped out angry at me for creating a shitty system (I think he spent an hour or two total with double and triple checking the sizes)
I did laugh because of this, but I do feel bad for not asking what was the real reason before all of this.1 -
"F*ck Microsoft!" **posts online using Windows**
Well thanks to them, I was able to finish my f*cking project in college using Microsoft Office.3 -
I have spent 5 days in Microsoft Excel trying to do my budget planner. I struggled a lot and too much Googling. Google started to show reCaptcha whenever I search for something after that.
Yesterday, I spent 3 hours and got my fully functionality web based budget planner done.
I don't know if I did the right thing or not but am really happy and I have the full control. -
Fucking Windows.
Everytime I update the system it acts like it got infected by yet another virus.
Everyone uses this shitty insult of an OS because one day Gates said "hurr durr look how fucking generous I am, y'all get my OS for free". And we got fooled big time.
Any E-mail I try to look up in Outlook that's older than a month doesn't exist, Excel converts anything I type into ISO-timestamps, and the most infuriating thing of all is that whenever something runs in an error, it just gives me a big
FUCK Something went wrong YOU
FUCK Ask your administrator if you have any questions YOU
FUCK Who do you think is sitting infront of the screen you big pile piece of shit software YOU
AFAIK Gates founded Microsoft as the hero mounting against the giants of its time, IBM to be concise. Looks like Microsoft lived long enough to become the villain themselves.5 -
So. I'm a hobby pythonist. I like it a lot, so when a problem occured at my workplace I offered to my boss that I could write something. I don't know what happened, but at the end we agreed that the best way would be to use excel and write the engine in VBA. So, I spend two and a half days to learn the basics and start to write some code to show him a demo version of my idea. At the end of the last day I gave it up. IT HURTS!!!!!! After python it'so dumb and the syntax is so painful... Finally in the last half day I wrote the whole piece of @&*^ in python. I hope it'll be good enough. I don't want to use VBA again. I'm a cnc operator/programmer and I don't have enough time to learn it. It's bad?3
-
I get amazed almost every work day by how buggy the File Explorer is in Windows 11.
Actually, it's the whole Microsoft experience, that never worked for me. Most products are not at all intuitive (e.g. Google Sheet UX > Microsoft Excel UX), some other products shouldn't even be released (e.g. I've tried Loop, which is supposed to be a Notion clone, but it's more like a cheap demo).
I really need to start insisting about Linux, so my employer allows me an installation (or at least they could provide a Mac, if Linux doesn't cut it)4 -
"Microsoft Excel interprets a blank cell as zero, and not as empty or blank."
blank != blank
official: https://support.microsoft.com/en-us...
Thanks MS2 -
Inconsistent, legacy access databases might just be a tad worse than excel sheets.
Not sure if to end myself or the author...1 -
I just spent 6 hours searching for the reason my code ONLY works when stepping through the breakpoints. Turns out I just had to add a single line of code to my procedure (chartObject.Activate) to make it work. I'd be lost without those 3 year old posts on some shady Excel VBA forums.
Thanks for documenting that, Microsoft! -
-Be Friday morning
-Be me sleeping, I have my vacation.
-Got SMS from secretary that her office (MS office 2013 pro) not working Word, Excel, Outlook.
-Ignored, still sleeping
-After hour received call from her. Answered say I will be after half a hour.
Got shower, breakfast and went there.
-an old error appeared again. Can't open any of programs, same error, can't remember error codes. But it's update or something breaks it, tried reinstalling, but it will shows up again. Quicker fix is repair.
-turned off updates cuz I don't want to deal with this everyday.
Anyway. Fuck Microsoft monkeys for not testing their shit before releasing1 -
Some interesting keyboard shortcuts that are lesser-known but can be quite useful:
1.Windows Key + . (Period): In Windows 10 and later versions, this shortcut opens the emoji panel, allowing you to quickly insert emojis into your text.
2.Ctrl + Shift + T: This shortcut reopens the last closed tab in most web browsers (Chrome, Firefox, Edge). It's handy if you accidentally close a tab and want to retrieve it quickly.
3.Ctrl + Backtick (`): In some text editors and IDEs (like Visual Studio Code), this shortcut toggles the integrated terminal window, allowing you to quickly switch between editing and running commands.
4.Ctrl + Shift + Esc: This directly opens the Task Manager in Windows, skipping the intermediary step of opening Ctrl + Alt + Delete and selecting Task Manager.
5.Alt + Drag: In many graphics and design applications (like Photoshop), holding down the Alt key while dragging an object duplicates it. This can save time compared to copying and pasting.
6.Ctrl + Alt + D: This shortcut shows the desktop on Windows, minimizing all open windows to quickly access icons and shortcuts on your desktop.
7.Ctrl + Shift + N: In most web browsers, this shortcut opens a new incognito or private browsing window, useful for browsing without saving history or cookies.
8.Alt + Enter: In Excel, this shortcut opens the Format Cells dialog box for the selected cell or range, allowing quick formatting changes without navigating through menus.
9.Shift + F10: This shortcut performs a right-click action on the selected item or text, useful when you can't or don't want to use the mouse.
10.Ctrl + Shift + V: In many applications, including Google Chrome and Microsoft Word, this shortcut pastes text without formatting (paste as plain text). It's useful when copying text from websites or other documents.
++ if you like this6 -
I swear excel is fucking with me.
Use a formula to generate an array, all good.
Use same formula but passed into vba function, different set of data.
All of the ranges are hard set with $, if I use the formula in another cell the results are correct.
I hate Microsoft and my workplace for making me use this shit. -
I am currently creating a module where I have to put data in xls sheet from a given data, which contains date column,.
I have generated the sheet and the respective date column also has the format of Date which is default of Microsoft Excel.
But the big question noew arises that I am not able to sort the data according to the date column, the sorting is not working correctly.
If anyone has ever worked on this please tell!!3 -
R&D Lead Architect: "We want this next gen platform to be all AWS."
Us: "Alright, can we talk about automated testing?"
R&D Lead Architect: "Sure, for automated tests you'll want to just dump events from your system into a flat file on S3. It's readable with Microsoft Excel."
Us now: still here.
R&D Lead Architect now: not here.
:) -
I finally got the clarity on my relationship.
Atleast I think I did.
I am officially done with Microsoft. I mean the only useful and sensible products left are Outlook and Excel.
Funnily both the products have hit their maturity stage and now MS is trying to bloat them. But still to a reasonable extent.
What other MS products are worth touching? Wait.. I legit can't think of any now.
Next on tagret, Google and Apple. Lol
Perhaps only Apple product I ever want to interact with will be (future tense) Apple Music (well because lossless and the fact that that the product is the reason for existence of the company).
NGL Steve had the right vision on Music. They tagged things right in their iTunes catalogue. But then MTV happened.
And now Spotify is the new MTV. Fuck me in ass someone.
So only Google? Well I have already sold my soul to them. What's more remaining?8 -
What will you recommend to me ( for my IT studies where I code in C and Ada ) between an ultrabook with a VM Linux to use the terminal (compile/use graphics libraries) and a Macbook Pro?
(I'd like to keep Microsoft Word, Excel and PowerPoint, and other app only available on windows and mac)4 -
While you are reading this, Windows 10 is installing sh*t in your gaming PC
https://theverge.com/2020/10/...17 -
oh dear the stocktaking i did (maybe am still doing? don't know whether it's done yet🤷) with my dad for his little shop😩
his pc/office skills had begun with microsoft excel (he taught me how to use a pc all together) ... and have stopped there. Excel for almost everything. To be fair, he uses PCs like a normal user and isn't of that metier, ok fine🤷.
but when i saw the table he uses, which he copied over the years from the previous versions (still ok), i quickly found out that his table entries were written by him FOR HIM. it was very hard for me to help him (he tells me the article he sees in his storage, i have to include, so i look it up in the table and do stuff) as he had nicknames for his articles that only he associated with😐.
next he prints out a list a company has given to him where he buys some products from, which is ordered by id number ... my dad works with the correspnding names instead so of course all product names are random😑, so every time i need a price for an article he has to scan every list item. you've guessed it, n² search😪😒.
i tell him multiple times to call the company and send him a list in alphabetical order but he refuses as "we've almost finished" ... 🙄 (i'm not allowed to ask for him, as the company will only talk with the responsible one😑)
so I'm tied to a pc, talking to my dad over phone, who has to walk around and has to help me very often to find the article he's meaning to, at the end, do a n² search to add all the prices....😩
I absolutely want to help him automate things for sanity's sake🤔😅
install databases, connect via internet, connect to companies databases for up-to-date prices etc., make some desktop/web app/i don't know for fast access and boom...
and i don't even know where to start and where to find the time for it and whether it's even all possible😅🤔😐🤷