Greetings!
The agenda for our TC call on Monday, 2024-07-22
Time of meeting:
https://www.timeanddate.com/worldclock/meetingdetails.html?year=2024&month=7&day=22&hour=16&min=0&sec=0&p1=25&p2=37The call counts towards voter eligibility.
Teleconference Numbers - Access code: 438387
Canada (use US number)
Denmark +45 78 77 25 34
Germany +49 30 255550324
Hungary +36 1 987 6874
Netherlands +31 6 35205016
United Kingdom +44 330 777 2407
US +1 267 807 9605
Chat room for meeting is at webconf.soaphub.org/conf/room/odf
Please send comments to the mailing list.
1. Dial-In, Roll Call, Determination of Quorum and Voting Rights
2. Motion (simple majority): Approve minutes of 17 July 2024
Apologies, the link takes you to another set of minutes. Something is
wrong at OASIS but to keep that from delaying approval, I have pasted
the 17 July minutes at the end of this email.
3. Motion (simple majority): Approve the Agenda
4. "add SORT function"
issues.oasis-open.org/browse/OFFICE-4157
Regina has posted a new draft! Please review carefully well before the
meeting!
5. XLOOKUP (issues.oasis-open.org/browse/OFFICE-4154)
6. XMATCH (issues.oasis-open.org/browse/OFFICE-4155) functions.
7. "add FILTER function"
issues.oasis-open.org/browse/OFFICE-4156
8. "add SORTBY function"
issues.oasis-open.org/browse/OFFICE-4158
9. Adjournment
Hope everyone is at the start of a great week!
Patrick
*******************************************
[12:03] Patrick: Francis, Patrick, Regina, Alfred, Michael, Svante - quorum
[12:03] Patrick: approval 8 July 2024 - approved by consent
[12:04] Patrick: approval of the agenda - by consent
[12:04] Svante Schubert: 4.
https://insider.microsoft365.com/en-us/blog/microsoft-365-apps-now-support-opendocument-format-1-4[12:05] Patrick: #5 Sort function
[12:08] Patrick: Interger|Array - versus Any - ?
[12:11] Regina Henschel: Specifiying data type 'Integer' includes that
implicit conversion is in place, whereas using data type 'Any' means,
that no implicit conversion is done.
[12:12] Regina Henschel: 6.3.6 Conversion to Integer, part 4
[12:15] Regina Henschel:
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1017990_715980110[12:17] Patrick: Could specify what happens if a value in an array is
not an integer - but would require a lot of text
[12:27] Patrick: Interger|Array - OK - but see how to formulate constraints
[12:35] Patrick: Sorting - Andrew, Carol, Bob - Sorted Andrew, Bob,
Carol - Assigned positive integers Andrew - 1, Bob - 2, Carol - 3 (in
the sort index)
[12:38] Patrick: Ignore Patrick - the sort index is the rows or columns
order of sorting
[12:39] Patrick: in summary - multi-level sorting
[12:40] Patrick: One function is either columns or rows, not both in the
same operation
[12:41] Regina Henschel: Values can be sorted by one column or as
multi-level sorting by more columns or values can be sorted by one row
or as multi-level sorting by more rows.
[12:43] Francis Cave: Values can be sorted either by column or by row.
The function allows for multi-level sorting, i.e. sorting first by one
column or row then by another.
[12:45] Patrick: Regina - Use The function allows for multi-level
sorting. (in the summary)
[12:45] Patrick: details in the semantics
[12:50] Michael Stahl: "the array that provides the input to be sorted"
[12:51] Patrick: Patrick - Input to sort. (leaving the array elsewhere
stated)
[12:53] Patrick: name attribute of a range element
[12:53] Francis Cave: The value may be the value of the name attribute
of an element <table:database-range>
[12:55] Patrick: Regina - Excel has a table name attribute so conversion
is possible
[12:56] Patrick: Regina - Alfred - can sort in Excel link to a database
directly?
[12:59] Patrick: directly in a sort function -
[12:59] Patrick: Alfred says yes
[13:01] Patrick: parameter data source in Excel? Regina - need to
describe for sort function
[13:02] Patrick: Adjourned</table:database-range>