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
  

Reply via email to