Cool stuff! I'll take a look
> On Nov 17, 2026, at 7:44 PM, Pedro F. Giffuni <[email protected]> wrote:
>
> The new stuff in the openformula branch fixes a bunch of real bugs.
> There still an issue with the F distribution, but I ran out of tokens so it
> will have to wait a bit :).
>
> Pedro.
>
> On Tuesday, November 17, 2026 at 01:12:06 PM GMT-5, Pedro F. Giffuni wrote:
>
>
> OK, now I went through the Spreadsheet tests and with chatGPT we came up with
> this new plan:
>
> Priority
>
> Functions
>
> Recommended action
>
> First
>
> NUMBERVALUE
>
> Implement the missing evaluator using the existing opcode
>
> Second
>
> FINDB, REPLACEB, SEARCHB
>
> Implement as a coordinated byte-oriented text-function family
>
> Third
>
> DATEDIF
>
> Add native evaluation and correct the import mapping
>
> Fourth
>
> ERROR.TYPE
>
> Audit and correct error-code translation
>
> Fifth
>
> ISOWEEKNUM
>
> Extend or adapt week calculation for ISO 8601
>
> Later
>
> RRI, GETPIVOTDATA, FDIST, FINV, ODDFPRICE, ODDFYIELD, HARMEAN
>
> Address specific semantic and interoperability defects
>
> Separate
>
> DDE
>
> Treat as a platform/security project
>
> ______
>
> I am currently in the second and stopped to look at the DATEDIF PR, but it
> looks like I've moved too much of the surroundings for it to apply directly.
>
> Pedro.
>
--
Jim
"This is an outrage!"
Tony Harrison