Все маководы должны быть счастливы теперь. Caolán McNamara добавил поддержку темной темы в LibreOffice 7.5. Выглядит это как-то вот так с темой значков Sifr Dark:

LibreOffice 7.5 alpha 1 доступен для тестирования.

Из нового и важного:

1. Немного улучшено выделение и удаление строк/столбцов в таблицах Writer в сложно устроенных таблицах

2. Улучшено визуальное отображение закладок в текстовых документах

3. В Calc, в диалог настройки формата ячеек добавили форматы типа "числа, как текст", вы пишете в ячейке 100, а отображается "Сто", в том числе есть настройки для разных валют

4. Панель элементов математических формул в Math перенесли в Боковую панель справа (спорное решение, но это нужно было Коллаборе для их Онлайн Офиса)

5. Улучшена в каких-то случаях работа с тачпадами, но так и не исправлены баги с прокруткой при помощи тачпада

6. Добавлена поддержка некоторых методов VBA

Скачать LibreOffice 7.5 alpha 1 можно отсюда:Windows 64 bitLinux 64 bit RPMLinux 64 bit DEBmacOS Intel 64 bitmacOS M1/M2

Are you running out of disk space on your Debian or Ubuntu Linux? Do you want to know which installed Debian or Ubuntu packages occupy the most disk space? There are many ways to find out this info. In this quick tip, you will learn about listing apt or apt-get installed packages that occupy the most space using the command-line options. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post Find APT packages occupy the most space on Debian/Ubuntu appeared first on nixCraft. 2022-11-15T17:39:27Z 2022-11-15T17:39:27Z Vivek Gite

Today I will talk about a common problem faced by many Linux or Unix sysadmins and developers. Typically modern apps and security devices heavily depend upon APIs and lists that feed data in JSON format. For example, a list of spamming or VPN CIDRs or a good list of verified bots' IP CIDRs is in JSON format. If they accept JSON format, you can take this list and upload it to your router or WAF. Unfortunately, not all devices accept JSON format. Hence, we can take JSON format and convert it to CSV format per our needs. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to convert JSON to CSV using Linux / Unix shell appeared first on nixCraft. 2022-07-22T13:15:44Z 2022-07-22T13:15:44Z Vivek Gite

usbgurd You deployed a perfect firewall and other network security policies preventing unauthorized access to the user's desktop computer over a network. However, you still need to block USB device access. We can configure a Linux desktop security policy to protect your computer against rogue USB devices (a.k.a. BadUSB) by implementing essential allow and blocklisting capabilities based on device attributes. For instance, I can define what kind of USB devices are authorized and how a USB device interacts with the Linux system. For example, I can define policy allowing Yubikey with serial number "XYZ" and USB LTE modem with serial # "ABC." Every other USB device access is denied by default. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to protect Linux against rogue USB devices using USBGuard appeared first on nixCraft. 2022-07-11T15:56:48Z 2022-07-11T15:56:48Z Vivek Gite

The AWS CLI is an essential tool for developers and sysadmin to automate and interact with AWS cloud services. It is an open-source tool built on the AWS SDL for Python. As a result, you no longer need to use AWS Management Console. Instead, you can use Linux terminal and commands for managing AWS resources. Let us see how to install AWS CLI on Linux using the command-line options. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to install aws cli on Linux appeared first on nixCraft. 2022-03-22T20:19:02Z 2022-03-22T20:19:02Z Vivek Gite

Chromium is a free and open-source web browser project designed and maintained by Google. Google Chrome browser uses Chromium codebase and other proprietary components for additional features required to play games, music and movies protected by DRM. This page explains how to install Chromium browser on Ubuntu Linux 20.04 and 22.04 LTS desktop computers. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to install Chromium browser on Ubuntu Linux appeared first on nixCraft. 2022-03-22T03:38:54Z 2022-03-22T03:38:54Z Vivek Gite

When you use the apt command to update the Raspberry Pi OS, no notification indicates whether you need to reboot the Raspberry Pi 3 or 4 for Linux kernel updates. So say you have a lab of 4 RPi4 and managing updates using ansible, then you need an automated way to find out if a reboot is required to load a new Linux kernel on your Raspberry Pi OS. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to find out if Raspberry PI Linux OS needs a reboot appeared first on nixCraft. 2022-03-14T09:39:37Z 2022-03-14T09:39:37Z Vivek Gite

So I have this specific use case where I get data in a comma-separated values (CSV) file. I pick up the company name, address, telephone, email, and some other data from that file. Once data is collected, I create a final pdf using a simple script. Unfortunately, data comes with unwanted leading and trailing white spaces in each field. So my final pdf file gets messed up because of those white space. Let us see how to trim leading and trailing white space for a string in Bash running on Linux or Unix machines. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to trim leading and trailing white space in bash appeared first on nixCraft. 2022-03-12T14:31:26Z 2022-03-12T14:31:26Z Vivek Gite

How do I enable kernel crash dump Debian Linux 9/10/11 using the command-line option? How can I view crash reports on Debian machine? Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to on enable kernel crash dump on Debian Linux appeared first on nixCraft. 2022-03-04T09:33:27Z 2022-03-04T09:33:27Z Vivek Gite

I have a tutorial that explains the basics of the SSH client configuration file and some of the most common configuration options for Linux and Unix developers or sysadmin. In this quick tip, I will explain how and why you sometimes need to ignore or exclude the ssh client config file under Linux, Unix, *BSD and macOS. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to tell ssh client to ignore ssh config file appeared first on nixCraft. 2022-10-21T18:30:21Z 2022-10-21T18:30:21Z Vivek Gite

FreeBSD default comes with a drill command to see information about DNS. The userspace tools for FreeBSD come from the latest version of the BIND-TOOLs package. It includes delv, dig, host, nslookup, and nsupdate. Let us see how to search and install dig, delv, and host commands on FreeBSD using the pkg command. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to install dig, delv, host commands on FreeBSD appeared first on nixCraft. 2022-10-08T05:18:50Z 2022-10-08T05:18:50Z Vivek Gite

{Updated} Want to do a reverse DNS (rDNS) Lookup in Linux, macOS, *BSD or Unix/WSL/Windows to find scammers/phishers/spammer using a forward confirm. Try these tips.The post How To Test or Check Reverse DNS on a Linux / Unix appeared first on nixCraft. 2022-06-09T16:31:00Z 2022-06-09T16:31:00Z Vivek Gite

Today, I will share one helpful tip that allows FreeBSD developers and sysadmin to make a backup list of installed all FreeBSD packages and then restore it. Hence, this is useful for disaster recovery (DR) or simply rebuilding a new server. It will save you time. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to backup & restore a list of installed FreeBSD packages appeared first on nixCraft. 2022-06-09T14:31:46Z 2022-06-09T14:31:46Z Vivek Gite

I already wrote about setting up wildcard Let’s Encrypt SSL/TLS with AWS Route53 DNS for Nginx or Apache. One of my clients decided to use Cloudflare CDN and DNS at some point. They changed their DNS to Cloudflare. Naturally, their wildcard certificate failed because it was using Route53 DNS authentication to issue the certificate. Let us see how to convert existing or expired TLS/SSL certification renewal from AWS Route53 to Cloudflare. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How To Convert AWS Route53 to Cloudflare Let’s Encrypt DNS challenge with acme.sh appeared first on nixCraft. 2022-02-08T21:40:04Z 2022-02-08T21:40:04Z Vivek Gite

Many of you access the nixCraft tutorial and blog post using the RSS feed. However, Google decided to kill the last part of Feedburner. Back in the old days, I and many others used FeedBurner. At some stage, Google acquired FeedBurner, and now they are putting it into maintenance mode. Hence, this new change will affect those getting daily emails via FeedBurner when new content is posted here. Therefore I urge you to update your feed. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post Update your nixCraft RSS feed appeared first on nixCraft. 2022-02-08T21:39:15Z 2022-02-08T21:39:15Z Vivek Gite

One can use a hardware security key such as YubiKey for OTP or FIDO2 for additional security on Linux to protect disks, ssh keys, password manager, web applications and more. Since I am a full-time Linux desktop user, I thought today I would document how to install the YubiKey GUI Manager to configure functionality on […] Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to install YubiKey Manager GUI on Linux appeared first on nixCraft. 2022-02-07T10:02:57Z 2022-02-07T10:02:57Z Vivek Gite

While working on the client's system, I found that the whois client was missing. So I used that in one of my deployment scripts. I should add that to cloud-init or Ansible, but the Ubuntu server was already running. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How to install whois on Ubuntu / Debian Linux appeared first on nixCraft. 2022-02-07T10:02:51Z 2022-02-07T10:02:51Z Vivek Gite

{Updated} In this tip, I will explain how we can iterate over a list of files with blank or white spaces in their names. This is a common problem in bash, where space is usually interpreted as a delimiter when using with for loop.The post BASH Shell: For Loop File Names With Spaces appeared first on nixCraft. 2022-09-19T18:06:00Z 2022-09-19T18:06:00Z Vivek Gite

Все же используют иногда нижнее подчёркивание в тексте, чтобы выделить слово или предложение. И, по умолчанию, цвет линии подчеркивания тот же самый, что и цвет текста, то есть чёрный. Если вы измените цвет шрифта на красный, то и линия подчёркивания тоже станет красной.

А ведь так хочется иногда подчеркнуть красной (или какой угодно цветом) линией обычный чёрный текст, правда?

Оказывается так можно сделать: 

Делается это путем создания нового стиля символа (не абзаца!).

1. Открыли раздел Стили на Боковой панели (нажмите F11)
2. Выбрали Стили символа
3. Щёлкаем правой кнопкой мыши по стилю "Без стиля символа" и выбираем "Создать"
4. В открывшемся диалоге задаем "Имя" новому стилю, например "Красная линия"
5. На вкладке "Эффекты шрифта" выбираем нужный стиль линии "Подчеркивание" (одна, две, жирная, пунктир, и так далее)
6. Справа от стиля линии станет активным выпадающий список, где можно выбрать цвет линии - выбираем красный
7. Жмем кнопку "Применить"

Теперь в тексте документа выбираем нужные слова (или просто отдельные буквы) и применяем к ним наш новый стиль "Красная линия", который теперь доступен на панели Стили в разделе Стили символов. Результат будет, как на картинке выше.

А можно и чуть проще, если вам нужно сделать это разово:

1. Выделяете нужные символы в тексте
2. На панели инструментов жмёте маленькую стрелочку вниз у значка "Подчеркнутый"
3. В появившемся выпадающем списке нажмите кнопку "Ещё" в самом низу, откроется тот же самый диалог для настройки стиля символа
4. Точно также выберите тип линии подчёркивания и её цвет
5. Нажмите кнопку "ОК"