ESC meeting minutes: 2022-06-30

[Miklos Vajna <vmiklos@xxxxxxxxxxxxx>]

* Present:
    + Heiko, Olivier, Caolan, Gabriel, Ilmari, Michael W, Tomaz, Stephan, Thorsten, Cloph, Miklos, Aron, Sophie, Xisco, Hossein, Kendy

* Completed Action Items:

* Pending Action Items:

* Release Engineering update (Cloph)
    + 7.4 status: rc1 in 1 week (still from libreoffice-7-4); UI and string freeze
    + 7.3 status: 7.3.5 rc1 this week
    + status of app store builds? (Caolan)
      + Microsoft: already in the store, but not searchable (Cloph)
      + Apple: they detected a conflict with LibreOffice Vanilla, Florian is on it (Cloph)

* Documentation (Olivier)
    + New Help
       + No news
    + Helpcontents2
       + Updates and fixes (S. Chaiklin, ohallot, M. Kaganski, R. Lima. G. Kelemen, buovjaga)
       + New pages for Scriptforge (A. Romedenne, R. Lima)
    + Guides
        + Work in progress

    + Bugzilla Documentation statistics
        241(241) bugs open
    + Updates:
        BZ changes   1 week    1 month   3 months   12 months
           created     16(-3)    44(-4)    123(0)      331(1)
         commented     11(-30)   80(-70)   309(6)     1494(-3)
          resolved      8(2)     15(1)      64(3)      208(4)
    + top 10 contributors:
          Seth Chaiklin made 43 changes in 1 month, and 316 changes in 1 year
          Olivier Hallot made 38 changes in 1 month, and 471 changes in 1 year
          Rathke, Eike made 11 changes in 1 month, and 32 changes in 1 year
          Heiko Tietze made 10 changes in 1 month, and 112 changes in 1 year
          Adolfo Jayme Barrientos made 9 changes in 1 month, and 25 changes in 1 year
          Kaganski, Mike made 7 changes in 1 month, and 97 changes in 1 year
          Timur made 7 changes in 1 month, and 22 changes in 1 year
          Németh, László made 6 changes in 1 month, and 12 changes in 1 year
          Peter Toye made 5 changes in 1 month, and 5 changes in 1 year
          Dan Dascalescu made 4 changes in 1 month, and 7 changes in 1 year

* UX Update (Heiko)
    + Bugzilla (topicUI) statistics
        273(273) (topicUI) bugs open, 58(58) (needsUXEval) needs to be evaluated by the UXteam
    + Updates:
        BZ changes   1 week    1 month    3 months   12 months
             added      2(-2)      4(-3)     22(-3)      46(-6)
         commented     16(-26)   117(-88)   606(-38)   2361(-86)
           removed      2(2)       2(2)      11(1)       34(2)
          resolved      4(-2)     23(-6)     77(1)      337(-3)
    + top 10 contributors:
          Heiko Tietze made 83 changes in 1 month, and 1660 changes in 1 year
          Rafael Lima made 23 changes in 1 month, and 91 changes in 1 year
          Roman Kuznetsov made 20 changes in 1 month, and 208 changes in 1 year
          Seth Chaiklin made 18 changes in 1 month, and 184 changes in 1 year
          Timur made 17 changes in 1 month, and 37 changes in 1 year
          Eyal Rozenberg made 11 changes in 1 month, and 84 changes in 1 year
          Hossein made 10 changes in 1 month, and 29 changes in 1 year
          Dieter made 7 changes in 1 month, and 211 changes in 1 year
          Enhua Xu made 6 changes in 1 month, and 6 changes in 1 year
          Shinji Enoki made 6 changes in 1 month, and 8 changes in 1 year

    + [Bug 149781] Spanish translation is missing in some strings in the
           Language Configuration Options
    + [Bug 149678] Pictures in writer: ignores height changes and proportional settings
    + [Bug 149763] Lots of Spaces get suppressed, when a Paragraph mark is added
           after this Sample
    + [Bug 149764] user-defined rows by columns (RxC, 2RxC/2, 4RxC/4, 8RxC/8, 16CxC/16)
 -> + [Bug 149701] New Feature: Print Preview In Sidebar
      + needsDevAdvice for feasability (sounds like a serious impact on performance)

* Crash Testing (Caolan)
    + 103(-45) import failure, 51(-11) export failures
      + already have additional fixes, to be visible in the next round
    + 6 coverity issues
    + 7 ossfuzz issues
      1 crash

* Crash Reporting (Xisco)
   + https://crashreport.libreoffice.org/stats/version/7.2.7.2
         + (+74) 484 410 396 382 314 268 167 0
   + https://crashreport.libreoffice.org/stats/version/7.3.3.2
         + (-22) 1041 1063 1438 1797 1583 1417 1055 555 0
   + https://crashreport.libreoffice.org/stats/version/7.3.4.2
         + (+165) 1128 963 675 0
   + numbers look good, nothing specific to report

* Mentoring/EasyHack update (Hossein)
          committer...   1 week      1 month     3 months     12 months
                  open      54(-10)     126(-7)     135(0)        135(0)
               reviews     348(-50)    1156(-86)   2856(-112)   12622(-18)
                merged     307(-119)   1381(-12)   3823(3)      15650(-27)
             abandoned      17(12)       42(-10)    161(-37)      810(1)
           own commits     181(-98)     931(-46)   2844(-38)    12301(-42)
        review commits      70(-14)     249(21)     589(16)      3562(-4)
        contributor...   1 week      1 month     3 months     12 months
                  open      43(11)       98(2)      111(9)        112(10)
               reviews     850(-146)   3150(-44)   8304(-138)   34226(-34)
                merged      21(5)        49(6)      130(11)      1286(-24)
             abandoned       9(4)        22(-14)     98(-85)      461(5)
           own commits      24(12)       59(9)      136(13)      1303(-10)
        review commits       0(0)         0(0)        0(0)          0(0)
    + easyHack statistics:
       needsDevEval 8(8)   needsUXEval 1(1)   cleanup_comments 307(307)
       total 364(364)   assigned 14(14)   open 322(322)
    + top 10 contributors:
          Srebotnjak, Martin made 8 patches in 1 month, and 22 patches in 1 year
          Paris Oplopoios made 8 patches in 1 month, and 19 patches in 1 year
          Nagy Tibor made 4 patches in 1 month, and 33 patches in 1 year
          Attila Szűcs made 4 patches in 1 month, and 16 patches in 1 year
          Goncharuk, Lera made 2 patches in 1 month, and 5 patches in 1 year
          Attila Bakos made 2 patches in 1 month, and 34 patches in 1 year
          Siddhant Chaudhary made 2 patches in 1 month, and 5 patches in 1 year
          Lukas Molleman made 2 patches in 1 month, and 2 patches in 1 year
          Dietrich Schulten made 2 patches in 1 month, and 2 patches in 1 year
          Nathan Teodosio made 2 patches in 1 month, and 2 patches in 1 year
    + top 10 reviewers:
          Xisco Fauli made 118 review comments in 1 month, and 936 in 1 year
          Adolfo Jayme Barrientos made 116 review comments in 1 month, and 1032 in 1 year
          Thorsten Behrens made 110 review comments in 1 month, and 854 in 1 year
          McNamara, Caolán made 76 review comments in 1 month, and 576 in 1 year
          Michael Stahl made 76 review comments in 1 month, and 1238 in 1 year
          Nabet, Julien made 64 review comments in 1 month, and 656 in 1 year
          Vajna, Miklos made 48 review comments in 1 month, and 600 in 1 year
          Vajngerl, Tomaž made 44 review comments in 1 month, and 446 in 1 year
          Hossein made 42 review comments in 1 month, and 246 in 1 year
          Kaganski, Mike made 40 review comments in 1 month, and 670 in 1 year
    + Patches automatically abandoned:
        tdf#143574: sw: move UItest to CppUnittest ( Xisco Fauli )
            - https://gerrit.libreoffice.org/#/c/125808
        tdf#145630 converted some atan() to atan2() ( Pesi Taototo )
            - https://gerrit.libreoffice.org/#/c/126498
        tdf#134589 Correct the time format of OOXML to UTC ( Lai Verne )
            - https://gerrit.libreoffice.org/#/c/127989
        tdf#145630 Change atan to atan2 where appropiate ( Tushar Jham )
            - https://gerrit.libreoffice.org/#/c/131038
        tdf#146619 Cleanup numitem.cxx ( Hossein )
            - https://gerrit.libreoffice.org/#/c/131571
        bin/upload_symbols.py: make pythonic ( Lukas Molleman )
            - https://gerrit.libreoffice.org/#/c/133333
        bin/upload_symbols.py: make pythonic ( Lukas Molleman )
            - https://gerrit.libreoffice.org/#/c/133354
        [WIP] SVX, editeng: fix writing mode ( Attila Bakos )
            - https://gerrit.libreoffice.org/#/c/133446
    + big CONGRATULATIONS to contributors who have at least 1 merged patch, since last report:
          Parsa Saei
          Amir H
          Mahdyar M. M. Sadeghi
          Mahkame Arabgari
          Nathan Teodosio (Canonical)

+ Hackfest took place at Amirkabir University of Technology
  * First part - building LibO, 16 people (previous week, June 22)
  * Second part - submitting code, 8 submissions (this week, June 25)
  * Good experience, will continue with virtual sessions

* GSoC (Ilmari)
    + Timeline: https://developers.google.com/open-source/gsoc/timeline
    + Mid-term evaluation will be on 25th July

* Commit Access

* Developer Certification (Stephan/Kendy/Thorsten/László)
  + resting since: 24 weeks (limit: 20 weeks)

* Jenkins / CI update (Cloph)
  + Jenkins decided to stop talking to us, restarting, no stats yet
  + apart from today, it was a good week
  + the Jenkins server dropped all the clients, will fix
    + updating at the same time

* l10n (Sophie)
  * team is working hard to catch the deadline

* What’s cooking (Miklos)
  + 16k cols in Calc (Lubos): https://bugs.documentfoundation.org/show_bug.cgi?id=133764
  + feature/chartdatatable: MSO-style data tables for charts (Tomaz): see initial commits in master
    + currently upstreaming in master, happy to hear feedback once everything is upstreamed


* Under-loved areas voting result (Miklos)
  + ranking from the sheet (from most preferred to least preferred):
    + RTL/CTL
    + macOS support
    + CJK
    + Complete Firebird Support to make embedded Firebird the functional equivalent of embedded hsqldb
    + Complete auto migration of existing hsqldb databases to Firebird
    + Accessibility: Document Level Accessibility
    + Accessibility: Widget Level Accessibility
    + Accessibility: File Format Support
    + The whole reports part is dependent on a set of old Java (Pentaho Reporting/JFreeReport) external components
    + Command Make Screenshots to get screenshots at build time (for all languages) is currently broken
    + Accessibility: UIA support on Windows
    + XForms support
    + Writer/Web
    + next step? (Miklos)
AI:   + will take it to the board (Thorsten)
      + should we remove the individual ranks? (Kendy)
        + last time the entire sheet was given (Thorsten)
        + is anybody against having their name visible? (Kendy)
          + not published, but giving visibility to the board (Thorsten)
          => no objections

* QA update (Xisco)
    + UNCONFIRMED: 1692 (-5)
        + enhancements: 277  (-2)
        + needsUXEval: 0 (-3)
        + haveBackTrace: 6 (+0)
        + needsDevAdvice: 29 (-1)
        + documentation:  21 (+0)
        + android:  3 (+0)
        + iOS:  0 (+0)
        + Online:  12 (+0)

    + Most pressing bugs:
     New:
        None
     Old:
        + macOS: Can't save or open files using Finder dialog on Standard accounts on macOS 10.15 Catalina
           + https://bugs.documentfoundation.org/show_bug.cgi?id=128233
           + started to happen with a new macOS version
           + somebody has to do the work to keep up with the new Apple requirements
             + sometimes this works, sometimes not (Stephan)
           + had another look, can't reproduce (Cloph)
             + don't think it's a generic problem
             + think even if the langpack design is not elegant, it's fine

    + New high severity bugs of the week:
        + Systematic crash on resize of database table creation window
            + https://bugs.documentfoundation.org/show_bug.cgi?id=149717
            + needs confirming
            + maybe will lower the priority/severity

        + CRASH: importing spreadsheet
            + https://bugs.documentfoundation.org/show_bug.cgi?id=149752
            + already fixed, thanks Lubos

* QA stats
    + https://bugs.documentfoundation.org/page.cgi?id=weekly-bug-summary.html
      +96  -2 (-134) overall)
      many thanks to the top bug squashers:
       QA Administrators       36
       Justin L                9
       Xisco Faulí             9
       László Németh           5
       Olivier Hallot          5
       Heiko Tietze            4
       Julien Nabet            4
       Noel Grandin            4
       Adolfo Jayme Barrientos 3
       Buovjaga                3

    + top 10 bugs reporters:
       NISZ LibreOffice Team   10
       Gabor Kelemen (allotropia) 5
       Xisco Faulí             5
       Mike Kaganski           4
       Ainhoa                  2
       Alex Thurgood           2
       Jambunathan K           2
       Rafael Lima             2
       Robert                  2
       enhua_2008              2

    + top 10 bugs fixers:
       Németh, László          5
       Olivier Hallot          5
       Grandin, Noel           4
       Adolfo Jayme Barrientos 3
       Attila Szűcs            3
       McNamara, Caolán        3
       NISZ LibreOffice Team   3
       Nagy Tibor              3
       Vajna, Miklos           3
       Hung, Mark              2

    + top 10 bugs confirmers:
       Xisco Fauli             12
       NISZ LibreOffice Team   10
       Dieter                  6
       Rafael Lima             6
       Heiko Tietze            4
       Ilmari Lauhakangas      4
       Nabet, Julien           4
       Raal                    4
       *UNKNOWN*               3
       Le Grand, Armin         3


* Highest-Priority bugs (aka "MABs"):
   + http://bit.ly/2lJAAJI
     6.0 : 1/53 -     1 %  (+0)
     5.4 : 0/41 -     0 %  (+0)
     5.3 : 0/54 -     0 %  (+0)
     5.2 : 0/43 -     0 %  (+0)
     5.1 : 1/36 -     2 %  (+0)
     5.0 : 0/64 -     0 %  (+0)
     4.4 : 0/76 -     0 %  (+0)
     4.3 : 0/73 -     0 %  (+0)
     4.2 : 2/134 -    1 %  (+0)
     4.1 : 3/85 -     3 %  (+0)
     4.0 : 2/83 -     2 %  (+0)
     old : 1/246 -    0 %  (+0)


* Bisected bugs open: keyword 'bisected'
   + more accurate - down to a single commit.
   + http://bit.ly/2dyIfDy
   +

     done by:
        Raal                   4
        Xisco Fauli            4
        Aron Budea             1


* Bibisected bugs open: keyword 'bibisected'
   + http://bit.ly/2cSCXlS
   +

     done by:
        Raal                   4
        Xisco Fauli            4
        Aron Budea             1


* all bugs tagged with 'regression'
   + 1228(+1) bugs open of 11863(+16) total 11(+0) high prio.

     done by:
        Xisco Fauli            5
        Alex Thurgood          3
        Raal                   2
        Aron Budea             1
        Rafael Lima            1
        sclewell               1


* ~Component   count net * high severity regressions
   + http://bit.ly/1HWHb3E
     Writer        - 6(+0)
     LibreOffice   - 2(+0)
     Calc          - 1(+0)
     Draw          - 1(+0)
     Impress       - 1(+0)

   by OS:
     All           - 9(+0)
     Linux         - 0(+0)
     Mac OS X      - 0(+0)
     Windows       - 2(+0)


* ~Component   count net * all regressions
   + http://bit.ly/1BUdI8i
     Writer: other            - 451(+1)
     Calc                     - 191(-4)
     Impress                  - 123(+2)
     Crashes                  - 65(+4)
     Writer: docx filter      - 59(+0)
     LibreOffice              - 50(+1)
     UI                       - 45(+0)
     Draw                     - 44(+0)
     Writer: perf             - 37(+0)
     Borders                  - 35(+0)
     Writer: other filter     - 35(+0)
     Base                     - 32(-1)
     RTL                      - 25(+0)
     Chart                    - 24(-1)
     Writer: doc filter       - 21(+0)
     Printing and PDF export  - 19(+0)
     BASIC                    - 18(+1)
     graphics stack           - 16(+1)
     filters and storage      - 15(+0)
     framework                - 3(+0)
     Formula Editor           - 2(+0)
     Linguistic               - 1(+0)
     sdk                      - 1(+0)