2022 Developer Survey is open! Take survey.

Questions tagged [libreoffice]

LibreOffice is a cross-platform office suite that originated as a fork of OpenOffice.

Filter by
Sorted by
Tagged with
0 votes
0 answers
5 views

Libre-office: Texmaths extension disappeared and can not be reinstalled

So I've been using Texmaths, an extension for Libre-office for 2 months. Suddenly, yesterday Libre-office closed (happens sometimes), but then when I reopened it the button for the extension had ...
user avatar
0 votes
1 answer
22 views

LibreOffice: how to get it to use the window manager's file browser?

I think I asked that some years ago, but cannot find it anymore. I just upgraded to Fedora 36 and since then, my LibreOffice uses its own inbuilt file browser again, rather than Gnome's nautilus. The ...
user avatar
  • 1,425
1 vote
1 answer
30 views

How to make libreoffice headless conversion act differently on file loading error

I use a script via my file manager context menu to convert various document formats (e.g. *.DOC) to ODT format like this: for filename in "${@}"; do if [[ -f "${filename%.*}.odt&...
user avatar
  • 419
0 votes
0 answers
22 views

Debian: Minimum LibreOffice Packages to Convert docx Files to pdf in Headless Mode

I'm developing a Docker container with a Debian 10 base image (this is a fixed dependency) that converts docx files to pdf using LibreOffice (soffice) in headless mode. I've got it working with the ...
user avatar
  • 101
0 votes
1 answer
33 views

How to use one table (ods) file as a base for another table file?

I have an accounting ledger table (.ods) file which should be the base for other table files. This table file should be the base for other table files such as: 2023.ods 2024.ods 2025.ods These are ...
user avatar
0 votes
0 answers
17 views

Why is Libreoffice-calc is auto-selecting what i write in one cell?

I am getting crazy trying to type numerical data inside a cell, since Libreoffice is auto selecting "on the fly" what I type : so for example if I want to type 12 in a cell : then I type 1 ...
user avatar
  • 113
0 votes
1 answer
42 views

Can't get ODBC working with MariaDB

Linux Mint 20 (Ubuntu 20). MariaDB version: "mariadb Ver 15.1 Distrib 10.7.3-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2" I want to run LibreOffice Base as the front end, ...
user avatar
  • 1,042
1 vote
1 answer
70 views

Cannot open files with Umlaut with Libreoffice on Debian

I have set up a new system with a backported debian 11 and KDE Plasma 5 and wanted to continue working on my files. Some of them are from shared project containing Umlaute (ö, ü, ä) which I cannot ...
user avatar
  • 141
0 votes
0 answers
17 views

Converting XLSX (or ODS) to PDF with no admin rights

I am writing a code in PHP that open and edit an Excel File (template) using PHPExcel library. At the end convert to PDF. I tried use all writers to PDF that PHPExcel has: Dompdf, Mpdf and Tcpdf. None ...
user avatar
  • 101
0 votes
0 answers
23 views

What happened to "crop" when an image is selected?

I want to crop an image in Writer, so I select the image and right-click (Ubuntu 20.04, V6.4.7.2) and there is no longer an option to crop. Why?
user avatar
1 vote
0 answers
126 views

Prevent LibreOffice from using system theme

I recently started using Linux Mint 19.3 Cinnamon. I understand that LibreOffice automatically uses the system colour theme---my preferred system theme is dark so LibreOffice uses it as well. However, ...
user avatar
0 votes
0 answers
12 views

LibreOffice Impress textbox - decrease the distance of each movement

Sometimes I only need a slight movement, but it actually moves way over what I needed, making aligning screen items very hard. Often, I had to do tricks to make the alignment look better, for example, ...
user avatar
  • 101
0 votes
1 answer
54 views

Why the option button can't be selected when odf file converted into pdf with libreoffice7.2?

I have installed the latest libre-office version 7.2 , and wrote a fillable odt file. The option button can be selected in libre-office,i have upload the whole sample odt file,you can download it and ...
user avatar
  • 35
0 votes
0 answers
27 views

Set all documents with libre office to be editable by default?

i'm downloading documents and spreadsheets daily, and it seems like 100% of them are set as read-only. i can start editing them with just 2 clicks, but it's mildly annoying. can i set all documents ...
user avatar
  • 1
0 votes
1 answer
73 views

Free sketching on LibreOffice Draw

I have a drawing Graphical Board and am trying to draw in LibreOffice Draw using it. The only options I can find are to insert images, draw shapes and insert text. Is there a simple "free (...
user avatar
  • 111
0 votes
0 answers
61 views

Arch Linux Libreoffice is problematic and slow in persian/arabic documents

There is no problem when working on English language documents, but if my document is Persian or Arabic, libreoffice Writer and libreoffice Impress will slow down and other problems will occur. Is ...
user avatar
  • 101
0 votes
0 answers
98 views

How to stop LibreOffice Draw from crashing in Debian Bullseye?

After I upgraded from Debian 10 to 11, LibreOffice Draw 7.0 no longer runs. If I open an existing file, or try to create a new one, it crashes, then immediately tries to pull up a document recovery ...
user avatar
  • 5,345
0 votes
1 answer
74 views

Libre Office Calc - Dark Modes Aren't so Dark

How can you change the default color of the spreadsheet's grid in Libre Office Calc? I've tried applying dark-mode themes, but all the themes I've tried still leave the grid white. If this simply isn'...
user avatar
  • 4,313
-1 votes
1 answer
34 views

LibreOffice KDE plugin install error on 5.14.0-kali4-amd64

I am trying to follow this tutorial to make my libreOffice look pretty: https://www.debugpoint.com/2016/08/quick-tip-change-the-default-libreoffice-look-and-feel/ however when I run sudo apt-get ...
user avatar
  • 14
1 vote
1 answer
96 views

Why LanguageTool is not working on LibreOffice?

I am using LibreOffice 7.2.2.2. I have installed LanguageTool 5.4, then 5.5.1, but none of them are working. They only add buttons to the toolbar, though they do not react. What would you suggest?
user avatar
0 votes
1 answer
194 views

Debian 11: Libreoffice crashes at once

I have installed Debian 11 from scratch (it is not a Debian 10 upgrade). When I open Calc and push any one key, Libreoffice crashes and this also happens in safe mode. I tried to gather some logs, but ...
user avatar
  • 123
0 votes
0 answers
61 views

Is it possibly to clear the clipboard when LibreOffice is being closed?

I'm running XFCE on Linux Mint. Sometimes I copy & paste potentially sensitive data inside LibreOffice Calc or Writer, which shouldn't exist anymore inside the clipboard once I exit those programs....
user avatar
  • 195
0 votes
0 answers
19 views

Upgrade to Debian 11 and now LibreOffice Calc doesn't show preview during text import

I recently upgraded to debian 11 with libreoffice 7, but now my text import isn't showing the preview anymore so I can't select types for fields/columns. I've tried playing with the import options ...
user avatar
  • 191
2 votes
1 answer
346 views

How to find out if a cell is (visibly) blank in LibreOffice Calc?

In LibreOffice Calc the =BLANK() formula will only return TRUE on cells with the underlying datatype ”blank”. In other words: If the cell contains a formula that returns nothing (or if it contains the ...
user avatar
  • 123
0 votes
0 answers
48 views

Adding error bar label in libre office

I want to add label to the existing error bar similar to this Source: Step by step to create a column chart with percentage change in Excel I could only replicate the error bar, but the amount of ...
user avatar
0 votes
0 answers
24 views

EPSON XP-6100: incorrect position of printout

On the first side the printout is about 2 mm too far to the right and 2 mm to high. On the next side it is about 4 mm too far to the right and 2 mm to high and so on. I created in LibreOffice small ...
user avatar
1 vote
1 answer
18 views

LibreOffice Upgrade from 3.5.4 to 4.3.3 Broke Lots of Macros

Recently upgraded from Debian Wheezy to Jessie (yeah, I know...). During said upgrade, the LibreOffice suite got upgraded from version 3.5.4 to 4.3.3. Well, lots of my Writer macros were broken after ...
user avatar
  • 239
0 votes
1 answer
100 views

bengali fonts displaying very late in Libreoffice writer

I have installed a flatpack version of LibreOffice 7 in my MX Linux 19.4 KDE version since the apt version was having problems in my system. In this version of LibreOffice, Bengali words do display ...
user avatar
0 votes
0 answers
28 views

Table relations in Base with ODBC connected SQlite ZeitgeistDB (Base tells not supported)

There aren't too many programs, that provide access to the ZeitgeistDB in Linux. Tracker-Needle in Debian isn't even available, anymore. So i thought i might use LibreOffice Base to access the DB and ...
user avatar
  • 739
0 votes
0 answers
47 views

Difference between gstreamer1.0-plugins-good and libgstreamer-plugins-good1.0-0?

I'm running KDE Neon and trying to troubleshoot video playback in Libreoffice. Since multimedia playback in libreoffice relies on gstreamer framework. When I went to install all gstreamer plugins to ...
user avatar
  • 1
0 votes
1 answer
90 views

libreoffice headless interprets source image as text

I am trying to use libreoffice to convert different source formats to pdf. This works with most formats but image formats are always interpreted as text: libreoffice --headless --convert-to pdf:...
user avatar
  • 135
0 votes
0 answers
112 views

Fedora 34 - Libreoffice - Could not load a pixbuf from icon theme

After upgrading to Fedora 34 I installed libreoffice. When I try to run it I get the following: (soffice:8828): Gtk-WARNING **: 14:00:00.573: Could not load a pixbuf from icon theme. This may ...
user avatar
0 votes
1 answer
99 views

Bengali font not working in Libre-office or any text editor applications in MX-Linux kde

I have installed open-bangla keyboard to type in Bengali in my system. Though I can type in Bengali in the web browsers and also in skype app(which is installed), I cannot do the same in any other ...
user avatar
0 votes
0 answers
44 views

Keeping a process in the foreground

My script invokes the shell to run the following command on startup: libreoffice --impress --norestore --show /home/directory This process is repeated everyday to have the presentation be displayed ...
user avatar
-1 votes
1 answer
55 views

Unshrink text permanently in Libreoffice

When I use LibreOffice Calc in Ubuntu 20.04, I am not able to expand a paragraph so that it looks always like this : Instead, it always looks like this with the little arrow on the right : I would ...
user avatar
1 vote
1 answer
317 views

LibreOffice install language package from official dnf-repositories

If I check under tools > options > Language Settings > Languages > Language of > User interface: it only contains "Default - English (USA)" and "English (USA)", ...
user avatar
0 votes
0 answers
37 views

How can one use Pyautogui to update Libreoffice Calc?

Is it possible to use pyautogui to read and update data from libreoffice calc file? If yes, how?
user avatar
0 votes
0 answers
54 views

Libreoffice's insert special character window looks HUGE (can't resize to smaller)

I write this post because I have the doubt about this being a libreoffice bug, a GNOME bug... or what could be the cause, because I don't seem to find and issue related to this anywhere else. When I ...
user avatar
  • 33
0 votes
1 answer
24 views

Did LibreOffice key-bindings to select an entire row change?

Like most LibreCalc users (I guess), Ctrl+Space to select an entire column of cells and Shift+Space to select an entire row is like second nature. Recently I noticed that Shift+Space wasn't working on ...
user avatar
3 votes
2 answers
638 views

How can I convert specific sheets in an xlsx file to csv via the linux command line?

I have about 16,000 .xlsx files in a directory. Each file follows the same structure. The first sheet is empty, and called "Sheet 1". The second is where the interesting data is, and it's ...
user avatar
1 vote
0 answers
47 views

GNOME Documents is not showing LibreOffice previews

I have GNOME with GNOME Documents and LibreOffice (fresh, so 7.0) installed. But when I want to preview a .doc or .xls file in GNOME Documents, it says: LibreOffice support is not available The ...
user avatar
  • 355
1 vote
1 answer
58 views

How do I prevent Libreoffice from stubbornly focusing on the cursor?

If I am editing a Libreoffice Writer document and the cursor is, say, in page 3 but I keep reading and am now in page 5, upon saving focus will jump back to page 3, where the cursor is. I find this ...
user avatar
  • 133
0 votes
0 answers
147 views

Blurry icons panel in LibreOffice

I have a pesky problem with LibreOffice. By some reason all icons on panel are blurry and difficult to see, as you can see in the screenshot below: Unfortunately, I did not find any explanation or ...
user avatar
1 vote
1 answer
85 views

How to insert a few rows of data into an existing .odt file with bash and libreoffice calc headless?

Is there a way in bash to open an existing .odt file in libreoffice calc and insert a few rows of data (in headless mode), basically manipulating an .odt file through bash? I'm reading some PDF files ...
user avatar
  • 13
2 votes
2 answers
396 views

LibreOffice.org: Create new file from the command line

I love my command line. I love that I can type: emacs non-existing-file.txt and then emacs will start editing a file, that does not exist yet, but if I save it, it will be called non-existing-file....
user avatar
  • 29.7k
3 votes
2 answers
1k views

Changing the UI font for LibreOffice in Linux

I'm using the official LibreOffice package for Linux, version 7.0.1, and I've no idea how to change the font for the user interface (dialogs, menu, options, etc). I've been Googling for that for the ...
user avatar
2 votes
1 answer
641 views

Libre Office - convert calc/exel schedule to csv from command line

I'm truing to batch convert some exel schedules to csv format from the command-line with the following command: libreoffice --convert-to csv *.xlsx I'm getting: error xsltParseStylesheetFile : cannot ...
user avatar
  • 4,750
1 vote
0 answers
105 views

AppImage error: library not found after build

(Linux Mint 20) I'm trying to build an AppImage of LibreOffice Base as a test to see if I can build the individual components of the suite. Here is my libreoffice-base.yml: app: LibreOffice_Base ...
user avatar
  • 2,554
0 votes
1 answer
180 views

LibreOffice distorts embedded videos

I'm using LibreOffice Impress on Arch Linux to make a presentation. When I embed a video into my presentation, the video initially plays fine, but gets distorted after a few seconds. The distortion ...
user avatar
  • 1,397
0 votes
0 answers
46 views

How to distribute rectangles evenly

I have 3 rectangles that I want to distribute horizontally evenly. According to this, there is a Modify > Distribution but I don't see it. Using LibreOffice 6.0.7.3 in Ubuntu 18.0.4
user avatar

1
2 3 4 5 6