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