Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Implementation of YEARFRAC function inconsistent with Excel | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | cfries <email> | ||||
Component: | code | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CLOSED IRREPRODUCIBLE | QA Contact: | |||||
Severity: | Normal | ||||||
Priority: | P3 | CC: | elish, issues, rb.henschel | ||||
Version: | 4.0.0 | Keywords: | needmoreinfo | ||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
cfries
2013-09-19 11:34:04 UTC
Note: There was a typo in the url to the test spreadsheets. The url is http://finmath.net/spreadsheets/Day%20Count%20Fractions.zip (I could not attache that file, due to file size limitations. The spreadsheet requires the OpenOffice Add-In Obba.oxt from http://www.obba.info ). Created attachment 81579 [details]
Excel 2010 vs. Calc 4
I've installed Obba for Excel and Calc. The spreadsheets at comment 1 look like in attachment 81579 [details]. Please advise. Rob Weir has pointed to his test document at http://www.robweir.com/basis-test.xls in dev@openoffice.apache.org (http://www.mail-archive.com/dev@openoffice.apache.org/msg11342.html), which he had produced to cover all cases which are possible in ODF. Please use that document, to test whether AOO calculates correctly. If Excel has results, that are different from ODF, then AOO would need an additional function YEARFRAC_ADD, which mimics Excels calculation. Functions defined in ODF should always calculate as specified. No info from author. Hi Edwin. Sorry, I did not see that you had a problem to run the spreadsheet. It works for me. I will check that. Can you try again? What error message do you see? However, why then is this report closed. Even if my demo sheet does not work, I gave test cases. I can give more, if needed (should I then reopen this report)? Note: The implementation of YEARFRAC has from OO 3.x to 4.x - so maybe I have to update some of my test. Best Christian (In reply to Regina Henschel from comment #4) > > If Excel has results, that are different from ODF, then AOO would need an > additional function YEARFRAC_ADD, which mimics Excels calculation. Functions > defined in ODF should always calculate as specified. The problem is that if AOO opens an XLS file (claiming XLS compatibility) then the Excel YEARFRAC function is mapped to the AOO YEARFRAC function. I assume that all users expect the sheet to work "as in Excel". Hence: if you use the same name as Excel function THAT function should mimic Excels calculation. PS: My bug report was that a) The AOO Spec does not agree with Excel and b) The AOO implementation did not agree with the spec (that might have changed with AOO 4 - I will check). |