 So I'm going to talk about what we've done in the last year. This is very disappointing So for example, our competitors have just announced Python being integrated with Microsoft Office Online Python But of course as Kano was saying Jupiter notebooks have done this for for ages and you know, we've had Python for well, you know decades So I won't talk about that Good. Let me talk instead about the smart picker, which is awesome and has been there in the last year So obviously Calabra online or next cloud office as we know it wants to be beautifully integrated with next cloud It needs to look just like it's belongs. You know, it's not a squatting alien. It's a native beauty So we need the smart picker so we integrated that and you know, you can use all those beautiful features But there's even more we can turn your existing documents your strange office Format documents into essentially a big wiki that links to subheadings and elements and sub parts of other documents and Ties all of that good stuff together So you can take your existing content in those horrible proprietary systems and move them into a free system and then get all of this linking and You know association logic there really nicely and to make this even more beautiful We have this nice mouse over hover thing again very similar to what next clouds done with URLs So you can hover your hover over and you can follow the link quickly You can see a pretty few of where it goes so you can quickly build a mental map of you know, what's going on in this document When you're in meetings, obviously, it's nice to be able to give action items to people that aren't there So, you know, so you can use the at command you can get pop-ups there and they'll get notifications and attend more meetings maybe We have a whole load of beautiful new templates in hub 5 Many of these from the LibreOffice community are bundled and now much easier to use We've made it much easier to manage your fonts and to see them So if you if you need particular interoperability fonts particularly to get the metrics right for your document layout We can very very easily right in next cloud there upload them see the previews and so on and of course now You can see the previews actually in the UI as well So as you drop your font list down you can get that that beautiful experience of course everything works beautifully in next cloud But if you're using an exotic font, you know sending it to someone else on a legacy system They may not have those fonts. So you can also embed those fonts There's properties and the ability to do that But you know just beware that your beautiful experience of typography may not be shared by other people. So there you go Or you can just send them a web link to your document instead of a you know file attachment Little little bits here, but I just like to highlight some of the things that come from the community work So I was really pleased recently to do the stats Collabra has been around doing LibreOffice stuff for 10 years now. So I added up and there's 1,400 individuals Hacking on the code contributing code to make Interoperability better to free people is part of the LibreOffice project We work on I just want to highlight a few of those things that you may know maybe never cared about Your typography and hyphenation and exact precise flowing to make the text beautiful, but let's load it So that's great. So so that's really cool and change tracking in numbers. So you can see where your change tracking has gone Maxim has been working on table style design just to make tables prettier and more consistent and so on And QR code generation Google has been sponsoring Google summer of code for many years And you know so you can drop your QR codes in that's in the latest release there coming with hub six Another thing is we really want to include everybody so accessibility features are just really really important and Improving keyboard use so a nice accelerator pop-ups there in the toolbar. So you hold down alt and off you go And translated ones to depending on your local. So it should be the bindings you're familiar with Moving lots of UI into the client. So it's then keyboard navigable and screen readable and usable And we have a lot of complicated UI. I don't know if you've ever tried to oh, is this a laser pointer? Can I kill someone? Let me just check. No, maybe not. Aha. Look at this You can even edit the patterns here. Look so you can yeah, I don't know There's these wonderful you eyes. Maybe you've never tried to edit the bitmap pattern fulfills But anyway, we can do it. So I'm navigator so that you can find where you are in the document more quickly There's this stuff on the side. It looks even more beautiful in hub six Screen reading support so for the core of the documents so that you can navigate through that and You can see that on your braille display. It's an initial version and we're improving that very substantially the latest improvement is screen reading for nested tables so you can then Work out and there's a whole lot of funky table nesting that's possible in documents dark mode You know if you're if you're lying in bed reading the documents and your spouse is sleeping, you know It's socially responsible to use dark mode just a tip So there's some good things we doing there improving the templates to use automatic colors so we can switch the colors You know and invert them to make things work nicely But also this non-printing character stuff so since we're rendering different views you can have different features in your different views So, you know non-printing characters spell checking underlines so on and so on We have built an accessibility checker, which is even more important because you know There are a relatively smaller number of impaired people But a lot of people it should be caring about Creating good documents other people can read and interact with even if they're impaired So we have a great accessibility checker there that I'll tell you you need to add your alt tags You need to add your captions you need to make it a perfect for other people and then of course exporting that as PDF With universal accessibility there is of course really important E-pub export as well just key. These are not particularly new, but they all tie in with the accessibility features One of the things I'm passionate about is making this thing ever quicker and slicker and more, you know Well beautiful is good, but faster is good too. So I've been working on this with a small team and just Using much less memory, you know Actually, you win both performance and also memory footprint by reducing memory use just better with your cache You're more efficient and so on and so run length and coding various things Compressing image cache is swapping uncompressed swapping compressed images to disk as well as uncompressed ones For very large documents and just improving synchronization between client and server to make that better CP optimization Lots of good things here too Mainly doing less work. I mean we often do work just in case and we don't really need to need to be doing that better style Previewing lots of people and there's some numbers people like graphs. So I you know here are numbers for you This is where some of the 2x wins came from But you know, we just discovered that when everyone joined a writer document You re re-invalidate and re-render the document for each user, which is kind of an n-squared. That's not good So we need to you know make this it's not an n-squared It's an order in but Or is it maybe anyway, so it's well, we'll think about this. There was quite a lot of invalidation going on. There wasn't need it I'm proving writer scrolling performance of much faster rendering Much better load time presentation rendering all sorts of other pieces. Oh Yeah interoperability. I mean we have the world's best. I mean it's pretty awesome interoperability outside of Microsoft We're we're kicking back side, but still there's always new things So a key feature is getting your doughnuts the right color and gradient and so on so we've been putting multi Multi-stop gradients everywhere 64-bit zip support for those gigantic spreadsheets Maybe these don't seem incredibly useful to you But you know, it's just a symptom of pushing the boundary of interoperability into your corner cases a compact pivot tables So pivot tables can have this compact form now. So we do that a document theming So instead of flattening the colors we can retain the theme So I mean we could always load theme documents, but now you can change the theme and you can do that for your spreadsheets And you know, it can look I mean it looks beautiful, right? Oh, maybe not. I We need some graphic talent perhaps in our color selection Multi-page voting tables. This is a really cool thing that's been funded by the open desk project as have some several of these features And this is just a huge huge problem And yeah, we've we've really fixed it very comprehensively So this is a big possibly the most important Ticket we've had in writer for many many years are now gone on whole clusters of interoperability bugs being closed So fantastic and really good for government forms where tables are important and occasional layout cock-ups You know, you really don't want this you want this and then this so, you know, this is the Microsoft alternative What else nearly done usability features? So we've been able to insert headed, you know footers and headers and page numbers for years But you know new users don't know you need to insert a header and then you need to put a field in it It's too difficult for them. So we made a nice UI to do that this year and We did Zotero integration for citations and bibliography management for universities for lawyers for governments doing Legislation and so on and lots of other uses and that's pretty cool And you can collaborate with a team your citations and you can build citation databases So you can make sure all your friends are cited and not the other guys You know, you can build those that strength to your team in terms of its metrics AI based grammar checking so lots of stuff. Duden's very popular But language tool is free software and made actually in Potsdam in Germany by a cool team So so some great integrations there and a translations with with depot We're really looking forward to getting the next clouds on-premise stuff Fully integrated there and so that's that's kind of cool And of course you really want your videos in your documents of funky things So I think finally just want to say this is all built on top of LibreOffice technology and LibreOffice is kind of awesome And we love that please do get involved and thank you Yeah for the support of all of you guys for promoting us and you know Talking about our shared vision, you know, we're open source the the office suite for the free world as well I like to point this out at the particular moments of geopolitics and on-premise there's really no compromise in that control and ownership Please get involved check out the source. Thank you for being here. You've been a very good audience. Thank you