Summary: | Missing OpenFormula function Datedif | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Sameer Bahadur <bahadur.sameer> |
Component: | Calc | Assignee: | Eike Rathke <erack> |
Status: | RESOLVED FIXED | ||
Severity: | enhancement | CC: | erack, markus.mohrhard, osc |
Priority: | high | ||
Version: | 3.3.4 release | ||
Hardware: | Other | ||
OS: | All | ||
See Also: | https://issues.apache.org/ooo/show_bug.cgi?id=49467 | ||
Whiteboard: | target:3.6.0 | ||
Crash report or crash signature: | Regression By: | ||
Attachments: |
patch sofar, not yet ready for submitting
test case document ODF .ods same test case saved as .xls |
Description
Sameer Bahadur
2012-01-04 11:12:32 UTC
Yearfrac is a OpenFormula/ODF function and needs to be implemented if we want to follow the standard. The bug here is the missing Datedif function from Openformula: http://docs.oasis-open.org/office/v1.2/cos01/OpenDocument-v1.2-cos01-part2.html#__RefHeading__1018176_715980110 I'll start working on it; I would like to have the datedif function myself too... Created attachment 61212 [details]
patch sofar, not yet ready for submitting
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4e71be498903dee5bf719a73f4976bb5356335dd fdo#44456 added calc function DATEDIF as in ODF1.2 Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=40c8170c5281cd7b19313a79f902ef9715351c9f changes to patch fdo#44456 added calc function DATEDIF This is not finished yet and needs some further love. Created attachment 61607 [details]
test case document ODF .ods
Note difference in H17, hence H37 is red FALSE. I believe this is an error of Excel.
Created attachment 61608 [details]
same test case saved as .xls
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=121a39be3019baa840bb595acf0e648245a01b04 further changes to patch fdo#44456 added calc function DATEDIF Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=eb1770f05fde3777af7a62ec1c84ce8b088e3ec4 further changes to patch fdo#44456 added calc function DATEDIF Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=485792374600cd9919ab6edf201e8bd97d640261 added unit tests for DATEDIF fdo#44456 *** Bug 260998 has been marked as a duplicate of this bug. *** Seen from the domain http://volichat.com Page where seen: http://volichat.com/chat-with-strangers Marked for reference. Resolved as fixed @bugzilla. |