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

Engineering Memes

1597 readers
369 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
MisterFrog@lemmy.world
653
Get Dated (lemmy.dbzer0.com)
submitted 3 months ago* (last edited 3 months ago) by HootinNHollerin@lemmy.dbzer0.com to c/engineeringmemes@lemmy.world
54 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] bstix@feddit.dk 13 points 3 months ago* (last edited 3 months 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.

[–] MonkderVierte@lemmy.ml 1 points 3 months ago* (last edited 3 months 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.

[–] funkless_eck@sh.itjust.works 2 points 3 months ago

Then select Format > Text

[–] FooBarrington@lemmy.world 2 points 3 months ago (1 children)

Would be pretty annoying for numbers

[–] MonkderVierte@lemmy.ml 1 points 3 months ago (2 children)

Format as number then.

[–] FooBarrington@lemmy.world 5 points 3 months ago

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

[–] K4mpfie 1 points 3 months 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

[–] tetris11@lemmy.ml 2 points 3 months ago* (last edited 3 months 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
[–] PoolloverNathan@programming.dev 3 points 3 months ago* (last edited 3 months ago) (1 children)

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

[–] tetris11@lemmy.ml 1 points 3 months ago

It's my own grammar, "Luanatic"

[–] DacoTaco@lemmy.world 1 points 3 months ago* (last edited 3 months 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...

[–] pyre@lemmy.world 2 points 3 months 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.

[–] fushuan@lemm.ee 1 points 3 months ago (1 children)

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

[–] DacoTaco@lemmy.world 1 points 3 months 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

[–] fushuan@lemm.ee 1 points 3 months 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.

[–] bstix@feddit.dk 1 points 3 months 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.