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

19
votes
5answers
5k views

OpenOffice vs LibreOffice - what's the difference?

I'm considering switching from Microsoft Office (too expensive) to an open-source option. What's the difference between OpenOffice and LibreOffice?
9
votes
3answers
18k 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 ...
8
votes
4answers
6k views

How to change the text direction in LibreOffice?

I need "right to left" text direction to write in Persian.
8
votes
1answer
2k views

How to remove rules from a style in OpenOffice/LibreOffice?

When creating a style in LibreOffice, you can "link" them to other rules so that they inherit the other rules styles and only modify specific properties. For example if the default style defines a ...
8
votes
2answers
8k views

Converting Open Office (odt) files to Latex

How do you convert Open Office (ODT) documents to tex files? I have made a report using libre office. Now I wish to continue editing the document using lyx (latex front end). So the ODT file needs to ...
8
votes
1answer
2k views

Exporting vector graphics from Inskcape into Libreoffice

I'm trying to export a reasonably complex illustration from Inkscape into a Libreoffice Writer document. I'd like to avoid rasterizing the illustration as much as possible. So far I've tried the ...
6
votes
2answers
8k views

How do I export the charts in a spreadsheet as PNGs?

I made a spreadsheet and generated some graphs in Calc. I would like to grab each chart as a PNG (JPG will be fine too) and save them as an individual file so I can post the charts on my blog. I ...
6
votes
1answer
3k 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 ...
5
votes
5answers
888 views

Does any spreadsheet allow you to create your own functions?

I've always been frustrated when using spreadsheets by the inability to define my own functions when there is no existing function to (cleanly) do what I want. Does any spreadsheet offer this ...
5
votes
2answers
1k views

How to stop OpenOffice/LibreOffice from popping up toolbars when I click on stuff

When I import a picture or a chart into my document and click on it, LibreOffice spawns a toolbar, shifts the whole screen around for a second, and then allows me to move stuff again. It gets very ...
5
votes
7answers
6k views

Which doc format should I use in LibreOffice if other users open it in MS Office

I often share documents with colleagues. I use LibreOffice (and OpenOffice). But my colleagues use Microsoft Office. My documents always look differently when opened in MS Office (.doc and .odt ...
5
votes
4answers
59k views

How to open ods files in Excel?

What is the best way to open ods files in Excel 2003? Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)? The file I ...
5
votes
1answer
386 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 ...
4
votes
1answer
506 views

How to configure own shortcuts for styles?

When I Ctrl+B a selected text, it will become bold. Alas, this style is directly formatted, which means it gets lost once I default via Ctrl+M. Yet whenever I reset the whole document, I only want it ...
4
votes
1answer
525 views

Is there a way to set the default quotation mark in LibreOffice Calc from smart quotes (“ ”) to dumb quotes (the straight kind)?

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 ...
4
votes
1answer
2k 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
1answer
304 views

Is it possible to access and edit Google documents directly from Libreoffice?

I'd like to work with a Google spreadsheet directly inside Libreoffice, without having to export and import it, in order to automatically reflect the changes on the online file. Basically, I'm looking ...
4
votes
3answers
858 views

Can I import OpenOffice.org settings into LibreOffice?

I'm considering migrating from OpenOffice.org to LibreOffice, and I want to make sure LibreOffice picks up all of the settings and customizations I've made. Will LibreOffice read the user profile ...
4
votes
9answers
13k views

Registering a program to show in the “Open With” list

After installing LibreOffice and then unistalling OpenOffice, all the files for the many office document types (odt, ods, doc, xls, rtf and a dozen more) are unassociated with any application. When I ...
4
votes
1answer
796 views

Custom CSV (.csv) filter for OpenOffice.org or LibreOffice?

Is it possible to create a some kind of 'custom CSV filter' for OpenOffice.org or LibreOffice spreadsheet program. What I need is to have the program to use predefined CSV settings for loading and ...
3
votes
3answers
5k views

LibreOffice Writer: How to apply strikethrough text formatting?

Version: LibreOffice 4.0.2.2 Is it possible to apply strikethrough text formatting in LibreOffice Writer?
3
votes
2answers
417 views

How do I access the search functionality in Open Office?

I am very new to oo and plodding slowly; never used a spreadsheet, etc.etc. I downloaded a document of botanical names for flowers/herbs, etc. The page was set in 3 columns and was 138 pages long (!) ...
3
votes
2answers
2k views

LibreOffice is saving CSV files with tabs as separators

I just opened a CSV file in LibreOffice, made a small change and hit save, saying "yes, keep using CSV". The file is now filled with tabs instead of commas. My scripts (using Python's CSV lib) won't ...
3
votes
2answers
4k 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 ...
3
votes
1answer
191 views

Chapter outline numbers as initials in LibreOffice Writer?

I am trying to have the chapter title (outline) level 1 numbers as initials in LibreOffice Writer. I have set up a character style which gives me the big title numbers, but they are all from the base ...
3
votes
2answers
2k views

Which fonts come with OpenOffice / LibreOffice? [closed]

Is there a list of all the fonts which come with OpenOffice / LibreOffice ?
3
votes
2answers
451 views

LibreOffice: stop automatic formatting of text into a formula?

In LibreOffice, I'm entering some text into cells, which happens to look like a math problem: -5 / -10 / -15 The program assumes I want to calculate this, and sticks an equals sign automatically in ...
3
votes
3answers
1k 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
2answers
2k views

How to change an image resolution in Libre Office or Open Office?

I have a odt file with many heavy images and to be friendly with some one i want to forward the odt i want to decrease the images resolution by hand. How to do it?
3
votes
1answer
85 views

Export LibreOffice Colour Scheme

I changed the colour scheme in LibreOffice (Tools → Options → Appearance) and defined my own colour scheme. I would like to know where (in which file or database) this new colour scheme was saved to ...
3
votes
1answer
1k views

Updating LibreOffice on Linux clients

We currently have Linux Mint installed on a number of devices and would like to upgrade the version of LibreOffice installed i.e. 3.4.4 to the latest version of 3.5.2 however upon running the command ...
3
votes
1answer
113 views

Two instances of the same table in the document

In LibreOffice writer I have a table on which I perform some small calculations. How can I have an instance of the same table on another page in the same document (automatically updated)? (e.g. ...
3
votes
1answer
1k views

What is the best document standard to save to using Open/LibreOffice in order to maintain compatibility with Office?

For some reason I've always assumed the older formats (Office 2007/XP) DOC/XLS were the safest to maintain compatibility with Office simply due to them being aged and likely more mature, however I've ...
3
votes
1answer
90 views

Arabic: Unicode: how to stack fatha kasra damma

I am using LibreOffice to type arabic, but if what I am asking cannot be obtained with LibreOffice then I would like to know whether it is possible in LaTeX, because I have seen this in a book, but do ...
3
votes
2answers
1k views

Is there a CLI-only package to convert MS Office files to PDF?

Is there a command-line interface only package to convert Microsoft Office files to PDF? Specifically, I need to be able to export doc/docx (Word), ppt/pptx (PowerPoint), xls/xlsx (Excel), and ...
3
votes
2answers
12k views

Is it possible to copy & paste a pivot table in a spreadsheet?

I have a spreadsheet where I use some pivot tables to summarize and highlight some relevant data. Since I have to use multiple pivot tables, all with nearly the same data input but with slight ...
3
votes
2answers
5k views

How to change icons in LibreOffice toolbars?

I personally find (you're free to disagree) LibreOffice's toolbar icons ugly and not quite intuitive, so I decided to replace them... if I only knew how... Any advice? (I'm especially interested in ...
3
votes
1answer
581 views

Memory Issue using OO (soffice) as batch conversion service

I have a Java Web Application that uses an OOo instance (on the same environment) started in headless mode as batch converter. environment is RHEL 5.5. The OpenOffice version is 3.1. I've run some ...
3
votes
1answer
490 views

How compatible is LibreOffice with OpenOffice?

LibreOffice and OpenOffice both use the OpenDocument format, and LibreOffice is based on OpenOffice. But how compatible are they which each other?
3
votes
1answer
145 views

How can I get LibreOffice to 'number' footnotes in the order *, †, ‡, § etc.?

With LaTeX, I can do: \documentclass[10pt]{article} \usepackage[symbol*]{footmisc} \begin{document} One\footnote{f1} Two \footnote{f2} Three \footnote{f3} Four \footnote{f4} \end{document} And ...
3
votes
0answers
262 views

Export Power Point presentations to flash with control buttons on Linux

I need to export *.pps, *.ppt, *.ppsx, and *.pptx files to .swf files. On Windows I used iSpring for Power Point, and worked well. This is the result of iSpring: I am searching for an ...
3
votes
0answers
124 views

E-Learning Web Authoring

The company I work for creates online courses for operation and maintenance of various equipment. Currently, we write the courses in Word. We have an XML schema that is applied to the document. The ...
2
votes
2answers
2k views

Only root User is able to open LibreOffice

I am currently using Linux Mint 14 - Nadia as my Operating System. The biggest inconvenience right now is not being able to open Libreoffice as a normal user or simply by just double clicking it. ...
2
votes
3answers
2k views

libreoffice what is a fast way to paste special > text and numbers only (aka paste special values)?

I copy and then paste values in excel quite a bit (when I use Excel). When I use LibreOffice you can do the same thing (see related question here) but it is oh so tedious! It gets especially tedious ...
2
votes
2answers
53 views

How to autofilter for given strings in common spreadsheet softwares?

I know I can create an "autofilter" at the top of an XLS table.. But how can I create a filter that filters for given strings? example TABLE input: LASFD@FOO.COM LKXYCVER@FOO.COM ...
2
votes
1answer
498 views

What character encoding does ODT use?

Whenever I open an ODT file saved by LibreOffice with default settings, and open it in a plain text editor, I get a bunch of nonsense. Not a single trace of the text I typed. In what character ...
2
votes
1answer
5k views

Open Office Calc: Convert a date to timestamp

I have a column with dates in M/D/Y like this: 8/8/2007 8/9/2007 8/10/2007 8/13/2007 8/14/2007 8/15/2007 8/16/2007 I would like to convert them to a unix timestamp (in a new column). Would anyone ...
2
votes
3answers
641 views

How do I prevent LibreOffice saving the file with the thumbnails?

I am using LibreOffice 4.0 on Windows 7 and I have noticed that it saves files (for example Writer) with a preview. (The icon of the file shows what's inside it, it looks like a page). How do I turn ...
2
votes
1answer
1k views

LibreOffice 4.2.1.1: do not display list of recent documents

Today I installed LibreOffice 4.2.1.1. When opening LO, it displays a list of recent documents with screenshots, similar to Firefox and Chrome. I don't want this. How can I disable this setting?
2
votes
3answers
217 views

Vim undoing text width formatting

I wrote a document in vim with textwidth=80. I would now like to paste this document into libreoffice for formatting. The problem is the line breaks. In libreoffice the lines are too short because of ...