# Community Weekly Meeting #133

**URL:** <https://forum.collaboraonline.com/t/community-weekly-meeting-133/2020>\
**Category:** Meeting Minutes\
**Tags:** meeting-minutes\
**Created:** [August 24, 2023, 11:31am UTC](https://forum.collaboraonline.com/t/community-weekly-meeting-133/2020 "2023-08-24T11:31:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tex](https://avatars.discourse-cdn.com/v4/letter/t/eb8c5e/32.png) [@Tex](https://forum.collaboraonline.com/u/Tex)\
**Post date:** [August 24, 2023, 11:31am UTC](https://forum.collaboraonline.com/t/community-weekly-meeting-133/2020/1 "2023-08-24T11:31:32Z")

</div>

Collabora Online Weekly Meeting #133

Date: Aug 24th 2023

All minutes published on: [Topics tagged meeting-minutes](https://forum.collaboraonline.com/tag/meeting-minutes)

## Attendees

- Michael M, Mike D, Skyler, Oli, Darshan, Andras, Szymon, Rashesh, Aron, Caolán, Gökay

## Release schedule

- Code release for next week
  - code freeze Monday evening.
  - Updated weblate & asked translators to catch-up.
  - Reviewing patches & trying to get everything in for the deadline
  - expect this around the 30th of August.

- Mobile releases probably early next month
  - Still in the plans – need to get a clear picture of blockers
  - If they exist – asked Ezinne to do some testing.
  - IOS
    - Attila fixed the navigator issues.

  - Android (Rashesh)
    - All PRs are merged
    - New PRs are coming … when we open chart wizard for the 1st time – were getting something empty: fixing that.
      - Another related to dark mode: a new option to change this in mobile view
      - we have a fix for this.
      - Updating some Java dependencies.

## Online activity (Pedro)

- Pedro is out on vacation for ten days.
- PRs without reviewer 6
  - [Collabora Online · GitHub](https://github.com/orgs/CollaboraOnline/projects/3/views/2)
    - [chore(helm): update annotations for community haproxy-ingress by genofire · Pull Request #7042 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/pull/7042) → Rash after hack-week
    - others we can find people for.

- Oli
  - [Up and down arrow keys should move focus up/down a level · Issue #6933 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/issues/6933)
    - got merged → arrow keys getting focus in/out of notebookbar tab buttons

  - [Make jsdialogs capture keydown events in Impress by CosmicOli · Pull Request #7151 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/pull/7151)
    - arrow keys should be handled by jsdialog – not escaping the view
      - occurred in impress

  - **Next:** working on improving arrow key focus in notebookbar

- Szymon
  - Also working font previews (so the font drop-down menu will display the font name in its font)
    - finished – need some styling input from Pedro – to make it beautiful.
    - What’s the performance impact: cached in the core, also in the browser, we fetch only the visible ones too.
      - Stored in JS / browser array.

    - Could we use a preview via https:// that the browser could cache locally.
    - We’re not aware of what we’re downloading: 2nd entry of combo-box with this name: makes that tougher …

  - Added missing JSDialog widgets
    - will be able to run the URL dialog from the core now.

- Darshan
  - WIP: Print single calc sheet: [Add option for print sheet by Darshan-upadhyay1110 · Pull Request #7035 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/pull/7035)
    - On-hold waiting for Nick’s exportas work.

  - Hack-week: shortcut for sheet changes – moving between them.
    - Updated the help information on this too.
    - Looking at ordered & un-ordered list; ctrl-shift-l doesn’t get usual bullet point.
      - [Unordered List Keyboard Shortcut by Darshan-upadhyay1110 · Pull Request #7122 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/pull/7122) =\> unordered list

    - Opening the user-list with a shortcut key. [Open user list box using keyboard ( CTRL + ALT + P) by Darshan-upadhyay1110 · Pull Request #7121 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/pull/7121)

- Michael / Caolan – Performance  
- Performance improvements for comments in spreadsheets → now merged:  
- [cool#6911 calc comment positions are now cell addresses by caolanm · Pull Request #6988 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/pull/6988)  
- [Draw calc note indicator browser side by caolanm · Pull Request #7001 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/pull/7001)  
- loading quicker which is nice …propagated from different sheets.
  - Did some work on export performance improvement
  - “ch units” bug [Github Issue #6984](https://github.com/CollaboraOnline/online/issues/6984#issuecomment-1678733322) fixed in core.
    - [Bug #101895 - Paragraph dialog units shown as “ch” and “lines” when “Enable char unit” is enabled by default](https://bugs.documentfoundation.org/show_bug.cgi?id=101895#c20)

- Testing results:
  - a hang when typing quickly, we get a problem each 10 characters
  - Caolan seeing dark-mode tiles from time to time …
    - someone else toggled into dark-mode and Caolan got it.
    - Reading & code review needed on dark-mode …

  - Found some good problems from calc:
    - [24.04/23.05 Generic Calc performance ticket · Issue #6893 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/issues/6893) – getTextSelection nightmare which we try to do on keypress – consuming vast memory & time. → probably needs more info.

  - Lots of logging churning on the console → disabled this and started re-profiling.
    - “Client session not found to forward message”
    - “Aug 24 10:33:57 cp-staging-eu-perf coolwsd[14198]: wsd-14198-14259 2023-08-24 10:33:57.905319 +0000 [docbroker\_001] WRN Client session [06c] not found to forward message: o31003 invalidatetiles: part=0 x=5740 y=39145 width=5315 height=316 wid=6757| wsd/DocumentBroker.cpp:3625”
      - lots of those…

  - Seems that things are **way** smoother without the delay when we are not saturating the log … which is good =) …
  - **AI:** cleanup the debug display of other sheets’ invalidations in calc (Caolan)
    - different color – eg. blue, and much more transparent (?)

- Skyler
  - Busy with using UNO with websocket
    - [https://gerrit.libreoffice.org/c/core/+/154680](https://gerrit.libreoffice.org/c/core/+/154680)
      - working through review comments.
      - Pushed lots of changes to gerrit.

    - Wrote a small python server to bridge websockets to regular tcp sockets ([GitHub - Minion3665/collabora--urp-ws-proxy: A websocket proxy for interpreting UNO Remote Protocol (presumably transmitted between COOLWSD and a client of your choice)](https://github.com/Minion3665/collabora--urp-ws-proxy)). Why not Java/C++? I though it would be easier to get it going and it won’t be needed by the end.

  - Collabora Online hangs locally: [Collabora Online connections hang when a relative LO path is used · Issue #7041 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/issues/7041)
    - was a relative path building problem.

  - On holiday next week.

- Timur
  - on holiday.

- Mike D
  - ["Help \> Online Help" Disappears After Pressing "Keyboard Shortcuts" · Issue #7148 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/issues/7148)
  - Pressing **Help \> Keyboard Shortcuts** causes “Online Help” button to disappear.

## Forum (Mike D)

These were the key topics:

- Topic 1: Alt Keys + Docker + Not working in Calc/Impress???
  - [‘Alt’ key does not works with Calc and Impress](https://forum.collaboraonline.com/t/alt-key-does-not-works-with-calc-and-impress/2017)
  - Person had issues with ALT shortcuts + docker container.
  - Looks liked it worked in Writer, but not in Calc/Impress?
    - Expected – and Gokay is fixing it it will be in the 23.05.3 release next week.

- Topic 2: Nextcloud “Talk” + “Collabora Online” interaction
  - [Video windows doesn't switch between participants while editing a shared document](https://forum.collaboraonline.com/t/video-windows-doesnt-switch-between-participants-while-editing-a-shared-document/1987)
  - [Talk video window doesn't switch between participants while editing · Issue #7046 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/issues/7046)
  - This was an issue from a few weeks back.
  - He finally submitted a lot more info.
  - (I also added that his info into the Github Issue, so that it’ll all link together. 🙂 )
  - I asked for more clarification, but to me, it seems like it’s a Nextcloud Talk “issue”, not necessarily anything to do with Collabora.

- Topic 3: Google Docs’s “IMPORTRANGE” support?
  - [Referencing ranges in other sheets](https://forum.collaboraonline.com/t/referencing-ranges-in-other-sheets/2019)
  - Google Docs Help: “IMPORTRANGE”
  - Loading external documents is a problem for our architecture:
    - each document in its own jail … its an issue we should address.

Still unanswered from two weeks ago:

- This person asking about Japanese Phonetic Guides:
  - [Unable to use phonetic guides](https://forum.collaboraonline.com/t/unable-to-use-phonetic-guides/1982)
    - when you learn – you get the Latin alphabet first
      - the CJK character is used, with latin chars above for learners
        - Ruby/Asian-phonetic guides.

    - Lets ask what is missing ? … - send a screenshot.
      - [LibreOffice 7.5 Help: “Asian Phonetic Guide”](https://help.libreoffice.org/latest/en-US/text/shared/01/05060000.html?DbPAR=SHARED)
      - [Wikipedia.org: “Ruby Characters”](https://en.wikipedia.org/wiki/Ruby_character)
      - [One of my older Reddit posts on LO + Japanese Ruby Text](https://old.reddit.com/r/libreoffice/comments/11h18kj/libreoffice_writers_asian_phonetic_guides_are/)  
16 → 17 - zero replies in user support:  
→ [User Support - Collabora Online](https://forum.collaboraonline.com/c/user-support/11?order=activity)  
62 → 62 - zero replies in installation and config:  
→ [Installation & Configuration - Collabora Online](https://forum.collaboraonline.com/c/installation-configuration/10?ascending=true&order=posts)

## Community

- Nextcloud conference just before the LibreOffice one
- Will be in Bucharest – and Gabriel will be organizing it too.
  - [LibreOffice Conference 2023 in Bucharest, Romania - The Document Foundation Blog](https://blog.documentfoundation.org/blog/2023/03/01/libocon-2023-in-bucharest/)
  - Registration is now open
  - You are invited to the “Introduction in LibreOffice Development” workshop:
    - [Learn about LibreOffice development at our upcoming conference! - The Document Foundation Blog](https://blog.documentfoundation.org/blog/2023/06/13/learn-about-libreoffice-development-at-our-upcoming-conference/)
    - [Workshop: Introduction to LibreOffice Development » LibreOffice Conference](https://conference.libreoffice.org/2023/workshop-introduction-to-libreoffice-development)
    - [Bucharest, Romania 2023 » LibreOffice Conference](https://conference.libreoffice.org/2023/registration-form/)

## Next meeting

31/08/2023