1. 7 LibreOffice Tips To Get More Out Of It - It's FOSS
2. Cached

Brew cask install libreoffice: brew cask install macvim: brew cask install paw: brew cask install sequel-pro: brew cask install slack: brew cask install sourcetree. 7.0.5 This version is slightly older and does not have the latest features, but it has been tested for longer. For business deployments, we strongly recommend support from certified partners which also offer long-term support versions of LibreOffice.

Released:

Pythonic interface to Apache OpenOffice API (UNO)

Project description

PyOO allows you to control a running OpenOffice or LibreOfficeprogram for reading and writing spreadsheet documents.The library can be used for generating documents in variousformats – including Microsoft Excel 97 (.xls),Microsoft Excel 2007 (.xlsx) and PDF.

The main advantage of the PyOO library is that it can use almost anyfunctionality implemented in OpenOffice / LibreOffice applications.On the other hand it needs a running process of a office suiteapplication which is significant overhead.

PyOO uses UNO interface via Python-UNO bridge. UNO is astandard interface to a running OpenOffice or LibreOfficeapplication. Python-UNO provides this interface in Python scripts.Direct usage of UNO API via Python-UNO can be quite complicatedand even simple tasks require a lot of code. Also many UNO callsare slow and should be avoided when possible.

PyOO wraps a robust Python-UNO bridge to simple and Pythonicinterface. Under the hood it implements miscellaneousoptimizations which can prevent unnecessary expensive UNOcalls.

Available features:

• Opening and creation of spreadsheet documents
• Saving documents to all formats available in OpenOffice
• Charts and diagrams
• Sheet access and manipulation
• Formulas
• Cell merging
• Number, text, date, and time values
• Cell and text formating
• Number formating
• Locales

If some important feature missing then the UNO API is always available.

Prerequisites

PyOO runs on both Python 2 (2.7+) and Python 3 (3.3+) but latest LibreOfficereleases are likely to support Python 3 only.

The only dependency is the Python-UNO library (imported as a module uno).Unfortunately Python-UNO cannot be installed using pip.Do NOT install package named uno available on PyPI - it’s not related to LibreOffice.

Debian / Ubuntu

On Debian based systems Python-UNO can by installed as python3-uno package.

Obviously you will also need OpenOffice or LibreOffice Calc.On Debian systems it is available as libreoffice-calc package.

macOS

Install LibreOffice, for example using cask:

Then use Python binary bundled with the installed application:

Installation

PyOO library can be installed from PYPI using pip.:

If you downloaded the code you can install it using the setup.py script:

Alternatively you can copy the pyoo.py file somewhere to your PYTHONPATH.

Usage

Starting OpenOffice / LibreOffice

PyOO requires a running OpenOffice or LibreOffice instance whichit can connect to. On Debian you can start LibreOffice froma command line using a command similar to:

The LibreOffice will be listening for localhost connectionon port 2002. Alternatively a named pipe can be used:

If the --headless option is used then no user interface isvisible even when a document is opened.

For more information run:

It is recommended to start directly the soffice binary.There can be various scripts (called for example libreoffice)which will run the soffice binary but you may not get thecorrect PID of the running program.

Accessing documents

PyOO acts as a bridge to a OpenOffice.org program so a connectionto the running program has to be created first:

Host name and port number used in the example ('localhost', 2002)are default values so they can be omitted.

Connection to a named pipe is also possible:

New spreadsheet document can be created using Desktop.create_spreadsheet()method or opened using Desktop.open_spreadsheet():

If the office application is not running in the headlessmode then a new window with Calc program should open now.

Sheets

Spreadsheet document is represented by a SpreadsheetDocument class whichimplements basic manipulation with document. All data are in sheetswhich can can be accessed and manipulated via SpreadsheetDocument.sheetsproperty:

Cells can be accessed using index notation from a sheet:

All the changes should be visible in the opened document.

Every operation with a cell takes some time so setting all values separatelyis very ineffective. For this reason operations with whole cell rangesare implemented:

Formating

Miscellaneous attributes can be set to cells, cell ranges and sheets(they all inherit a CellRange class). Also note that cell rangessupport many indexing options:

Number format can be also set but it is locale dependent:

Charts

Charts can be created:

The first argument is a chart name, the second argument specifieschart position and the third one contains address of source data(it can be also a list or tuple). If optional row_header orcol_header keyword arguments are set to True then labelswill be read from first row or column.

Existing charts can be accessed either by an index or a name:

Chart instances are generally only a container for diagrams which specifyhow are data rendered. Diagram can be replaced by another type while chartstays same.

Diagram instance can be used for accessing and setting ofmiscellanous properties.

Saving documents

Spreadsheet documents can be saved using save method:

And finally do not forget to close the document:

Testing

Automated integration tests cover most of the code.

The test suite assumes that OpenOffice or LibreOffice is running andit is listening on localhost port 2002.

All tests are in the test.py file:

License

This library is released under the MIT license. See the LICENSE file.

Release historyRelease notifications | RSS feed

1.4

1.3

1.2

1.1

1.0

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Hashes for pyoo-1.4-py2-none-any.whl

Hashes for pyoo-1.4.tar.gz

This effort would not have been possible without the welcomed and ongoing assistance of Beta testers selected from among the members of the 'Home Brew Talk' forum. A number of their excellent suggestions have been incorporated into 'Mash Made Easy'.

Visit the 'Home Brew Talk' forum at: http://www.homebrewtalk.com

Note: Mash Made Easy is a free spreadsheet that is complete and fully functional. It operates within Excel 2007 and later, LibreOffice, and Google Sheets. Visit our 'Downloads' page to acquire your free copy. After use, if you find that you appreciate its usefulness and simplicity, and you wish to contribute to the maintenance and upgrading of this software, please visit our 'Contributions'page.

Changes or additions since the last release:

--------------------------------------------------------------------------------------------------------------------------

Version 10.0 : Release Date 2/28/2021

Added features to the 'Water' tab/sheet

Version 10.1 : Release Date 4/14/2021

A) Version 10.1 greatly simplified grist component selection via eliminating all of the various Malted and Unmalted Barley Grain categories and simply lumping all of these together under a single drop-down called 'Non Categorized'. Caramel/Crystal malts and Carapills malts are now combined and categorized as 'Crystal/Carapills' under a single drop-down. Drop-down categories still exist for grist components such as Wheat and Rye, the various of Flaked grains, Acid Malt, Melanoidin/Honey, and MaltoDextrin/Sugar.

The justification for this radical change and simplification (in keeping with the name 'Malt Made Easy' is twofold. First, I have honed and refined a set of algorithms worthy of handling the pHDI and BC (buffering capacity, malt acidity) of all non Crystal barley based grains (malted and unmalted) into a single category, and likewise a set of algorithms worthy of handling Caramel/Crystal and Carapils pHDI's and BC's. Second, the scant real pHDI and BC data extant today from sources that you can count on with the fingers of one hand is simply terrible and incomplete, as well as not fully unified between testers, so those touting hundreds of various malt and/or unmalted grain valuations for critical pHDI and BC values are for the most part either pulling these values straight out of thin air, and or cherry picking and cross applying the scant data to malts/grains never tested while applying loads of confirmation bias and yet more cherry picking and averaging and guessing, etc... anyway, so why not revamp and refine math model means to accomplish all of this?

B) MME now defaults the Kolbach denominators for mash water Ca and Mg ions to 7 and 14 respectively whereby to attain better agreement with the findings of AJ deLange, and also somewhat better compliance with the quite variable findings of chemists Barth and Zaman as regards downward shift within the mash due to calcium and magnesium ions in the mash water.

7 LibreOffice Tips To Get More Out Of It - It's FOSS

Version 10.15 : Release Date 4/15/2021

Notable cosmetic improvement to the individual grist component addition drop-down section as can be seen within the snapshot above. No other changes from version 10.1

Version 10.20 : Release Date 4/15/2021

Fixed 'Acidulated Malt' related errors as relate to Acid Malt entry via the grist component drop-down section.

Version 10.20 : Release Date 4/15/2021

Fixed a major bug with respect to mineralization quantities. All users must transition to this release.

Cached

Email: mashrite55@gmail.com