Collabora Online & ownCloud

ownCloud Conference 2021, Virtual

Video record: https://www.youtube.com/watch?v=j7rHbPeolvQ

Transcript

1. By Miklos Vajna
   Head of Professional Services
   vmiklos@collabora.com
   Collabora Online & ownCloud
   What happened in the past year?
   

   View Slide

2. 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.”
   

   View Slide

3. 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
   

   View Slide

4. 4
   Collabora Online & ownCloud
   Usability / User Interface
   

   View Slide

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

   View Slide

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

   View Slide

7. Collabora Online & ownCloud 7
   Classic mode retained
   configurable & default
   

   View Slide

8. 8
   Collabora Online & ownCloud
   File support &
   Interoperability
   

   View Slide

9. Collabora Online & ownCloud 9
   EPUB export in Writer
   

   View Slide

10. Collabora Online & ownCloud 10
    ODF 1.3 support
    

    View Slide

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

    View Slide

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

    View Slide

13. Collabora Online & ownCloud 13
    Import SmartArt graphics
    

    View Slide

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

    View Slide

15. Collabora Online & ownCloud 15
    Custom Geometry & image effects
    

    View Slide

16. 16
    Collabora Online & ownCloud
    Performance
    

    View Slide

17. Collabora Online & ownCloud 17
    Tilebench – test & optimize
    

    View Slide

18. 18
    Collabora Online & ownCloud
    Fixes & features & more
    

    View Slide

19. 19
    Collabora Online & ownCloud
    Writer
    

    View Slide

20. Collabora Online & ownCloud 20
    Drop down lists in form fields
    

    View Slide

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

    View Slide

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

    View Slide

23. 23
    Collabora Online & ownCloud
    Calc
    

    View Slide

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

    View Slide

25. Collabora Online & ownCloud 25
    Improved sheet movement
    

    View Slide

26. Collabora Online & ownCloud 26
    Customize & create Pivot Tables
    

    View Slide

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

    View Slide

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

    View Slide

29. 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
    

    View Slide

30. 30
    Collabora Online & ownCloud
    Impress
    

    View Slide

31. Collabora Online & ownCloud 31
    More powerful tables
    Including shades
    

    View Slide

32. Collabora Online & ownCloud 32
    Table shadows
    

    View Slide

33. Collabora Online & ownCloud 33
    Edit Header and Footer in Online
    

    View Slide

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

    View Slide

35. 35
    Collabora Online & ownCloud
    Draw
    

    View Slide

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

    View Slide

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

    View Slide

38. 38
    Collabora Online & ownCloud
    Various
    

    View Slide

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

    View Slide

40. 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
    

    View Slide

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

    View Slide

42. 42
    Collabora Online & ownCloud
    Integration – Server side
    

    View Slide

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

    View Slide

44. Collabora Online & ownCloud 44
    Design results
    

    View Slide

45. 45
    Collabora Online & ownCloud
    Mobile Devices
    

    View Slide

46. 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
    

    View Slide

47. 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
    

    View Slide

48. 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
    

    View Slide

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

    View Slide

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

    View Slide

51. Thanks for listening
    & your support!
    Miklos Vajna
    @CollaboraOffice
    hello@collaboraoffice.com
    Collaboraoffice.com
    vmiklos@collabora.com
    

    View Slide