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


# 83f26b2a 18-Nov-2026 Jim Jagielski <jimjag@gmail.com>

oox: read _xlfn.ISOWEEKNUM from xlsx

ISOWEEKNUM is also the ODF name of WEEKNUM and the lookup keeps the first
opcode, so the row is flagged to take the last one.


# 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.


# f437eb03 18-Nov-2026 Pedro Giffuni <pfg@apache.org>

Audit correction: RRI reclassification

- RRI: No implementation defect; prior discrepancy traced to test-data error
- Update inventory, summary, roadmap, and source audit
- Retain German help and _x

Audit correction: RRI reclassification

- RRI: No implementation defect; prior discrepancy traced to test-data error
- Update inventory, summary, roadmap, and source audit
- Retain German help and _xlfnodf export naming as separate audit items
- No production code changes

show more ...


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

H.6: Defer ODDFPRICE/ODDFYIELD native implementation

- Revert H.6.1 opcode registration (c4aad856fa)
- Update roadmap: Group 3 DEFERRED pending financial registration policy
- AddIn implementations

H.6: Defer ODDFPRICE/ODDFYIELD native implementation

- Revert H.6.1 opcode registration (c4aad856fa)
- Update roadmap: Group 3 DEFERRED pending financial registration policy
- AddIn implementations preserved (financial.cxx, analysishelper.cxx)
- Priority P2 but DEFERRED until policy defined

show more ...


# 8ce50c34 18-Nov-2026 Pedro Giffuni <pfg@apache.org>

Audit correction: RRI reclassification

- RRI: No implementation defect; prior discrepancy traced to test-data error
- Update inventory, summary, roadmap, and source audit
- Retain German help and _x

Audit correction: RRI reclassification

- RRI: No implementation defect; prior discrepancy traced to test-data error
- Update inventory, summary, roadmap, and source audit
- Retain German help and _xlfnodf export naming as separate audit items
- No production code changes

show more ...


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

H.5: Implement ISO 8601 ISOWEEKNUM semantics

- Add SC_OPCODE_ISOWEEKNUM (416) and ocIsoWeekNum
- Add ScIsoWeekNum() using Date::GetWeekOfYear(MONDAY, 4)
- Register ISOWEEKNUM in ODF and Excel namesp

H.5: Implement ISO 8601 ISOWEEKNUM semantics

- Add SC_OPCODE_ISOWEEKNUM (416) and ocIsoWeekNum
- Add ScIsoWeekNum() using Date::GetWeekOfYear(MONDAY, 4)
- Register ISOWEEKNUM in ODF and Excel namespaces
- Add Function Wizard entry (1 arg, no mode)
- Add HID_FUNC_ISOWEEKNUM and help topic func_isoweeknum.xhp
- Add calcval tests SG.ISO-01..25 (year boundaries, week 53, leap, century, time fractions)
- WEEKNUM (ScGetWeekOfYear) unchanged: retains 2-arg SUN/MON mode
- Update audit records

show more ...


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

H.4: Fix ERROR.TYPE error-code mapping, add help and tests

- Add MapErrorType() mapping internal AOO error codes to ODF 1-7
- Update ScErrorType() to return ERROR.TYPE values per ODF 1.4
- Add Engli

H.4: Fix ERROR.TYPE error-code mapping, add help and tests

- Add MapErrorType() mapping internal AOO error codes to ODF 1-7
- Update ScErrorType() to return ERROR.TYPE values per ODF 1.4
- Add English help topic func_errortype.xhp
- Add calcval test cases SG.ERRTYPE-01..12
- Update audit records

show more ...


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

fix: Wire DATEDIF BIFF import mapping to native opcode

Change BIFF5/BIFF7 function ID 351 (DATEDIF) from ocNoName to ocDateDif
in xlformula.cxx saFuncTable_5. This enables XLS import of DATEDIF to
r

fix: Wire DATEDIF BIFF import mapping to native opcode

Change BIFF5/BIFF7 function ID 351 (DATEDIF) from ocNoName to ocDateDif
in xlformula.cxx saFuncTable_5. This enables XLS import of DATEDIF to
resolve to the native evaluator instead of producing #NAME!.

- Preserves argument count metadata (3 args) and EXC_FUNCFLAG_IMPORTONLY
- DATESTRING (ID 352) and NUMBERSTRING (ID 353) remain as ocNoName
- BIFF export remains unsupported (import-only policy unchanged)
- ocDateDif = SC_OPCODE_DATEDIF = 415, already registered and dispatched

Updated audit documentation across all 5 deliverable files.

Static verification: code change reviewed, opcode registration confirmed in
compiler.hrc, opcode.hxx, interpr4.cxx.

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 ...


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

impl: Add NUMBERVALUE evaluator and FINDB/SEARCHB/REPLACEB functions (H.1, H.2)

Implement four missing Calc functions on the openformula branch:

1. NUMBERVALUE (ODF 1.4 §6.13.28) - evaluates text-t

impl: Add NUMBERVALUE evaluator and FINDB/SEARCHB/REPLACEB functions (H.1, H.2)

Implement four missing Calc functions on the openformula branch:

1. NUMBERVALUE (ODF 1.4 §6.13.28) - evaluates text-to-number with explicit
decimal and group separators. Connects existing opcode 392 (ocNumberValue)
to a new ScInterpreter::ScNumberValue() evaluator implementing whitespace
removal, trailing percent handling (each % divides by 100), lenient group
separator removal (no strict 3-digit rule), decimal-to-period replacement,
and full-string consumption validation via ::rtl::math::stringToDouble.
Locale defaults used for omitted/empty separators.

2. FINDB / SEARCHB / REPLACEB - byte-oriented text functions completing the
existing LENB/LEFTB/RIGHTB/MIDB family. New opcodes 412-414 added at the
end of the function range (existing opcodes unchanged to preserve XLS binary
compatibility, where tokstack.cxx stores 8192+opcode_value). DBCS byte model
(1 byte ASCII/non-DBCS, 2 bytes DBCS per IsDBCS()), consistent with existing
B functions. FINDB case-sensitive, SEARCHB case-insensitive via utl::TextSearch,
REPLACEB avoids splitting DBCS characters at boundaries.

Also adds Function Wizard documentation (scfuncs.src), help IDs (helpids.h,
hidother.src), and 26 regression test cases (calcval-cases14.tsv).

show more ...