ESC meeting minutes: 2023-07-20

* Present:
     + Heiko, Michael W., Regina, Stephan, Olivier, Cloph, Hossein, Thorsten, Gabriel,
       Eike, Stephane, Michael S

* Completed Action Items:
   + Create the https://wiki.documentfoundation.org/ReleaseNotes/24.2 page (Ilmari)
   + Create the https://wiki.documentfoundation.org/Development/Budget2024 page (Ilmari)

* Pending Action Items:

* Release Engineering update (Cloph)
     + 7.6 status: rc2 in 1 week
       + 1 review on libreoffice-7-6 is needed
       + late feature request (Thorsten):
         Impress text edit improvement: https://gerrit.libreoffice.org/c/core/+/154640
         Drag threshold improvement: https://gerrit.libreoffice.org/c/core/+/154379
           + Both effect how to interact with text quickly in Impress
             + don't introduce new strings
             + do change configuration
         + no concerns from Heiko about the first patch at least
             + but really necessary in 7.6? not well tested
             + fair statement (Thorsten)
               + but gets us closer on par with Powerpoint
               + available to fix things on short notice
         + strictly UI-related (Cloph)
         + lets push to 7.6 and see if there'll be an issue with RC2 (Heiko)
             + will do that (Thorsten)

         + https://gerrit.libreoffice.org/c/core/+/154642 (Thorsten)

         + involves a single string change
             + should be OK to make an exception (Cloph)
               + please ping Olivier,Sophi about it

            + will do that (Thorsten)

     + 7.5 status: 7.5.5 released today
        + approved in Mac app store, soon in MS store (already approved)
     + status of bumping Linux baseline to AlmaLinux 8 on master
        + successful Clang build
        + some GCC issues
        + bump directly to AlmaLinux 9?
           + GTK 4 as part of the distro then, => --enable-gtk4
             + otherwise needs to see how to enable that locally for
               AlmaLinux 8
           + Kernel 5.4 instead of 4.x, so would affect more users
        + better stick to 8 for now (Thorsten)
        + latest DevTools is 12, use that or any earlier one
           + any reason not to pick the latest one? (Stephan)
              + not really (Cloph)
        + requirements for Qt6? (Heiko)
           + not in 8, not sure if it's in 9 (Cloph)
           + would be nice to have --enable-kf6 enabled by default (Heiko)
           + depends on how much work it is to make it compile on AlmaLinux 8 or 9
     + tl;dr: continue work to make AlmaLinux 8 the new baseline

* Documentation (Olivier)
     + Helpcontents2
        + updates and review of UNO command in menus help pages (ohallot)
        + Fixes and updates (R. Lima, S. Chaiklin, stragu)
        + new pages/updates for ScriptForge (R. Lima)
        + Update on Frame help pages (vmiklos)
     + Guides
        + published Getting Started Guides 7.5 (ohallot)

     + Bugzilla Documentation statistics
         275(275) bugs open
     + Updates:
         BZ changes 1 week 1 month 3 months 12 months
            created 11(5) 31(-1) 74(-2) 298(3)
          commented 16(8) 53(-15) 171(-11) 997(-6)
           resolved 1(0) 3(-3) 26(-1) 161(1)
     + top 10 contributors:
           Stéphane Guillou made 57 changes in 1 month, and 280 changes in 1 year
           Seth Chaiklin made 14 changes in 1 month, and 307 changes in 1 year
           Olivier Hallot made 13 changes in 1 month, and 472 changes in 1 year
           Rafael Lima made 9 changes in 1 month, and 114 changes in 1 year
           Monastirsky, Maxim made 8 changes in 1 month, and 12 changes in 1 year
           Kaganski, Mike made 7 changes in 1 month, and 96 changes in 1 year
           Nabet, Julien made 6 changes in 1 month, and 23 changes in 1 year
           William Friedman made 4 changes in 1 month, and 4 changes in 1 year
           Leroy made 3 changes in 1 month, and 3 changes in 1 year
           Alex Thurgood made 3 changes in 1 month, and 6 changes in 1 year

* UX Update (Heiko)
     + Bugzilla (topicUI) statistics
         268(268) (topicUI) bugs open, 64(64) (needsUXEval) needs to be evaluated by the UXteam
     + Updates:
         BZ changes 1 week 1 month 3 months 12 months
              added 9(0) 17(-4) 31(-2) 60(-3)
          commented 78(-11) 197(-47) 698(-130) 2433(-44)
            removed 1(1) 3(2) 10(2) 30(2)
           resolved 8(-2) 24(-5) 104(-3) 321(4)
     + top 10 contributors:
           Heiko Tietze made 111 changes in 1 month, and 1490 changes in 1 year
           Stéphane Guillou made 54 changes in 1 month, and 411 changes in 1 year
           Vernon, Stuart Foote made 42 changes in 1 month, and 415 changes in 1 year
           ady made 40 changes in 1 month, and 84 changes in 1 year
           Justin Luth made 26 changes in 1 month, and 93 changes in 1 year
           Ilmari Lauhakangas made 21 changes in 1 month, and 225 changes in 1 year
           Eyal Rozenberg made 20 changes in 1 month, and 274 changes in 1 year
           Kaganski, Mike made 13 changes in 1 month, and 133 changes in 1 year
           Myndex made 12 changes in 1 month, and 12 changes in 1 year
           Weghorn, Michael made 8 changes in 1 month, and 15 changes in 1 year
     + [Bug 156337] PDF export security tab is disabled and does not tell what is wrong
     + [Bug 145646] While selecting from the dropdown of data validation using keyboard,
            different one gets entered on pressing return
     + [Bug 155414] macOS's "Accessibility > Display > Reduce Motion" setting doesn't
            stop "Marching Ants"
     + [Bug 156369] Tripple-Clicking causes jumping to the end of paragraph.
     + [Bug 156374] Make Hanging Indent command create a hanging indent, when used on
            a paragraph without one
     + [Bug 156357] Cannot copy formula by copying cell when displaying with
            Show Formula
     + [Bug 113687] Wrong cell attributes assumed
     + [Bug 156345] desired new function: select range (of pages) in a document
     + [Bug 156311] Cycle directly from the last to first sheet in a calc file
     + [Bug 156305] Allow to invert selection in Autofilter
     + [Bug 156299] Icon inconsistencies: menu Insert shape and Sidebar Shapes deck

* Crash Testing (Caolan)
     + 26(+0) import failure, 0(+0) export failures
     + ??? coverity issues
     + Google / ossfuzz: ?? fuzzers active now

* Crash Reporting (Xisco)
     + 7.5.1.2 24389(+572)
     + 7.5.2.2 17612(+561)
     + 7.5.3.2 16012(+1028)
     + 7.5.4.2 7349(+1685)

* Mentoring (Hossein)
+ New EasyHack suggested by Stéphane
  + tdf#145081 - Line spacing style type "Fixed" is exposed on the property side bar but not on the style sheet dialog
   https://bugs.documentfoundation.org/show_bug.cgi?id=145081
  + Choose which adjacent column of a "double clicked" formula dictates the extent of the fill
    https://bugs.documentfoundation.org/show_bug.cgi?id=149356
+ Reviewed and merged a fix for a blogged EasyHack
  + ODF standard and the code – EasyHack on LibreOffice Dev Blog
https://dev.blog.documentfoundation.org/2022/08/16/odf-standard-and-the-code-easyhack/
    tdf#150302 - Toggle SameLetterHeights does not work if property not initialized
    https://bugs.documentfoundation.org/show_bug.cgi?id=150302
+ ~10 blogged EasyHacks
  + Most of them are done
           committer... 1 week 1 month 3 months 12 months
                   open 90(24) 141(28) 204(27) 216(25)
                reviews 360(22) 1130(-10) 3106(80) 10938(114)
                 merged 228(-41) 1213(-106) 3362(-22) 12609(67)
              abandoned 9(3) 39(-5) 139(-9) 630(-5)
            own commits 156(7) 708(-35) 2267(-63) 10316(33)
         review commits 50(5) 216(-4) 723(0) 3051(21)
         contributor... 1 week 1 month 3 months 12 months
                   open 31(-4) 48(-3) 229(-5) 238(-4)
                reviews 688(-68) 2876(-194) 8092(-146) 32062(76)
                 merged 25(-5) 81(12) 325(-27) 2736(-6)
              abandoned 1(-5) 14(0) 44(-12) 482(-19)
            own commits 21(2) 73(5) 237(5) 1035(14)
         review commits 0(0) 0(0) 0(0) 0(0)
     + easyHack statistics:
        needsDevEval 8(8) needsUXEval 1(1) cleanup_comments 331(331)
        total 403(403) assigned 32(32) open 344(344)
     + top 10 contributors:
           Dipam Turkar made 17 patches in 1 month, and 20 patches in 1 year
           Dr. David Alan Gilbert made 6 patches in 1 month, and 21 patches in 1 year
           Stéphane Guillou made 4 patches in 1 month, and 19 patches in 1 year
           Luigi Iucci made 4 patches in 1 month, and 6 patches in 1 year
           Armin Le Grand (allotropia) made 4 patches in 1 month, and 73 patches in 1 year
           Matt K made 3 patches in 1 month, and 5 patches in 1 year
           Ahmed Eltokhy made 3 patches in 1 month, and 6 patches in 1 year
           Juan C. Sanz made 2 patches in 1 month, and 6 patches in 1 year
           Baole Fang made 2 patches in 1 month, and 24 patches in 1 year
           Venetia Furtado made 2 patches in 1 month, and 3 patches in 1 year
     + top 10 reviewers:
           Caolán McNamara made 128 review comments in 1 month, and 210 in 1 year
           Nabet, Julien made 78 review comments in 1 month, and 956 in 1 year
           Michael Stahl made 72 review comments in 1 month, and 1084 in 1 year
           Vajngerl, Tomaž made 68 review comments in 1 month, and 472 in 1 year
           Kaganski, Mike made 64 review comments in 1 month, and 356 in 1 year
           Xisco Fauli made 54 review comments in 1 month, and 780 in 1 year
           Christian Lohmaier made 48 review comments in 1 month, and 396 in 1 year
           Weghorn, Michael made 40 review comments in 1 month, and 176 in 1 year
           Grandin, Noel made 38 review comments in 1 month, and 582 in 1 year
           Timar, Andras made 36 review comments in 1 month, and 414 in 1 year

* GSoC (Ilmari)
   + Phase 1 evaluations: July 10 - July 14 18:00 UTC
     + all looking good (Hossein, Thorsten)

* Commit Access

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

* Jenkins / CI update (Cloph)
gerrit_android_aarch64 jobs: 222 ok: 191 ko: 15 fail ratio: 6.76% mean_ok: 12 ( 34) median_ok: 8 ( 27)
gerrit_android_arm jobs: 221 ok: 184 ko: 14 fail ratio: 6.33% mean_ok: 12 ( 33) median_ok: 9 ( 26)
gerrit_android_x86 jobs: 225 ok: 186 ko: 20 fail ratio: 8.89% mean_ok: 12 ( 33) median_ok: 8 ( 24)
gerrit_android_x86_64 jobs: 223 ok: 188 ko: 12 fail ratio: 5.38% mean_ok: 12 ( 33) median_ok: 8 ( 23)
gerrit_linux_clang_dbgutil jobs: 443 ok: 309 ko: 83 fail ratio: 18.74% mean_ok: 52 ( 64) median_ok: 47 ( 60)
gerrit_linux_gcc_release jobs: 435 ok: 360 ko: 48 fail ratio: 11.03% mean_ok: 30 ( 35) median_ok: 24 ( 28)
gerrit_mac jobs: 482 ok: 308 ko: 135 fail ratio: 28.01% mean_ok: 48 ( 50) median_ok: 42 ( 43)
gerrit_windows jobs: 471 ok: 278 ko: 141 fail ratio: 29.94% mean_ok: 68 (104) median_ok: 63 ( 78)
gerrit_master jobs: 540 ok: 221 ko: 247 fail ratio: 45.74% mean_ok: 99 (100) median_ok: 82 ( 85)
    + tests that failed more than twice in last seven days
       3 CppunitTest_framework_dispatch gerrit_windows
       3 CppunitTest_sc_subsequent_export_test gerrit_windows
       3 CppunitTest_svgio gerrit_windows
       3 CppunitTest_sw_mailmerge gerrit_windows
       4 UITest_writer_macro_tests gerrit_linux_clang_dbgutil
       7 UITest_calc_tests8 gerrit_linux_clang_dbgutil
      10 Killed by the kill-wrapper gerrit_linux_clang_dbgutil
      18 Killed by the kill-wrapper gerrit_mac
      28 CppunitTest_starmath_qa_cppunit gerrit_windows (single bot)
      + bit rough week, bot issues (git checkout failures due to killed in unclean
        state)
        + an issue that only happens rarely
      + all CppunitTest_starmath_qa_cppunit on Windows were on a single bot

* What’s cooking (Miklos)
   + document themes (Tomaz)
   + tdf#155118 multi-page floating tables in Writer (Miklos)
   + WSL build (Cloph)
     + still hacky, but promising
     + not building within wsl, but rather from git-bash
       calling into wsl only when necessary
     + using strawberry perl (openssl wants perl that is using windows-paths, easier to
       install windows-perl than to hack that into the external build-system)
     + make instructions available? (Hossein)
       + will come later (Cloph)
     + how fast is it? (Hossein)
       + no usable numbers yet (Cloph)

* LibreOffice conference Bucharest 2023 (Gabriel)
     + CfP over, lots of proposals
     + don't forget to register!
     + workshop promotion
        + participants will get certificates
        + thanks to Olivier for a template

* QA update (Xisco)

     + UNCONFIRMED: 1188 (+18)
         + enhancements: 273 (+2)
         + needsUXEval: 7 (-9)
         + haveBackTrace: 11 (+0)
         + needsDevAdvice: 34 (+0)
         + documentation: 4 (-1)
         + android: 3 (+0)
         + iOS: 0 (+0)
         + Online: 12 (+0)

     + Most pressing bugs:
      New:
      Old:
      Fixed:

     + New high severity bugs of the week:
         + CRASH: inserting row and undoing
             + https://bugs.documentfoundation.org/show_bug.cgi?id=156268
             + Hossein already submitted a patch

* QA stats (Stéphane)
     + https://bugs.documentfoundation.org/page.cgi?id=weekly-bug-summary.html
       +123 -41 (-115) overall)
       many thanks to the top bug squashers:
        Stéphane Guillou (stragu) 20
        Justin L 19
        QA Administrators 11
        Heiko Tietze 7
        Xisco Faulí 5
        Michael Stahl (allotropia) 4
        Michael Weghorn 4
        Mike Kaganski 4
        m.a.riosv 4
        Eike Rathke 2

     + top 10 bugs reporters:
        Xisco Faulí 6
        Rafael Lima 5
        Regina Henschel 5
        sdc.blanco 4
        vicxp0518 4
        Gabor Kelemen (allotropia) 3
        Mike Kaganski 3
        steve 3
        Hossein 2
        M-Rick 2

     + top 10 bugs fixers:
        Justin Luth 10
                                4
^ could the empty one above be Khaled with arabic spelling? (Hossein)
+ lets find out what's odd there (Stephane)
        Kaganski, Mike 4
        Xisco Fauli 4
        Michael Stahl 3
        Andreas Heinisch 2
        Heiko Tietze 2
        Németh, László 2
        Rafael Lima 2
        Stéphane Guillou 2

     + top 10 bugs confirmers:
        Stéphane Guillou 22
        Heiko Tietze 9
        Justin Luth 6
        Xisco Fauli 6
        m.a.riosv 5
        *UNKNOWN* 4
        ady 4
        Roman Kuznetsov 3
        Dieter 2
        Kaganski, Mike 2

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

      done by:
         Stéphane Guillou 4
         Xisco Fauli 4
         adamseskunas 3
         Aron Budea 1
         Raal 1

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

      done by:
         Stéphane Guillou 5
         Xisco Fauli 4
         adamseskunas 2
         Aron Budea 2
         Raal 1

* all bugs tagged with 'regression'
    + 1196(+3) bugs open of 12664(+19) total 11(-2) high prio.

      done by:
         Stéphane Guillou 6
         Xisco Fauli 3
         adamseskunas 1
         ady 1
         Aron Budea 1
         خالد حسني 1
         Weghorn, Michael 1
         Robert Großkopf 1
         Sophie Sipasseuth 1

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

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

* ~Component count net * all regressions
    + http://bit.ly/1BUdI8i
      Writer: other - 420(+0)
      Calc - 219(+3)
      Impress - 133(+1)
      LibreOffice - 49(+0)
      Crashes - 46(+0)
      Draw - 45(-1)
      Writer: docx filter - 43(-1)
      Base - 42(+0)
      UI - 36(+1)
      Borders - 33(+1)
      Writer: perf - 33(+0)
      Writer: other filter - 30(+0)
      Chart - 25(+0)
      Printing and PDF export - 23(+0)
      RTL - 23(+0)
      BASIC - 18(+0)
      filters and storage - 18(+0)
      Writer: doc filter - 13(+0)
      graphics stack - 12(+0)
      Formula Editor - 3(+0)
      Extensions - 2(+0)
      framework - 2(+0)
      sdk - 2(+0)
      Linguistic - 1(+0)