Engineering Memes

1404 readers

2 users here now

About:

Memes about engineering for all disciplines.

Rules:

General Rules:

No hate speech
No harassment, calls to violence
No advertisement

Posts:

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

founded 2 years ago

MODERATORS

MisterFrog

658

Get Dated (lemmy.dbzer0.com)

submitted 1 week ago* (last edited 1 week ago) by [email protected] to c/engineeringmemes

53 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 1 points 1 week 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 1 week ago* (last edited 1 week 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 1 week ago* (last edited 1 week ago) (1 children)

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

[–] [email protected] 1 points 1 week ago

It's my own grammar, "Luanatic"

[–] [email protected] 1 points 1 week 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 1 week ago* (last edited 1 week 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 2 points 1 week 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.

[–] [email protected] 1 points 1 week ago (1 children)

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

[–] DacoTaco 1 points 1 week 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 1 week 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.