this post was submitted on 16 Jan 2025
643 points (98.2% liked)

Engineering Memes

1366 readers
757 users here now

About:

Memes about engineering for all disciplines.

Rules:

General Rules:

  1. No hate speech
  2. No harassment, calls to violence
  3. No advertisement

Posts:

  1. Must be a meme/joke/observation/attempt at humour
  2. Must be engineering related (software engineer humour probably better suited for programmer humour communities, though not explicitly banned)

founded 2 years ago
MODERATORS
643
Get Dated (lemmy.dbzer0.com)
submitted 1 day ago* (last edited 1 day ago) by [email protected] to c/engineeringmemes
 
top 50 comments
sorted by: hot top controversial new old
[–] [email protected] 3 points 7 hours ago (1 children)

This but with goddamn scientific notation.

That and sometimes the answer to fixing it is simply selecting the cell, not changing a thing, and hitting enter.

[–] pajam 2 points 5 hours ago

Yep, I hate that Excel doesn't open CSV files and treat every cell as "Text" considering that's how a CSV stores the data. It loves to convert to scientific notation, or omit leading zeros, or omit trailing zeros on a decimal, or assume something is a date. I always have to update csv files to .txt instead and then import it via the wizard and manually select Text for all columns.

[–] Foreigner 41 points 15 hours ago (2 children)
[–] RampageDon 4 points 8 hours ago

Always put a ' in front of any information in Excel you do not want changed

[–] [email protected] 8 points 15 hours ago

Look, a date!

[–] MisterFrog 6 points 13 hours ago

MM/DD/YYYY detected. Burn it with fire!

[–] [email protected] 10 points 17 hours ago (1 children)

If I remember correctly Microsoft once responded saying that it can in fact not turn off that feature in Excel. Excel will always interpret your input and change it to what it thinks is correct

[–] [email protected] 13 points 16 hours ago* (last edited 16 hours ago) (2 children)

It's always been possible to format a range before inputting data. It won't be interpreted that way.

It only does that when it's formatet as "General" aka "Nobody knows what the fuck I'm about to do".

It would probably be more beneficial to change the default format to something else.

[–] [email protected] 1 points 13 hours ago* (last edited 8 hours ago) (2 children)

It only does that when it's formatet as "General" aka "Nobody knows what the fuck I'm about to do".

How about handling that as plain text?

Edit: wait, table calculation, what did i think? Well, i hadn't slebt much or good the last few days and 12 hours now, so there.

[–] [email protected] 2 points 12 hours ago

Then select Format > Text

[–] FooBarrington 2 points 13 hours ago (1 children)

Would be pretty annoying for numbers

[–] [email protected] 1 points 13 hours ago (2 children)
[–] FooBarrington 4 points 12 hours ago

Maybe numbers shouldn't be a special case, but should be the default for software meant to handle tables if numbers

[–] [email protected] 1 points 15 hours ago (3 children)

It would probably be more beneficial to change the default format to something else.

AfaIk this is not possible. Or MS doesn't allow it. User Defined would be pretty useless if MS would simply stop interpretating what I want to do in general

[–] [email protected] 2 points 15 hours ago* (last edited 15 hours ago) (1 children)
function validate(val) 
   try:  
       cast val as numeric
   except:
      print "Oops, not a number"
      cast val as general  ## date or whatever 
end

validate(12.5)     ## returns 12.5
validate("12.5")   ## returns 12.5
validate("12 . 5") ## returns a date maybe

[–] [email protected] 3 points 11 hours ago* (last edited 11 hours ago) (1 children)

Oh my god what cursed Python, Lua, and SQL offshoot is this

[–] [email protected] 1 points 8 hours ago

It's my own grammar, "Luanatic"

[–] [email protected] 1 points 15 hours ago

I mean, MS should change the default.

As a user, the only way currently is to make a template document and use that as a default when creating a new book.

[–] DacoTaco 1 points 15 hours ago* (last edited 15 hours ago) (2 children)

You most certainly can. You can set the format of a cell, and if its set to number 12.5 will be 12.5, it wont even try date formats...

[–] [email protected] 1 points 10 hours ago (1 children)

Try opening a sheet sent by a Spaniard colleague. Good luck with decimals.

[–] DacoTaco 1 points 10 hours ago (1 children)

Thats a locale issues that excel has and cant fix ( for compatibility reasons ). Its one of the reasons i hate excel haha. But not related to cell types

[–] [email protected] 1 points 10 hours ago

No, I know. I can fix it, but old sheets and stubborn colleagues and clients and my fucking grandma won't.

My point was more related with excel manipulating input incorrectly because of Unspecified.

[–] pyre 2 points 15 hours ago

they're talking about defaults, as in when you create a new file the first thing you do is type a number and not get interpreted as a date.

[–] steventhedev 56 points 1 day ago* (last edited 1 day ago) (3 children)

If you think the insanity stops here - you haven't heard of February 29th, 1900

[–] [email protected] 6 points 16 hours ago* (last edited 16 hours ago)

Even "better": https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates

The renaming is based on a meta study that found that about 20% of all studies involving these genes had errors traced back to excel converting them to dates.

[–] [email protected] 1 points 13 hours ago

Some code piled up in there over the years.

[–] [email protected] 23 points 1 day ago (1 children)

Very interesting! I never knew about years like 1900 (or other century years that aren't divisible by 400) not being leap years. TIL!

https://learn.microsoft.com/en-us/office/troubleshoot/excel/determine-a-leap-year

[–] dual_sport_dork 41 points 1 day ago (2 children)

Excel preserves this bug deliberately to maintain compatibility with spreadsheets that were produced with Lotus 1-2-3, a program which no one cares about anymore, with the only consequence of fixing it being that all of those companies and corporations with bugged worksheets will have to update their dates just once.

But Microsoft is adamant about Excel preserving all of its legacy jank specifically so it will not break equally janky spreadsheets that some absurd number of businesses rely upon for their daily operations, and without which much of the Western world would apparently collapse into a quivering heap. Or so it is feared, anyway.

[–] shalafi 18 points 1 day ago (1 children)

The absolute refusal to change anything is how Excel got where it is today. Businesses and workers alike would shit if they rolled into work one day and Excel was behaving differently.

It's not simply a matter of updating sheets now and again, it's a matter of trust. If Excel was constantly (or ever) evolving, how do you trust it's output?

[–] grue 5 points 1 day ago (1 children)

Oh no, it would force businesses to legitimize their currently half-assed spreadsheet-as-application nonsense.

Asking billion-dollar industries to use proper programming languages, or to use decent version control and configuration management, or at least just to fucking document the particular environment a workflow uses (e.g. the version of Excel the spreadsheet is intended to run in) so that it can be reproducible, is obviously completely unreasonable!

[–] [email protected] 2 points 11 hours ago (1 children)

Yeah, I'm sure your bakery's software dev. team is just too lazy to develop proper software.

[–] grue 1 points 6 hours ago

If the bakery is doing something so complicated with Excel that they'd be screwed if Microsoft fixed the bugs in it, then they should have a dev team!

[–] [email protected] 8 points 1 day ago (1 children)

From what I've seen done in spread sheets, I'm convinced a major change in Exel could cause global anarchy.

[–] dual_sport_dork 5 points 1 day ago (1 children)

Phyllis in accounting would have a bird. Someone would probably wind up murdered with a staple puller.

[–] bravesirrbn 1 points 16 hours ago

Phyllis is in Sales though. I think you mean Oscar

[–] glimse 20 points 1 day ago (2 children)

Excel makes some crazy assumptions with dates but....it doesn't get confused about decimals. I just tried 12.5, 1900.12.5, and 5.12.1900 but none converted to dates

[–] [email protected] 2 points 10 hours ago

As someone from Spain, excel decimals are the bane of my fucking existence

[–] [email protected] 8 points 1 day ago (3 children)

The worst culprit for me are the alphanumerical employee codes like "MARC4"

[–] jaybone 3 points 1 day ago

Is that the code for the employee who rats out your stash?

load more comments (1 replies)
[–] [email protected] 3 points 22 hours ago (1 children)

The fix to this problem that the entire world complains about but doesn't bother googling is like, 3 clicks total in 99% of cases.

[–] [email protected] 7 points 16 hours ago

To be fair, it's a lot of work if 99% of the entire world needs to click 3 times.

I sometimes wonder if Microsoft is deliberately making a shit product just to keep people employed.

[–] givesomefucks 16 points 1 day ago (4 children)

You can change whole row/columns to a different number default to stop it.

Make it assume decimals, dollars, dates, even SSN formats.

[–] shalafi 9 points 1 day ago (2 children)

You can format cells to do any number of crazy things, but damned if I don't occasionally run into something that simply refuses to take my setting.

[–] hydrospanner 1 points 17 hours ago

My god, I was just using a reference table on another sheet to drive a few columns of data in my first sheet (basically a color hex code in the main sheet that would match a code in the reference table and return the color name in one column and a part size in the next one) and for some unknown reason, 3 rows of the reference table were causing an N/A (value not found) error in the first sheet.

I checked every variable I could think of and nothing was solving the issue.

Finally tried literally retyping the same damn value in the cell and it instantly fixed the issue. There weren't any extra spaces, format never changed...it just really needed me to retype it.

[–] givesomefucks 10 points 1 day ago (1 children)

Sometimes you have to save and close to show Excel you mean business...

It's a dominance thing

[–] WraithGear 10 points 1 day ago (1 children)

Silly me went and learned VBA code to make excel work right. … and whose idea was it to have default paste, paste the format?!? When has anyone EVER wanted a table filled with different sizes and colors and fonts. Make the formatted paste the ctrl-shift-v if you want that so bad. JfC. Am i not being rational? Because this gets me HEATED.

[–] [email protected] 5 points 1 day ago (1 children)

Pasting with format as default is one of the biggest mistakes of humanity. I can’t remember a single situation in all my life that I needed this.

My favorite is writing an email, copy&pasting a name and send it to the person. Only to discover later (on a different device) that your stupid email program pasted with format without actually showing it to you. And your mail looks like some moron played with the format settings.

[–] WraithGear 2 points 1 day ago

I want NAMES!!

load more comments (3 replies)
load more comments
view more: next ›