Online Open Document Editing New Possibilities
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Nouws, Cor
Open Document editing is, as many things in life, more and more an online action. Collabora introduced the important first steps in 2015. Since then much work has been done and LibreOffice and Collabora Online grew enormously in possibilities. This presentation will guide you trough the various areas. And in the Q&A, lets talk about expectations for the future.
 Hello, yeah. Welcome with my 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. So 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 LibreOff, since 2004, all kind of voluntary stuff and a known company and since 2019, last year, I've helped them collaborate with marketing and it also has to do with how 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. 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 Collaboration line. 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 in online has an enormous amount of settings that you can do. So in this case, it's a shape that is selected and you have the colors and you have also a custom color picker that is available in online nowadays. Another 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. And this is an example of a Microsoft Office file that's just loaded in Collaborer 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. Next thing that has been nicely improved is easier, is the handling of images and 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? You tried and you failed or the software failed? That's exceptional. But the thing you tried was really complicated or it was an early version or maybe? I think you're overestimating my talent so it wasn't complicated. It's interesting now that we talk about this. You see 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 but I think when you have some speech work to do with huge documents, etc., 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 and oh yeah there you see the various handles indicated. Table of content, if there's a table of content you can do a refresh so 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 or Microsoft X file where you can add a protected section. Oh welcome with your bicycle. And 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, Colabora online. 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 and 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. If you try to change something that's protected it will just fail and you will get notified. And validation. Most people know it anyway. Those people working with spreadsheet online it's just available. And 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 and 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 and 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 and you do a paste special over the selection and you can choose to subscribe. And so also online the numbers will be changed. And then if you do conditional formatting in this example with data bars you see that the possibilities are all available. What 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. And in spreadsheet grouping of rows and columns to collapse stuff it's interesting. It still wishes out there for example to freeze the first row in the spreadsheet online that's still on the wish list. So 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. And 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, etc. 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. Master slide is basically a sort of page style in the presentation and if you change a master slide and the master slide also holds the formatting of the bullet lists for example and 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. So where initially I think two years ago but longer when you gave presentations online you had availability to show them which is good which is still there and they show the slide the slide transition for example but that was mostly it you could do some text and some shaping but now yes really the options to do a lot of formatting and working on your presentation. This is another thing header and footer and a last or nearly last thing is editing of course in the sidebar of charts for example and of shapes and this is a nice thing with LibreOffice project photo and a picture of a collaborator team. And this are mostly the features that I get out they come in LibreOffice code almost by itself but not really so 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. So 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 collaborator office website there's a special page that explains how it works with LibreOffice online, Collaboration online snapshots where you can test and 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. And it helps the project of course to be healthy and to be sustainable. And I have some URLs here about Collaboration online about code to participate and see get free desktop work at LibreOffice, there all the code is available as well. Thanks for your attention. Any questions maybe? Suggestions? Yes please. I know there are various large organizations that use either Libre or Collabor. So it's a mixed environment. Yeah, yeah, yeah. If you look at Collaboration 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 support but all code that is in Collabor is in LibreOffice as well. You can actually compare to the other set. I think that makes sense. I don't know exactly their schedule but roughly you're right. And yes for the Netherlands I work there in this environment about 16 years now already and 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 Collabor in your own environment or do you have to use your service? There is for example code that you can install with Docker image and you can install it and it's 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 larger environments just for the etc. Anything that I missed? Okay, thank you.
 Hello, yeah.  Welcome with my 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.  So 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 LibreOff,  since 2004, all kind of voluntary stuff and a known company and since 2019, last year,  I've helped them collaborate with marketing and it also has to do with how 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.  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 Collaboration  line.  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 in online has an enormous amount  of settings that you can do.  So in this case, it's a shape that is selected and you have the colors and you have also  a custom color picker that is available in online nowadays.  Another 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.  And this is an example of a Microsoft Office file that's just loaded in Collaborer 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.  Next thing that has been nicely improved is easier, is the handling of images and 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?  You tried and you failed or the software failed?  That's exceptional.  But the thing you tried was really complicated or it was an early version or maybe?  I think you're overestimating my talent so it wasn't complicated.  It's interesting now that we talk about this.  You see 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 but I think  when you have some speech work to do with huge documents, etc., 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 and oh yeah there you  see the various handles indicated.  Table of content, if there's a table of content you can do a refresh so 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 or Microsoft X file where you can  add a protected section.  Oh welcome with your bicycle.  And 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, Colabora online.  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 and 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.  If you try to change something that's protected it will just fail and you will get notified.  And validation.  Most people know it anyway.  Those people working with spreadsheet online it's just available.  And 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 and 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 and 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 and you do a paste special over the selection  and you can choose to subscribe.  And so also online the numbers will be changed.  And then if you do conditional formatting in this example with data bars you see that  the possibilities are all available.  What 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.  And in spreadsheet grouping of rows and columns to collapse stuff it's interesting.  It still wishes out there for example to freeze the first row in the spreadsheet online that's  still on the wish list.  So 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.  And 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, etc.  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.  Master slide is basically a sort of page style in the presentation and if you change a master  slide and the master slide also holds the formatting of the bullet lists for example  and 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.  So where initially I think two years ago but longer when you gave presentations online  you had availability to show them which is good which is still there and they show the  slide the slide transition for example but that was mostly it you could do some text  and some shaping but now yes really the options to do a lot of formatting and working on your  presentation.  This is another thing header and footer and a last or nearly last thing is editing of  course in the sidebar of charts for example and of shapes and this is a nice thing with  LibreOffice project photo and a picture of a collaborator team.  And this are mostly the features that I get out they come in LibreOffice code almost by  itself but not really so 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.  So 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 collaborator office website there's a special page that explains how it works  with LibreOffice online, Collaboration online snapshots where you can test and 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.  And it helps the project of course to be healthy and to be sustainable.  And I have some URLs here about Collaboration online about code to participate and see get  free desktop work at LibreOffice, there all the code is available as well.  Thanks for your attention.  Any questions maybe?  Suggestions?  Yes please.  I know there are various large organizations that use either Libre or Collabor.  So it's a mixed environment.  Yeah, yeah, yeah.  If you look at Collaboration 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 support but all code  that is in Collabor is in LibreOffice as well.  You can actually compare to the other set.  I think that makes sense.  I don't know exactly their schedule but roughly you're right.  And yes for the Netherlands I work there in this environment about 16 years now already  and 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 Collabor in your own environment or do you have to use your service?  There is for example code that you can install with Docker image and you can install it and  it's 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 larger environments just for the  etc.  Anything that I missed?  Okay, thank you.
online_open_document_editing_new_possibilities_0_143.png online_open_document_editing_new_possibilities_144_1283.png online_open_document_editing_new_possibilities_1284_2483.png online_open_document_editing_new_possibilities_2484_2723.png online_open_document_editing_new_possibilities_2724_3167.png online_open_document_editing_new_possibilities_3168_3803.png online_open_document_editing_new_possibilities_3804_4895.png online_open_document_editing_new_possibilities_4896_5147.png online_open_document_editing_new_possibilities_5148_6575.png online_open_document_editing_new_possibilities_6576_7223.png online_open_document_editing_new_possibilities_7224_7523.png online_open_document_editing_new_possibilities_7524_10727.png online_open_document_editing_new_possibilities_10728_11159.png online_open_document_editing_new_possibilities_11160_11483.png online_open_document_editing_new_possibilities_11484_13415.png online_open_document_editing_new_possibilities_13416_13583.png online_open_document_editing_new_possibilities_13584_15215.png online_open_document_editing_new_possibilities_15216_15875.png online_open_document_editing_new_possibilities_15876_17279.png online_open_document_editing_new_possibilities_17280_17747.png online_open_document_editing_new_possibilities_17748_18347.png online_open_document_editing_new_possibilities_18348_18803.png online_open_document_editing_new_possibilities_18804_19535.png online_open_document_editing_new_possibilities_19536_19739.png online_open_document_editing_new_possibilities_19740_21023.png online_open_document_editing_new_possibilities_21024_21299.png online_open_document_editing_new_possibilities_21300_22391.png online_open_document_editing_new_possibilities_22392_22691.png online_open_document_editing_new_possibilities_22692_23423.png online_open_document_editing_new_possibilities_23424_25943.png online_open_document_editing_new_possibilities_25944_30599.png online_open_document_editing_new_possibilities_30600_30722.png