Programmer Humor

32495 readers

849 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

Posts must be relevant to programming, programmers, or computer science.
No NSFW content.
Jokes must be in good taste. No hate speech, bigotry, etc.

founded 5 years ago

MODERATORS

[email protected]

763

when you import some data into Excel and it tries to format all your number fields (lemmy.world)

submitted 9 months ago by [email protected] to c/[email protected]

38 comments fedilink hide all child comments

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

[–] [email protected] 1 points 9 months ago* (last edited 9 months ago) (1 children)

Can't you just type in the digits of the Pi that you want to use in some cell and then refer to that cell instead of using the default Pi?

5 is mathematically a "round-up" number. If you want your numbers to behave differently I think you'd be better off using a different function.

[–] [email protected] 1 points 9 months ago* (last edited 9 months ago) (1 children)

Five isn't mathematically a round-up number, we just arbitrarily decided to round up because numbers were used in merchant contexts where obviously you want to get people to pay more for their stuff than less. As for solutions I just introduce a tiny error because it's genuinely less effort than constantly referencing a cell and locking it so that it won't run away if you drag it around. It's a very easy to forget a lock.

[–] [email protected] 1 points 9 months ago (1 children)

Name the cell "myPi" and use that instead of the Pi function.

[–] [email protected] 1 points 9 months ago

That's a pretty high-q move. I've moved to LibreOffice which does Pi properly, but i'll keep that in mind next time I need a static data reference.