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.
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.
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 something a different function.
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.
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.
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.
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 something a different function.
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.
Name the cell “myPi” and use that instead of the Pi function.
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.