Openoffice does this too, and the worst part is that it will take something and interpret it as a date, but then you force it to interpret it as a number, instead of using the number you typed it will use the index number of the date which is a completely different and useless value.
In short, it takes the number you put in and converts it into a date against your will, and you can’t change it back. It would be like if you typed in “sunshine” and it interpreted that as the temperature of a sunbeam and put that in the cell instead of the fucking thing you typed. So annoying!!
Another minor gripe is how their Pi() uses enough digits that it lands on a 5 and rounds up, which breaks all sorts of sine math. If they had rounded down or added/removed a digit of pi that wouldn’t be an issue. I have to intentionally add error to my functions just so they work. On the up side I was able to provide mathematical proof that the human tendency to round up at 5 is at odds with the real world. It makes more sense to round down, though I always just add/remove a decimal point so I don’t have add arbitrary information to the system by always assuming a roundup or rounddown. If I’m forced to end at a 5, I round down, which is at odds with how people do it but it breaks less.
EDIT: come to think of it, it makes a lot of sense for 5 to be a round-down situation. If a particle has just enough energy to jump to the next state but no extra, it would be far more likely to stay in its current energy state than it would be to expend energy to make that jump. Even an infinitesimally small increase over the exact amount required to make a jump would give it that necessary kick to actually make the jump.
I don’t know, whether these things have been fixed by now, but you should mind that OpenOffice’s development has been basically dead since 2010. All the core devs moved over to LibreOffice, basically because Oracle had bought Sun Microsystems, who previously held the “OpenOffice” brand. You really want to be using LibreOffice these days.
Programmers who have to deal with data I/O and SQL regularly need to use a spreadsheet to examine, columnize and validate data manually, so that data structures are confirmed to be correct. Nobodys programming in Excel per se, but its still a ubiquitous tool that we use on the regular.
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !programmerhumor@lemmy.ml
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.
libreoffice reigns supreme
laughs in pola.rs
Alt+h+v+v
Unrelated but alt+e+s+v is so ingrained into my muscle memory. I should really get a macro pad
Ctrl+Shift+V exists now which does the exact same thing.
Actually it’s a bit better. Excel always ignores alt codes for the first key press or two after switching windows.
#VALUE!CSV files having their leading zeros cut off fuck my entire world up.
Openoffice does this too, and the worst part is that it will take something and interpret it as a date, but then you force it to interpret it as a number, instead of using the number you typed it will use the index number of the date which is a completely different and useless value.
In short, it takes the number you put in and converts it into a date against your will, and you can’t change it back. It would be like if you typed in “sunshine” and it interpreted that as the temperature of a sunbeam and put that in the cell instead of the fucking thing you typed. So annoying!!
Another minor gripe is how their Pi() uses enough digits that it lands on a 5 and rounds up, which breaks all sorts of sine math. If they had rounded down or added/removed a digit of pi that wouldn’t be an issue. I have to intentionally add error to my functions just so they work. On the up side I was able to provide mathematical proof that the human tendency to round up at 5 is at odds with the real world. It makes more sense to round down, though I always just add/remove a decimal point so I don’t have add arbitrary information to the system by always assuming a roundup or rounddown. If I’m forced to end at a 5, I round down, which is at odds with how people do it but it breaks less.
EDIT: come to think of it, it makes a lot of sense for 5 to be a round-down situation. If a particle has just enough energy to jump to the next state but no extra, it would be far more likely to stay in its current energy state than it would be to expend energy to make that jump. Even an infinitesimally small increase over the exact amount required to make a jump would give it that necessary kick to actually make the jump.
I don’t know, whether these things have been fixed by now, but you should mind that OpenOffice’s development has been basically dead since 2010. All the core devs moved over to LibreOffice, basically because Oracle had bought Sun Microsystems, who previously held the “OpenOffice” brand. You really want to be using LibreOffice these days.
That explains why I haven’t got a response from them in over three years.
EDIT: I’ve downloaded LibreOffice. Their Pi() uses 3.14159265358979 which is an awesome number to end it on.
“Programmer humor” “excel”
Programmers who have to deal with data I/O and SQL regularly need to use a spreadsheet to examine, columnize and validate data manually, so that data structures are confirmed to be correct. Nobodys programming in Excel per se, but its still a ubiquitous tool that we use on the regular.