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

0
votes
1answer
60 views

How to apply a page style to a specific set of pages?

I want to split my document in three parts. The first part is the first document which has the style "First Page". The other ones have "Default". Now, I want the appendix to have the "Index" page ...
4
votes
1answer
680 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 ...
0
votes
2answers
609 views

How can I get the “After the Deadline” Libre Office extension to work

I have installed the "After the Deadline" extension for LibreOffice 3.6.3, but it does not pick up any grammatical errors, either as a wavy blue line while I type, or with a complete spell check of ...
2
votes
2answers
677 views

Horrible kerning in LibreOffice

You'd think that kerning would be the #1 thing to get right in a text processor, but LibreOffice shows me this: Font is Palatino, with bold applied. How to fix this? Note that the kerning is ...
1
vote
1answer
681 views

Creating fillable PDF form with dynamically updated fields

Is there a way to create fillable PDF forms where a set of fields gets their data when one of the fields is filled out? The normal use case would be application form, where your name or membership ...
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 ...
0
votes
0answers
44 views

How to reduce the number of spell-check languages/dialects

Even when I install Libre-Office (3.6.1) in advanced mode and only select Dutch, German, English and French as spell-check languages, I still find many more dialects (German-German + Austrian-German + ...
3
votes
1answer
147 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 ...
1
vote
3answers
1k views

What Excel formats are (most) compatible with LibreOffice and Google Docs? [closed]

I use Excel (and occasionally Numbers), but I want to be able to share with users of Google Docs and LibreOffice (and I may want to switch in the future). What's the most compatible format to save my ...
2
votes
1answer
2k views

MSI installer: Run in English instead of the system language

How can I make an MSI installer run in English? I'm trying to install LibreOffice on a machine running a Korean version of Windows XP. I don't know Korean. I haven't used Windows with any frequency ...
2
votes
0answers
336 views

Typing math formulas in LaTex and getting them in MathType format?

I am asked to type some math formulas that can work in Microsoft Office and MathType equation editor. But I only have access to Ubuntu 12.04 near me, there is LibreOffice available under Ubuntu as ...
1
vote
0answers
460 views

OpenOffice, LibreOffice and NeoOffice all crashes on startup on OSX LIon

I tried all new versions of LibreOffice, OpenOffice, NeoOffice. When I install them without any problems and then I try to launch them, I get the following error: Process: soffice.bin [1178] ...
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 ...
5
votes
5answers
940 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 ...
1
vote
0answers
114 views

Is there an easy way to view SVN changes in the OpenOffice/LibreOffice document compare view?

I store documents in a subversion repository. I would like to be able to see either my local yet to be checked-in modifications, or else the differences between two particular revisions, using the ...
0
votes
2answers
4k views

Can I make LibreOffice default program for all files

I have winXP LibreOffice and MS office installed. How do I make LibreOffice the default opening program for all of its know document types? I know that I can change one extension at a time. But is ...
3
votes
1answer
6k 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 ...
3
votes
0answers
276 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 ...
2
votes
1answer
2k views

Professional templates pack in LibreOffice

I have installed the Professional Template Pack II - English OpenOffice.org extension in LibreOffice 3.5.5.3 on Windows 7. However, when I try to select a template, I don't see anything new. Is the ...
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 ...
2
votes
1answer
327 views

System-wide auto-complete word list syncing/integration?

I've been thinking that convenient auto-completion is my must-have feature of the text editors and word processors that I use. I wonder if anyone knows of a program or library that implements a ...
2
votes
1answer
243 views

Command line utility for the LibreOffice Mythes library

(Open|Libre)Office provides a thesaurus using the Myth library. Is there a command line tool to access these thesaurus data ?
2
votes
0answers
243 views

How are the 2010 OpenDocument Text (.odt) from OpenOffice and the 2012 one from LibreOffice different?

As you probably know when you're reading this question, an .odt file is just a .zip file containing some folders and .xml files. I used to appreciate this, for I could make a document with keywords ...
0
votes
2answers
2k views

Libre Office (or Open Office) create a Writer template with image background

I am seeking a Writer-type application that will allow me to set an image page background (for stationery papers) and save it as a template. I have Libre Office right now and I choose ...
1
vote
1answer
2k views

How to prepare organization chart in Libre Office?

It is very difficult to draw an organization chart in Libreoffice. Is there a function similar to Microsoft word or excel?
6
votes
7answers
7k 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 ...
0
votes
1answer
839 views

How do I restore the MS Word file associations after installing LibreOffice?

I have installed LibreOffice because it is the word processing application used by my son's school. But I've noticed after the installation that Microsoft Word file types are now associated with ...
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 ...
1
vote
1answer
5k views

Dark background in LibreOffice under Windows

I hate to write on with background, so i usally write my papers in a simple text editor, because I can have a dark background, but it's still annoying not to be able to use LibreOffice advanced ...
1
vote
1answer
914 views

LibreOffice / Openoffice or Scribus for book project?

I want to create a book and publish it later with an ondemand book printing provider. I read that Libreoffice 3.4 and 3.5 have some more DTP features but dont know if I should take Scribus or ...
1
vote
2answers
241 views

Is there a Microsoft Office alternative for Linux that allows users to retain the formatting as is?

We have been migrating several PCs, laptops, etc to Linux and one of the most common issue we have is with users attempting to format documents previously created with Microsoft Office of varying ...
3
votes
1answer
115 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. ...
1
vote
2answers
732 views

How can I black out text in LibreOffice?

I'd like to black out specific text from a document so that the words are fully concealed. I know how to put a line through the text, but not how to adjust the size of that line so that the text under ...
0
votes
2answers
2k views

Change spacing between words in LibreOffice

The question is simple. How can I change the space between words in LibreOffice? Something like this (from InDesign):
2
votes
2answers
1k views

Is there a subversion plugin available for LibreOffice/OpenOffice similar to MagnetSVN?

I recently came across the plugin, MagnetSVN, for MS Office which allows for svn interaction directly from MS Word. I'm looking for something similar for LibreOffice and/or OpenOffice. I came across ...
2
votes
1answer
4k views

Convert ppt to jpg

I am using an Ubuntu system. I want to convert ppt or pptx to jpg using terminal commands. I have libreOffice and ImageMagick installed in my system. I am successfully converting pdf to jpgs using ...
5
votes
1answer
452 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 ...
1
vote
1answer
1k views

Could not open libreoffice “general error in central configuration file”

Problem: Today I attempted to open a document with libreoffice. I got the error "could not open application. There is a general error in your central configuration file." Naturally I opened up my ...
6
votes
4answers
63k 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 ...
0
votes
1answer
1k views

Double valued drop-down menu in libreoffice-calc

Suppose I have a spreadsheet like this in libreoffice-calc: Now I want to have a drop down list in A3 to choose between the strings in E3 (Text a) and H3 (Text b) such that automatically cell B3 ...
2
votes
0answers
204 views

Querying DB2 view from Libreoffice Base

I've created a view in DB2 that has the information I need for labels that I was hoping to print out from LibreOffice. When I query the view from the console ("SELECT * FROM ADDRBOOK.LABELS"), I get ...
3
votes
1answer
642 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 ...
0
votes
1answer
432 views

Are there clip arts for LibreOffice or OpenOffice?

Is there a standard set of clip arts for LibreOffice (or OpenOffice), like the ones coming with Microsoft Office? I am running Debian and LibreOffice from the standard repository, if it makes any ...
0
votes
1answer
157 views

Are there Linux utilities for previewing files (partic. .doc's) rather than full-blown editing?

Instead of opening .doc, .odt, etc. files in LibreOffice which is resource intensive, are there any good utilities for simply viewing (previewing) such files without the need for editing facilities? ...
4
votes
3answers
892 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 ...
1
vote
1answer
2k 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 ...
8
votes
1answer
3k 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 ...
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?
2
votes
2answers
9k 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 ...
5
votes
2answers
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 ...