Unix and Linux Stack Exchange
Unix and Linux Stack Exchange

Questions tagged [libreoffice]

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

269 questions
50
votes
1 answer

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-click menu, but I can't see anything related ... )
neydroydrec
  • 3,777
  • 8
  • 32
  • 42
35
votes
4 answers

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 periodically (by someone else). I want to write a…
allrite
  • 453
  • 1
  • 4
  • 5
33
votes
2 answers

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 with the formula H2/86400+25569 which I got from the…
Fazle Rabbi
  • 506
  • 1
  • 5
  • 15
22
votes
3 answers

E: Unmet dependencies. Try 'apt --fix-broken install' with no packages (or specify a solution) libreoffice

Every time I try to upgrade it shows me this message sudo apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done You might want to run 'apt --fix-broken install' to correct these. The…
Carlos tmf
  • 321
  • 1
  • 2
  • 3
21
votes
6 answers

Linux PPTX presentation Viewer

Besides Open Office, is there any solution for opening .pptx presentations on Linux (Debian to be more precise)?
Razvan
  • 312
  • 1
  • 2
  • 5
18
votes
2 answers

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. Instead of a UTF-8 mdash (—) that I get if I do a…
Scott Deerwester
  • 391
  • 1
  • 3
  • 14
14
votes
1 answer

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 changing its default program from the Properties…
user5104897
  • 721
  • 3
  • 12
  • 23
12
votes
4 answers

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. When I specify…
Johan
  • 123
  • 1
  • 1
  • 6
11
votes
1 answer

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
n0pe
  • 9,411
  • 13
  • 60
  • 108
10
votes
5 answers

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 document disappears, as it was stored by default…
jj_p
  • 283
  • 2
  • 8
8
votes
2 answers

Why does LibreOffice (at least as packaged for Debian) depend on libldap?

The Debian package libreoffice-core (which is described in the Debian repositories as containing " the architecture-dependent core files of LibreOffice," and which is itself a dependency for libreoffice-writer and similar packages) has an absolute…
Chris Henry
  • 197
  • 8
8
votes
1 answer

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 LibreOffice document in Writer and export it to PDF in the…
Niall Cavanagh
  • 81
  • 1
7
votes
1 answer

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 trans(... whatever) between slides. I made a…
Baard Kopperud
  • 7,023
  • 6
  • 42
  • 62
7
votes
4 answers

GTK FileChooser causes crashes in several programs

I have repeatedly encountered a problem with several programs that use open/save file dialogues. Upon initiating these by trying to open or to save a file, the program freezes for about 10 seconds and then crashes. With libreoffice for example, I…
Jonas Schwarz
  • 254
  • 2
  • 15
6
votes
1 answer

Is it possible to open a password-protected ODT document if the exact password was forgotten?

I have a long password for an old .odt password-protected document. I am using that password for other purposes so that I am sure that was the initial password of that odt document. But I have modified very slightly that password for that document…
cipricus
  • 1,386
  • 13
  • 42
1
2 3
…
17 18