this post was submitted on 12 Feb 2024
761 points (98.5% liked)

Programmer Humor

32143 readers
112 users here now

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

Rules:

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] Omega_Haxors@lemmy.ml 1 points 7 months ago* (last edited 7 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.

[–] bstix@feddit.dk 1 points 7 months ago (1 children)

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

[–] Omega_Haxors@lemmy.ml 1 points 7 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.