[Libreoffice-bugs] [Bug 40100] EDITING YEARFRAC function returns incorrect results for some dates

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=40100

Jeffrey <jeffdchang at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jeffdchang at gmail.com,
                   |                            |yfjiang at novell.com

--- Comment #1 from Jeffrey <jeffdchang at gmail.com> 2011-08-16 07:47:20 PDT ---
Confirmed for LibreOffice 3.4  340m1(Build:103) on OpenSuse Linux.

Tried it with =YEARFRAC(DATE(1958,3,1),DATE(1994,12,31),1) and
=YEARFRAC(DATE(1958,3,1),DATE(1995,1,1),1), which give different results, so it
is not because the difference of 1 day is so small the decimal is unchanged.
Also tried with =YEARFRAC(DATE(1958,1,1),DATE(1997,12,31),1), and it gives a
non-zero value, so Calc recognizes the difference of a day between 12/31 and
1/1.

Do not know why bug appears for those two values.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.