Greetings! Notes from the ODF TC teleconference, 11 September 2023, follow below. Next meeting will be on the 18th of September. Hope everyone is at the start of a great week! Svante ****************** 1. Dial-In, Roll Call, Determination of Quorum and Voting Rights [18:04] Svante Schubert: 1) We reached quorum 2. Motion (simple majority): Approve the Agenda [18:05] Svante Schubert: 2) Agenda approved by consent 3. Motion (simple majority): Approve minutes of 24 July 2023 -
https://lists.oasis-open.org/archives/office/202307/msg00036.html [18:05] Svante Schubert: 3) Minutes of 24 July 2023 approved 4. Update on Patricks condition and decide whether it would be useful for Francis to be appointed as Secretary for a limited period (say to the end of October) [18:08] Svante Schubert: Patrick requested a leave of absence over the week-end (active with this meeting) [18:14] Francis Cave: Proposal: to appoint Francis Cave as interim Secretary of the TC for the time being. [18:16] Svante Schubert: Agreement from all present voting members 5. Change to EasterSunday function, ODF 1.4 Change Constraints: a)
https://issues.oasis-open.org/browse/OFFICE-2164 b)
https://lists.oasis-open.org/archives/office/202307/msg00065.html (Regina) c)
https://lists.oasis-open.org/archives/office/202308/msg00008.html (informal meeting notes) [18:17] Svante Schubert: In 1582 switched from Julian Calendar to Gregorian Calendar. The calendar was adopted: 5 14 October the ten days that never existed Our new ODF 1.4 function EASTERSUNDAY( [ Integer Year ] ) will not work with the same algorithm for 1582 as afterwards. see
https://github.com/oasis-tcs/odf-tc/raw/master/docs/odf1.4/part4-formula/OpenDocument-v1.4-part4-formula-tracked.odt [18:22] Svante Schubert: All agree on Regina's proposal from the email. 6. OFFICE-4094: Redefinition of SECOND function in regard to rounding See proposal and comparison shown in attached ODT to JIRA:
https://issues.oasis-open.org/secure/attachment/12085/12085_NewProposal+SECOND+function.odt The proposal is that the TRUNCATE parameter would default to TRUE, which is the current expected (ODF 1.3) behaviour. But MS Excel currently rounds, i.e. behaves as if the TRUNCATE parameter is set to FALSE. To support the proposed change, MS Excel would need to explicitly write out TRUNCATE = FALSE a)
https://lists.oasis-open.org/archives/office/202308/msg00008.html (informal meeting notes) b)
https://issues.oasis-open.org/browse/OFFICE-4094 c)
https://issues.oasis-open.org/secure/attachment/12085/12085_NewProposal+SECOND+function.odt [18:31] Svante Schubert: Vote on reopen issue OFFICE-4094 and apply the proposal given by Regina: [18:32] Svante Schubert: Unanimous agreement 7. User Comment on MathML Version Update a)
https://lists.oasis-open.org/archives/office-comment/202308/msg00000.html b)
https://issues.oasis-open.org/browse/OFFICE-4148 [18:35] Svante Schubert: Regina explains her new proposal in the JIRA issue:
https://issues.oasis-open.org/browse/OFFICE-4148 [18:36] Svante Schubert: Removing the version of MathMl to allow ODF applications to use any future version of MathML as an optional feature of ODF. [18:36] Svante Schubert: A MathML is an optional feature and we do not have to change the RNG for a version update:
http://docs.oasis-open.org/office/OpenDocument/v1.3/os/schemas/OpenDocument-v1.3-schema-rng.html#6930 [18:43] Francis Cave: We need to check how to cite the latest version of MathML in the correct way. [18:45] Francis Cave: I will ask. [18:46] Svante Schubert: Vote on accepting issue OFFICE-4148 and apply the proposal given by Regina. [18:47] Svante Schubert: Unanimous agreement 8, ODF 1.4 progress sheet Update from Francis - Q&A a)
https://lists.oasis-open.org/archives/office/202308/msg00011.html b)
https://lists.oasis-open.org/archives/office/202308/msg00012.html c)
https://lists.oasis-open.org/archives/office/202308/msg00011/ODF_1.4_editing_progress_sheet_2023-08-21.ods [18:53] Svante Schubert: Francis gave a show and tell of the spreadsheet Francis and Patrick are using. [18:53] Svante Schubert: And issue an update when there is a change. 9. New Issue OFFICE-4147: Wrong algorithm in 4.11.7.7 Procedure E in part 4 a)
https://issues.oasis-open.org/browse/OFFICE-4147 b)
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#Basis-ProcedureE c)
https://issues.oasis-open.org/secure/attachment/12086/Steps%20manually.ods [18:55] Svante Schubert: Regina gives an overview over the issue OFFICE-4147 [18:55] Svante Schubert: She found some issues, after following the algorithm described at 4.11.7.7 (part 4) "manually" [18:56] Svante Schubert: 1) The truncation is missing in Procedure E [18:58] Regina Henschel: 2) Ordering of date1 and date2 is missing [18:58] Regina Henschel: 3) Wrong condition in step 8. [19:00] Svante Schubert: Regina is travelling next week, so we are discussing the issue OFFICE-4147 in two weeks on the 25th of September. Next meeting will be on the 18th of September. 10. Adjournment. [19:00] Svante Schubert: Meeting adjourned