History log of /trunk/audit/openformula-function-gaps/datedif-semantic-design.md (Results 1 – 5 of 5)
Revision Date Author Comments
# c2b81925 19-Nov-2026 Jim Jagielski <jimjag@gmail.com>

Merge trunk into hsqldb2 branch


# 19559844 19-Nov-2026 Jim Jagielski <jimjag@gmail.com>

Merge branch 'openformula' into trunk


# 4f909564 18-Nov-2026 Jim Jagielski <jimjag@gmail.com>

audit: update the OpenFormula function gap notes to match the code

Using Pedro's audit notes as a baseline, update them based on
the fixes and changes made.


# 62e7f86e 17-Nov-2026 Pedro Giffuni <pfg@apache.org>

H.3.1: Complete DATEDIF semantics, help, and tests

- Correct md borrow, ym/yd anniversary handling, and signed arithmetic
- Add ScDateDif declaration and help topic registration
- Fix SG.DATEDIF-010

H.3.1: Complete DATEDIF semantics, help, and tests

- Correct md borrow, ym/yd anniversary handling, and signed arithmetic
- Add ScDateDif declaration and help topic registration
- Fix SG.DATEDIF-010-md expectation and expand DATEDIF calcval coverage
- Update DATEDIF design and audit records

show more ...


# f8b15cbb 17-Nov-2026 Pedro Giffuni <pfg@apache.org>

impl: Add DATEDIF function (H.3)

Implement ODF 1.4 §6.10.3 DATEDIF natively in Calc:

- New opcode SC_OPCODE_DATEDIF = 415 (existing opcodes unchanged;
STOP_2_PAR moved to 416, LAST_OPCODE_ID to 4

impl: Add DATEDIF function (H.3)

Implement ODF 1.4 §6.10.3 DATEDIF natively in Calc:

- New opcode SC_OPCODE_DATEDIF = 415 (existing opcodes unchanged;
STOP_2_PAR moved to 416, LAST_OPCODE_ID to 415)
- ScInterpreter::ScDateDif() evaluator in interpr2.cxx implementing
all six formats (y, m, d, md, ym, yd) using calendar arithmetic
(not day-count approximation)
- Document-aware null date via pFormatter->GetNullDate()
- Floor-based time fraction handling
- Case-sensitive format matching with invalid format rejection
- Reverse-date handling: y/m/d negated, md/ym/yd absolute
- Function Wizard entry, help ID, and 15 regression test cases
- Semantic design documented in audit/openformula-function-gaps/

No build or runtime testing performed (GCC 15.2 ABI incompatibility
blocks AOO compilation). Runtime validation deferred.

show more ...