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

3
votes
1answer
141 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
1k 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 ...
1
vote
0answers
261 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
414 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
850 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
281 views

Difference between Libre Office and Open Office [closed]

What's the difference between Libre Office and Open Office. Ubuntu 12.04 is shipped with Libre Office and before that all versions 10, 9, 8 were shipped with Open Office. If Libre Office is better ...
1
vote
0answers
98 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
3k 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 ...
2
votes
1answer
4k 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
243 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
1k 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
287 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
217 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
227 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
1k 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?
4
votes
6answers
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 ...
0
votes
1answer
681 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
2answers
4k 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
691 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
238 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
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. ...
1
vote
2answers
613 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
1k 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
359 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
991 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 ...
5
votes
4answers
56k 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
978 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
196 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
552 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
406 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
148 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
841 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
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 ...
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
7k 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
1answer
4k views

How do I create a line graph which ignores zero values?

I want to create a graph showing trends over time, calculated from a formula of various data. However, some data is missing, resulting in zeroes in the calculated data which the chart uses. When ...
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 ...
1
vote
1answer
772 views

how do I set default formatting with openOffice?

I type a lot and i like to have the background black and the text a soft green or gray. I can see how to change the background and text color for one document but i would like to set this up as the ...
1
vote
2answers
450 views

Plain .tar.gz binary distribution of LIbreOffice?

Is there a place where I get recent (~3.4) LibreOffice binaries for Linux? I'm not looking for .debs or .rpms, just a plain archive I can extract in my home directory and run from there. Since one of ...
0
votes
0answers
86 views

LibreOffice prevents SD card from being ejected

When I try to eject the SD card which is generally always in my Windows 7 netbook using either the context menu or the "Safely remove hardware and eject media" icon the computer tells me it can't ...
2
votes
2answers
1k views

Why doesn't LibreOffice handle .doc[x] files well [and will this be ever fixed]? [closed]

I've been using OpenOffice for years now then I switched to LibreOffice as soon as The Document Foundation released install binaries months ago. I must admit that I'm very satisfied because I can do ...
2
votes
1answer
205 views

OpenDocument Presentation Viewer

In lines of Powerpoint Viewer from Microsoft is there any free viewer for Open Document Presentation(ODP) files? I prepare my presentations in LibreOffice in Ubuntu and am looking for an option to ...