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. On Tuesday, November 17, 2026 at 05:23:56 AM GMT-5, Jim Jagielski <[email protected]> wrote: Super happy you did!! On Nov 16, 2026, at 3:46 PM, Pedro F. Giffuni via dev <[email protected]> wrote: Couldn't help finding something to fix after the fact ;-). Pedro. On Sunday, November 15, 2026 at 10:33:54 PM GMT-5, Pedro F. Giffuni via dev <[email protected]> wrote: Great! That unblocked a final set of changes... namely adding help files for the new functions and some other checks and audits. Please give it one final check, cleanup what is not needed (*.md files?) and feel free to merge. Pedro. On Friday, November 13, 2026 at 02:33:55 PM GMT-5, Jim Jagielski <[email protected]> wrote: Very cool... I played around with it a bit earlier today and added some stuff, as well as tried to run tests on macOS and Ubuntu On Nov 12, 2026, at 4:35 PM, Pedro F. Giffuni via dev <[email protected]> wrote: Hello;First of all, kudos for the ODT 1.4 work, that's really great to have!Despite this, there is still some technical debt on the side of OpenFormula.I started a branch (openformula) to tackle that but I am currently stuck due to my build environment:I am currently running my experiments with WSL (Ubuntu) but I cannot run the resulting executables. Also apparently the calcval harness is macOS-only. Do we need this for release? not really. I hope the branch serves as a starting point, so that someone else doesn't waste a lot of tokens ;-). In any case, I did have Claude generate a spreadsheet to test OpenFormula, which may be helpful for someone wanting to continue such work. Enjoy, Pedro. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] -- Jim "This is an outrage!" Tony Harrison -- Jim "This is an outrage!" Tony Harrison
