question for code pointer | was: Aw: Re: fuzzy rounding, roundoff, roundup(), et cetera.
newbie nullzwei via gnumeric-list <[email protected]> Mon, 12 Jul 2021 21:22:19 +0200
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <trinity-52ce16b7-61ce-4b40-b87e-874d5c5c7d9c-1626117739512@3c-app-gmx-bs31> |
hello @John Denker, took some time but got it up and running, have to play with it and learn, looks very useful so far ... :-) a question at you or others ... i'd like to try an attempt to get rid of 'zombie values', can anyone give my a short description which functions handele: - keyboard input and string to double conversion, - file read (spreadsheets) and string to double conversion, - file read (csv, data streams and similar) and string to double conversion, - when and how long doubles come in use? would be very nice, thank you, b. --- Gesendet: Samstag, 10. Juli 2021 um 23:52 Uhr Von: "John Denker via gnumeric-list" <[email protected]> An: [email protected] Betreff: Re: fuzzy rounding, roundoff, roundup(), et cetera. I coded a version of roundup(xx, pp) It correctly handles all the tricky cases I know of, including: ru 0.24999999999999997 16 ru 0.1250000001000003 16 ru 0.49999999999999997 16 ru 0.1 -15 It comes with a test harness, and an updated preliminary specification, in my fpu_exceptions.c program. See the "ru" and "ruspec" commands in particular. Interested parties are invited to experiment with it. If you find a case that doesn't seem to be handled correctly, please let me know. https://www.av8n.com/cgit/FPU/tree/fpu_exceptions.c _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list