Advent Resource #22: PDF Forms Guide

The Leading English Education and Resource Network (LEARN) is a non-profit organization that primarily serves the public and private Anglophone, and Aboriginal, Youth and Adult Education sectors of Québec.

LEARN has developed a short guide for creating a PDF Form using LibreOffice, which has been originally published for version 4.0.5.2 [download PDF], and has been updated a first time for version 4.2.8.2 [download PDF] and a second time for version 5.0.5.2 [download PDF].…

Read More

Advent Resource #21: Solver Tutorial

Solver Tool has the capability to solve linear (and often nonlinear) programming problems, and is available in Microsoft Excel as well as LibreOffice.

edX, an online learning destination and MOOC provider founded by Harvard University and MIT in 2012 and offering high-quality courses from the world’s best universities and institutions to learners everywhere, has developed a tutorial which shows the user how to (1) load the solver into the spreadsheet, (2) define the problem and write out formulas for the objective and constraints, and (3) solve the problem.…

Read More

Advent Resource #20: Introduction to Statistics

downloadDana Lee Ling is a Professor at the College of Micronesia, who – amongst other academic tasks – is teaching students to use LibreOffice Calc to make statistical calculations. To support his lessons, he has published a manual – “Introduction to Statistics Using LibreOffice Calc, AOO Calc and Gnumeric” – based on the following contents: Populations and samples, Measures of middle and spread, Visualizing data, Paired data and scatter diagrams, Probability, Probability distributions, Introduction to the normal distribution, Normal distribution and z-values, Confidence intervals for the mean, Hypothesis testing against a known population mean, and Hypothesis testing two sample means.…

Read More

Advent Resource #19: LibreOffice Macros

coverAndrew Pitonyak has been the great master of StarBasic since forever. I still remember copies of his book being distributed at the 2nd OpenOffice Conference in Berlin, in September 2004, the very first time I was exposed to the global OOo community (and I decided to embark on the journey that has led to the birth of LibreOffice and The Document Foundation).…

Read More

Advent Resource #18: Croscore Fonts

apmicrosoftofficefontsA frequently­ overlooked point of lock­-in with Microsoft Office is its default use of proprietary fonts. Contrary to the popular view, fonts are often not freely distributable, and may in fact be covered by restrictive license terms similar to proprietary software. Microsoft Office by default uses two such fonts: Calibri and Cambria. These fonts are only available in Microsoft Office, and are not freely available for download or use otherwise.…

Read More

Advent Resource #17: Renewed QA Wiki Page

qaQuality Assurance wiki page has been reorganized and updated, and provides a number of resources for people willing to commit their time improving the quality of LibreOffice.

As explained on the Get Involved in QA wiki page: “QA is short for Quality Assurance. QA identifies problems in our software, confirms problems reported by users, and validates proposed fixes and enhancements so each new version of LibreOffice is more reliable and robust and provides our users with a satisfying tool”.…

Read More