Пользователи MS Excel, которые перешли (вольно или невольно) на LibreOffice Calc постоянно спрашивают "А что, по цвету ячеек нельзя фильтровать что ли тута?"

Действительно, до версии LibreOffice 7.2 фильтровать по цвету ячеек в Calc было нельзя. К счастью пользователей, в версии 7.2 Samuel Mehrbrodt таки запилил эту возможность. Выглядит это вот так:

Обратите внимание на ещё пару вещей:

1. При установке любой фильтрации в Автофильтре - цвет кнопки Автофильтра в первой ячейке меняется на системный (в моем случае - это синий) для наглядности. Когда столбцов с Автофильтрами много - это очень наглядно показывает, какие из столбцов отфильтрованы.

2. При фильтрации номера строк, попавших под фильтр также становятся системного цвета (опять же синий у меня).

3. Доступен фильтр не только по цвету фона ячейки, но и по цвету текста в ячейке.

4. В Автофильтр добавлена возможность сбросить все настроенные фильтры разом (та самая строка Clear Filter).

В общем-то достаточно круто это всё стало, правда? =)

The Document Foundation ещё не объявил (но скоро объявит) о доступности для тестирования первого бета выпуска LibreOffice 7.3.

Скачать LibreOffice beta 1 для различных ОС можно по ссылкам

Windows 32 bit

Windows 64 bit

Linux 64 bit (deb)

Linux 64 bit (rpm)

macOS 64 bit (Intel)

macOS (M1)

Так как это бета выпуск, то он предназначен для целей тестирования и не рекомендуется к использованию в постоянной работе.

Если вы найдёте ошибку в этом выпуске LibreOffice, обязательно дайте знать разработчикам в баг трекер.

{Updated} Kernel-based Virtual Machine (KVM) is a virtualization module for the Linux kernel that turns it into a hypervisor. How can I install KVM with bridged networking, setup guest operating system as the back-end virtualization technology for non-graphic Debain Linux 9.x/10.x server?The post How to install KVM server on Debian 9/10 Headless Server appeared first on nixCraft. 2021-11-25T12:57:00Z 2021-11-25T12:57:00Z Vivek Gite

The Document Foundation объявил о релизе третьего корректирующего выпуска LibreOffice 7.2. Скачать LibreOffice 7.2.3 можно по ссылке libreoffice.org/download.

Список исправленных ошибок относительно релиза LibreOffice 7.2.2:

https://wiki.documentfoundation.org/Releases/7.2.3/RC1

https://wiki.documentfoundation.org/Releases/7.2.3/RC2

Всем, кто использует LibreOffice 7.2, рекомендую обновиться.PS: Если найдёте ошибку в программе, то не стесняйтесь сообщить о ней разработчикам по этой ссылке.

 

While working with an application, I needed PHP 7.4 and 8.0 on Amazon Linux 2 EC2 and Lightsail instance. Here is how to install PHP version 7.2/7.3/7.4 or 8.0 on Amazon Linux 2 using the yum command. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to install PHP 7.2/7.3/7.4 or 8.0 on Amazon Linux 2 appeared first on nixCraft. 2021-11-24T20:10:33Z 2021-11-24T20:10:33Z Vivek Gite

{Updated} How do I get more information about CPU under FreeBSD operating systems such as CPU Speed and model using the command-line options?The post How can I check my CPU in FreeBSD? appeared first on nixCraft. 2021-11-24T19:47:00Z 2021-11-24T19:47:00Z Vivek Gite

Sometimes we need to evaluate multiple when conditions in Ansible playbooks. Let us see how to define multiple when conditions in Ansible for a single task. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to define multiple when conditions in Ansible appeared first on nixCraft. 2021-08-03T10:37:00Z 2021-08-03T10:37:00Z Vivek Gite

{Updated} How do I find out BIOS version using a Linux command line option? How do I check the motherboard BIOS version using Linux command line option?The post Linux Find Out BIOS Version Using a Command Line Option appeared first on nixCraft. 2021-08-02T19:27:00Z 2021-08-02T19:27:00Z Vivek Gite

The xz command on Linux, macOS, *BSD, and Unix-like systems offer excellent compression. It will outperform zip and other formats when we use xz with tar for maximum reduction in size. For instance, I compressed a directory having 37M size using both xz and zip. The zip file size was 31M, while the xz file was 16M after compression. Pretty impressive, isn't it? Let us see how to compress the whole directory using xz and tar. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to compress the whole directory using xz and tar appeared first on nixCraft. 2021-11-23T10:24:29Z 2021-11-23T10:24:29Z Vivek Gite

{Updated} How do I change OpenSSH passphrase for one of my private keys under Linux, OpenBSD, FreeBSD, Apple macOS/OS X or Unix-like operating systems?The post OpenSSH Change a Passphrase With ssh-keygen command appeared first on nixCraft. 2021-08-02T09:11:00Z 2021-08-02T09:11:00Z Vivek Gite

One of the most common questions I get is how can I find a Linux command path that I just installed on Linux using a package manager such as apt/dnf command. We have many new developers coming from the Windows world. Many are first-time Linux users. Some are using Linux from WSL, and others are directly dealing with cloud servers over ssh. Let us see some common commands to list or find a path for Linux commands. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to find a path of a Linux command like a pro appeared first on nixCraft. 2021-08-01T18:16:05Z 2021-08-01T18:16:05Z Vivek Gite

{Updated} Here are 10 Linux command to know the system and increase your productivity quickly.The post 10 Linux commands to know the system appeared first on nixCraft. 2021-11-22T23:37:00Z 2021-11-22T23:37:00Z Vivek Gite

We all know we can use the xclip Linux command-line interface to X selections, aka clipboard. The xclip command to copy any Linux command output to the Linux clipboard directly. For example, the following will copy text Hello World to your clipboard, and you can pate it using the Ctrl+v/Ctrl+Shift+V keyboard in other apps: echo "Hello World" | xclip -sel clip But, I want to copy a file (or recursing into directories and copy everything) to the clipboard in Linux and then paste it somewhere else. How do you copy a file to the clipboard in Linux? Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How do I copy a file to the clipboard in Linux? appeared first on nixCraft. 2021-11-22T21:48:01Z 2021-11-22T21:48:01Z Vivek Gite

{Updated} When you want to have both stderr and stdout displayed on the terminal and in a file use this syntax on your Linux or Unix/macOS/BSD:cmd 2>&1 &vert tee filewhois ip-address 2>&1 &vert tee spammer.txtmore spammer.txt.Learn how to save the output of a Linux / Unix command to a file.The post How To Save The Output Of A Linux/Unix Command To A File appeared first on nixCraft. 2021-11-22T20:51:00Z 2021-11-22T20:51:00Z Vivek Gite

{Updated} This page explains the use of the double-dash ('‐‐') in Linux, macOS, and Unix shell commands. For example: lxc exec container ‐‐ sh -c 'apt update && apt -y upgrade'. First, let us see what it does and when we might need it.The post What Does ‐‐ (double dash) Mean In SSH Shell Command? appeared first on nixCraft. 2021-07-31T09:14:00Z 2021-07-31T09:14:00Z Vivek Gite

Here is a simple shell script to notify secondary read-only replica (slave) MariaDB server health status failure via email and push notification. Master-slave data replication allows you to copy databases to multiple MariaDB servers. It is useful for backup, data recovery, load balancing, and much more. See how to configure SSL-protected MariaDB replication between a master and slave server. 2021-07-30T23:30:22Z 2021-07-30T23:30:22Z Vivek Gite

On Debian or Ubuntu Linux, one can run 'apt list --upgradable' command to see and list available package updates. On RHEL, we can use 'dnf check-update' to list available updates on screen. However, the apk command does not have an option to show and list available security software updates. But fear not. Some other tricks can list, and you can see what packages updates are available on Alpine Linux using the apk command. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to see what packages updates available on Alpine Linux appeared first on nixCraft. 2021-07-30T22:22:53Z 2021-07-30T22:22:53Z Vivek Gite

{Updated} How do I reuse ssh connection using multiplexing to speed up remote login procedure with OpenSSH client under Linux, macOS, *BSD and Unix-like operating systems?The post How To Reuse SSH Connection To Speed Up Remote Login Process Using Multiplexing appeared first on nixCraft. 2021-07-30T22:19:00Z 2021-07-30T22:19:00Z Vivek Gite

When working with Ubuntu, Debian Linux, and ZFS, you will run into ZFS cache size problems. You see, not all Ubuntu or Debian servers need aggressive file caching. Some servers act as a web server or run Linux container workloads or KVM guest VMs where you want those guest VMs to manage their own caching. Therefore, it would be best to have tons of ECC RAM for ZFS. Unfortunately, not all projects get that kind of extravagance in real life. This page explains how to set up ZFS arc size on Ubuntu/Debian or any Linux distro of your choice. So that, Linux kernel avoid running out of memory. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to set up ZFS ARC size on Ubuntu/Debian Linux appeared first on nixCraft. 2021-07-26T09:45:09Z 2021-07-26T09:45:09Z Vivek Gite

{Updated} How do I find out details about my Linux Laptops temperature, battery status and other information from the command prompt? How can I check battery status using the terminal on Linux?The post Linux commands to check the Laptop battery's status via the terminal appeared first on nixCraft. 2021-07-26T06:46:00Z 2021-07-26T06:46:00Z Vivek Gite