[Libreoffice-bugs] [Bug 125580] Wrong value when adding two dates

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #15 from b. <newbie-02 at gmx.de> ---
Created attachment 171147
  --> https://bugs.documentfoundation.org/attachment.cgi?id=171147&action=edit
testsheet for 'fills' with fractional values

hi @all, 

my proposal in c#12 was a little weak, i saw later that it has difficulties
e.g. starting from 1970-01-01, 

pls. find attached a new version which can handle that, it needs one special
calculated correction value and then reaches ~128 bit precision in doubles (see
comments and 'how and why' in the sheet, 

it is 'formula based' and thus userspace (be careful trying it in macros, saw
some crazy miscalculations with basic lately), but IMHO similar could / should
be implemented in code to get finally rid of all these 'fill' and 'series
fails', 

disclaimer: 'work in progress', looks well but not yet extensively tested ...
corrections welcome ...

-- 
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/20210413/25cd48c3/attachment.htm>