Summary: | calc: calculate: formula: precision: calc should catch up with ex$el accuracy features - make silly rounding switchable | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | b. <newbie-02> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | dante19031999, gmolleda, peter, xiscofauli |
Priority: | medium | ||
Version: | 7.2.0.0.alpha0+ | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
b.
2021-02-28 19:22:40 UTC
Looks similar to 140695. Doing further examination. (In reply to Peter S Anderson from comment #1) > Looks similar to 140695. Doing further examination. hello, thanks for looking, 'similar' - yes, but not the same, that is for excessive 'bit eating', this is about giving the user ability to work without, No progress for the time being. Probably best to wait until there is some response from higher powers concerning bug 140695. Hello Dante, is it something your work on KahanSum improves ? Should it be closed as dupe of bug 137679 ? (In reply to Xisco Faulí from comment #4) > Hello Dante, > is it something your work on KahanSum improves ? > Should it be closed as dupe of bug 137679 ? No. It may be a little bit better because I killed some horrible roundings in some of the affected functions. But everything else stills untouched. I don't know what made all the functions modified, but I'm quite sure that operators like +, -, *, ... are still major data losses. LibreOffice Calc: A B C 3 B3*C3 53 70% 4 B4*C4 88 30% 5 Round(A3+A4) Vi vidos 63 and not 64 en A5. En aliaj oficejaj pakoj vi ĉiam vidas 64 kiam kalkulite: gnumeric , Excel, OnlyOffice, Google Sheets. You will see 63 and not 64 in A5. In other office packages you always see 64 when calculated: gnumeric, Excel, OnlyOffice, Google Sheets. |