[Libreoffice-bugs] [Bug 142922] Basic: Round VBA compatibility function implements wrong rounding mode

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142922

--- Comment #2 from b. <newbie-02 at gmx.de> ---
mmmmhhhh ... Σκύλλα και Χάρυβδις (Skylla and Charybdis) ... 

Excel round(x,n) in a sheet: 
'=round(0.12335,4)' -> 0.1234
'=round(0.12345,4)' -> 0.123*5*
'=round(0.12355,4)' -> 0.1236
'=round(0.12365,4)' -> 0.123*7*

Excel round(x,n) in VBA macros: 
'=round(0.12335,4)' -> 0.1234
'=round(0.12345,4)' -> 0.123*4*
'=round(0.12355,4)' -> 0.1236
'=round(0.12365,4)' -> 0.123*6*

in one! program and its associated macro language ... mentally healthy people
might call things like this unhealthy, 

either we copy this ambiguity -> discrepancies between sheet and macro ->
irritated users, 
or we do something with less internal contradictions -> compromises Excel
compatibility -> irritated users, 

any idea for a third way?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210630/cde80874/attachment-0001.htm>