No apologies at all! I'm just picking off lint basically :) 

> On Nov 18, 2026, at 11:36 AM, Pedro F. Giffuni via dev 
> <[email protected]> wrote:
> 
> Oh I see now ...
> 
> First of all, my apologies. I had it all fine but then I thought I could 
> rearrange the commits to have it make more sense.
> 
> RRI is the English for ZGZ so one of the changes to translate the 
> documentation and description from German to English. I did some unrelated 
> fixes, and later renamed the opcode from ZGZ to RRI but left an alias for 
> backwards compatibility.
> 
> I tried to modify the commit history (can be done but it's tricky) to have 
> the two RRI commits together but that caused a mess in the other commits as 
> well.
> 
> Your changes undid that last commit, but it was mostly a 
> cosmetical/consistency cleanup.
> 
> I now see there we other undesired effects like the
> Opcode registration for ODDFPRICE and ODDFYIELD 
> <https://github.com/apache/openoffice/commit/510e06d8a49c3e9addd94f093db5b4eae615cfd0>
> and then reverting that change (the change never made sense, both had to die).
> 
> At this stage I don't know if this mess can be fixed properly. But if the 
> Spreadsheet passes the FDIST/FINV, Financial stuff, we are in a good place 
> despite the log mess.
> 
>  
> 
> Pedro.
> 
> ps. in the spreadsheet don't worry about RRI and DDE, the tests are broken, 
> not AOO.
> 
> On Wednesday, November 18, 2026 at 10:23:24 AM GMT-5, Jim Jagielski 
> <[email protected]> wrote:
> 
> 
> Thanks! Your commit didn't build so my fixes worked on getting it running and 
> tested on macOS and Ubuntu.
> 
>> On Nov 18, 2026, at 9:26 AM, Pedro F. Giffuni <[email protected]> wrote:
>> 
>> Done .. should be complete now.
>> 
>> Heck, we had too many broken things!
>> 
>> Pedro.
>> 
>> On Wednesday, November 18, 2026 at 09:19:47 AM GMT-5, Jim Jagielski 
>> <[email protected]> wrote:
>> 
>> 
>> OK. I've kept my changes local and will sync/rebase/merge w/ `openformula` 
>> after a bit.
>> 
>>> On Nov 18, 2026, at 9:16 AM, Pedro F. Giffuni <[email protected]> wrote:
>>> 
>>> Hmm.. I am changing stuff as we speak.. hold for half an hour please.
>>> 
>>> On Wednesday, November 18, 2026 at 09:13:07 AM GMT-5, Jim Jagielski 
>>> <[email protected]> wrote:
>>> 
>>> 
>>> I have some changes in place. Should I go ahead and commit them to the fork?
>>> 
>>>> On Nov 18, 2026, at 9:04 AM, Pedro F. Giffuni via dev 
>>>> <[email protected]> wrote:
>>>> 
>>>> I had it perfect, and then I just had to arrange the log and ruined it 
>>>> all... hold horsed for a while :)
>>>> Pedro.
>>>>    On Wednesday, November 18, 2026 at 06:46:54 AM GMT-5, Jim Jagielski 
>>>> <[email protected]> wrote:  
>>>> 
>>>> 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
>>> 
>>> --
>>> Jim
>>>   "This is an outrage!"
>>>                         Tony Harrison
>>> 
>> 
>> --
>> Jim
>>   "This is an outrage!"
>>                         Tony Harrison
>> 
> 
> --
> Jim
>   "This is an outrage!"
>                         Tony Harrison
> 
> <OpenFormula_test.ods>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]

--
Jim
  "This is an outrage!"
                        Tony Harrison

Reply via email to