<?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-semantic-test-plan.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-semantic-test-plan.md#c2b81925c0a64ac9dacc28969eb3a2b5a73b36dc</link>
        <description>Merge trunk into hsqldb2 branch

            List of files:
            /trunk/audit/openformula-function-gaps/function-semantic-test-plan.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-semantic-test-plan.md#195598447694ec8542914a9b51ae9942e8ebacd9</link>
        <description>Merge branch &apos;openformula&apos; into trunk

            List of files:
            /trunk/audit/openformula-function-gaps/function-semantic-test-plan.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>8501d2b60c8391294370b6b46ee16d4e87e13c09 - oox: read _xlfn.F.DIST, F.INV, NUMBERVALUE and RRI from xlsx</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-semantic-test-plan.md#8501d2b60c8391294370b6b46ee16d4e87e13c09</link>
        <description>oox: read _xlfn.F.DIST, F.INV, NUMBERVALUE and RRI from xlsx

            List of files:
            /trunk/audit/openformula-function-gaps/function-semantic-test-plan.md</description>
        <pubDate>Wed, 18 Nov 2026 16:52:46 +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-semantic-test-plan.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-semantic-test-plan.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>9bc678ecbc9fdb9999f4654ba7d99debe77c8e73 - H.5.1: Priority 2 consistency fixes - calcval tests for H.1/H.2 functions</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-semantic-test-plan.md#9bc678ecbc9fdb9999f4654ba7d99debe77c8e73</link>
        <description>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

            List of files:
            /trunk/audit/openformula-function-gaps/function-semantic-test-plan.md</description>
        <pubDate>Tue, 17 Nov 2026 22:24:55 +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-semantic-test-plan.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-semantic-test-plan.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-semantic-test-plan.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-semantic-test-plan.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>62e7f86e31aeeea8e6cfda4779001721ba725d12 - H.3.1: Complete DATEDIF semantics, help, and tests</title>
        <link>http://opengrok-test.openoffice.org:8080/history/trunk/audit/openformula-function-gaps/function-semantic-test-plan.md#62e7f86e31aeeea8e6cfda4779001721ba725d12</link>
        <description>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

            List of files:
            /trunk/audit/openformula-function-gaps/function-semantic-test-plan.md</description>
        <pubDate>Tue, 17 Nov 2026 20:21:34 +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-semantic-test-plan.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-semantic-test-plan.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>
