Re: [slightly OT] Libreoffice calc errors

On Thu, Jan 19, 2012 at 15:09, NoOp <glgxg@xxxxxxxxxxxxx> wrote:
On 01/19/2012 11:59 AM, Jacob Mansfield wrote:
Hi all, does anyone know how to fix an "!NUM#" error in Libreoffice
Calc? all the help files say is that it's a 503 error, defined as
"Invalid floating point operation: A calculation results in an
overflow of the defined value range." any help in the matter would be
greatly appreciated, as I need this working for tomorrow. I can
provide the equations I'm using if it helps. thanks!
...

Your best bet for getting a detailed answer is to subscribe to the
libreoffice user list:
http://www.libreoffice.org/get-help/
 http://www.libreoffice.org/get-help/mailing-lists/
and ask there.

And at the very least, don't go there asking that question without
actually telling people what failing calculation is... :/ and maybe
some sample data.

That's like me asking "Hey, can you help me debug my python program?"
without actually telling anyone what my program is, what it does, or
showing them the code.

--
ubuntu-users mailing list
ubuntu-users@xxxxxxxxxxxxxxxx
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

Relevant Pages

  • Re: [slightly OT] Libreoffice calc errors
    ... all the help files say is that it's a 503 error, ... "Invalid floating point operation: A calculation results in an ... overflow of the defined value range." ...
    (Ubuntu)
  • Re: Arithmetic overflow checking
    ... Unfortunately, for unsigned arithmetic, C blesses silent wraparound ... and says it has to work "properly", with no trapping on wraparound. ... fail with overflow traps when the calculation result is perfectly ...
    (comp.lang.c)
  • Re: Saturating Arithmetic
    ... It means that in case of an overflow after a calculation, ... saturates to the maximum or minimum value that can be held by the ... signals are combined to yield a result greater than the maximum ...
    (comp.arch.embedded)
  • Re: Rounding error when converting from double to int
    ... than could be overflow in some of these multiplications ... I calculated the maximum number you could apply this calculation ... to calculate the cents correctly. ... You're still introducing rounding error with binary fractions. ...
    (comp.lang.c)
  • Re: [slightly OT] Libreoffice calc errors
    ... does anyone know how to fix an "!NUM#" error in Libreoffice Calc? ... all the help files say is that it's a 503 error, defined as "Invalid floating point operation: A calculation results in an overflow of the defined value range." ...
    (Ubuntu)