Collabora Online Weekly Meeting #211

[darshan]

COOLWeekly206

Date: 20/3/2025

All minutes published on: https://forum.collaboraonline.com/tag/meeting-minutes

Attendees (write your name):

• Skyler, Darshan, Pedro, Banobe, Bayram, Méven, Ezinne, Gulsah, Parth,Vivek, João, Timur,

  Anna

Testing

Files – ( password is coolmeeting)

Staging-perf

• Writer - https://staging-perf.eu.collaboraonline.com/nextcloud/index.php/s/3nFkwmcfKTzxSnS

• Calc - https://staging-perf.eu.collaboraonline.com/nextcloud/index.php/s/D7HLedZwq8KLQp5

• Impress - https://staging-perf.eu.collaboraonline.com/nextcloud/index.php/s/AyeiNzNT78wpxix

• Features, user flows (Anyone can add here the things they need to test)

  • [Application] [Requester]: what to test

1. Release Schedule

• 24.04.13.2 Released

• 24.04.13.3 to be released next week.

• Mobile release: released 24.04.12 → next release should be in ~1 month!

• PRs in need for attention (Please add here any PR that needs attention)

• PRs without reviewer https://gitub.com/orgs/CollaboraOnline/projects/3/views/2 now 5

• Nicolas

• Gabriel

• Julius

• Ongoing work to improve mentions by Elizabeth https://github.com/CollaboraOnline/online/pull/10556

• Implement startPresentation parameter https://github.com/nextcloud/richdocuments/pull/4209

  • Esc key seem to don’t work at all in this case

• Pending bug fix for federated share

• Bug fix for PDF files (mostly cosmetic)

• Thorsten

  • [No update]

• Banobe

  • Status bar: Bogus insert mode: inactive (Merged)

  • Style List sidebar information hierarchy in co-25.04 (Merged)
    - Created tdf ticket and patch was merged to master in libre office core

  • Rename “Spotlight” to “Highlight styles” in co-25.04 (Merged)

    - Created tdf ticket but was marked as cannot resolve as “Spotlight” is already present in (7.6, 24.2, 24.8, and 25.2 release builds.)

  • Status bar remove scrolling (in progress)

    - Since we are removing default states from status bar and also inconsistencies, we are to remove the left and right arrows too

    - We need to find what prioritise to show on the status bar (left to right) in terms of importance and depending on the status bar width, elements are hidden from right to left.

  • Options missing on Save As mode (in Progress)

• Attila

• working on making chart text formatting from sidebar.
  Made some of the chart font properties set from the sidebar (font size, bold, italic …). CharFontName is not working yet, it is more complex, as it probably set multiple properties not only the CharFontName.
  Working on implementing the other side .. update the sidebar based on chart part selected.

  Already found a way that will probably work, but still searching better solution.

• Andras

  • no update

• Szymon

• sidebar gear icon shortcut for styles in calc

  • fixed

• sidebar formula editor cannot be opened second time fix

• more strict jsdialogs syntax checking in 25.04

• current: regression in currency dropdown

• Darshan

  • PR:

    • Change Navigator’s position #9567 https://github.com/CollaboraOnline/online/issues/9567

    • Detach navigator from sidebar #9933

      • https://github.com/CollaboraOnline/online/pull/9933

      • https://gerrit.libreoffice.org/c/core/+/172594

    • Navigator now opens on the left side for all apps.

    • Added a floating button with logic to show/hide it when the navigator opens or closes.

    • Special case for Impress: Added a tab view to switch between the Slide Sorter and Navigator.

    • Floating button design improvements suggested by Pedro. Design mockup for navigator : https://share.collabora.com/index.php/s/EDESsHc2w368pt3 (pass gh#6248-navigator)

    • Next case:

      • Handle behaviour in read-only mode.

      • Hide the floating button at high zoom levels to prevent overlap.

• Aron

  • nothing to add

• Caolan

• Some work underway for memory optimizations

  • https://gerrit.libreoffice.org/c/core/+/181513 merged

• Working on a similar memory optimization to preload typedetection data

• Auto committed Watchdog profiles

  • https://github.com/caolanm/profiles/tree/co-24.04/watchdog

• Auto committed copy-on-write/do_wp_pagege profiles

  • https://github.com/caolanm/profiles/tree/co-24.04/do_wp_page

• https://github.com/CollaboraOnline/online/pull/11146

• Vivek

  • Setting Iframe with Integrator

    • https://github.com/nextcloud/richdocuments/pull/4461 → Ready to merge.

  • Wordbook Iframe flow

    • setting: allow wordbook to edit and remove words from wordbook (https://github.com/CollaboraOnline/online/pull/11172) → Merged

    • handle large wordbook file with Web Worker (https://github.com/CollaboraOnline/online/pull/11199) → In Review

    • Doing some POC about optimization . Need discussion with Pedro/Szymon.

      • Can we discuss this after this meeting? @Vivek @szyklos ?

      • Vivek: sure

• Bayram

• (To Test) - Loss of functions in XLSX pivot table’s context menu until refreshed (tdf#123225)

  • core1: https://gerrit.libreoffice.org/c/core/+/181795 (Merged → lo/master - lo-25.2 - co/24.04)

  • core2: https://gerrit.libreoffice.org/c/core/+/182242 (Merged → lo/master - lo-25.2 - co-24.04)

  • core3: https://gerrit.libreoffice.org/c/core/+/182529 (Merged → lo/master - lo-25.2 – co-24.04)

  • porting to other branches → lo-25-2, co-24-04 → DONE

• (In Progress) - tdf#158857 - Keep Power Query when saving XLSX

  • core1: https://gerrit.libreoffice.org/c/core/+/164290 (Merged)

  • core2: https://gerrit.libreoffice.org/c/core/+/170691 (Merged)

  • exporting xl/queryTables/queryTable*.xml

• Skyler

• Video on iOS

  • Pull requests…

    • https://github.com/CollaboraOnline/online/pull/11214 → this one is the last to be merged – Kendy said it looked good but did not formally review, so I’ve pushed him for that…

• Now working on MacOS shortcuts…

  • All works from the keybind front!

    • Emoji picker still broken

    • patch under review here: https://github.com/CollaboraOnline/online/pull/11308

    • some discussion over whether ctrl+r should be captured by us…

• Quick look

  • Working on this

  • have a patch that would work…

    • …except for iOS memory limits

    • …now trying to optimize it so we can convert documents within 100mb – somewhat successful but having to rip out different internals in a Not Ideal way. Lots of issues with a larger (but not huge) document I have, etc.

      • wondering if we can sensibly lazy-load more stuff

      • wondering if we can do some cursed neat streamed conversion rather than loading the whole document at once…

• Pranam

• Improving interoperability to import formulas from MSO

• Fixing some async dialogues freezing new users joining

• Gökay

Continues:

• Various bug fixes & reviews:

  • Calc: Column selection issue and tile position after zoom.

• Pending: Tile rendering on Notes view mode.

• Hubert

  • No updates

• Gulsah

  • Excel crashes opening XLSX converted from some XLS files

    • Sent a WIP patch to discuss

    • https://gerrit.libreoffice.org/c/core/+/183125

    • I paused to work on.

  • Calc: colored cell references not working

    • Focus cell feature caused an annoying regression.

    • Fixed: https://github.com/CollaboraOnline/online/pull/11312

  • Create contextual Notebookbar tab and compact mode drop-down for formula editing

    • Trying to default open Area panel on sidebar when a formula is selected on document

      • Sidebar.xcu change is not enough to see panel open.

      • Investigating…

  • Next: Make equation font dialogs async

• Timur @Anna

• Just observing.

• Méven

  • No updates

• Chris

  • Working on scroll performance/behaviour

    • PR #10772 landed (anchor annotations to scroll position/comment optimisation)

    • PR #11044 opened (sidebar animation performance)

  • Next:

    • Look at #10968 (Preload tiles more intelligently)

    • Look at scrolling performance on 4k/hidpi monitors in Firefox

    • Add possible jQuery-related easy-fix issues to GitHub

• Nick

  • Correctly receiving jsdialog online now, and have basic navigator working now

    • WIP: https://gerrit.libreoffice.org/c/core/+/172594/2

    • WIP: https://github.com/CollaboraOnline/online/pull/9933

    • Need to:

      • Create open/close button

      • Fix navigator closing

      • Combine with slide sorter for impress

  • Back at university now so will have less time for collabora

• Rashesh

  • new address input field added to calc which adds ability to create named ranges

  • working on @mention

    • https://github.com/CollaboraOnline/online/issues/10047 & https://github.com/CollaboraOnline/online/issues/7923

    • https://github.com/CollaboraOnline/online/pull/10273

  • Filed a nextcloud issue regarding mention: https://github.com/nextcloud/richdocuments/issues/4169

    • https://github.com/nextcloud/richdocuments/pull/4171 → merged

  • https://github.com/nextcloud/richdocuments/issues/4276 → discussion around Master slides import from templates folder

• Parth

  • Setup Collabora Online

    • Core building

    • Issue with AppArmor

      • Action Item for Parth : To push a PR against the .io website to it includes tips for Ubuntu on AppArmor

      • https://ubuntu.com/blog/ubuntu-23-10-restricted-unprivileged-user-namespaces

Events

COOL Days 2025 - 2nd - 4th June - Budapest, Hungry https://forum.collaboraonline.com/t/cool-days-2025-2nd-4th-june-budapest-hungry-collabora-office-and-collabora-online/3396/4

Forum Topics

• Top forum topics from last week:

  • User support:

    • Resolved:

      • Tools menu missing in documents https://forum.collaboraonline.com/t/tools-menue-missing-in-documents/3523/4

      • Quick Tryout Nextcloud Docker not working https://forum.collaboraonline.com/t/quick-tryout-nextcloud-docker-not-working/3521

    • Alfresco document opening issue: https://forum.collaboraonline.com/t/cant-open-docs-from-alfresco-share-23-4-1-using-alfresco-collabora-online/3457/1 => Meven answered (Thanks)

    • Feature request:

      • Can Collabora for Android handle importing .wpd (WordPerfect documents) https://forum.collaboraonline.com/t/can-collabora-for-android-handle-importing-wpd-wordperfect-documents/3514

    • Need to look :

      • How to make COOL listen to both IPv4 and IPv6? https://forum.collaboraonline.com/t/how-to-make-cool-listen-to-both-ipv4-and-ipv6/3519

Announcement:

• COOL Community Sticker Contest https://www.collaboraonline.com/blog/community-sticker-contest/

Next meeting

• 27/03/2025

[hegelec]

Thank you so much, Darshan, for bringing up my suggestion in the meeting. I was meaning to thank you for your response in the original thread, but will do so here. I’m so impressed with this product so far and the team behind it!

Best wishes,
Christian

[darshan]

Hi Christian,

Really appreciate your kind words! Glad you’re enjoying the product, and your suggestion was definitely worth bringing up. Looking forward to more of your insights!

[darshan]

@hegelec, you’re welcome to join the community meeting, where we discuss new ideas, issues, and product progress. It’d be awesome if you have anything to add!

Communicate