 Hallo, welkom bij mijn talk about the new possibilities in online editing of open document and I added interoperability. I'm trying to give a nice overview of the things that have been developed over the past year, roughly. All the new features that have been added by a lot of developers, hardworking people to give the new platform the new working. Yes, this works. About me, a lot of things. On the right is the interesting thing, my private life, which is busy. On the left the business thing, which is interesting too with Open Office LibreOffice since 2004. All kind of voluntary stuff and a known company. And since 2019 last year, part-time help and collaborate with marketing. And it also has to do with how the things change in marketplace. My business mostly is helping with training, with desktop stuff. And since we see that the world, people move to online work that has influence on my activity as well, with button. So, I have some sections, general, writer, text files, spreadsheets and just mentioning all nice features. Of course, this is not really new, but it has been improved is about tracking changes, commenting, handling comments. That has been nicely improved in the LibreOffice collaborate online. Next thing, that's the formatting of bullets. It has been made possible to get a lot of dialogues visible. And so, that gives all kind of features that are available in desktop, also available in online. Another thing that has been realized, and this is one of the examples that I'm going to show. It's the sidebar, which in LibreOffice desktop and also online has an enormous amount of settings that you can do. In this case, it's a shape that is selected and you have colors and you have also a custom color picker that is available in online nowadays. User interface, it has nice new cleaner toolbars. Another thing, talking about online and document editing. Of course, we prefer to work with open document, but quite often we have to do with Microsoft often files. En this is an example of a Microsoft Office file that's just loaded in a collaborate online. And you can do a save as and you can save it as an open document file. And you see if you load that same file, it just looks similar apart from the fact that in this case there's a table selected etc. But it just works. So our tooling also is a bridge between the open standard and the Microsoft file format sort of. Next thing that has been nicely improved is easier, is the handling of images shapes that are selected online. You can easily turn them, you see when you start to turn them, it indicates how the result is. And on the right indeed, there is how it works then. The next section is a bunch of items that has been improved in working with text files, tables. If a table is activated, you see the markers for the rows and the columns. You can drag them. It's easy to work with. And on the left of the screen you see the sidebar that also has a section for tables where you can work with rows and columns and things like that. Are there people here that work with tables in online documents now and then? Sorry? You tried and you failed or the software failed? That's exceptional. The thing you tried was really complicated. It was an early version or maybe. It's interesting now that we talk about this. This is just a part that I've told and shown. There's an enormous amount of possibilities that people get online. And this application is also the base for the iOS version of Colabora and the new Android version. So there's a ton of possibilities that being added and that are useful to have. I think when you have some speech work to do with huge documents, et cetera, the preferred platform in any case for me still is this one. Just for being able to work faster. But still, it's great that when working together you can handle tables. Oh yeah, there you see the various handles indicated. Table of content. If there is a table of content, you can do a refresh so that it gets updated. But you can also do the setting. So adding the styles, adding extra lines, things like that. It's available online. Another interesting thing is text files often have sections that can be locked, that can be protected by passwords. In this case, I'm not sure. Oh yeah, it's a DocX file, Microsoft X file where you can add a protected section. Oh, welcome with your bicycle. En you can simply handle these protected things that are available in the open document format. And that are available in the Microsoft Office format. You can handle them in LibreOffice Collaborate online. En so that means a great compatibility. There are applications out there that are saying they're extremely compatible. But basic stuff like protection and section, it doesn't exist there. But it is handled here. Another nice thing is the watermark. En also here you see the availability of a dialogue, all kind of settings so that you can tweak it to your needs. The next thing is about spreadsheets, which are often used. Also here cell protection. En if you try to change something that's protected, it will just fail and you will get notified. Data validation, most people know it. Anyway, those people working with spreadsheet online, it's just available. En if you try things to do that are not allowed, again, you will be notified. Then page formatting of a spreadsheet, it can be tedious. There can be a lot of things that are needed to set. So general things, but also headers, footers. En as a last thing, how it is scaled, for example, when you do an export as PDF things, you can do it as if it is on the desktop. Then the conditional formatting, for example, this already is a bit longer existing. Maybe it has been extended, but in the toolbar you can choose various conditional formatting formats. They will be applied to the selection in the spreadsheet. I make a little side step, paste special in spreadsheets. That's nothing new, that's there already for a long time. Also allows you to do some special actions. For example, the number 30 here has been copied. You do a page special over the selection and you can choose to subscribe. Also online, the numbers will be changed. Dan, if you do conditional formatting in this example with data bars, you see that the possibilities are all available. Quite new in the spreadsheet is that you can now zoom somewhere between 60 and 100 or 200 percent, 180, 200 percent. That's much more convenient. In spreadsheet grouping of rows and columns to collapse stuff, it's interesting. There are still wishes out there, for example, to freeze the first row in the spreadsheet online. That's still on the wish list. We're not fully there, but editing of charts. It's available both in the sidebar on the right. You can set properties, which can also allow the dialogs to do various things. The last thing for the spreadsheet is the formula editor. Similar to, as available on the desktop, but it allows you to choose formulas. It allows you to look into the structure, find errors, combine functions, et cetera. The next thing is what we are doing here. It's about presentations, master slides. People here that work with presentations now and then that know the use of master slides. A master slide is basically a sort of page style in the presentation. If you change a master slide and the master slide also holds the formatting of the bullet list, for example. En if you change a master slide, all the slides that have it applied will show the new formatting. Now, it's extremely convenient, of course, when you work online that you also can use this functionality there. Also new is that in the side pane on the left you can move, you can drag slides to a new position. Initially, I think, two years ago, a bit longer, when you gave presentations online, you had availability to show them, which is good, which is still there. They showed the slide transition, for example, but that was mostly it. You could do some text and some shaping, but now you have really the options to do a lot of formatting and working on your presentation. This is another thing, header and footer. A last or nearly last thing is editing, of course, in the sidebar of charts, for example, and of shapes. This is a nice thing with LibreOffice project photo and a picture of a Collabora team. These are mostly the features that I get out. They come in LibreOffice code almost by itself, but not really. It's always good to tell people how they can participate. What I understood from the presentation from Simon before here, and it's quite clear, it's always important for the health of open source software that there is money available for people who can maintain it, extend it, improve it, whatever. That's one thing. The other thing is that people can just volunteer and look what they want to work on and where they can contribute. On the Collabora.office website, there's a special page that explains how it works with LibreOffice online, Collabora online snapshots, where you can test. I really want to encourage people to take a look and see what is in it for themselves. What we also encourage is that organizations, especially the large organizations that make use of the tooling, find some partner or some way to pay a little money for the use that they make so that the people that work on the project also can have their salary that they need. It helps the project of course to be healthy and to be sustainable. I have some URLs here about Collabora online, about code to participate and see get free desktop at LibreOffice. All the code is available as well. Thanks for your attention. Any questions, maybe? Suggestions? Yes, please. So how is the Collabora office doing in the Netherlands? Is there any big government or is private institutions running it? I know there are various large organizations that use either Libre or Collabora. So it's a mixed environment. Yes, yes, yes. If you look at CollaboraOffice and LibreOffice, the most difference is the service you get and that it's longer available, that you get special support. And if there are special patches and features, you will get them first as a customer. But in the end, in LibreOffice, in a different schedule and without the support, but all code that is in Collabora is in LibreOffice as well. You can actually compare to that pattern. I think that makes sense. I don't know exactly their schedule, but roughly you're right. And yes, for the Netherlands, I worked there in this environment about 16 years now already. But it doesn't mean that I know everything that's ongoing. Still, you happen to talk with people either private or for a company and you learn that they use it already for five years or whatever. How can you notice? It's also freedom in the sense that people don't have to tell you when they download something and use it. Okay, okay. Thanks. Oh, sorry. Can you use the Collabora in your own environment or do you have to use your service? No, no. There is, for example, a code that you can install with the Docker image and you can install it in its free to use up to 20 users. And then there's a message, okay, you're using something that's for free, but it's not supposed to be used in a larger environment, just for the, et cetera. Anything that I missed? Okay, thank you.