Questions tagged [libreoffice]

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

Filter by
Sorted by
Tagged with
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. ...
32
votes
4answers
105k 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 ...
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....
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 ...
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‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌?
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 ...
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
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
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 ...
1
vote
2answers
664 views

Attaching different LibreOffice Writer documents

I have a lot of .odt documents. How can I attach them together without hurting their contents? Copy and paste in LibreOffice is not safe and may change the format. For example, the position of ...
0
votes
1answer
1k 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 ...