LibreOffice, ownCloud join hands

code

Collabora and ownCloud are well-known names in the open source world. Together they have come up with a VM that runs LibreOffice on ownCloud server. This essentially means you can view and edit presentations, spreadsheets and documents directly on ownCloud. Continue reading LibreOffice, ownCloud join hands

Install LibreOffice 5.0 on Ubuntu

libreoffice_compYou may be aware that LibreOffice 5.0 RC3 arrived a couple of days back. You can download the full suite from the LibreOffice official downloads page. However, a PPA makes life easier and gives you the option to choose and download only the packages you want. Continue reading Install LibreOffice 5.0 on Ubuntu

OnlyOffice: self-hosted office

OnlyOffice is a combination of the quality formatting in MS Office with the flexibility of Google Drive. It is a collaborative office solution that can be used directly from the web browser. While the business strategy is a commercial one there is a free version for non-profit organizations and educational institutions. OnlyOffice suite is freely available (as open source) for download if you are willing to host it yourself.

Security features include AES 256 file encryption, SSL connection, 2-Step verification. Both automatic and manual backup are supported.

The Suite

  • Document Management: share version controlled docs with team and external users
  • Online Document editors: edit documents, spreadsheets, presentations
  • Project Management: take control of projects with wide range of task and time management options
  • Gantt Chart: visualize progress
  • CRM & Invoicing
  • Mail Aggregator
  • Calendar and Instant Messenger

Installation

OnlyOffice Linux version depends on mono, MySQL and nginx. Besides Linux, packages for Docker and Windows are also available. Download OnlyOffice self-hosted version packages and follow the installation instructions linked in the page.

Once installed, visit http://localhost.

Webpage: OnlyOffice

Useful LibreOffice extensions

libreoffice_compLibreOffice has many extensions to boost productivity with the suite. We picked a few of them to share with our readers. You can search and download the extensions from the official extensions website. Try them and let us know your experience.

  • LanguageTool
    A style and grammar proofreading software for English, French, German and many other languages. You can think of LanguageTool as a software to detect errors that a simple spell checker cannot detect, e.g. mixing up there/their, no/now etc. It can also detect some grammar mistakes.
  • Read Text
    Lets an external program or web application read text from Writer, Calc, Draw, Impress, Web Writer or the system clipboard. If you use it to read text aloud, it can help you to edit your writing or to compare your document’s text with a printed document. If you use it with a web application, you can translate your text to another language or check punctuation and grammar. You need eSpeak / Festival / Mbrola on Linux for speech synthesis.
  • AltSearch
    Extension that adds many new features to Writer’s stock find & replace function. Supports regular or extended expressions, various criteria for text search, text containing multiple paragraphs, multiple search and replace and many many more functionalities.
  • Code Colorizer Formatter
    A simple parser is used to identify elements in the supported languages; for example, keywords, literals, comments, and operators. Each element type is set to use a specific character style. The style sets the color used for that portion. Supports Bash, Basic, C++, Java, Perl, PHP, Python, R, SQL, XML, C#, 8085 Assembler, and x86 Assembler.
  • Review Toolbar
    Implements a new Review toolbar with some relevant command buttons that are spread out in various menus and toolbars. The icons represent options to view and edit changes, comments, toggle highlighting, toggle line numbers and clear the document.
  • WebDAV integration
    Allows the user to open and save documents directly on a WebDAV server.
  • TexMaths
    an addon designed to provide LaTeX support into LibreOffice. LaTeX equations can be inserted as images (SVG or PNG formats) and the LaTeX code is saved into the image attribute for further editing.
  • MultiSave
    Save a document simultaneously into OpenDocument and/or MS-Office and/or PDF formats.

Once the .oxt file is downloaded locally, open LibreOffice and navigate to Tools ▸ Extension Manager ▸ Add… and select the extension to install it. Note that some extensions might need JAVA to be installed on your system.

Webpage: LibreOffice Extensions

LibreOffice Viewer Beta debuts on Android

Efforts to port LibreOffice and OpenOffice on Android have been going on for a while now. The first sustainable breakthrough comes from LibreOffice as the Beta Viewer hit the Android market today. There are bugs to be fixed, features to be added, polishing to be done but it’s a welcome first step.

The Viewer can currently recognize and render the following document types:

  • Open Document Format (.odt, .odp, .ods, .ots, .ott, .otp)
  • Microsoft Office 2007/2010/2013 (.docx, .pptx, .xlsx, .dotx, .xltx, .ppsx)
  • Microsoft Office 97/2000/XP/2003 (.doc, .ppt, .xls, .dot, .xlt, .pps)

The app uses the same engine as the desktop LibreOffice and is from the same organization, Collabora. Rendering is a bit slow in the Beta and there are issues with browsing SD card. However, expect these to be fixed soon.

Upcoming releases will see the following features:

  • Interactive document elements (e.g. URLs)
  • Support for browsing external SD storage
  • Many more…

Head on to the Google Play page for LibreOffice Viewer Beta and check it out. Report bugs to help the devs fix them.

Install LibreOffice 4.3 and later on Ubuntu

libreoffice_compUpdate: use the following LibreOffice Fresh PPA to get the latest version of LibreOffice in the 4.x series:

$ sudo apt-add-repository ppa:libreoffice/ppa
$ sudo apt-get update
$ sudo apt-get upgrade

LibreOffice 4.3 is just out and appears to be a great release. While you can download the whole package from the LibreOffice website and install it, Ubuntu standard repos do not have 4.3 at the time of writing. There is a libreoffice PPA from which you can install LibreOffice 4.3 directly. Run the following to install:

$ sudo apt-add-repository ppa:libreoffice/libreoffice-4-3
$ sudo apt-get update
$ sudo apt-get upgrade

While the above PPA hosts the last release candidate (almost same as release version) you can install the latest released version from another PPA meant for LXDE variant of Linux Mint:

$ sudo apt-add-repository ppa:mati75/mint-lxde
$ sudo apt-get update
$ sudo apt-get upgrade

You can also use the LibreOffice Pre-Release PPA (note that this PPA stages aplha, beta and pre-releases, be careful!):

$ sudo apt-get purge libreoffice-core
$ sudo add-apt-repository ppa:libreoffice/libreoffice-prereleases
$ sudo apt-get update
$ sudo apt-get install libreoffice

OpenOffice and LibreOffice on Android

android_compIf you are a heavy open source software user you might crave for some of your favourite desktop applications on Android. How about your office suite? OpenOffice or LibreOffice? Let’s explore the current options.

OpenOffice

Already ported to Android as AndrOpen Office. View or edit your documents at will. All the major components – Writer, Calc, Impress, Draw, Math and Base have been ported. This project is not affiliated to the original Apache project though it is forked from the same codebase.

LibreOffice

This is not ready yet but in progress with daily builds available for testing. Head on to the main page with links to daily builds, developer page etc. Remember that the test builds are not quite something that you’ld like to try out at the time of writing.

View, edit MS Office files in Google Chrome

chrome_compNow it is possible to view and edit MS Office documents in Google Chrome offline using the Office Editing for Docs, Sheets, and Slides extension. Of course, it’s a long and poor choice for an extension name but the functionality is quite useful for users who have to deal with MS Office docs frequently whether they want it or not. The editing features are not as extensive as the MS Office suite yet but the supported features work well. The supported file types are: doc, docx, xls, xlsx, ppt. pptx. Once it is installed all of these types of files can be opened in Google Chrome offline or while browsing.

Google has retired QuickOffice app from Android and this is one of the options Google Chrome has introduced for handling MS Office docs. Download and try it out now!

Webpage: Office Editing for Docs, Sheets, and Slides