Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index


Hi Gordon,

To find the error code, use the ERRORTYPE function.

For example, if the cell containing the erroneous formula is B2, then put the formula =ERRORTYPE(B2) in some other blank cell. Hope that helps.

Regards,

Steve


------ Original Message ------
From: "Kevin Berry" <berrykevin321@gmail.com>
To: "Steve Fanning" <stevemfanning.wh@gmail.com>
Cc: "documentation list" <documentation@global.libreoffice.org>
Sent: 05/06/2020 19:52:27
Subject: Re: Calc Error Codes Rev 1

Yeah, the #DIV/0 might actually be a 532, huh? How do I make Calc show me the error Code, not just the error Message?

What made me add that in there was that the explanation of that error is " Division by 0, or another calculation that results in an overflow of the defined value range (a value too big or too small)."
Dividing by zero is the "too big" part of that.

I attached the spreadsheet I was using to replicate some of these errors. The part that is relevant to this email is A2:E4

Gordon Bates
berrykevin321@gmaill.com
github.com/jdoes


On Fri, Jun 5, 2020 at 2:07 AM Steve Fanning <stevemfanning.wh@gmail.com> wrote:
Hi Gordon,

Thanks for that. I have accepted most of the changes and placed the updated file in the Draft folder, ready for second review.

I did not accept one of the changes (in Table 2) because I'm not sure that it is correct. As far as I was aware, error 503 gives a #NUM! error in the cell, not a #DIV/0! error (unless you've come across a counterexample?).

Regards,

Steve



------ Original Message ------
From: "Kevin Berry" <berrykevin321@gmail.com>
To: "Stephen Fanning" <stevemfanning.wh@gmail.com>; "documentation list" <documentation@global.libreoffice.org>
Sent: 04/06/2020 20:34:51
Subject: Calc Error Codes Rev 1

I have completed review1 of the error codes section, and placed it in the feedback folder.

Gordon Bates
berrykevin321@gmaill.com
github.com/jdoes
--
To unsubscribe e-mail to: documentation+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.