Hi Gordon,
I have included a suitable tip in the chapter.
Regards,
Steve
------ Original Message ------
From: "Kevin Berry" <[email protected]>
To: "Steve Fanning" <[email protected]>
Cc: "documentation list" <[email protected]>
Sent: 06/06/2020 00:51:56
Subject: Re: Re[2]: Calc Error Codes Rev 1
Thank you for catching that mistake. Yes, it is a 532, not 503.
I didnt see the =ERRORTYPE(cell-address) in the chapter- maybe I just
overlooked it. Is that something that might be able to be added in
there?
Gordon Bates
[email protected]
github.com/jdoes
On Fri, Jun 5, 2020 at 12:46 PM Steve Fanning
<[email protected]> wrote:
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" <[email protected]>
To: "Steve Fanning" <[email protected]>
Cc: "documentation list" <[email protected]>
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
[email protected]
github.com/jdoes
On Fri, Jun 5, 2020 at 2:07 AM Steve Fanning
<[email protected]> 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" <[email protected]>
To: "Stephen Fanning" <[email protected]>; "documentation
list" <[email protected]>
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
[email protected]
github.com/jdoes
--
To unsubscribe e-mail to: [email protected]
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
