The Brazilian Community launches the LibreOffice 7.0 Getting Started Guide in Portuguese

Timothy Brennan Jr.

The Brazilian LibreOffice community is pleased to announce availability of the LibreOffice 7.0 Getting Started Guide in Brazilian Portuguese.

Guia de Introdução
Guia de Introdução 7.0

The guide is intended for Portuguese speaking users who wants to begin their first contact with LibreOffice and needs a manual that expounds all the software’s  features and allows them to immediately start some sophisticated tasks.

The Getting Started Guide describes the important concepts that guided the development of LibreOffice and presents each of its modules: spreadsheets (Calc), presentations (Impress), vector drawings (Draw), texts (Writer), equations (Math), and databases (Base). In addition to these modules, there are several chapters describing important concepts common to all modules such as styles, printing, electronic signature, macros, exporting in various formats, redacting, and document classification.

Making the Getting Started Guide available is the teamwork of Brazilians LibreOffice enthusiasts who have gone to great lengths to produce a comprehensive and accessible guide. The guide is a translation of the guide from English, this time using automatic translation, but with a thorough review of the result by the team, who put in great effort to confirm the concepts presented, but also to improve the Portuguese generated by the automatic translation. The next editions of the Getting Started Guide will be done without translation, but by writing directly in Portuguese the new information introduced in the new versions of LibreOffice.

Vera Cavalcante

“I have dedicated myself intensely in the LibreOffice community, putting effort into the LibreOffice Magazine project of which I was one of the publishers. This edition of the Getting Started Guide was a great opportunity to get back to interacting with LibreOffice and meet new people with the same interest, in a voluntary work context.”, stated Vera Cavalcante, a member of the Brazilian LibreOffice community. “I am very meticulous, and helped correct some translations and (a few) inconsistencies in the software during the process of revising the Guide. In the end, we have better software ”, she added.

Jackson Cavalcanti Jr.

“Joining the translation and proofreading team for the Getting Started Guide was an opportunity to get back to interacting with the LibreOffice community, returning to my participation I had started years ago. The opportunity was very rewarding, not only for self-improvement in the use of the LibreOffice suite but also to learn a lot about document writing.”, said Jackson Cavalcanti Jr. “I used the opportunity to instigate debates about the terms used and the technical vocabulary in Brazilian Portuguese, which allowed me to review some terms used in the software and improve the translation of the LibreOffice suite.” he added.

Timothy Brennan Jr.

“I participated as a novice in the effort of the Getting Started Guide and could see the seriousness of the work and the good spirit of collaboration in the Brazilian team. It has been a teamwork lesson where questions were answered promptly and, at the same time, I learned a lot about elaborating complex documents.”, said Timothy Brennan Jr., a team member. “I have dedicated myself to reviewing some chapters of the Getting Started Guide (Chapters 8, Getting Started with Base and, 10, Print, Export, Send, and Sign). Now I consider myself an expert in LibreOffice as well as any other office suite. It has also been an important professional gain”.

Flávio Schefer

“I am also new to free software projects and revieweing the Getting Started Guide was an opportunity to team up with the Brazilian team and acquire knowledge,” said Flávio Schefer. “I was in a career transition and the knowledge and practices acquired in the team’s work was important during this period”, he added.

Felipe Viggiano, Raul Pacheco da Silva, Túlio Macedo and Olivier Hallot  also participated in the effort.

Felipe Viggiano, Raul Pacheco da Silva, Túlio Macedo e Olivier Hallot

Download the Getting Started Guide in PDF format now (in Brazilian Portuguese) by visiting our library at https://documentation.libreoffice.org/pt-br/portugues/

Community Member Monday: Rafael Lima

Today we’re talking to Rafael Lima, who helps the LibreOffice project by updating its documentation…

To start with, tell us a bit about yourself!

I am a university professor in Brazil, and I teach and research optimization applied to management sciences. In my work I often need to write papers and prepare spreadsheets to analyze data, and for that I’ve been using LibreOffice for over a year now. I have been working with supply chain optimization problems such as vehicle routing, network design and facility location.

I have always been an enthusiast of Open Source, since my undergraduate days in 2001. At the time I started using Linux and most of my current research work is done using FOSS tools. The dynamics of how open source software is developed is a topic that has always caught my attention.

Outside of work, I like to spend my free time practicing sports (mostly playing tennis) and whenever I have the opportunity I like to travel to new places. And obviously, like many tech enthusiasts, I like gaming too!

What are you working on in the documentation project right now?

The Documentation Team is currently working on the guides for the LibreOffice 7 series, and I am helping update and review some chapters in these guides. I have recently updated the Getting Started Guide chapters on Math and Macros.

Besides that, I have recently started writing a Macro tutorial focused on LibreOffice Calc, to help Calc users to get started with Basic programming and develop their own macros and functions. I hope to cover many aspects of Basic programming in Calc, ranging from reading and writing data from cells, formatting, dialog creation and writing extensions. If all goes well, I hope to finish the tutorial by February and release it to the community. If anyone wants to follow the development of the tutorial, it is available on my GitHub page.

How did you get started in the LibreOffice community? What was the experience like?

I started contributing to the Documentation Team after I read a blog post by TDF saying that they were looking for volunteers to help update the guides for LibreOffice 7. Then I joined the mailing list and I was welcomed and instructed by Olivier Hallot on the workflow of the Documentation Team.

After going over the Wiki and the Contributor’s Guide, I started updating the Math Guide. It was a very nice experience, because all questions I had were promptly answered by other members of the team and I was able to learn quickly how work gets done.

After finishing the Math guide I kept on contributing with other guides, mainly the Getting Started Guide and the Writer’s Guide.

Anything you’d recommend to newcomers in the docs project?

My work in the Documentation Team was my first real experience with an open source project, and it was a great opportunity to learn how open source really works. It’s amazing to see how the LibreOffice community is capable of delivering high-quality applications and documentation.

As a newcomer I was afraid I was not going to be able to tackle the complexities of such a huge project as LibreOffice. However, being a large project means that LibreOffice has a large community to support new contributors.

From a more practical standpoint, my recommendation for newcomers is to start by reading the Contributor’s Guide, and then choose one of the LibreOffice applications to which you would like to contribute. Also, join the mailing list, introduce yourself and more experienced members will be glad to explain how contributions can be made.

Many thanks to Rafael for all his contributions! And for everyone reading this who wants to build up skills for a potential career in technical writing, join our community, gain experience, and meet new people!

Getting Started with LibreOffice 7.0 Guide Just Arrived!

Get the LibreOffice introductory Guide and start producing professional documents.

The Documentation Team is happy to announce the immediate availability of the LibreOffice 7.0 Getting Started Guide, updated to include all LibreOffice 7.0 features.

The guide is written for anyone who wants to get up to speed quickly with LibreOffice. Readers may be new to office software, or may be familiar with another office suite. This guide is a valuable asset for all users.

LibeOffice Getting started Guide 7.0

(more…)

Community Member Monday: Steve Fanning

LibreOffice has extensive documentation in many languages, thanks to the great work of our worldwide docs community. Today we’re talking to Steve Fanning, who has been working on the updated LibreOffice Calc Guide

Hi Steve! Tell us a bit about yourself…

I live near Bolton in the North West of England with my wife and, sometimes, our adult son (he has recently been working in Australia for a year). I studied applied mathematics and theoretical physics at university and subsequently enjoyed a career mostly spent implementing and designing complex real-time software systems.

Passionate about improving the documentation for the company’s systems, I moved into specialist technical writer roles during the last few years of my employment. I retired around two years ago and now enjoy indulging in my main hobbies, which are bridge, computing, reading and coarse fishing. I guess that some readers might wonder about coarse fishing – it is angling for freshwater fish for pleasure and relaxation rather than food (all fish caught are returned to the water alive).

What are you doing in the LibreOffice project?

On retirement, I wanted to maintain and develop my technical writing skills and after some research, decided to join the LibreOffice Documentation Team. I immediately dived into the deep end, updating some of the more challenging chapters of the Calc Guide in preparation for the 6.2 issue. Since then I seem to have been digging deeper into Calc, coordinating the publication of the 6.4 Calc Guide, and updating many of the chapters for the 7.0 Calc Guide. I have also enjoyed creating an area on The Document Foundation’s wiki to describe Calc’s 500+ functions in more detail.

Why did you decide to become a member of The Document Foundation, the non-profit entity behind LibreOffice?

When the opportunity arose, I was delighted to become a member of TDF. I am hoping that it will make me more aware of the strategies of the organisation and, if appropriate, provide greater opportunity to influence those strategies. And who could resist the offer of a free @libreoffice.org email address?

What else are you working on, and is there any other area that interests you?

Currently most of my LibreOffice time is taken up supporting and mentoring Ronnie Gandhi, who is a technical writer helping us under the Google Season of Docs 2020 programme. His task is to populate many of the pages within the Calc Functions wiki area and I am reviewing his work and providing comments and other feedback as appropriate. Many of these functions are quite complex and require some research before raising comments but I am finding the whole experience very educational.

As for the future, it is hard to look too far ahead as we are all enduring the COVID-19 pandemic and the resulting restrictions and lockdowns. With lots of free time on my hands, I have been grateful to have interesting LibreOffice work to occupy myself and keep my brain ticking over. In the future I hope to continue to help keep our guides up to date, continue developing the Calc Functions wiki area, and would also like to get more involved in maintaining the help system.

Many thanks to Steve for all his work, and mentoring other contributors – this all helps millions of LibreOffice users around the world! Indeed, joining the documentation project is a great way to contribute back to LibreOffice, build up skills and meet new people in the community. Join in and give us a hand!

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

Make better presentations with the Impress Guide 7.0

Do you use LibreOffice Impress? Want to do more with your presentations? Check out the brand new Impress Guide 7.0 update, created by our awesome documentation community:

This 330-page book explores the basics of Impress, before moving on to master slides, styles, templates, graphic objects, effects, exporting in various formats, and much more. Download the PDF version here!

Who made this happen?

Answer: our community! Many thanks to Peter Schofield, Felipe Viggiano, Claire Wood, Regina Henschel, Dave Barton, Jean Hollis Weber, Samantha Hamilton and Olivier Hallot for their work on it.

We asked Peter to summarise his experiences as he updated the text:

I am experienced with LibreOffice in creating documents. Also, I have had over 30 years of experience as a Technical Writer in many fields of engineering, construction, electronics and software. However, I am not experienced in creating presentations, so writing the user guide was an experience and I now know more about creating presentations.

Did I enjoy it? Yes, because I enjoy having a challenge when writing instructions. Also, it gave me the opportunity to write the guide from the perspective of a novice in using presentation software. I do find that in some of the other LibreOffice guides, taking the novice view has been forgotten.

And what about newcomers to the documentation project – how can they get started? Peter adds:

The main tip for all contributors to LibreOffice is to write a software user guide assuming that a novice will be using the guide to help them become more experienced in using the software. Make it easier for users to understand, which will in turn make LibreOffice more popular as it gets recommended.

Write a user guide in a Simplified English, so that it becomes easier to translate and easier for non-English speakers to use an English-language user guide. Simplified English is used in the aviation industry and is a good standard to adopt for the LibreOffice team, but needs very tight control to be successful.

Thanks again to Peter and everyone else in the documentation team for the update. And everyone is welcome to give them a hand – it’s a great way to contribute back to LibreOffice, understand the software better, and build up skills for potential career options in technical writing!

Google Seasons of Doc 2020: Extensive Calc Functions Description is there.

The Calc Guide for LibreOffice release 6.2 contained a lengthy appendix (70 pages) devoted to the 500+ functions available in Calc, providing a shallow list of the functions and their arguments. During the update of the document for release 6.4 in 2019, the Documentation Team agreed that it would be better to move this list to an online service, and as part of this move, to enhance the function descriptions by adding more examples, use cases and collateral information on standards, compatibility and more.

That situation provided an opportunity for us to create a documentation project to submit to Google Season of Documents 2020 (https://developers.google.com/season-of-docs), an initiative by Google to create, enhance and extend the documentation of open source projects worldwide such as LibreOffice.

The Document Foundation applied to the program on behalf of the LibreOffice Community and submitted several ideas for documentation, which included the Extensive Calc Functions Wiki pages. The Foundation received several applications, containing important information including the technical writer’s resumés, proposals for project schedule and suggested deliverables. After a careful evaluation by the project mentors, the Foundation retained the application of Ronnie Gandhi (@Krezhairo) a computer science undergraduate student enrolled at IIT Roorkee, India.

The project was targeted for three months work and ended in early December 2020. Steve Fanning, who had already worked as coordinator of the Calc Guide, served as mentor with Olivier Hallot as second mentor. Ilmari Lauhakangas and Olivier managed the administrative aspects of the project on behalf of The Document Foundation.

Monitoring the project was an important part of the task. There was frequent correspondence on the Documentation Team’s mailing list to discuss the detailed technical aspects of the work. In addition, Ronnie, Steve and Olivier met online once each week for follow-up discussions and resolution of any issues. To maximize the benefit of the opportunity provided by Google, it was decided to improve the wiki page contents with

  • Statements describing each function’s compliance with the Open Document Format for Office Applications (OpenDocument) Version 1.2 specification
  • Extra use cases and examples
  • Illustrations when applicable
  • External references for further reading
  • Identification of equivalent functions in other spreadsheet software

A useful side-effect of the project was the identification of several potential areas of improvement for Calc’s help files and the exposure of a software issue in two rarely used functions! In addition, Ronnie was able to present his work at the openSUSE + LibreOffice Virtual Conference in October 2020 and hopefully gained some insights into the role of a Technical Writer.

We are grateful for the work that Ronnie was able to carry out during this task. As all documentation related to software development, the Extensive Calc Functions Wiki is open for further improvements. If you would be interested in helping, please get it touch through the Documentation Team’s mailing list.

Access the Extensive Calc Functions Description in the Document Foundation wiki at https://wiki.documentfoundation.org/Documentation/Calc_Functions.

Happy documenting!