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.

1
vote
0answers
21 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
34 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
1answer
42 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
223 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
17 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
115 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
54 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
223 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
38 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
212 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
74 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
34 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
340 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
31 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
47 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
50 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
80 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
33 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
182 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
591 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
122 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
1k 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
612 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
3
votes
1answer
5k 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
72 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?
0
votes
0answers
410 views

LibreOffice can't be installed in Linux Mint 18.3

I'm getting this error while trying to install LibreOffice via terminal. Tried sudo apt-get -f install and it shows 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Some packages could ...
3
votes
1answer
207 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
168 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
265 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
2k 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
782 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
73 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
149 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
312 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
327 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
40 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
793 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
94 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
137 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
593 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 ...
0
votes
1answer
37 views

How to edit LibreOffice 4 with MsOffice Word corrections?

I've received a file in docx. with some corrections made in MsOffice Word in the mode of correction (edition). How I can accept them in Libreoffice4 in Linux?
2
votes
2answers
303 views

Calc adds ' (apostrophe) when importing time from CSV

I have a CSV file as shown below that contains time durations. When I import into Calc, it looks good. However, when I want to work with the time duration and manipulate them, it doesn't work. When ...
0
votes
0answers
334 views

Average of cells with time HH:MM:SS

I am trying to get the average of a column for which the data type is Time (format HH:MM:SS) The function AVERAGE doesn't seem to work for this data type.
0
votes
2answers
778 views

Is there a live linux distribution with a specific set of softwares

How do I find a live linux distribution with a contain at least a specific set of software that I want? If you might be wondering, I am trying to find a live linux distribution (can be live dvd or ...
4
votes
1answer
3k views

Updating Libreoffice on Linux Mint

So I'm currently in internship and we work with Linux Mint. I have never worked with Mint before, so I have no idea how some things work. My boss gave me a project to make a guide on how to update ...
3
votes
1answer
453 views

How to format an arrow as a double line in LibreOffice Draw

I've searched all options in Line format, and I can make it dotted or change the arrow heads, but it seems impossible in my LibreOffice 5.0.3.2 to draw something as simple as a double line for an ...