Questions tagged [libreoffice]
LibreOffice is a cross-platform office suite that originated as a fork of OpenOffice.
269
questions
0
votes
0
answers
36
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 ...
- 528
1
vote
1
answer
78
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 ...
- 528
1
vote
0
answers
64
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"...
0
votes
1
answer
43
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 ...
- 117
0
votes
0
answers
16
views
Change Plasma keyboard layout and LO Writer paragraph language with one shortcut
I often write in 2-3 languages in the same text for which I use 3 different keyboard layouts. Thus, I very often have to switch the layouts but also the paragraph language.
I would like to have the ...
- 1,346
1
vote
2
answers
106
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 ...
- 350
0
votes
2
answers
98
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 ...
- 1
-1
votes
1
answer
50
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 ...
- 1
0
votes
0
answers
28
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 ...
- 569
0
votes
0
answers
23
views
Binary Search Libreoffice Calc
Does anybody know of a way to organize a binary search in LibreOffice Calc?
To take a simple example, say I have column A with the numbers 1-16 listed, sorted in ascending order: (1,2,3,...); and ...
2
votes
2
answers
538
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.
- 21
0
votes
0
answers
47
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 ...
- 1
0
votes
1
answer
57
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, ...
- 1
0
votes
1
answer
53
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. ...
- 914
1
vote
1
answer
38
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 ...
- 125
0
votes
0
answers
82
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.
...
- 1,346
0
votes
0
answers
155
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 ...
- 561
1
vote
0
answers
111
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 ...
- 585
0
votes
1
answer
173
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.
...
- 11
0
votes
0
answers
93
views
libreoffice needs multiple version of libs
I try to install libreoffice on Archlinux and when I want to run that it needs libboost_locale.so.1.78.0 (boost-1.78)
~> libreoffice --calc
error while loading shared libraries: libboost_locale.so....
- 1
0
votes
2
answers
93
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....
- 135
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 ...
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 ...
- 197
2
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 ...
- 138
0
votes
0
answers
271
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 ...
6
votes
1
answer
2k
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 ...
- 1,346
1
vote
1
answer
137
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 ...
- 117
1
vote
2
answers
176
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 ...
- 1,675
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&...
- 441
0
votes
1
answer
1k
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 ...
- 101
0
votes
1
answer
84
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 ...
- 11
0
votes
1
answer
1k
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, ...
- 1,092
2
votes
2
answers
210
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 ...
- 151
2
votes
0
answers
1k
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, ...
0
votes
0
answers
16
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, ...
- 101
0
votes
1
answer
75
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 ...
- 99
0
votes
0
answers
37
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 ...
- 1
0
votes
1
answer
514
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 (...
- 131
0
votes
0
answers
138
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 ...
- 101
4
votes
4
answers
908
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 ...
- 4,715
1
vote
1
answer
239
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'...
- 4,955
-1
votes
1
answer
60
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 ...
- 14
1
vote
1
answer
346
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?
- 119
0
votes
1
answer
564
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 ...
- 123
1
vote
0
answers
147
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....
- 407
5
votes
2
answers
2k
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 ...
- 152
1
vote
1
answer
20
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 ...
- 291
0
votes
1
answer
128
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 ...
- 138
0
votes
0
answers
36
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 ...
- 787
0
votes
1
answer
227
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:...
- 145