 A year of cool, Collabra Online and of course some details about mobile. I'm Cornels, Marketing Lead at Collabra and we are going to show you some things about the good stuff in Collabra Online last year. Of course, Collabra Productivity, I think it's well known already introduced last year. It's really about dedication to open source and bringing the goodness to the business world organizations that they are possible to invest some of their money in good free software. That's about us and when I talk about Collabra Online, a lot has been used, been done by the community around Collabra Online in usability, user interface, file support, performance, features, et cetera, et cetera and let's see how much I can show of all the goodness. First the usability and the user interface. A lot of details have been done to make it really look smoothly and attractive, easy to find. It's when you talk about the rendering, although this image doesn't show it, but the rendering of spreadsheets, details in text files, where borders are, areas start and in interfaces, in buttons, in pop-ups, in sidebars, all has been continuously improved and it shows, I think. Another major new feature of the last year has been the notebook by user interface choices. There's more choices and a lot of tabs, a lot of clean, easy-to-use buttons, menus and as you can see at the bottom it shows that it's also by double clicking on the tab, the whole notebook bar collapses, giving the user more space to work actually in the file. It's not only that we have the notebook bar, but the classic mode, so the simple menu and the icons, it is retained and it can be configured, it is configurable and it can be turned on by default. There's some noise going on here or somewhere. File support and interoperability. EPUB export in Writer is new. EPUB has been added to the files recently, to Writer recently and now you can also export online to EPUB. ODF 1.3, it's new, it has wide support and of course also in Collabra online. New feature is to export to CSV files in Calc. Importing is already possible for some time with a great dialogue with a lot of choices to set all the import settings you need, but export is possible now too. Then of course talking about interoperability, PowerPoint is one of the spear points, so an impressed PowerPoint. We talk about headers and footers, we talk about smarts, art graphics, we talk about shapes, all kinds of goodness that has been improved the last year. Of course when you look to interoperability, it also means that often there is a user interface component that has been added to make working possible with new features. This is another one, Danberg-Gilse custom geometry effects, so that it's really imported as it is created in some other software. Then performance has a lot to say about it. Yesterday Noel talked about it and in half an hour Micah will talk about it and it's on server side, but it's also faster work in the browser in java script and for example your spreadsheet gets faster and your notebook bar will be loaded faster, more on that in half an hour. Here is just some nice graphs showing how much improvement can be done by some testing and tooling. Then talking about features in writer, there's a whole lot of features improved there. One of the things, for example, drop down list in form fields. We all know the form fields, it is a sort of historic, how do you say, artifact or something. It exists for a long time, but it's still in use and it is wonderful that you can use it online now as well. Gutter margins, I think this has been mentioned recently. This means that in the writer documents you can easily choose to set a gutter position which is very, very handsome for printing. Then one of my favorite new features of the last year is the full control of the anchoring of images and text flow, images and shapes. As you know, Collabra online is outstanding. It's marvelous how it handles the images online, how you can move them, how it's fully wizzy wick. It's easy to handle and that has even been improved now with the context menu to set anchor, to set wrapping and to arrange all shapes and images. You can also see the anchoring now. It's one of my favorite features, of course, since I love to work with images. Then Calc. There's been major improvements in Calc as well. Here you see free spanish, free spanish. So when you have a large spreadsheet, thousands of rows, you will be happy to set the first one, two, three, four rows, whatever to freeze those and to be able to work in a very easy way to understand where you are looking at. It has been enabled in online the last year. With larger spreadsheets, there are more sheets and you want to move them, copy them, rename them, etc. This slide is showing you the great user interface that has been improved, looks marvelous and is very easy to use. Talking about spreadsheets, larger spreadsheets, obviously in data sets, we need pivot tables and the pivot tables were already present for some time, but there were strong limits or there were real limits in what you could do with pivot tables. Now it's easier to either create them and to customize the pivot tables and as you see with these screenshots, it's really every dialogue, every choice, every sub choice, etc. In every detail, you can handle pivot tables online or maybe I should say in nearly every table, but I haven't seen anything that doesn't work. Then another thing, defining range just in online. In spreadsheets, range names are important and the good thing is that this also allows in the correct dialogue, when you find that, to use print ranges in online and print ranges is not only to send it to that printer, but you all know that it also helps to do a good PDF file, so print ranges online, I think it's one of the outstanding distinctive features of Collabra Online again. Then charge. I mentioned then in calc, but obviously you have charts in writer and you have them in impress, etc. And the sidebar allows you to make a lot of changes in titles, in all the settings. It's easy to use and this has been brought to mobile phones as well. More goodness for calc. There's a whole set of analysis statistical tools that has been brought in dialogue to online. And then let's flow to impress. Tables have been improved. More powerful, easier to use, also including shadows. Headers and footers have been extended, more easy to use and more details. Smart art graphics already mentioned that. And there's also the improved viewing of presentations and also the handling of slides in the sidebar, in the slides, pane on the left, you can easily scroll through all the slides now. Then another tool is draw and people who know Libroff as well know that it's strongly connected with impress. A lot of the features and interface is shared. But as such it was not present online, because of course it needs a lot of extra user interface elements. But that has been realized the last year. Here's an overview of draw with some various sheets in one file. And draw is obviously for technical drawings, posters, brochures, etc. vector graphics. It's one of my favorite, again a very favorite tool. It must have to do with the images. And of course when you want to use draw, you are happy that you can make drawings with connectors, for example. So there has been made a whole lot of connectors available. And since we talk about an office suite that allows us to, well, to work consistently, all these connectors also are available in Rython and Kalk. And drawing online, we mentioned font work. It's an old tool, still popular to make nice, funny, wavy and complex text. It has been brought to online. It is visible in the sidebar. The tooling to work with it the settings. It has been brought to mobile devices. And it's not only in draw, it's also in writer and in impress that you can and in Kalk, that you can use font work now. Then there's some various, hey, what I said font work is not draw only, it's also in writer, Kalk and impress. Very well said. Then we have PDF search and annotations. It's not only that you can create PDF files in collaboration online, but you also are able to do search and now add annotations to PDF files. So this allows you to collaborate on PDF files that you have uploaded somewhere in your share online. And with collaboration online, it's now possible to actually collaborate on those. Another feature that is interesting and I guess not all CIS admins are happy with it to allow it, but it's VBA Starbasic macros are available in online. As I said, it's not something that all people will allow you to use all CIS admins. So clearly it has been disabled by default and the administrator see he can enable and obviously set the security level. But it works. It allows you to run, to open a dialogue, run macros, etc. Of course, the whole interface options and because of the nature of the online application, it's not possible to have, how should I say, all automating that you can have on a desktop. So it is really good to use it for macros that are designed to run on the spreadsheet, in this case in online. But it does work and it is useful for tasks that are, well, mostly to do and need to be done more and more often. You could have macros for that. PDF scrolling, so large PDF files scrolled through them continuously without having to click or press page down again and again. And I think there's even more news, multiple slides selected in the slide pane, tabs and stuff on rulers, tables in writer and in press from the menu now, shape wrapping to the background, date format and calc. It's more and more. And then I think one or two things to show on the integration on the server side, but that's really for people who work on the integration of Collabra online. It shows you that there is the possibility to do some settings there to create the environment to show it as you would like to have it. So here is basically the same file, but with some changes in the integration. And then coming to the last slide, gradually here's something about mobile devices. Mobile phone updates, page panel setup has been added, step stops, word count, page setup on phones as well, table dialogues from the menu on tablets. There's a lot of effort put continuously in improving the interface for Android and iOS. And it's fun to see that it works both ways, or let me even say three ways. Sometimes stuff needs to be improved on a mobile device. And it means that some basic improvements have to be made in online, which may result in improvements that need to be made in LibreOffice Core. So there's a chain of changes sometimes that results in the more goodness left and right. There's a Notebook bar, Notebook bar, that's something that's not good, but Notebook bar on tablets, CDK font support, dark mode, opening passwords. Well, dark mode, it's initially to see how it works, but we're clearly not done. Pivot tables, faster document handling. And one of the important announcements of last year was the Chromebook support, obviously important for students, schools, to have profile set privacy, not to depend on the use of Google, of Microsoft, but giving them freedom of choice. It's affordable, and it provides a really rich interface. A lot of things that people can do, and it's an excellent file support, as you know, the number of the amount of files and the way it is handled in LibreOffice and Collabra online, it's outstanding. So it's good to celebrate that. And while we are celebrating, this is a nice picture from, I think it was from Spain, Almeria, the conference, with a large part of the team and partners and volunteers that's shown here. And I think we all look forward to meeting in person the next year. Thanks for listening. Thanks for your support. And please let me know if there's any questions. Thank you very much, Ko. I can only echo the slide before last. Looking forward to meeting in person again. Yes, exactly. So we have about seven and a half minutes left for questions. So please, I don't see any question on the chat. So if you have any questions, please leave them at hash LibreCon iPhone room one. Maybe I can jump in. It all shows clear, one would say. Yeah, I must say it's, I mean, it's quite impressive like how all shiny and, I mean, it's, I see a lot of changes. And yeah, that's quite impressive. That's quite cool. Yeah, thanks for that. Maybe one, like, naive questions was about this security level that you were talking about. I didn't write down the slide number, but about CBM macro support. Yes, exactly. Yeah. Can you expand a bit on that? Like, what is it, is it that, I mean, people just want to kind of have better defense in depth and they don't want to activate like a bit high code or like saying that might be buggy or I didn't get your full question, but about the security level, it is, it is the same as, yeah, it must be the same as you have in the desktop application. And it clearly should be that it's about trusted macros in etc. Yeah, you don't want people to have run a random macros in an online application, although we didn't tell something about that now. But if you look at the whole architecture of the online application, there's quite some security and safety goodness around it. It's not just random, but yeah, but still, you don't want a random code to be executed. Yeah, this is why I was asking a question, because I remember you showing that you already have pretty good isolation between the LO4 kit processes and the different other things interact with each other, like several layers of isolation there. Okay, but yeah, so that's one more thing to tweak then. Okay.