Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [libreoffice]

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

0
votes
0answers
24 views

Repair a corrupted .odp file

I have a corrupted .odp file that cannot open anymore in LibreOffice Impress. There is no back-up available in LibreOffice (.bak file is missing). I was wondering if there are some powerful Linux ...
2
votes
1answer
30 views

Open output of a command using libreoffice

I am running certain commands in a loop and would like to open its output in libreoffice (calc), without storing it. This is what I have tried: libreoffice --calc <(process m n) libreoffice --...
0
votes
0answers
9 views

Libreoffice printer list adds entities that don't work. How to suppress?

I have various printers available via CUPS which everything, including LibreOffice, has available in the printing menu. These have useful queue and display names, defined locally, such as ...
2
votes
2answers
131 views

Lock file naming pattern

Whenever I open a LibreOffice document, LibreOffice creates a lock file along the original file. This file has a naming schema like the following: .~lock.MyDocument.odt# Is this a LibreOffice ...
1
vote
0answers
24 views

Can I manipulate .xls workbooks in linux (tcsh)

I have 2 Excel Workbooks, A and B. Workbook A.xls has 2 worksheets, Sheet1 and Sheet2. Workbook B.xls also has Sheet1 and Sheet2. Without opening the workbooks, I would like to delete Sheet2 in A....
1
vote
0answers
33 views

How to remove the thin line on the edge of LibreOffice GUI menu bar?

How do I get rid of this thin line in the menu bar of LibreOffice and other applications? Previously I used Elementary OS which did not show that thin line didn't exist. After changing to KDE Neon, ...
2
votes
1answer
26 views

Diagramm with varying sheets as data area's

I'm searching for a way to change the data area of a diagramm with a drop down menu: on sheet1 i want to have the diagramm and a drop down menu where i can select from which sheet the diagramm take ...
1
vote
0answers
25 views

Gnupg - Passing Decryption To Application

When you decrypt a file with GnuPG with the -d option and the file is in ascii form, it simply scrolls down the screen and can be read. But what if it isn't an ascii file that was encrypted, but say a ...
1
vote
0answers
42 views

Running an old version of LibreOffice

Using Linux Mint 19 64-bit here. I'm experiencing a bug in current LibreOffice versions (6.2.0.3, but it's apparently been around since 5.x.) A known good version with regards to this bug can be ...
0
votes
2answers
94 views

How can I unlock a file locked for editing by DESKTOP/Username?

How can I unlock the file below on Mint 19? This is a LibreOffice document I had opened when my PC crashed.
0
votes
1answer
315 views

Libreoffice not responsive / slow on Linux Mint 19 Cinnamon

After a fresh install of Linux Mint on my system, Libreoffice feels slow and unresponsive. Every time I type something, there is a significant delay before the text comes up. This is especially ...
1
vote
1answer
18 views

MultiMarkdown processors: Fonts?

I just found MultiMarkdown, which is awesome. I've installed the GitHub official application from https://github.com/fletcher/MultiMarkdown-6 on my Gentoo box, and I'm using it to create HTML pages ...
2
votes
1answer
169 views

Can I increase the number of decimal places stored by Libre Office Calc?

I have an array of numbers with 16 decimal places. When I copy them into a Libre Office Calc spreadsheet, the numbers are rounded off to the 15th decimal place. I assume this is a result of the ...
0
votes
1answer
59 views

Plot with hours that have a sign on Libreoffice-Calc

On Libreoffice calc I have a spreadsheet that can compute certain quantities in time (hours). These quantities can be positive or negative. For example, the values in the spreadsheet can be a daily ...
2
votes
0answers
286 views

office files are being read as zip archive and vice versa. How can I resolve this?

I am running Manjaro linux KDE and am enjoying. But opening office & zip file is a pita for me. Look the screenshot. My zip file opens by libreoffice (or WPS). And if I correct it in file ...
0
votes
1answer
46 views

How to do sum calculations in libreoffice calc, single column

I have a .csv file which has two columns and about 50 rows of data in them. One of the columns has some numbers in it. What should have worked is - =sum<B1:B50> the result should be displayed ...
0
votes
2answers
275 views

How to remove the gradient of Libre Office on dark theme of KDE?

I'm using the Dark Theme of the Debian 9 with KDE Plasma 5.8.6, but when I open the Libre Office, this is what I see: I think this gradient is very ugly, so I want to change for a solid color, or for ...
0
votes
0answers
101 views

LibreOffice won't open on Fedora 27

If I've tried to open a file I've got splash screen with loader and it disappear. If I run it from terminal I've got output: Application Error if I run libreoffice --writer I don't get any output, ...
0
votes
0answers
38 views

LibreOffice Calc error - the formula separators have been reset to their default values

I want to set locale setting for Language in Libre Calc 6 to my current one in Ubuntu 18 (strange it's not that way by default...). I set it to locale with point for decimal separator (and space for ...
0
votes
1answer
459 views

How does “Export as JPG” work in LibreOffice Writer?

In OpenOffice Writer there is no option to export a document as JPG, only export as PDF. Therefore to make an image, first I have to convert the document as pdf, then convert the PDF to JPG. But if I ...
0
votes
0answers
14 views

LibreImpress deleting inserted pdf images after a while

I have Libre Office 5.4.6.2 40m0(Build:2) on Ubuntu 17.10 My LibreOffice Impress keeps deleting all the .pdf images I insert to it every so often (can't figure out the periodicity yet). It looks like ...
1
vote
0answers
33 views

LibreOffice becomes unresponsive and overloads my CPU when Copying and Pasting text

I have a table in LibreOffice which I regularly update. The table currently has 6, 561 words, 45, 255 characters and takes up 39 pages. I don't have any extravagant pictures, just a handful of ...
0
votes
2answers
53 views

Should a package always be purged before upgrading?

I am thinking of upgrading Libreoffice 5 to 6 through backports. Do I have to purge LO5 first? Furthermore, is purging absolutely necessary before upgrading packages in general?
1
vote
1answer
65 views

LibreOffice placeholder fields documentation

I have to modify a LibreOffice template with a number of conditional statements. I managed to figure out one can add such statements through Insert > Fields > More fields, tab Functions, type ...
1
vote
1answer
94 views

Put page numbers in front of images in LibreOffice Impress

In LibreOffice Impress (5.2.7.2), I inserted page numbers in the master slide, positioned almost at the bottom right corner. But in a few slides, there are images occupying the whole space, thus ...
0
votes
1answer
38 views

How to count errors in a LibreOffice spreadsheet?

I have a bigger spreadsheet (a few hundred rows, ~ 30 columns), and I would like to display a cell in the header with the number of errors (number of cells that have errors in them) in this ...
0
votes
2answers
208 views

How to install LibreOffice on Bodhi Linux

How to install the LibreOffice suit on the latest Bodhi Linux version (4.5.0)?
2
votes
0answers
637 views

Convert .odt to .pdf on the command line - include automatically inserted blank pages

"How to convert libreoffice ODT to PDF in bash" has a nice description of how to convert .odt to .pdf. It does, however, not work if you want to check 'Export automatically inserted blank pages'. ...
0
votes
1answer
133 views

Disable macros headless libreoffice

I'm using libreoffice as a pdf converter inside a docker container by utilising the headless functionality. How can I disable macros? I'm using debian strech-9.3 and libreoffice 5.4.5
0
votes
0answers
2k views

How to open Composite Document File V2 Document, Cannot read section info

Output of file command for a given odt file gives me Composite Document File V2 Document, Cannot read section info. By searching on Google I found it a doc document and I installed unoconv to read ...
1
vote
1answer
833 views

How to create a nested list in Libreoffice Writer?

I would like to create a list that looks as follows: Main item 1 1a. Sub item 1a 1b. Sub item 1b Main item 2 2a. Sub item 2a 2b. Sub item 2b 2c. Sub item 2c Main item 3 3a. Sub item 3a
4
votes
1answer
6k views

Convert epoch time to human readable in LibreOffice Calc

I have a epoch time in cell H2 which has a value of 1517335200000. I am trying to convert it to a human readable format which should return 30/01/2018 6:00:00 PM in GMT. I have tried to convert it ...
1
vote
2answers
91 views

To read RTF files, is there a package, besides libreoffice, I can install on RHEL7?

I received an rtf formatted file on an RHEL7 machine - that does not have libreoffice. Is there a package I can (yum) install - that will allow me to read that rtf file?
3
votes
1answer
226 views

LibreOffice: soffice/oosplash start permission denied error

Few days after installed OpenBSD, I got the following error: $ libreoffice /usr/local/lib/libreoffice/program/soffice[171]: /usr/...
0
votes
2answers
189 views

how to import customers to dolibarr

I have a rough and ready table as: mysql> mysql> show tables; +----------------------+ | Tables_in_businesses | +----------------------+ | 2017july | +----------------------+ 1 row ...
1
vote
1answer
298 views

LibreOffice Writer crashing on Debian “buster” with Gnome desktop

I had the problem with libreoffice --writer crashing on my system without any message. libreoffice --calc was working without any problem. (I did not check on the others like draw or impress). I have ...
3
votes
1answer
3k views

Export from Libreoffice Calc to a table LaTeX [closed]

I would like to know if there is a way to transform a sheet of LibreOffice Calc to a table LaTeX. Thank you in advance!
0
votes
1answer
854 views

Except some applications (like VLC) from using the current gtk3 theme

I want to use a dark theme all over but to have some exceptions. Especially VLC looks awkward with a dark theme. Is there a way to avoid VLC using the dark theme? Considering answers under the ...
0
votes
2answers
89 views

Memory resouce monitoring program

How to write a shell script to filter out the %Mem consumption of some process like Mozilla Firefox and LibreOffice Writer. Both values need to sum up.
1
vote
1answer
174 views

Using the Address function in Openoffice Calc

I want to find the position of the largest value(s) in a row. I am using this function to get the largest value, MATCH((MAX(start position of row numbers:end position of row numbers),(start ...
0
votes
0answers
38 views

how to handle broken XML Microsoft Office Word documents

I have received an xml file with a form that I am supposed to fill. The filename ends in .doc, so I assume it's supposed to be a word document. As far as I understand it was automatically generated by ...
2
votes
0answers
362 views

Copy-pasting image files into LibreOffice Writer doesn’t work from the Xfce desktop

I want to copy-paste image files into LibreOffice Writer. It works fine when copying the files within Thunar: the image appears in the document. It doesn’t work when copying the files from the Xfce ...
1
vote
1answer
361 views

find and replace macro in libreoffice

How can I write a find and replace macro to merge many items in few, as "USA, Mexico, Canada, Honduras" in "America", "China, India, Vietnam" in "Asia" and so. Before macro: USA, Mexico, Canada, ...
2
votes
0answers
41 views

Why do some LibreOffice templates fail to run in Ubuntu 17.04?

I'm running Xubuntu 17.04, and I'm using LibreOffice Calc for my data. LibreOffice Calc technically runs fine, but I thought: Hey, why not try the other LibreOffice template? So I tried to run ...
6
votes
4answers
825 views

How to create a symlink which opens (literally) the target file

Suppose I have a file bar.txt inside directory foo and create a symlink baz.txt to foo/bar.txt. Like: ./foo ./foo/bar.txt ./baz.txt -> foo/bar.txt If I open baz.txt my editor will think baz.txt ...
1
vote
1answer
122 views

How to print to PDF while appending to an existing document?

I am considering installing Linux Mint. I need to be able to Print to PDF, which appears to be as simple as selecting Print to PDF as the printer, however I also need to be able to append to ...
2
votes
2answers
3k views

Write shell output to MS Word document

Problem: I usually output text from my shell to file using >. I am trying to find an equivalent process that outputs a MS Word document (.doc or .docx). I was thinking to use libreoffice and ...
0
votes
2answers
1k views

Installing Ubuntu Software Applications in Qubes OS

Is it possible to install the Ubuntu Software Applications, such as LibreOffice and others in Qubes OS? Thanks.
1
vote
1answer
155 views

Inserting delimiter into file

I have a file with a similar format to the following: 1.1.1.5 Ensure mounting of hfsplus filesystems is disabled 1.1.1.6 Ensure mounting of squashfs filesystems is disabled 1.1.15 Ensure nodev option ...
1
vote
1answer
683 views

Times New Roman not working after installing ttf-mscorefonts-installer in Debian

I have installed ttf-mscorefonts-installer to get Times New Roman to work in Libre Office in Debian Stretch. A very weird thing has happened though - Times New Roman is not installed but other fonts ...