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

26
votes
4answers
16k views

How to change the text direction in LibreOffice?

I need "right to left" text direction to write in Persian.
20
votes
5answers
6k 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?
14
votes
1answer
3k 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 ...
12
votes
3answers
17k 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?
9
votes
2answers
10k 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 ...
9
votes
4answers
25k 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 doesn'...
9
votes
1answer
4k views

Exporting vector graphics from Inkscape 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 ...
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 ...
8
votes
4answers
77k 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 ...
8
votes
2answers
595 views

How to copy drawing from LibreOffice Draw to MS Word?

What is the best way to copy a drawing (complete document) from LibreOffice Draw into an MS Word document (using MS Word) on Windows? A "naive" copy&paste form Draw to Word gives next to useless ...
7
votes
2answers
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 ...
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 ...
6
votes
1answer
8k 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 ...
6
votes
2answers
11k 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
3answers
2k 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 ...
6
votes
7answers
8k 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 format)...
6
votes
3answers
2k 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 vsd/...
5
votes
5answers
1k 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 ability?...
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-...
5
votes
2answers
311 views

How can I combine PDFs in LibreOffice?

I'd like to be able to simply drag a pdf file into the pages explorer of a pdf that's being edited. This has no effect and dragging the file into the work area on a new page results in something like ...
5
votes
1answer
1k 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 ...
5
votes
1answer
1k views

Libre Writer recognises 'Garamond' font when loading a document written in it, but does not have it as a selection

I am using Ubuntu 14, and am loading at Word .doc text file template provided by CreateSpacelink. The text in this template uses a font called Garamond. When I put a cursor over text in the template ...
5
votes
2answers
3k views

Move rows with the keyboard in Calc

How might one move a row to a different location with the keyboard? I have found this guide for the mouse but due to disability I have trouble using the mouse for this. Note that I am not looking to '...
5
votes
9answers
20k 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 ...
5
votes
2answers
996 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 ...
5
votes
2answers
757 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 ...
5
votes
1answer
315 views

Default font and cell padding when opening files in LibreOffice/OpenOffice Calc

I've seen solutions for setting a default font when creating new files. What about a default font (and cellpadding) when opening an existing CSV file? LibreOffice seems to always default to Liberation ...
5
votes
1answer
618 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
2answers
4k 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. ...
4
votes
2answers
6k 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 ...
4
votes
2answers
321 views

How does the group feature in LibreOffice Calc work?

LibreOffice Calc has as Group feature. The official help site just tells you where to find the button and what hotkey to use, but doesn't explain what grouping actually does: https://help.libreoffice....
4
votes
3answers
1k 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 ...
4
votes
2answers
1k 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 ...
4
votes
2answers
5k views

Which fonts come with OpenOffice / LibreOffice? [closed]

Is there a list of all the fonts which come with OpenOffice / LibreOffice ?
4
votes
1answer
107 views

How can I disable LibreOffice document recovery for files in my Dropbox directory?

I'm running LibreOffice 4.2.8.2, and I also use Dropbox. My problem is that I often modify my documents on different machines: one at work and one at home (both run Ubuntu 14.04). After modifying ...
4
votes
2answers
65 views

Change text direction RTL in LibreOffice on mac

I have marked the checkbox for CTL on language options and I can choose the Right-To-Left button, But on OSX EL Capitan when I type in Hebrew the text gets choppy and the cursor jump the the beginning ...
4
votes
0answers
490 views

LibreOffice has ugly PNG import [closed]

I'm trying to import a PNG graphic exported from Inkscape (I tried importing the SVG directly but it doesn't work: the text is missing and replaced by black boxes) in a LibreOffice document, but it ...
4
votes
1answer
880 views

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

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

Exporting UTF-8 text from LibreOffice without byte order mark

In LibreOffice, if I save a document as file type "encoded text" and select "Unicode (UTF-8)" as the encoding, it always writes a byte order mark (BOM) at the start of the text. It does this even when ...
3
votes
2answers
807 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
3answers
358 views

LibreOffice Writer … the ohm sign (Omega)

I am using LibreOffice Writer on Ubuntu 14.04 to do a class assignment and I need to use the Ω (Ohm sign, big letter omega) to show resistance. Unfortunately I can't seem to find the sign anywhere. ...
3
votes
2answers
30 views

Is it possible in LibreOffice Writer to make a style out of an element that has been manually formatted?

I have a frame that I have worked on to be positioned and styled exactly how I want it to look. In the same document, I want to make many other frames with the exact same parameters. However, I can't ...
3
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 ...
3
votes
1answer
3k views

How to create a new file from Finder's context menu?

Could you tell me how to add a menu item into Finder's contextual menu (the one I get when I Control-click in a folder)? When I create a document or spreadsheet using LibreOffice, I usually run ...
3
votes
3answers
412 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 ...
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
1answer
23 views

Add glue points to table in Libreoffice Draw

Is there a way to add glue points to table in Libreoffice Draw ? There are 4 standard glue points but I cannot add extra ones. By table I mean the object that you obtain by clicking Insert->Table.
3
votes
2answers
438 views

Hotkey (or similar) to quickly switch to a monospace font (“teletype”) in either LibreOffice or Microsoft Office

I find myself doing a lot of writing where I would have to change fonts for certain parts of the text. The obvious example is writing code documentation, where you'd have to reference code frequently, ...
3
votes
1answer
305 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
4k 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?