deco-math_step_00_b_sa_code_exact_rounddown_roundup_in_gnumeric | was: Aw: Re: Re: Re: Re: deco-Math project, step 00_a: exact bin and dec 'ranges' (in gnumeric).

2021-07-09 Thread newbie nullzwei via gnumeric-list
hello Morten, acc. to a proposal of John Denker to work around wrong floor() results for 'zombie values' by floor(x) < x ? floor(x) : floor(x) - 1; i'd try to put it into goffice/goffice/math/go-math.c, and it seems to work. would you mind to check the code: ---

Aw: Re: Re: deco-Math project, step 00_a: exact bin and dec 'ranges' (in gnumeric). follow up.

2021-07-09 Thread newbie nullzwei via gnumeric-list
thank you, you are right, but then frexp() calculates something different to 'extracting the parts (sign, mantissa and exponent) of the IEEE double representation', (IEEE double mantissa for normalized values has to be [1 .. 2[),  may be frep() calculates exactly half the mantissa and exponent

Re: fuzzy rounding, roundoff, roundup(), et cetera.

2021-07-09 Thread John Denker via gnumeric-list
On 7/8/21 10:52 AM, b. via gnumeric-list wrote: > i wanted to ask for some concrete help, not to start again long discussions > about the inaccuracy of fp-math, IEEE, gnumeric, Excel and Calc. Sometimes it's better to get the answer that is correct rather than the answer you wanted or expected.