Language Selection

English French German Italian Portuguese Spanish

LibO

LibreOffice Calc Basics I: SUM, COUNT, AVERAGE

Filed under
LibO
HowTos

This tutorial explains how you can work with Calc, the spreadsheet program of LibreOffice, by learning its basic formula examples. In this first part, we will learn the most basic ones namely SUM, COUNT and AVERAGE. Let's start!

Read more

"LibreOffice Expert" magazines available for schools and communities

Filed under
LibO

The magazines come with DVDs that include LibreOffice for Linux, Windows and macOS, alongside extra templates, extensions and guidebooks. So ideally, we’d like to get these magazines out to locations and communities where internet connections aren’t always available – so that the users can really benefit from the discs.

Read more

Oyez! Oyez! Oyez! The LibreOffice Draw Guide 7.2 has arrived!

Filed under
LibO

Anyone who wants to quickly acquire knowledge about LibreOffice Draw and is new to drawing software, or may be familiar with another office suite, will find this user guide very useful. It introduces the main features of LibreOffice Draw. Although Draw is a vector graphics drawing tool, it can also perform some operations on raster graphics (pixels) such as photographs.

Using Draw, a wide variety of graphical images can be created quickly. Some of the drawing functions are: layer management, snap functions and grid-point system, dimensions and measurement display, connectors for making organization charts, 3D functions that enable small 3D drawings to be created (with texture and lighting effects), drawing and page-style integration, and Bézier curves.

Read more

LibreOffice: The Klingons and Interslavs are already here

Filed under
LibO

We happily report that Klingons have – at this point – not taken over control of the LibreOffice bug-tracker.

While Klingon language support still ranks somewhat low among issues thought not to be essential, the federation that is LibreOffice 7.3 will also bring Interslavic support to the mix when released come early February.

Since you were wondering, Interslavic is an artificial language meant to operate in the cross-section of Slavic interlingualism.

Targ-herders everywhere are reportedly mildly pleased. The synergy in KSL (Klingon as second language) regions is a potato harvest that we can all appreciate.

Undeterred by the confines of a monogalactic community of translators, LibreOffice numbers are growing. Hundreds of millions or earthlings alone now have powerful tools honed in their native languages.

Read more

LibreOffice: The Klingons and Interslavs are already here

Filed under
LibO

While Klingon language support still ranks somewhat low among issues thought not to be essential, the federation that is LibreOffice 7.3 will also bring Interslavic support to the mix when released come early February.

Since you were wondering, Interslavic is an artificial language meant to operate in the cross-section of Slavic interlingualism.

Targ-herders everywhere are reportedly mildly pleased. The synergy in KSL (Klingon as second language) regions is a potato harvest that we can all appreciate.

Read more

LibreOffice 7.2.5 Released with 90 Bug Fixes, Now Available for Download

Filed under
LibO
Linux
News
Software

Coming exactly one month after LibreOffice 7.2.4, which was an emergency update to address a critical security vulnerability, the LibreOffice 7.2.5 update is here to fix a total of 90 bugs (according to the RC1 and RC2 changelogs) across all core components of the open-source and cross-platform office suite, as well as to further improve document compatibility.

This is the fifth of seven planned maintenance updates for the LibreOffice 7.2 office suite series, which was released in mid-August 2021 with many new features and improvements, including improved interoperability with the MS Office document formats, native support for Apple M1 machines, as well as various UI enhancements.

Read more

LibreOffice 7.2.5 is now available

Filed under
LibO

The Document Foundation announces LibreOffice 7.2.5 Community, the fifth minor release of the LibreOffice 7.2 family, which is available on the download page.

This version includes 90 bug fixes and improvements to document compatibility. The changelogs provide details of the fixes: changes in RC1 and changes in RC2.

For enterprise-class deployments, TDF strongly recommends the LibreOffice Enterprise family of applications from ecosystem partners, with long-term support options, professional assistance, custom features and Service Level Agreements: LibreOffice in Business.

Read more

Use basegfx to convert angle unit – EasyHack

Filed under
LibO

First, what is basegfx, how it is used for converting angle units, and why we should care?

If you look at the list of LibreOffice modules in docs.libreoffice.org, you will see that basegfx is one of the LibreOffice modules. It contains the “algorithms and data types for graphics“, and it provides useful functions for LibreOffice graphics code. We care because using these functions helps us write cleaner code using well tested methods.

Read more

Also: Happy New Year 2022!

LibreOffice 7.3 RC1 is available for testing

Filed under
LibO

The LibreOffice Quality Assurance ( QA ) Team is happy to announce LibreOffice 7.3 RC1 is available for testing!

LibreOffice 7.3 will be released as final at the beginning of February, 2022 ( Check the Release Plan for more information ) being LibreOffice 7.3 RC1 the third pre-release since the development of version 7.3 started in mid June, 2021. Since the previous release, LibreOffice 7.3 Beta1, 241 commits have been submitted to the code repository and 130 issues got fixed. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 7.3 RC1 can be downloaded from here for Linux, macOS and Windows, and it will replace the standard version.

In case you find any problem in this pre-release, please report it in Bugzilla ( You just need a legit email account in order to create a new account ).

Read more

Also: LibreOffice Calc Guide 7.1 Russian Edition

LibreOffice has been awarded the Editor’s Pick badge by Software Informer

Filed under
LibO
Reviews

Work with document files either imported from programs like MS Word, Excel and other office tools or created natively in formats like ODF or PDF compatible with modern and open standards. Editing, copying and incorporating data in databases is possible.

LibreOffice is an open-source free alternative to heavy commercial office suites like MS Office. While having generally the same functionality, LibreOffice is more open to modification and updates, making it a more attractive suite if you want a comfortable and adjustable tool for working with documentation.

Read more

Syndicate content

More in Tux Machines

today's howtos

  • ​How to Upgrade Debian 10 Buster to Debian 11 Bullseye

    After more than two years of development, the new Debian stable version, Debian 11 codenamed “Bullseye”, was released on August 14, 2021, and it will be supported for five years. This release comes with a lot of new packages and major software upgrades. Debian 11 bullseye ships with Linux 5.10 LTS kernel with support for the exFAT filesystem and includes a newer version of desktop environments. This article shows how to upgrade your Debian 10 Buster system to Debian 11, Bullseye via command line.

  • How to Install and Setup MERN Stack with Nginx on Ubuntu 20.04

    Since this post shares cloud strategies with awesome people like you, naturally this post may contain affiliate links for products I use and love. If you click on those links and make a purchase, I'll earn some coffee money which I promise to drink while creating more helpful content like this.

  • How to Install Zabbix Agent on Rocky Linux/Alma Linux 8

    A Zabbix agent is a program that runs on a remote machine that needs to be monitored through the Zabbix server. The agent collects the data on the remote server and send back to Zabbix server when requested. Zabbix agent must be installed on all the remote systems that need to be monitor through the Zabbix server.

  • How To Install and Configure Zabbix Agent on Ubuntu 20.04

    A Zabbix agent is a program that runs on a remote machine that needs to be monitored through the Zabbix server. The agent collects the data on the remote server and send back to Zabbix server when requested. Zabbix agent must be installed on all the remote systems that need to be monitor through the Zabbix server.

  • How to Install Lighttpd with PHP in Ubuntu 20.04

    The concept of web servers has crossed the minds of most, if not all, Linux enthusiasts; especially the ones interested in pursuing web-based projects and careers. Due to the numerous web servers offered to the Linux community, you might feel like tossing a coin or rolling a dice to find the one that ‘might’ suit your web-based needs. Lighttpd is best attributed as a compatible, very flexible, fast, and secure web server. It is therefore optimized for high performance on whichever operating system environment hosts it. Also, this web server is indeed light such that it needs very few resources to run or execute its functional objectives like handling AJAX applications. This web server is BSD licensed, open-source, with flawless compatibility on UNIX-like systems. This article seeks to walk you through the installation and configuration of Lighttpd as an ideal web server for your Ubuntu 20.04 operating system.

  • How to self-host a Python package index using Pulp | Red Hat Developer

    Find out how developer teams use Pulp to maintain and share their own Python package repositories. Examples are based on the Operate First deployment.

  • How To Install Kate Editor on Ubuntu 20.04 LTS - idroot

    In this tutorial, we will show you how to install Kate Editor on Ubuntu 20.04 LTS. For those of you who didn’t know, The Kate Text Editor is an open-source and free text editor application that stands for KDE Advanced Text Editor. Kate lets you edit and view many files at the same time, both in tabs and split views, and comes with a wide variety of plugins, including an embedded terminal that lets you launch console commands directly from Kate. Kate editor is a cross-platform application available for Linux, MacOS & Microsoft Windows, It is available for both 32 bit and 64 bit operating systems. This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you through the step-by-step installation of Kate Editor on Ubuntu 20.04 (Focal Fossa). You can follow the same instructions for Ubuntu 18.04, 16.04, and any other Debian-based distribution like Linux Mint.

  • How to Change Desktop Themes on Linux Mint

    Linux Mint is a great Linux distro for anyone starting out with Linux. It comes in three different flavors: Cinnamon, MATE, and Xfce, each catering to a different audience. Over the years, Linux Mint has undergone several changes, including a few cosmetic alterations that are a departure from its original visual appearance. As part of this change, Mint now lets you choose from a wide range of themes to customize your desktop to your preference. If you're just getting started with Mint, here's a guide demonstrating all the different ways to change themes.

  • How to install and use Firewalld on Almalinux 8 - Linux Shout

    Firewalls are one of the most essential parts of security when we are going online. Here we learn the steps and command to install, configure, and how to use FirewallD on AlmaLinux 8 using CLI or GUI. Many of us who are not already Linux would already be familiar with the firewall feature on Windows, where it is very easy to turn On or Off ports or services using GUI. However, what about Linux such as CentOS, Rocky Linux, RedHat, AlmaLinux, and more… If you are using full Linux Desktop then a firewall would already be there but in most of the cases without a graphical interface. Nevertheless, Debian, RedHat, Ubuntu, and other Linux systems provide the appropriate firewall GUI software directly from their respective repository to manage things with the help of mouse clicks. But what if you just want a basic OS installation with no graphical interface? Because minimal versions of Linux would not even have the CLI version of Firewall by default. Well, this is a very small problem, if you have an active internet connection and due to an in-built package manager under Linux, we can install a firewall with just a single command.

  • How to use Terraform Taint and Untaint - buildVirtual

    The Terraform taint and untaint commands are important to be aware of if you are a regular user of Terraform. The Terraform Taint command allows you to manually flag a resource as tainted, which means it will be destroyed and recreated on the next terraform apply. Terraform untaint allows you to remove that tainted condition from the resource. So, why is that useful? What are the use cases for terraform taint?

6 Reasons to Pick Linux Over Windows

Almost all students do their work on laptops and PCs that run on Windows. Of course, some of you are lucky enough to afford something that runs on Apple’s macOS. While Windows is a popular OS, it’s far from being perfect. Few students are even aware that their PCs and laptops can run on various operating systems.

One of the alternatives students often overlook is Linux. Many believe that this OS is hard to manage. That’s why they prefer to either buy or, in some cases, pirate Microsoft’s creation unless it comes pre-installed on the device, of course.

It’s true that Linux is harder to install than its counterpart. But it has a lot more to offer than meets the eye. So, what exactly sets it apart?

Read more

today's leftovers

  • Planet Incinerating Technology | LINUX Unplugged 441

    We make some last-minute changes to our server setup and catch up on a bunch of thought-provoking feedback. Special Guests: Martin Wimpress and Neal Gompa.

  • GNU World Order 443
  • LibreSSL update

    Undeadly reached out to Theo asking whether he would share with readers an explanation of the changes. He kindly responded: [...]

  • Early Days at Bell Labs

    It's Brian Kernighan discussing the formation of Unix, starting from the back story of the creation of Bell Labs, including predecessors CTSS and Multics, and C predecessors BCPL which was modified to become B, and why Dennis Richie added types to B to make C.

    This video really hits its stride when Kernighan discusses piping and redirection, and the ease of creating wonderful things out of small parts that, and Kernighan used these words, "do one thing and do it well."

What Distribution and Version Pulled You into Linux?

I recently watched a video posted by my good friend (and former Linux Journal colleague) Shawn Powers introducing viewers to Linux and Linux distributions. And it got me thinking about my own personal experience and when I first started to dabble in the world of open source operating systems.

Read
more