Questions tagged [libreoffice]
Questions about LibreOffice and the included applications (Writer, Calc, Impress, Base, Draw, Math). Unless the question is a general how-to, user should always tell which version of LibreOffice in use.
2,253
questions
6
votes
1
answer
1k
views
How to get the data from Libre Office Calc and use it in a bash script?
I am Using Ubuntu 20.04.1
I have Libre Office Calc. with two columns working.
I do edit these two columns weekly once..
A 987654320
B 987654321
C 987654322
D 987654323
E 987654324
F ...
0
votes
1
answer
268
views
LibreOffice creates lock file
I'm unable to access libreoffice files in Ubuntu.It's creating lock files and not opening. Why is it happening? Please tell the solution.
3
votes
0
answers
408
views
Menu Bar missing in LibreOffice 6 under Ubuntu 20.04
desperate Question:
How do I get the menu bar back in LibreOffice 6?
Above you see: LibreOffice 5.1 under my old faithful Ubuntu-MATE 16.04.
Below you see: LibreOffice 6.4 under fresh installed ...
1
vote
1
answer
215
views
Xubuntu: LibreOffice dispays no menu icons
I face an issue while using LibreOffice on Xubuntu: LO does not display the icons in the menus.
I don't know if the problem is specific to the gtk3 VCL but I don't have the problem with x11 and qt5 ...
0
votes
0
answers
369
views
How to force LibreOffice Calc to recalculate a spreadsheet from the command line?
I want to be able to force recalculating a spreadsheet from the command line in LibreOffice Calc.
I believe this is possible but am having trouble figuring out a complete solution. I found another ...
3
votes
1
answer
1k
views
Text in Pdf file out of the right margin, and strange chacarters - libreoffice draw
When I open a Pdf file in libreoffice Draw, the text exceeds the right margin, and strange characters appear in the text. How can I fix it?
Original (opened with document viewer):
Opened with ...
0
votes
1
answer
852
views
Libre office Calc freezes wile working on a sheet in xlsx format
I'm currently facing an issue where an excel file ocassionally freezes while working on it and applying some vlookup formula to it. I'm not sure if it is an issue with the file itself or in Libre ...
1
vote
0
answers
309
views
Libreoffice writer bypassing Linux file permissions
I have a file marked as read-only:
ls - l | grep 400.IntoTheShelterOfTheCabin.odt
-r--r--r-- 1 stephen stephen 27K 2020-07-22 08:11 400.IntoTheShelterOfTheCabin.odt
Yet LO Writer will save changes ...
3
votes
2
answers
9k
views
Video not playing in LibreOffice Impress
Using Ubuntu 18.04.4 and LibreOffice Impress 6.0.7.3
When I insert an mp4 video in the slide only a screenshot of the video appears and I am not able to play it. How do I play mp4 videos in ...
1
vote
2
answers
5k
views
LibreOffice does not find libicui18n.60.so after upgrade 18.04->20.04
I have upgraded from bionic to fossa, and now LibreOffice complains that it does not find a shared library:
$ soffice
/usr/lib/libreoffice/program/soffice.bin: error while loading shared libraries: ...
9
votes
3
answers
21k
views
Convert PDF to Word Using Libreoffice in terminal
I am using the following libreoffice command to convert my pdf files into word(doc)
lowriter --headless --infilter='writer_pdf_import' --convert-to doc:"MS Word 2007 XML" sample.pdf
After ...
2
votes
1
answer
271
views
How does gnome-documents depends on libreoffice?
I want to install gnome-documents on Ubuntu 20.04 desktop. It's a pretty bare installation and I'm taking care of what is being installed. When trying to get it through apt I see the long list of ...
0
votes
1
answer
2k
views
How to download a particular version of libreoffice using sudo cmd?
I am new to ubuntu OS. The thing is, I need to download the LibreOffice version 6.0.1 in my ubuntu OS. I tried the following command .
sudo apt-get install libreoffice=6.3.0
it is showing Version '6....
0
votes
1
answer
1k
views
Character spacing in LibreOffice writer
I'm having some trouble with LibreOffice Writer! The spacing between the letters seems messed up, with characters having more or less space than they should. This is a document I originally created ...
1
vote
0
answers
105
views
Bullets disappeared from presentations in LibreOffice, might be a font issue?
I have on my disk quite a lot of old presentations from earlier versions of OpenOffice (.odp format) and even StarOffice (.sxi format). When viewed in OpenOffice on my old computer (OpenOffice 3.2.0, ...
0
votes
1
answer
228
views
Is to possible to have office documents opened in LibreOffice while using RStudio on modern Ubuntu?
I use Ubuntu MATE 18.04 LTS with installed R and RStudio to build bookdown books and documents.
Previously I used these applications in 16.04 LTS.
Building/knitting book or single RMarkdown document ...
0
votes
1
answer
2k
views
How to export a xlsx to pdf/A on the cli
I've tried both with lowriter and localc yet it always looks very bad and isn't PDF/A.
Ive tried:
localc / lowriter --convert-to pdf *.xlsx
2
votes
2
answers
1k
views
Determine which fallback font is used by LibreOffice (for Garamond)
When I enter Garamond as a Font in Libreoffice, I get a nice font which is not listed in the installed fonts. Actually, as Garamond is a paid font, the one displayed on screen is a fallback font. I ...
1
vote
1
answer
2k
views
Libreoffice Calc window is minimized when started (ooSetupFactoryWindowAttributes is set to zeros)
I have a fresh Ubuntu 20.04 install and have the following problem.
When opening Libreoffice Calc, the window is very small on the top left and only two x are visible.
The code in ...
1
vote
1
answer
58
views
When I have the "File" menu open in Gimp or LibreOffice, why can't I use my Xfce4 shortcut keys like the start menu, etc?
When I open the "File" menu or any of the other menus in LibreOffice or GNU Image Manipulation Program, why do my xfce4-keyboard-settings shortcuts stop working until I click off the menu in ...
1
vote
1
answer
30
views
Foot note/ End note numbering in Bengali in Libreoffice
Can anyone help me with how to enable Foot note/ End note numbering in Bengali language in Libreoffice?
Only options available (CTL>General Options>Nuerals) are:
Arabic
Eastern Arabic
System
...
0
votes
1
answer
227
views
LibreOffice 6.4.4.2 can't open file under symbolic link
I installed LibreOffice 6.4.4.2 from Software center (Ubuntu 20.04).
I tried to open file under a symbolic link, but I can't open it because symbolic link directory looks like a file.
How do I open a ...
0
votes
1
answer
2k
views
Changinge font size of a pdf file using Libre draw?
I can change the font size of pdf using Libre draw one line at a time. Since the file is big, I want to do that in one go. Any suggestion on how to do that?
3
votes
1
answer
853
views
How can I set LibreOffice to use ISO 8601 date format?
I need LibreOffice to use ISO 8601 date format, but it falsely shows MM/DD/YY when it should correctly be showing YYYY-MM-DD.
To reproduce I do:
Open a new LibreOffice document and choose Insert->...
1
vote
1
answer
111
views
Ctrl+Alt+Arrow up/down LIbreOffice Writer vs Workspace
I often use Ctrl+Alt+Arrow Up/Down to reorder paragraphs in MS Word and LibreOffice Writer and also in text editors that allow it.
When I work in Ubuntu this key moves the screen-focus between ...
2
votes
1
answer
3k
views
How to connect Libreoffice Base with mysql on Ubuntu 20.04?
I have a virgin install of 20.04 (instead of upgrading from 18.04, and older versions). mysql works, but I cannot use LibreOffice Base to connect to my database in mysql. This worked well in 18.04. I ...
9
votes
2
answers
4k
views
Convert .pptx or .ppt files to mp4 on Ubuntu
I have few slides sent by my professor. In those slides, each slide is embeded with an audio file. I want to view them as a video file.
In Microsoft Office PowerPoint for Windows, there is an option ...
2
votes
1
answer
752
views
Czech Localization for LibreOffice
I am running on Ubuntu 20 04. I have LibreOffice 6.4.4.2 installed and trying to switch its user interface to Czech language.
I have installed the package libreoffice-l10n-cs and restarted LibreOffice....
1
vote
4
answers
3k
views
Ubuntu 20.04 - no menu bar in LibreOffice
In Ubuntu 20.04 with GNOME flashback, there is no menu bar in LibreOffice (the one with File, View etc.). I read somewhere on the Net that the issue is related to libreoffice-gtk3 package, and ...
0
votes
1
answer
959
views
Canon MG2550 printer: "check your printer configuration"
I’m trying to print from Libre Office Writer (Version: 6.4.3.2) on Focal. This is the first time I have connected the printer since installing Ubuntu as a dual boot.
As soon as the printer was plugged ...
1
vote
0
answers
53
views
Characters run together in Libreoffice Writer
In LibreOffice Writer under Ubuntu 20.04 and LibreOffice 6.4.3.2, the characters are all jumbled together. Can the characters and spacing be fixed? Screen image below.
0
votes
0
answers
131
views
LibreOffice writer reverts date field to local format
I have a date field in my footer and I would like it to be shown in ISO 8601 date format and not the local format.
I use
right click -> Edit Fields... -> Format
to change it and I saved my ...
0
votes
1
answer
59
views
Command to open 68 MB pdf file uses all system resources and fails, but it works on other files
When I double click this pdf with Thunar, it opens quickly.
But when I use this command in a launcher, it uses 100% of CPU and half of RAM, yet it never opens the 68 MB pdf file?
/usr/lib/...
1
vote
0
answers
3k
views
Understanding AppArmor log messages
I'm trying to understand different log messages in /var/log/kern.log that started appearing a few days ago. I'm new to AppArmor, I've read man pages and I understand the concepts, I've searched on the ...
1
vote
2
answers
263
views
AbiWord File says Error and file cannot convert
I have been using AbiWord for the last few months working on a major project. I have gotten very far in my writing, but yesterday as soon as I pressed save my computer died. I did not think of it as a ...
4
votes
3
answers
836
views
Add languanges to be always present on "Tools > Language > All Text" in LibreOffice Writer
How do I explicitly add specific languages to "Tools > Language > All Text" in LibreOffice Writer?
2
votes
0
answers
193
views
Visited hyperlinks won't change color in LibreOffice
The color of visited links won't change.
I've changed the color, rest the menu, tried linking to websites, and other slides. Nothing ever happens. It just remains the original link text color.
...
0
votes
1
answer
2k
views
Why is Libreoffice using only one core?
When I use libreoffice calc for big table (around 100 000 lines), when I make operations on the filters, libreoffice freezes for some times while calculating, and i've seen in the CPU use that it's ...
8
votes
4
answers
2k
views
Help of libreoffice does not work after Ubuntu 20.04 dist-upgrade (object not accessible insufficient user rights)
When i do F1, the help window appear and a message alert also :
Object not accessible. The Object cannot be accessed due to insufficient user rights.
libreoffice help do not open
I understand what ...
1
vote
0
answers
163
views
Ctrl+C and other commands working every other time in LibreOffice on 20.04
I'm using Ubuntu 20.04 in English (US).
Keyboard shortcuts are working normally on the GNOME Shell and all programs but LibreOffice.
At least in Writer, Calc and Draw, commands like Ctrl+C and Ctrl+...
1
vote
0
answers
247
views
Flatpak Libreoffice has blank icons in dock/dash
I installed LibreOffice as a Flatpak in Ubuntu 18.04. The same behavior was observed with the Snap version.
When I open a Writer or a Calc file the icon in the GNOME dash (vertical dock bar on the ...
0
votes
1
answer
85
views
Menu bar disappeard in LibreOffice, Waterfox after upgrading from 18.04 to 20.04
After upgrading Ubuntu from 18.04 to 20.04, both LibreOffice and Waterfox no longer have menu bars. I am using XFCE4 as my desktop environment. I have seen that this problem pops up from time to ...
3
votes
1
answer
6k
views
How to draw a normal curve in Libreoffice Calc?
How to calculate the distribution, mean and standard deviation for drawing a normal curve distribution chart (bell shape curve) in Libreoffice Calc?
0
votes
0
answers
49
views
Being stopped on LibreOffice when trying to update Lubuntu
The following packages have unmet dependencies:
libreoffice-core : Depends: libreoffice-common (> 1:6.3.5) but 1:6.3.2-0ubuntu2 is installed
libreoffice-help-common : Depends: libreoffice-common (...
0
votes
1
answer
192
views
Drawing a Chart From CLI Using LibreOffice
I have a file that contains two columns of values, so I am looking for a way to draw a chart from my CLI. In another word, I need a script that reads the file that contains the values and represents ...
0
votes
1
answer
192
views
Libreoffice dysfonctional mail merge
Ubuntu 19.10/LibreOffice 6.3.5.2
Mail merge (by email) does not work. I checked:
the db calc document contains a column with valid emails
the SMTP connection from libreoffice was tested
In the ...
2
votes
2
answers
4k
views
Undefined symbol error when starting LibreOffice in Ubuntu 20.04
After executing the command libreoffice I am getting the following error message.
/usr/lib/libreoffice/program/soffice.bin: symbol lookup error: /lib/x86_64-linux-gnu/libcairo.so.2: undefined symbol: ...
0
votes
1
answer
631
views
Can't open .ods file I created and saved in Google drive - no application for "application/x-vnd.oasis opendocument.spreadsheet type" files
I created a spreadsheet in LibreOffice calc and saved it remotely, Google, as a .ods file. When I double clicked this file in files to open it I got:
There is no application for "application/x-vnd....
1
vote
0
answers
358
views
Open Google Doc in Libreoffice with Gnome file integration
I signed into my Google account in Gnome, and I can access my files from nautilus, however opening any document opens google docs in my browser directly, and opening in LibreOffice Writer results in ...
5
votes
2
answers
13k
views
How to remove LibreOffice installed with Lubuntu 20.04
I found a problem with the way the default install of LibreOffice Impress handles fonts on Lubuntu 20.04. That problem is covered here. In short, the solution was to remove the default install of ...