ESC meeting minutes: 2023-05-04

* Present:
     + Cloph, Olivier, Eike, Florian, Heiko, Hossein, Ilmari, Michael S, Stephan, Miklos, Xisco, Stephane, Thorsten, Gabriel

* Completed Action Items:

* Pending Action Items:

* Release Engineering update (Cloph)
     + 7.6 status: alpha 1 in 1 week, from master
       + feature freeze in 5 weeks
     + 7.5 status: 7.5.3 was announced as final earlier today
       + 7.5.4 rc1 in 2 weeks
     + 7.4 status: 7.4.7 rc2 was tagged yesterday

* Documentation (Olivier)
     + Helpcontent2
        + fixes and updates (S. Chaiklin, ohallot)
     + Guides
        + Work in progress.

     + Bugzilla Documentation statistics
         264(264) bugs open
     + Updates:
         BZ changes 1 week 1 month 3 months 12 months
            created 14(6) 43(0) 119(0) 309(-1)
          commented 16(11) 105(11) 336(5) 1107(-11)
           resolved 4(3) 13(-2) 57(1) 177(1)
     + top 10 contributors:
           Olivier Hallot made 49 changes in 1 month, and 488 changes in 1 year
           Seth Chaiklin made 49 changes in 1 month, and 441 changes in 1 year
           Stéphane Guillou made 36 changes in 1 month, and 194 changes in 1 year
           Ilmari Lauhakangas made 27 changes in 1 month, and 110 changes in 1 year
           Bogdan B made 26 changes in 1 month, and 220 changes in 1 year
           Heiko Tietze made 21 changes in 1 month, and 124 changes in 1 year
           Eyal Rozenberg made 6 changes in 1 month, and 11 changes in 1 year
           Don Matschull made 5 changes in 1 month, and 5 changes in 1 year
           Rafael Lima made 5 changes in 1 month, and 120 changes in 1 year
           Rathke, Eike made 4 changes in 1 month, and 17 changes in 1 year

* UX Update (Heiko)
     + Bugzilla (topicUI) statistics
         275(275) (topicUI) bugs open, 100(100) (needsUXEval) needs to be evaluated by the UXteam
     + Updates:
         BZ changes 1 week 1 month 3 months 12 months
              added 7(-3) 27(1) 52(2) 83(1)
          commented 83(7) 353(22) 803(41) 2305(-14)
            removed 1(0) 4(0) 9(0) 25(-1)
           resolved 7(-7) 31(3) 90(1) 286(0)
     + top 10 contributors:
           Heiko Tietze made 202 changes in 1 month, and 1408 changes in 1 year
           Stéphane Guillou made 79 changes in 1 month, and 263 changes in 1 year
           Vernon, Stuart Foote made 68 changes in 1 month, and 334 changes in 1 year
           Ilmari Lauhakangas made 57 changes in 1 month, and 223 changes in 1 year
           Dieter made 29 changes in 1 month, and 215 changes in 1 year
           Eyal Rozenberg made 29 changes in 1 month, and 270 changes in 1 year
           Rafael Lima made 28 changes in 1 month, and 291 changes in 1 year
           Bogdan B made 24 changes in 1 month, and 54 changes in 1 year
           Seth Chaiklin made 20 changes in 1 month, and 124 changes in 1 year
           m.a.riosv made 19 changes in 1 month, and 68 changes in 1 year
     + [Bug 155131] Differentiate between lines in LO Base table editor and viewer
            with alternating shades.
     + [Bug 155050] Confusion between "bibliography entry" and "citation"
     + [Bug 154917] Add Random Number Generator to the Tabbed UI
     + [Bug 155065] Change label of .uno:InsertPageNumberField to "Page Number Field"
            (from "Page Number")
     + [Bug 101876] UI: resizing function wizard only resize the formula field,
            not the structure and parameter fields width
     + [Bug 154715] "Edit Fields" for cross-reference fields should open on the type,
            format, and selection of the inserted field
     + [Bug 141296] Find & Replace: Checkmark "Current selection only" automatically
            unset after repeating "find" (or "find/ replace") despite that area is
            still marked

* Crash Testing (Caolan)
     + 165(+71) import failure, 129(+111) export failures
       - mostly a issue now solved by lazlo
       - fixes have been added for some other cases and
         some of the older ones have disappeared, so looking
         like its going in the right direction
     + 0 coverity issues
     + 4 ossfuzz issues, no crashes
       - new fodt->pdf export fuzzer (two issues so far) but
         only super short (2k) documents for now

* Crash Reporting (Xisco)
    + https://crashreport.libreoffice.org/stats/version/7.4.6.2
          + (+3) 679 676 683 513 392 371 241 0
    + https://crashreport.libreoffice.org/stats/version/7.5.1.2
          + (-181) 695 876 980 1160 1400 1241 854 546 0
    + https://crashreport.libreoffice.org/stats/version/7.5.2.2
          + (-92) 1070 1162 950 527 0
    + looking forward to see the results from the new 7.5.3 release

* ESC tender project proposal process (Thorsten & Florian)
   + Italo & Mike is working on the blog post (as discussed last week)
   + expect a draft tomorrow, to be published next week
   + any more feedback? (Thorsten)
     + end of the week is the deadline for the feedback
     + Michael M's feedback: https://www.mail-archive.com/libreoffice@lists.freedesktop.org/msg322227.html
     + Stephan's feedback: https://lists.freedesktop.org/archives/libreoffice/2023-April/090286.html
     + interested in giving some feedback if can find the time (Eike)

* Mentoring (Hossein)
           committer... 1 week 1 month 3 months 12 months
                   open 85(-103) 198(-38) 220(-46) 227(-44)
                reviews 466(24) 1340(196) 3616(40) 11842(58)
                 merged 287(-17) 1180(84) 3769(-32) 14681(-18)
              abandoned 12(-1) 61(-3) 197(-3) 710(-4)
            own commits 182(-2) 805(26) 2611(-41) 10591(-68)
         review commits 63(7) 238(31) 847(19) 2940(23)
         contributor... 1 week 1 month 3 months 12 months
                   open 25(-5) 55(3) 233(3) 240(3)
                reviews 744(-128) 2752(78) 8344(-154) 31104(-128)
                 merged 13(-3) 57(4) 189(4) 729(2)
              abandoned 3(-6) 29(2) 83(-12) 496(-3)
            own commits 23(-3) 93(9) 341(8) 985(17)
         review commits 0(0) 0(0) 0(0) 0(0)
     + easyHack statistics:
        needsDevEval 8(8) needsUXEval 1(1) cleanup_comments 324(324)
        total 391(391) assigned 28(28) open 336(336)
     + top 10 contributors:
           Armin Le Grand (allotropia) made 8 patches in 1 month, and 60 patches in 1 year
           Stéphane Guillou made 7 patches in 1 month, and 15 patches in 1 year
           Baole Fang made 5 patches in 1 month, and 13 patches in 1 year
           Czeber László made 4 patches in 1 month, and 7 patches in 1 year
           Vojtěch Doležal made 3 patches in 1 month, and 9 patches in 1 year
           Bayram Çiçek made 2 patches in 1 month, and 4 patches in 1 year
           Marco Pinto made 2 patches in 1 month, and 6 patches in 1 year
           Bogdan B made 2 patches in 1 month, and 91 patches in 1 year
           Vert D. made 1 patches in 1 month, and 1 patches in 1 year
           Radhey Parekh made 1 patches in 1 month, and 8 patches in 1 year
     + top 10 reviewers:
           Xisco Fauli made 122 review comments in 1 month, and 836 in 1 year
           McNamara, Caolán made 120 review comments in 1 month, and 1190 in 1 year
           Michael Stahl made 96 review comments in 1 month, and 1046 in 1 year
           Adolfo Jayme Barrientos made 86 review comments in 1 month, and 1030 in 1 year
           Nabet, Julien made 84 review comments in 1 month, and 854 in 1 year
           Vajna, Miklos made 84 review comments in 1 month, and 728 in 1 year
           Grandin, Noel made 70 review comments in 1 month, and 528 in 1 year
           Thorsten Behrens made 68 review comments in 1 month, and 526 in 1 year
           Heiko Tietze made 60 review comments in 1 month, and 298 in 1 year
           Ilmari Lauhakangas made 60 review comments in 1 month, and 316 in 1 year
     + Patches automatically abandoned:
         python3: upgrade to release 3.11.1 ( Taichi Haradaguchi )
             - https://gerrit.libreoffice.org/#/c/145054

         WASM: headless conversion without QT5 and with unique html ( Balazs Varga )
             - https://gerrit.libreoffice.org/#/c/145564

* New EasyHacks (Hossein)
   * tdf#117651 - AutoCorrect does not change preexisting text inside /slashes/ to italics, nor change -strikethrough
     https://bugs.documentfoundation.org/show_bug.cgi?id=117651
   * tdf#154088 - The implementation of drawing the grid of the characters should be unified
     https://bugs.documentfoundation.org/show_bug.cgi?id=154088
   * tdf#154018 - UI string: points vs. corners of polyline
     https://bugs.documentfoundation.org/show_bug.cgi?id=154018

* GSoC (Ilmari)
   + projects announced today 18:00 UTC+0 (in 4 hours)
   + community bonding until 28 May
   + coding can start even during bonding period, if needed/wanted

* Commit Access

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

* Jenkins / CI update (Cloph)
gerrit_android_aarch64 jobs: 212 ok: 195 ko: 10 fail ratio: 4.72% mean_ok: 10 ( 15) median_ok: 8 ( 12)
gerrit_android_arm jobs: 213 ok: 186 ko: 19 fail ratio: 8.92% mean_ok: 10 ( 14) median_ok: 8 ( 11)
gerrit_android_x86 jobs: 214 ok: 194 ko: 13 fail ratio: 6.07% mean_ok: 11 ( 15) median_ok: 8 ( 12)
gerrit_android_x86_64 jobs: 210 ok: 186 ko: 16 fail ratio: 7.62% mean_ok: 10 ( 14) median_ok: 7 ( 12)
gerrit_linux_clang_dbgutil jobs: 478 ok: 277 ko: 164 fail ratio: 34.31% mean_ok: 46 ( 52) median_ok: 45 ( 50)
gerrit_linux_gcc_release jobs: 424 ok: 317 ko: 90 fail ratio: 21.23% mean_ok: 23 ( 24) median_ok: 21 ( 21)
gerrit_mac jobs: 441 ok: 305 ko: 111 fail ratio: 25.17% mean_ok: 41 ( 46) median_ok: 39 ( 42)
gerrit_windows jobs: 458 ok: 286 ko: 115 fail ratio: 25.11% mean_ok: 74 (102) median_ok: 65 ( 92)
gerrit_master jobs: 460 ok: 222 ko: 175 fail ratio: 38.04% mean_ok: 98 ( 98) median_ok: 91 ( 91)
    + https://dev-www.libreoffice.org/tmp/gerrit_230504.html
    + tests that failed more than twice in last seven days
       3 CppunitTest_sc_ucalc_sort gerrit_linux_gcc_release
       3 CppunitTest_sw_uiwriter3 gerrit_linux_clang_dbgutil
       3 CppunitTest_sw_uwriter gerrit_linux_gcc_release
       4 CppunitTest_svx_unit gerrit_windows
       4 CppunitTest_sw_ooxmlexport17 gerrit_mac
       4 CppunitTest_sw_uiwriter4 gerrit_windows
       7 CppunitTest_framework_dispatch gerrit_windows
       7 CppunitTest_sw_uiwriter4 gerrit_linux_clang_dbgutil
      20 Killed by the kill-wrapper gerrit_mac
   + nothing unusual (Cloph)
     + couple of tests stand out more (compared to last week), but are not new

* What’s cooking (Miklos)
   + Multi-page floating tables in Writer (Miklos)
     + working on bugs, see tdf#155118 for details
   + multi-color gradients (Armin)
     + ooxml import/export has landed and is active as of today
     + first cut ODF support, too (kudos also to Regina!)

* LibreOffice conference Bucharest 2023 (Gabriel)
   + the document with the workshop, shared with the university, it's being discussed

* QA update (Xisco)
     + UNCONFIRMED: 1131 (+13)
         + enhancements: 290 (-11)
         + needsUXEval: 13 (+0)
         + haveBackTrace: 7 (+1)
         + needsDevAdvice: 32 (+1)
         + documentation: 4 (+1)
         + android: 3 (+0)
         + iOS: 0 (+0)
         + Online: 12 (+0)

     + Most pressing bugs:
      New: tdf#154337 - xforms kinda fundamentally broken, but only for local files?
           (Thorsten)
           - https://bugs.documentfoundation.org/show_bug.cgi?id=154337
           + is file:// URLs used by real-world users? or just for testing? (Michael S)
             + don't know (Xisco)
      Old:
      Fixed:

     + New high severity bugs of the week:

         None

* QA stats (Stéphane)
     + "Make "Run Graphics Tests" feature experimental": https://bugs.documentfoundation.org/show_bug.cgi?id=155069
       + UI is a bit poor (Stephane)
       + need input from Tomaz, CC'd now (Miklos)
     + New daily reports chart in dashboard: https://stragu.shinyapps.io/lo_qa_dashboard/
     + Recent focus areas:

       + document themes: https://bugs.documentfoundation.org/show_bug.cgi?id=107331

       + document signing/encrypting: https://bugs.documentfoundation.org/show_bug.cgi?id=105605

       + Calc named cell ranges: https://bugs.documentfoundation.org/show_bug.cgi?id=109178

     + https://bugs.documentfoundation.org/page.cgi?id=weekly-bug-summary.html
       +110 +13 (-113) overall)
       many thanks to the top bug squashers:
        Stéphane Guillou (stragu) 23
        Mike Kaganski 11
        QA Administrators 10
        Tibor Nagy (NISZ) 6
        Dieter 5
        Heiko Tietze 5
        m.a.riosv 5
        Roman Kuznetsov 4
        Buovjaga 3
        Eike Rathke 3

     + top 10 bugs reporters:
        Mike Kaganski 5
        Robert Großkopf 5
        Gabor Kelemen (allotropia) 4
        Regina Henschel 4
        Stéphane Guillou (stragu) 4
        Hossein 3
        Roman Kuznetsov 3
        Eyal Rozenberg 2
        Telesto 2
        Xisco Faulí 2

     + top 10 bugs fixers:
        Kaganski, Mike 5
        Stéphane Guillou 5
        Heiko Tietze 3
        Nagy Tibor 3
        Olivier Hallot 3
        Rathke, Eike 3
        Seth Chaiklin 3
                                2
        Czeber László 2
        Hossein 2

     + top 10 bugs confirmers:
        Stéphane Guillou 33
        Heiko Tietze 5
        *UNKNOWN* 4
        Xisco Fauli 4
        m.a.riosv 4
        Ilmari Lauhakangas 3
        Kaganski, Mike 3
        Nabet, Julien 3
        Telesto 3
        Dieter 2

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

      done by:
         Xisco Fauli 3
         Raal 2
         Stéphane Guillou 2
         Timur 1

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

      done by:
         Xisco Fauli 3
         Raal 2
         Stéphane Guillou 2
         ady 1
         Stefan_Lange_KA@T-Online.de 1
         Timur 1

* all bugs tagged with 'regression'
    + 1238(-7) bugs open of 12526(+10) total 14(+0) high prio.

      done by:
         Xisco Fauli 3
         Roman Kuznetsov 1
         Kaganski, Mike 1
         Robert Großkopf 1
         Stéphane Guillou 1
         Timur 1

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

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

* ~Component count net * all regressions
    + http://bit.ly/1BUdI8i
      Writer: other - 441(+0)
      Calc - 221(-5)
      Impress - 133(+0)
      LibreOffice - 52(+0)
      Crashes - 51(-1)
      Writer: docx filter - 49(-1)
      Draw - 48(-1)
      Base - 43(+0)
      UI - 37(+0)
      Writer: perf - 34(+0)
      Borders - 33(+1)
      Writer: other filter - 30(+0)
      Chart - 26(+0)
      Printing and PDF export - 23(+0)
      RTL - 23(+0)
      Writer: doc filter - 20(+0)
      BASIC - 18(+0)
      filters and storage - 15(+0)
      graphics stack - 12(+0)
      Formula Editor - 3(+0)
      Extensions - 2(+0)
      sdk - 2(+0)
      Linguistic - 1(+0)
      framework - 1(+0)