Questions tagged [libreoffice]

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

Filter by
Sorted by
Tagged with
44
votes
1answer
40k views

How to maintain (top) row visible while scrolling?

I did it once, but cannot find out how any more: how to keep the top row of my LibreOffice Calc sheet visible when scrolling? (Intuitively it should be either in view or format, at best in right-...
32
votes
4answers
106k views

Convert a .xlsx (MS Excel) file to .csv on command line with semicolon separated fields

I realize that this is not an entirely unix/linux related question. But since this is something I'll do on linux, I hope someone has an answer. I have an online excel file (.xlsx) which gets updated ...
14
votes
5answers
48k views

Linux PPTX presentation Viewer

Besides Open Office, is there any solution for opening .pptx presentations on Linux (Debian to be more precise)?
11
votes
1answer
4k views

Reduce the space around in-line formulas in LibreOffice

When inserting a formula into LibreOffice, there is a whole lot of padding between it and other words. How can I modify the formatting of formulas to make the padding much smaller? LibreOffice 3.3.1
10
votes
5answers
3k views

saving in /tmp is not really saving?

Open e.g. a mail attachment from Firefox (without previously saving it); this is a Libre Office document, you edit it, and then push save (not save as) and close both text editor and browser. Then the ...
10
votes
2answers
10k views

Specify encoding with libreoffice --convert-to csv

Excel files can be converted to CSV using: $ libreoffice --convert-to csv --headless --outdir dir file.xlsx Everything appears to work just fine. The encoding, though, is set to something wonky. ...
8
votes
1answer
201 views

Wrong emblem used for PDFs created by LibreOffice

If I create a test pdf file in a directory, by using something like ls -al > testpdf.pdf the file is shown in Caja 1.4.0 with an understandable emblem that is 'acrobat-like'. If I create a ...
7
votes
3answers
8k views

How to convert libreoffice ODT to PDF in bash

I am using libreoffice under CentOS 6. I can convert ODT files to PDF with: libreoffice --headless --convert-to pdf *.odt but the problem is that it only works when no document is open in libreoffice....
7
votes
1answer
12k 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 ...
7
votes
1answer
1k views

Open/Libre Office: Restricting Impress to PowerPoint-compatible content?

Is there a way to restrict the Open/Libre Office presentation-program Impress to just PowerPoint-compatible content? Preferably in a way that "shadows-out" or removes non-compatible animations and ...
6
votes
4answers
962 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 ...
6
votes
1answer
3k views

Setting default application for filetypes via CLI?

I have 150 Debian Jessie machines that open ODS files in Gnumeric when double-clicked despite LibreOffice Calc being installed. I know it is possible to change this by right-clicking the ODS file and ...
6
votes
1answer
15k views

Headless use of open office or libreoffice in Ubuntu 14.04

I want to install openoffice headless in Ubuntu 14.10, but when I try to install it, it says there is no package for that name. I installed libreoffice-common using apt-get, but I can't find headless....
4
votes
3answers
2k views

Lightweight feature-rich alternatives to OpenOffice and LibreOffice

I really like LibreOffice however I'm having issues with it freezing up and I can't seem to start a new instance of the writer on multiple desktops (I'm using dwm and want several documents open). ...
4
votes
1answer
103 views

How to add a component to existing LibreOffice?

Initially I didn't think I would need Impress Presentation, so through a custom installation I left it out. Of course, now I could use it ;) Go figure! Can I do this? I am using Ubuntu Studio 16.04 (...
4
votes
1answer
2k views

Making graphs from database with Time/Date field

I've been trying to make a diagram from a LibreOffice (version 4.2.8.2) Base database with a date/time field, by copying the table in Calc. But the graph completely ignores the time part. To explain ...
4
votes
2answers
18k views

Open CSV File And Go Straight To Spreadsheet

Part of my software issues various commands to open and view different file types. For instance I use atril for PDFs and eom for PNGs. However I have a slight problem with CSV files. I can open them ...
4
votes
1answer
3k views

How to convert all odt files in a folder into microsoft word files ?

I have a folder with a lot of odt files from LibreOffice, I could open each one by hand and save it as a microsoft word file, but that would take a long time, is it possible to reach this goal using ...
4
votes
1answer
2k views

Libreoffice Writer, how to get read-only a document part

I am writing a document with Libreoffice Writer. I would like to set a part of it as read-only, while the rest of the document as non-read-only. Is it possible to do it? How?
4
votes
1answer
1k views

Getting a digital signature from an eToken/smart card into LibreOffice

I successfully managed to make use of digital signatures in LibreOffice Writer by following flatmtn.com/creating-pkcs12-certificates But now I want to use a digital certificate from an eToken/smart ...
4
votes
0answers
2k views

How do I recover/use Powerpoint speaker notes after import to LibreOffice Impress? [closed]

I have several MS Office Powerpoints that I would like to view in LibreOffice Impress. The slides import without any problems, but the speaker notes appear to be missing. How do I recover/access the ...
4
votes
2answers
678 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 ...
3
votes
1answer
2k views

LibreOffice Writer Go to page

Is there a go to page feature in LibreOffice writer so one can type a page number to go to that page? There similar feature in MS Word.
3
votes
1answer
5k 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!
3
votes
2answers
844 views

Converting .odm to .odt

How can I convert LibreOffice Master Document which consists of several .odt files into a single .odt file‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌?
3
votes
1answer
637 views

How to convert .doc to ODF with a command line?

I'd like to convert many Microsoft Word documents to ODF (the OO.org formata with a command line (because there are many of them). (I need them for reading afterwards on a device where reading OO.org ...
3
votes
2answers
18k views

How to calculate percentages in LibreOffice Calc?

I am currently calculating percentages in LibreOffice Calc using the function =PART/TOTAL where PART and TOTAL are cell coordinates of a same column. Dragging-down the formula won't do, because the ...
3
votes
2answers
3k views

LibreOffice 4.0 looks ugly in KDE

I installed recent LibreOffice version (4.0) but it looks so ugly in my KDE on Linux Mint, as shown in the following picture... how can I fix this issue?
3
votes
2answers
9k views

Is there an easy way to list the number of unique values in a column in LibreOffice calc?

In LibreOffice calc I have a column with thousands of values. Is there an easy way to list the number of UNIQUE values? e.g. a column which had red red red green green blue blue blue would ...
3
votes
1answer
768 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 ...
3
votes
1answer
482 views

LibreOffice Writer Numbered headings

I can't seem to get LibreOffice to consistently number my headings. I created a new document on one computer, with my headings set up to number thusly: 1 First Heading 1 1.1 Heading 2 2 Second ...
3
votes
1answer
7k views

Run terminal commands from within LibreOffice's Basic programming?

Is there a way to run system commands in LibreOffice Basic macros so that macros will be able to do things outside LibreOffice (e.g. changing keyboard layout)?
3
votes
1answer
1k views

Libreoffice document recovery automatization

I am wondering if there is a way I can launch libreoffice so it does document recovery or exits. I want this so when my computer boots up and I log in I am immediately prompted with document recovery. ...
3
votes
1answer
491 views

Reverse horizontal scrolling direction in Libreoffice

I am running Libreoffice on Debian Unstable with XFCE, and I ran into a bit of an issue: every time I use the touchpad to move around the document horizontally, it moves in the opposite direction (i.e....
3
votes
1answer
664 views

How to do handwriting animation in LibreOffice Impress presentations?

I've got some slides with handwriting-style fonts on them. Is there a way to do a "handwriting" animation on them? To make it seem like the text is being written, letter by letter? I've figured out ...
3
votes
2answers
8k views

Proper way to convert PDF to word from bash command-line

I need to convert 1K pdf files to doc on a debian server. I can convert a PDF to word using libreoffice commandline: libreoffice --headless --invisible --convert-to doc Sample-doc-file-100kb.pdf Or ...
3
votes
1answer
538 views

Calc: How to convert a numeric column in-place?

In Libreoffice Calc, is there a way to convert a column of numbers "in-place", such as converting from miles to kilometers, or percent to decimal? I know how to do it by: adding a temporary column, ...
3
votes
1answer
3k views

Are there any MathType clones for Open/Libre - Office?

Are there any OpenOffice.org/LibreOffice equation editor/makers, similar to MathType?
3
votes
1answer
310 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/...
3
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
0answers
504 views

Color cells based on text value in LibreOffice Calc

I have a column of containing the days of the week. |dow | |----| |Tue | |Wed | |Thu | |Thu | I would like to color the background of each day differently. So every Mon would have the same color ...
3
votes
3answers
212 views

How is it possible to know whether my computer has been infected by a Macro Virus?

Today, I have received a new doc. document and wanted to open it using LibreOffice (Version 5.1.6.2). The following Warning Message was displayed: "This document contains macros. Macros may contain ...
3
votes
0answers
156 views

How is This Symbolic Link Not Being Followed?

I have LibreOffice Writer and OpenOffice Calc installed on my OpenSuSE system. This is arguably not ideal, but before I fully switch to one or the other, I noticed some strange behaviour when calling ...
3
votes
0answers
133 views

Why does selecting text only “copy” it (as in copy and paste) circumstantially?

One of the most user-friendly features of Linux is that highlighting or selecting text will automatically copy it so that it can be pasted upon a middle- click. However, this can also be a point of ...
3
votes
0answers
1k views

Viewing .doc and .docx documents with MathType equations on Linux

Is there a way to view .doc and .docx documents with embedded MathType equations on Linux? When I try to open them with LibreOffice, I get blank boxes where the math is supposed to be - the same ...
2
votes
2answers
475 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 ...
2
votes
3answers
182 views

Fully MS-compatible office

I am using LibreOffice 3.4.5 on CentOS. Unfortunately, it's not fully compatible with MS Office. In particular, reading docx files leads to loosing all of the embedded formulae and some of the ...
2
votes
2answers
197 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 ...
2
votes
1answer
4k views

libreoffice calc: formatting hyperlinks

My installation of libreoffice calc 5.1.1.3 doesn't seem to alter the formatting of hyperlinks, i.e. it looks the same as any other text by default. When doing searches for how to format said links, ...
2
votes
1answer
2k 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

1 2 3 4 5