<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="/rss.xsl.xml"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
    <title>Changes in function-implementation-roadmap.md</title>
    <description></description>
    <language>en</language>
    <copyright>Copyright 2025</copyright>
    <generator>Java</generator><item>
        <title>c2b81925c0a64ac9dacc28969eb3a2b5a73b36dc - Merge trunk into hsqldb2 branch</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#c2b81925c0a64ac9dacc28969eb3a2b5a73b36dc</link>
        <description>Merge trunk into hsqldb2 branch

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Thu, 19 Nov 2026 14:39:10 +0000</pubDate>
        <dc:creator>Jim Jagielski &lt;jimjag@gmail.com&gt;</dc:creator>
    </item>
<item>
        <title>195598447694ec8542914a9b51ae9942e8ebacd9 - Merge branch &apos;openformula&apos; into trunk</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#195598447694ec8542914a9b51ae9942e8ebacd9</link>
        <description>Merge branch &apos;openformula&apos; into trunk

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Thu, 19 Nov 2026 10:08:51 +0000</pubDate>
        <dc:creator>Jim Jagielski &lt;jimjag@gmail.com&gt;</dc:creator>
    </item>
<item>
        <title>83f26b2a297de14f8a6d31fcb09de5b79ced3996 - oox: read _xlfn.ISOWEEKNUM from xlsx</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#83f26b2a297de14f8a6d31fcb09de5b79ced3996</link>
        <description>oox: read _xlfn.ISOWEEKNUM from xlsxISOWEEKNUM is also the ODF name of WEEKNUM and the lookup keeps the firstopcode, so the row is flagged to take the last one.

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Wed, 18 Nov 2026 17:24:18 +0000</pubDate>
        <dc:creator>Jim Jagielski &lt;jimjag@gmail.com&gt;</dc:creator>
    </item>
<item>
        <title>4f909564306b0b9427c04e40b956b17bc2f57119 - audit: update the OpenFormula function gap notes to match the code</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#4f909564306b0b9427c04e40b956b17bc2f57119</link>
        <description>audit: update the OpenFormula function gap notes to match the codeUsing Pedro&apos;s audit notes as a baseline, update them based onthe fixes and changes made.

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Wed, 18 Nov 2026 14:17:52 +0000</pubDate>
        <dc:creator>Jim Jagielski &lt;jimjag@gmail.com&gt;</dc:creator>
    </item>
<item>
        <title>f437eb0387668d22e9d4372d5f370a07f8041129 - Audit correction: RRI reclassification</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#f437eb0387668d22e9d4372d5f370a07f8041129</link>
        <description>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

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Wed, 18 Nov 2026 00:02:51 +0000</pubDate>
        <dc:creator>Pedro Giffuni &lt;pfg@apache.org&gt;</dc:creator>
    </item>
<item>
        <title>ed55d629ef5218e76020fca342f751450d8a06fa - H.6: Defer ODDFPRICE/ODDFYIELD native implementation</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#ed55d629ef5218e76020fca342f751450d8a06fa</link>
        <description>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

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Tue, 17 Nov 2026 23:08:59 +0000</pubDate>
        <dc:creator>Pedro Giffuni &lt;pfg@apache.org&gt;</dc:creator>
    </item>
<item>
        <title>8ce50c348575e8ff726fab75835af1aabc78c72d - Audit correction: RRI reclassification</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#8ce50c348575e8ff726fab75835af1aabc78c72d</link>
        <description>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

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Wed, 18 Nov 2026 00:02:51 +0000</pubDate>
        <dc:creator>Pedro Giffuni &lt;pfg@apache.org&gt;</dc:creator>
    </item>
<item>
        <title>517a2e3b216754282385a674d10fc3dda88d9017 - H.5: Implement ISO 8601 ISOWEEKNUM semantics</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#517a2e3b216754282385a674d10fc3dda88d9017</link>
        <description>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

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Tue, 17 Nov 2026 21:55:56 +0000</pubDate>
        <dc:creator>Pedro Giffuni &lt;pfg@apache.org&gt;</dc:creator>
    </item>
<item>
        <title>cf30ea8b32426d16608748e67b170cdaddf2d323 - H.4: Fix ERROR.TYPE error-code mapping, add help and tests</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#cf30ea8b32426d16608748e67b170cdaddf2d323</link>
        <description>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

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Tue, 17 Nov 2026 20:40:09 +0000</pubDate>
        <dc:creator>Pedro Giffuni &lt;pfg@apache.org&gt;</dc:creator>
    </item>
<item>
        <title>47032aefbaedc538f58cf70300b3b6d11b46912c - fix: Wire DATEDIF BIFF import mapping to native opcode</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#47032aefbaedc538f58cf70300b3b6d11b46912c</link>
        <description>fix: Wire DATEDIF BIFF import mapping to native opcodeChange BIFF5/BIFF7 function ID 351 (DATEDIF) from ocNoName to ocDateDifin xlformula.cxx saFuncTable_5. This enables XLS import of DATEDIF toresolve 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 dispatchedUpdated audit documentation across all 5 deliverable files.Static verification: code change reviewed, opcode registration confirmed incompiler.hrc, opcode.hxx, interpr4.cxx.

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Tue, 17 Nov 2026 19:33:13 +0000</pubDate>
        <dc:creator>Pedro Giffuni &lt;pfg@apache.org&gt;</dc:creator>
    </item>
<item>
        <title>f8b15cbbe30249a9fbf72dc4ebd904ff5e78e14a - impl: Add DATEDIF function (H.3)</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#f8b15cbbe30249a9fbf72dc4ebd904ff5e78e14a</link>
        <description>impl: Add DATEDIF function (H.3)Implement ODF 1.4 &#167;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-&gt;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 incompatibilityblocks AOO compilation). Runtime validation deferred.

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Tue, 17 Nov 2026 19:13:18 +0000</pubDate>
        <dc:creator>Pedro Giffuni &lt;pfg@apache.org&gt;</dc:creator>
    </item>
<item>
        <title>0224e3dc6cff4d609b30ebb06209c919086b4154 - impl: Add NUMBERVALUE evaluator and FINDB/SEARCHB/REPLACEB functions (H.1, H.2)</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-implementation-roadmap.md#0224e3dc6cff4d609b30ebb06209c919086b4154</link>
        <description>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 &#167;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).

            List of files:
            /trunk/audit/openformula-function-gaps/function-implementation-roadmap.md</description>
        <pubDate>Tue, 17 Nov 2026 17:01:27 +0000</pubDate>
        <dc:creator>Pedro Giffuni &lt;pfg@apache.org&gt;</dc:creator>
    </item>
</channel>
</rss>
