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


# 8501d2b6 18-Nov-2026 Jim Jagielski <jimjag@gmail.com>

oox: read _xlfn.F.DIST, F.INV, NUMBERVALUE and RRI from xlsx


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


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

H.5.1: Priority 2 consistency fixes - calcval tests for H.1/H.2 functions

- Add 40 calcval test cases:
- SG.NUMVAL-01..10 (NUMBERVALUE: basic, European, group sep, percent, whitespace, empty, inva

H.5.1: Priority 2 consistency fixes - calcval tests for H.1/H.2 functions

- Add 40 calcval test cases:
- SG.NUMVAL-01..10 (NUMBERVALUE: basic, European, group sep, percent, whitespace, empty, invalid, locale, cell ref)
- SG.FINDB-01..10 (FINDB: basic, start pos, not found, case-sensitive, bounds, DBCS)
- SG.SEARCHB-01..10 (SEARCHB: basic, case-insensitive, wildcards, regex, DBCS)
- SG.REPLACEB-01..10 (REPLACEB: basic, append, multi-byte, DBCS, bounds, zero count)
- Update function-semantic-test-plan.md to reflect implemented status

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


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


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