https://issues.apache.org/ooo/show_bug.cgi?id=123294
--- Comment #7 from cfries <[email protected]> --- (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). -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
