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

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Mon Apr 2 17:07:07 CEST 2012


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

--- Comment #5 from Rajesh Sharma <rksharma74 at gmail.com> 2012-04-02 08:07:07 PDT ---
Libra Office has take 12/31/1899 as 1 and not 1900 as base for caluclation
if we will format 01/01/1900 as number it will give you 2. There is no 0 base
value. which is actully problem for all date based calculations. a base date is
required for calulation. 12/30/1899 is used as 0. So first resolve the base
vlaue proble then only date based calculation can be resolved

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



More information about the Libreoffice-bugs mailing list