LibreOffice is a free and open-source cross-platform office software suite, developed by the Document Foundation. It is the default office suite in many Linux distributions.

learn more… | top users | synonyms

7
votes
1answer
2k views

Preventing LibreOffice from using smart quotes (“ ”) instead of (dumb) straight quotes?

I use LibreOffice Calc to make lists of programs with different parameters to run on an hpc cluster. For each batch of commands I must do a find and replace on the smart quotes, as they cause errors ...
2
votes
1answer
3k views

How to copy a column with conditional format by “value” - Libreoffice 4.1

I have a column that contains the data and a set of rules for the conditional format of the cells. i.e. the conditional format changes the background colour of some cells if they are negative. I ...
7
votes
1answer
4k views

How to override GTK3 / Gnome Shell themes per application

I'm using both Cinnamon and Gnome Shell (Gnome 3) on Fedora 17 with the dark theme Blapple. Quite a few applications can't handle dark themes very good. In Gnome 2 I had a simple solution for these ...
4
votes
2answers
9k views

Convert file to PDF using LibreOffice under user apache (i.e. when using PHP)

I installed libreoffice-headless and can convert documents when logged on into the shell as a normal user. [root@desktop ~]# yum install libreoffice-headless [root@desktop ~]# yum install ...
9
votes
4answers
23k views

How to edit a read-only document in LibreOffice?

I need to fill a form (which I received in .doc format and saved as .odt). The file is read-only except for the fields where I can enter the information. Unfortunately, with the fields filled it ...
3
votes
1answer
1k views

How to prevent LibreOffice running 'recover' at each startup?

How to prevent LibreOffice running 'recover' at each start-up? On Ubuntu, each time I restart my computer, and then start LibreOffice, it asks me whether I want to recover documents. It does this ...
5
votes
1answer
569 views

ODBC Query cannot be executed because it is too complex?

I have a CSV file which I am using as a database with LibreOffice DB. What I'm doing is explained in detail in this answer. I can do some operations, but when I try to enter the following into the ...
3
votes
0answers
2k views

Libreoffice Base: How have a combobox linked to a related table linked to or in the form table control

I could not sum up, what I really want in the title. But here I am going to try to explain what is it about. I have switched from MS Access to Libreoffice Base because it is open source, free and ...
3
votes
3answers
2k views

How do you find the maximum value in a column, skipping to every nth value?

Using LibreOffice's Calc program (nearly the same functionality as Microsoft Excel) I have a set of numbers in column T, which represent numbers for the week (with labels in S). Each week's worth of ...
2
votes
1answer
410 views

Multimedia keys don't work in Foobar2000 when LibreOffice is in focus (Winamp is not affected)

Multimedia keys are ignored while focus is on Calc from LibreOffice. Media keys work in foobar when it's focused, also while other programs are focused. I use Windows 7 Home Premium SP 1. My Foobar ...
2
votes
1answer
2k views

Excel/Libreoffice returning TRUE for IF() instead of expression

See the following situation: For some Here cells A1:E3 have plain text data (no formulas), and C4:E4 have the same formula (i.e. typed in one cell and then autofilled to another ones). I wanted ...
2
votes
1answer
2k views

Printing from the command line with LibreOffice, lpr commands?

I'm trying to print a word document from the command line, but I need to specify printing options that I would normally use lpr for. This is the command I'm using libreoffice -p "filename.doc" I ...
2
votes
2answers
12k views

How can I print Excel spreadsheet files automatically?

My company has computer-generated reports that come out as Excel spreadsheets which are emailed to the Billing Department. They would like these reports to be automatically printed as they are ...
1
vote
2answers
62 views

Error 1327. Invalid Drive Windows 8

I'm trying to reinstall LibreOffice but getting the titular error. I think it's because I recombined a partitioned drive (D:\ and E:\ became D:) and LibreOffice was installed on the E:\ drive. So ...
0
votes
0answers
31 views

Switch off autocorrect in libreoffice calc for specific document, column, cell

There is a way to completely turn off autocorrect in libreoffice calc. However, I would prefer turn off autocorrect in less scale: document, worksheet, column/row, cell. How it can be obtained?
0
votes
1answer
108 views

How to get the average of the higher M values in N cells?

I have a spreadsheet with values in a matrix with several rows. For each row I have a N numbers. I want to calculate the average of the M higher values of the row. With M<N. Is there a common ...