[libreoffice-users] Re: Visible currency rounding

On 20-07-2013 01:26, toodr wrote:
> I had the same problem. I needed to implement the so called Bankers' Rounding
> Function,

if i read correctly at:
http://en.wikipedia.org/wiki/Rounding
Round half to even[edit]
A tie-breaking rule that is less biased is round half to even, namely:
If the fraction of y is 0.5, then q is the even integer nearest to y.
Thus, for example, +23.5 becomes +24, as does +24.5; while −23.5 becomes 
−24, as does −24.5.
This method treats positive and negative values symmetrically, and is 
therefore free of sign bias. More importantly, for reasonable 
distributions of y values, the expected (average) value of the rounded 
numbers is the same as that of the original numbers. However, this rule 
will introduce a towards-zero bias for even numbers (including zero), 
and a towards-infinity bias for odd ones.
This variant of the round-to-nearest method is also called unbiased 
rounding, convergent rounding, statistician's rounding, Dutch rounding, 
Gaussian rounding, odd-even rounding,[3] bankers' rounding or broken 
rounding, and is widely used in bookkeeping.
This is the default rounding mode used in IEEE 754 computing functions 
and operators.

This means that your function does not work correctly i.e.
23,574 should be rounded to 23,58, you function gives 23,57

so, i tried to create a function hwich lives up to my expectations... ;)
(but i NEVER used 'Bankers' Rounding'......)



function bround(i as double, Optional d as integer)
        dim format as string
        dim tmp as string
        dim c as double
    svc=createUnoService("com.sun.star.sheet.FunctionAccess")
    if IsMissing(d) then d=2
    bround = svc.callFunction("ROUND", array(i/2, d))*2
end function


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted