Skip to main content
The 2024 Developer Survey results are live! See the results

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
19 views

Font embedding with Libreoffice (eps files)

I would like to generate an eps file with embedded fonts, to make sure that the font I am using in Linux (Nimbus Sans) will look the same when the file is opened on a non-Linux (e.g. Windows) PC. I am ...
Time4Tea's user avatar
  • 2,405
0 votes
0 answers
26 views

LibreOffice opens unwanted toolbars on new files

Whenever I open a new .doc or .docx file (typically downloaded from the Internet, or attached to email I have received), LibreOffice opens a lot of toolbars, cluttering my window and reducing the ...
Francesco Potortì's user avatar
0 votes
1 answer
62 views

LibreOffice on FreeBSD (GhostBSD) is missing GnuPG encryption entry fields

I set up a FreeBSD 14 (GhostBSD) box with a complete set of my GnuPG keys. Encryption/Decryption on the cli works as expected. I am used to encrypt files within LibreOffice on Linux (on the same ...
faustomaijstral's user avatar
0 votes
1 answer
21 views

How to not display the LibreOffice file picker / loader when closing any LibreOffice application?

Until today, when I closed any LibreOffice application (e.g. Writer, Calc, Draw, Impress, etc.) in Linux Mint, the expected happened: LibreOffice would close. Now, suddenly, when I close any ...
End Antisemitic Hate's user avatar
0 votes
0 answers
20 views

How to change colours of text & lines in header rows/columns in LibreOffice Calc?

In LibreOffice Calc, how does one change the colours of the text in the header rows and columns? I'm referring to the "A", "B", "C", ... and "1", "2"...
End Antisemitic Hate's user avatar
0 votes
1 answer
102 views

How can I find and replace cells containing #N/A in LibreOffice Calc?

I used a VLOOKUP function on some cells, and got lots of #N/A among some results. I then later copy/pasted them as values to another sheet. So now I have a column with a few numbers and several #N/As. ...
anol's user avatar
  • 833
0 votes
1 answer
29 views

Add image to LibreOffice Writer 7 "Application Background"

I'm wondering if it is possible to set an image to the LibreOffice Writer "Application Background". This is the area in blue the attached image. I can modify the color of this area by going ...
this_name_here's user avatar
1 vote
0 answers
35 views

LibreOffice problem when trying change details

Am long term user of LibreOffice When open cells to modify details on the change page it opens longer down than shows on my monitor(s). LibreOffice has similar results with both ubuntu and openSUSE. ...
polpak's user avatar
  • 21
0 votes
1 answer
368 views

Problem installing LibreOffice on Amazon Linux 2023

I am following the instructions on how to install LibreOffice on Fedora which is what I believe Amazon Linux 2023 uses under the hood: https://tecadmin.net/install-libreoffice-on-fedora/ I can ...
kravb's user avatar
  • 101
0 votes
1 answer
63 views

file time stamps - birth time changes after editing an saving a file, with libre office writer or xed

Im on Linux Mint 21, I have a EXT4 file system Filesystem features: has_journal ext_attr resize_inode dir_index filetype needs_recovery extent 64bit flex_bg sparse_super large_file huge_file ...
Schmaehgrunza's user avatar
0 votes
1 answer
36 views

Multiple footnotes/citation for the same word in LibreOffice

I am using LibreOffice v7.1. I have a sentence that have to end with citation/footnote. For example, the following sentence has a word and footnote "1". In some cases I have a sentence that ...
user429323's user avatar
0 votes
1 answer
39 views

Need help to add text with text field with Libre Office writer

Hi I am trying to create LO Basic Macro that add text with text field, and put some text to text fields like this: If l>2 Then 'not first time, insert file after Doc5 ...
Juha Lehtonen's user avatar
0 votes
0 answers
368 views

remove password from libreoffice calc or excel file in terminal

I like passwords and security but once a file is safely on my encrypted drive it can become an annoyance and overkill having it there. The following command nicely and cleanly removes the password ...
cardamom's user avatar
  • 602
1 vote
1 answer
507 views

install Libreoffice language pack on Debian

I'm asking this as I remember trying for more than half an hour at some point in the last year and giving up, now I need to do it more urgently. Essentially to have spell-check in a European language ...
cardamom's user avatar
  • 602
1 vote
0 answers
135 views

LibreOffice takes long time to open

I'm running Arch Linux with KDE Plasma desktop environment. When I open any LibreOffice program lately, it takes several minutes to open. It hangs for some time on the "LibreOffice Community"...
Generic_User_ID's user avatar
0 votes
1 answer
116 views

Display the 0 at end of value (Libre Office Calc)

When I'm creating number values in a column, in Libre Office Calc, the 0 number is hidden from the view, if it is at the very end of the number. I'd like to see all of the numbers, even if the last ...
Ryan King Art's user avatar
1 vote
2 answers
236 views

In LibreOffice Calc how do I choose a random cell excluding cells with specified text?

In a LibreOffice Calc I am trying to retrieve the value from a random cell within a group of cells, some of those cells may contain the word "None", I don't want any of those chosen when the ...
DeJeL's user avatar
  • 350
0 votes
2 answers
182 views

How to add a system font to LibreOffice Writer?

My Linux system is using Monospace Regular to display Monospace Text. I would like to try the font in my documents. However when I go through my long list of fonts it is not there. How can I make it ...
eqs2388's user avatar
-1 votes
1 answer
159 views

How to force =RAND() to run only once in LibreOffice Calc?

I am trying to randomize a list of words in LibreOffice Calc. Column A contains numbers 1 to 15, indicating the initial order of the words. Column B contains the words themselves. Here is the original ...
wvz93427's user avatar
0 votes
0 answers
33 views

LibreOffice Writer fonts

I downloaded the KDP template (https://kdp.amazon.com/en_US/help/topic/A16ABVH839JCP0?ref_=kdp_ts_pb_man) but all the Styles are different fonts. How can I get them all to be the same font? Everytime ...
Snowcrash's user avatar
  • 699
2 votes
2 answers
1k views

Libre Office - Linux DEB or RPM for Chrome OS?

I'm trying to install Libre Office on my Chromebook and I don't know whether to download the DEB or RPM version.
John Stiver's user avatar
0 votes
0 answers
65 views

System font are not available in Libreoffice

Gnome is set to use Monospace Regular for Monospace Text. However when I open Libreoffice Writer that is bundled with my distribution, I cannot select that font in the GUI. How can I make the font ...
juc8853's user avatar
0 votes
1 answer
87 views

In Libreoffice calc, how can I compute until something happens?

In Libreoffice calc, can I compute columns until something happens? Like compute 2 raised to the power i while the result is less than 10 raised to the power 2023 and store the values to the cells A1, ...
guest's user avatar
  • 1
0 votes
1 answer
93 views

How to diff styles between two odt files?

How one could diff styles embedded in two different Open Document Text file (odt) ? For example, a person A create a file and modify the header/titles styles, store the document in a shared drive. ...
Zulgrib's user avatar
  • 984
1 vote
1 answer
51 views

How to close LibreOffice opened file one at a time?

I find that when I opened multiple files with LibreOffice and I close one, LibreOffice will also close another file. I want to close the file separately as my question title. I also find this question ...
manungsa's user avatar
0 votes
0 answers
110 views

Libreoffice Writer: change the toolbar button font color to automatic

It seems the default is to have a red button there, which is odd: clicking it makes selected font red, but wishing that is a rare possibility. This seems to be normal behavior - as said under here. ...
cipricus's user avatar
  • 1,629
0 votes
0 answers
263 views

LibreOffice systematically crashes my Linux system

When I launch LibreOffice, I get the widget with the LibreOffice logo (the one displayed while the application loads), then my screen blinks three/four times, then it turns black. All I can do at that ...
Pietro's user avatar
  • 573
1 vote
0 answers
159 views

How to view information about TSA from signed pdf?

How to get information about TSA (Time Stamping Authority) if it was used for a timestamp when signing a PDF document, e.g. with LibreOffice Draw? LibreOffice Draw only displays the time, it is not ...
Mato's user avatar
  • 595
0 votes
1 answer
352 views

Editing Libreoffice Calc spreadsheets in the terminal

Is there an app to edit LO Calc spreadsheets in the terminal, i.e. in text mode w/o the GUI?. It doesn't need to be a LO package, anything will do. It needs to be able to save in Calc's .ods format. ...
jzz11's user avatar
  • 11
0 votes
2 answers
126 views

How to install libreoffice in centos5 without yum?

I'm trying to install the Libreoffice in CentOS 5. Unfortunately, my system is separated with Internet. So I can't use the YUM for install. Fortunately I found https://downloadarchive....
Carter's user avatar
  • 136
0 votes
0 answers
17 views

RDP Timeout Using Libreoffice Impress on Pop!_OS

I am connecting using RDP a raspberry pi 400 to a desktop, both running Pop_OS, the pi running 19.10 and the desktop running 22.04. Everything is fully updated. I am using Remmina to manage the ...
Austin C.'s user avatar
8 votes
2 answers
2k views

Why does LibreOffice (at least as packaged for Debian) depend on libldap?

The Debian package libreoffice-core (which is described in the Debian repositories as containing " the architecture-dependent core files of LibreOffice," and which is itself a dependency for ...
Chris Henry's user avatar
3 votes
1 answer
2k views

What is SUSE's rationale for shipping Python 3.6 in Leap 15.4?

I recently switched from a Ubuntu 20.04 based distribution to openSUSE Leap 15.4. While I feel more comfortable with some of SUSE's packaging decisions, certain others are confusing me. As a Python ...
mara004's user avatar
  • 147
0 votes
0 answers
299 views

Linux Debian Bullseye - not able to install packages after uninstalling libreoffice

I uninstalled libreoffice and its packages to replace it with another office software. After this step I cannot use apt properly. Doing sudo apt-get install xxxx throws this error message (it always ...
ciahoneypot's user avatar
6 votes
1 answer
3k views

Is it possible to open a password-protected ODT document if the exact password was forgotten?

I have a long password for an old .odt password-protected document. I am using that password for other purposes so that I am sure that was the initial password of that odt document. But I have ...
cipricus's user avatar
  • 1,629
1 vote
1 answer
187 views

Remove Unused Data Range-Libre Office Calc (Line Chart)

I'm creating a line chart with Libre Office Calc. All of the number values stay within a high range, so when I create the chart, there is a large gap of unused data on the bottom of the chart, and its ...
Ryan King Art's user avatar
2 votes
2 answers
339 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 ...
ingli's user avatar
  • 1,889
1 vote
1 answer
1k 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&...
Sadi's user avatar
  • 505
0 votes
1 answer
2k 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 ...
John's user avatar
  • 101
0 votes
1 answer
92 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 ...
searcher's user avatar
0 votes
1 answer
2k 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, ...
mike rodent's user avatar
  • 1,142
2 votes
2 answers
263 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 ...
Pratched's user avatar
  • 151
3 votes
0 answers
2k 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, ...
Karthik Thrikkadeeri's user avatar
0 votes
0 answers
20 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, ...
Cal's user avatar
  • 101
0 votes
1 answer
87 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 ...
showkey's user avatar
  • 415
0 votes
0 answers
39 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 ...
ludant's user avatar
  • 1
0 votes
1 answer
811 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 (...
Aviv Aviv's user avatar
  • 131
0 votes
0 answers
144 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 ...
sam nikzad's user avatar
4 votes
4 answers
1k views

How to stop LibreOffice Draw from crashing in Debian Bullseye?

After I switching from Debian 10 to 11, LibreOffice Draw 7.0 can no longer open. I tried opening an existing file and starting a new file, no matter how I open Draw, it crashes with this message: Due ...
Village's user avatar
  • 3,717
2 votes
1 answer
341 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'...
Lonnie Best's user avatar
  • 5,205

1
2 3 4 5 6