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

4
votes
2answers
13k 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 ...
8
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
4k 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 ...
5
votes
2answers
10k 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 libreoffice-...
7
votes
2answers
5k views

How can I save my styles' modifications for eternity in LibreOffice?

Every time I modify or create a new style in Libreoffice Text Document it works great while I'm in the document. Yet, every time I go out from Libreoffice and then I go back, all my modifications and ...
3
votes
1answer
2k 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
620 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
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 ...
3
votes
0answers
3k 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 ...
2
votes
1answer
53 views

LibreOffice on OS X: running soffice keeps saying no Info.plist or no NSPrincipalClass in Info.plist

I'm trying to run LibreOffice 5.1.3 from the OS X terminal, to script some conversion tasks. However whenever I run soffice, I always get this error: No Info.plist file in application bundle or no ...
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
3k 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 ...
1
vote
0answers
53 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?
1
vote
2answers
70 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
1answer
15 views

LibreOffice custom list of languages (for document, selection, paragraph)

(This was also posted on the ask.libreoffice site, which is not a stackexchange site, so don't hurry closing or down-voting for that reason. But if you do, for whatever reason, please mention that ...