Slide 1

Slide 1 text

By Miklos Vajna Head of Professional Services [email protected] Collabora Online & ownCloud What happened in the past year?

Slide 2

Slide 2 text

Collabora Online & ownCloud 2 About Collabora Productivity “We drive LibreOffice Technology to the enterprise, education and administrations. We are the driving force behind putting it in the cloud as Collabora Online, and are part of a global consultancy, specializing in delivering the benefits of Open Source software to the commercial world.”

Slide 3

Slide 3 text

3 Collabora Online & ownCloud Collabora Online 2020/2021 Usability / User Interface File support & Interoperability Performance Features: Writer, Calc, Impress, Draw, Various Mobile Devices Integration ownCloud, improvements to the integration

Slide 4

Slide 4 text

4 Collabora Online & ownCloud Usability / User Interface

Slide 5

Slide 5 text

Collabora Online & ownCloud 5 Crisper rendering, more details TODO - images

Slide 6

Slide 6 text

Collabora Online & ownCloud 6 Eclectic Notebookbar UX choices Can collapse to just a menu

Slide 7

Slide 7 text

Collabora Online & ownCloud 7 Classic mode retained configurable & default

Slide 8

Slide 8 text

8 Collabora Online & ownCloud File support & Interoperability

Slide 9

Slide 9 text

Collabora Online & ownCloud 9 EPUB export in Writer

Slide 10

Slide 10 text

Collabora Online & ownCloud 10 ODF 1.3 support

Slide 11

Slide 11 text

Collabora Online & ownCloud 11 Export spreadsheets to CSV in Calc Thanks to Rizal Muttaqin for the icon design

Slide 12

Slide 12 text

Collabora Online & ownCloud 12 PPTX interop. improvements in Impress Headers / footers and various fields round-tripping nicely (for CERN)

Slide 13

Slide 13 text

Collabora Online & ownCloud 13 Import SmartArt graphics

Slide 14

Slide 14 text

Collabora Online & ownCloud 14 Shape text interoperability wins multi-column text layout in impress bottom-to-top, left-to-right

Slide 15

Slide 15 text

Collabora Online & ownCloud 15 Custom Geometry & image effects

Slide 16

Slide 16 text

16 Collabora Online & ownCloud Performance

Slide 17

Slide 17 text

Collabora Online & ownCloud 17 Tilebench – test & optimize

Slide 18

Slide 18 text

18 Collabora Online & ownCloud Fixes & features & more

Slide 19

Slide 19 text

19 Collabora Online & ownCloud Writer

Slide 20

Slide 20 text

Collabora Online & ownCloud 20 Drop down lists in form fields

Slide 21

Slide 21 text

Collabora Online & ownCloud 21 Gutter Margins Useful for e.g. Government binding standards

Slide 22

Slide 22 text

Collabora Online & ownCloud 22 Control of anchoring and text flow Accurately position anchor-points for images and objects to control layout & reflow

Slide 23

Slide 23 text

23 Collabora Online & ownCloud Calc

Slide 24

Slide 24 text

Collabora Online & ownCloud 24 Freeze panes Freeze columns or rows to navigate more easily through large spreadsheets

Slide 25

Slide 25 text

Collabora Online & ownCloud 25 Improved sheet movement

Slide 26

Slide 26 text

Collabora Online & ownCloud 26 Customize & create Pivot Tables

Slide 27

Slide 27 text

Collabora Online & ownCloud 27 Define & manage range names Print ranges as well!

Slide 28

Slide 28 text

Collabora Online & ownCloud 28 Improved chart editing in sidebar brings this to mobile phones too

Slide 29

Slide 29 text

Collabora Online & ownCloud 29 Statistical tools for data analysis Sampling Descriptive Statistics Analysis of Variance (ANOVA) Correlation Covariance Exponential Smoothing Moving Average Regression Paired t-test F-test Z-test Chi-square Test

Slide 30

Slide 30 text

30 Collabora Online & ownCloud Impress

Slide 31

Slide 31 text

Collabora Online & ownCloud 31 More powerful tables Including shades

Slide 32

Slide 32 text

Collabora Online & ownCloud 32 Table shadows

Slide 33

Slide 33 text

Collabora Online & ownCloud 33 Edit Header and Footer in Online

Slide 34

Slide 34 text

Collabora Online & ownCloud 34 Improved Presentation viewing Continuous scroll through of slides in a single large scrollable pane

Slide 35

Slide 35 text

35 Collabora Online & ownCloud Draw

Slide 36

Slide 36 text

Collabora Online & ownCloud 36 New module: Draw Flowcharts, technical drawings, posters or brochures… create vector graphic drawings online!

Slide 37

Slide 37 text

Collabora Online & ownCloud 37 Drawing Online - Connectors ... Shapes, Glue points, Connectors

Slide 38

Slide 38 text

38 Collabora Online & ownCloud Various

Slide 39

Slide 39 text

Collabora Online & ownCloud 39 Writer, Calc, Impress: Fontwork Wavy & complex 3D text

Slide 40

Slide 40 text

Collabora Online & ownCloud 40 PDF Search and Annotation 97% Online commits By aff i liation (last year) Collabora 5 | 15 | 21 | 28 | Others CIB 1&1 Volunteers Collaboration on PDF files

Slide 41

Slide 41 text

Collabora Online & ownCloud 41 VBA / StarBasic Macros Online Disabled by default, administrators can enable, and set a security level

Slide 42

Slide 42 text

42 Collabora Online & ownCloud Integration – Server side

Slide 43

Slide 43 text

Collabora Online & ownCloud 43 Design language / theming bits ... https://www.collaboraoffice.com/collabora-online-styleguide/styleguide.html

Slide 44

Slide 44 text

Collabora Online & ownCloud 44 Design results

Slide 45

Slide 45 text

45 Collabora Online & ownCloud Mobile Devices

Slide 46

Slide 46 text

Collabora Online & ownCloud 46 Mobile phone & tablets updates ● Page set-up panel ● Tabstops handling on ruler ● Word Count dialog menu ● Table dialog from menu on tablet Collabora Office for Android & iOS

Slide 47

Slide 47 text

Collabora Online & ownCloud 47 ● New NotebookBar on tablets ● CJK font support ● Dark mode (starting) ● Opening password protected documents ● Pivot tables (on tablets) ● Faster document handling Mobile phone & tablets updates .. 2 Collabora Office for Android & iOS

Slide 48

Slide 48 text

Collabora Online & ownCloud 48 ChromeBook support Check out our blog for more information Collabora Office providing … the best tool for the Education sector ● User control of documents on Chrome OS ● Rich office productivity tool ● Users choice of storage ● Regain control over files and privacy ● Privacy Shield / digital sovereignty ● Education: affordable PCs, and protect privacy from students ● No need to use Microsoft or Google anymore

Slide 49

Slide 49 text

Collabora Online & ownCloud 49 ChromeBook .. 2 Excellent interoperability, rich editing & handsome interface

Slide 50

Slide 50 text

Part of the awesome team serving you Looking forward to meet in person next year!

Slide 51

Slide 51 text

Thanks for listening & your support! Miklos Vajna @CollaboraOffice [email protected] Collaboraoffice.com [email protected]