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