Does libreoffice have a math concept like 'infinity'?

There's no mention of it in the documentation, so I'm assuming there's no concept of infinity in LibreOffice.

The only relevant forum post I could find shows that, even though IEEE floating point supports +/-Infinity special values, OpenOffice (and probably LibreOffice) apparently doesn't.


There's no number to represent infinity as such. The largest number LibreOffice recognises is apparently 1.79769313486232E+308 (I entered 1E999 into a c ell and that's what was stored). You could enter 1E999, or this number, or define a Name "Infinity" with this or another suitable value. I did a calculation with the maximum vale, and got an error cell "#NUM!", so maybe a not-so-high value would be more useful in some cases, 1E300 worked in my particular case. Too late for the original questioner I suppose, maybe useful to googlers like me.