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

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 ...
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 ...
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 ...
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
200 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
580 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
416 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
154 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
856 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
8k 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
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
880 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
498 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
89 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
224 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 ...
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 ...
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 ...
1
vote
1answer
1k views

Document structure navigation in LibreOffice/OpenOffice

Is there "Document structure" toolbar in Libre Office or Open Office? I would like to navigate documents inside Libre Office or Open Office by document structure (table of content) like I can do in ...
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 ...
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

Referencing equations in LibreOffice/OpenOffice

Equations in LibreOffice (OpenOffice) can be autonumbered. How can I reference equations in text by that numbers so when equation numbers then references in document updated automaticaly. For example ...
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 ...
2
votes
2answers
703 views

LibreOffice/OpenOffice vs. MS-Office

What is the difference between them? ...I mean like if I create a document under MS-Office, what problems could occur if I want to edit it later with ooo.org?
3
votes
2answers
416 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 (!) ...
0
votes
1answer
6k views

Add automatic page numbers in LibreOffice

How can I add an automatic page number to all pages in a LibreOffice .odt file? I've already tried the following: Insert > Header > (name of page style) and Insert > Footer > (name of page style) ...
1
vote
0answers
63 views

Different fonts for different weights in OpenOffice.org

I want the default font to be Gentium, but its bold is incomplete, so I want bold and bold-italic to be Gentium Basic. I want to have it set as the default font every time and not manually per usage. ...
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 ...
0
votes
2answers
7k views

How to turn a PDF document upside down [duplicate]

Possible Duplicate: How to save rotated Adobe pdf file? I'd like to rotate by 180 degrees each page in a high-resolution .pdf, but don't know how. In ImageMagick, using 'convert -flip ...
1
vote
6answers
11k views

PDF form created in Libre Office - trouble with form fields and font sizing

I am trying to create a PDF Form using LibreOffice. I can create the form elements and export as PDF. However, the form fields are giving me problems. The text in these fields always centers on the ...
1
vote
1answer
847 views

Use MS formats by default in LibreOffice

Can I (and if so, how?) set up LibreOffice to use the newer style MS Office formats by default?
0
votes
0answers
92 views

What's the proper way to use each style in office suites?

In LibreOffice 3.3, the default range of paragraph styles include the following: "Addresse, Bibliography, Caption, Complimentary Close, Contents…" and character styles include: "Bullets, ...
0
votes
1answer
366 views

Office Live and LibreOffice 3.3 compat issue

I have a compatibility question. I am using Office Live to edit .docx files online. But when I download the .docx files down to my Macbook pro (running snow leopard) and I try to open the .docx file ...
0
votes
3answers
1k views

Accessing .wps files in a Windows version of some OpenOffice variant

A friend recently got a new Windows computer, and is in the process of installing apps on it. She has a bunch of old .wps files from Microsoft Works, which did not come installed on the new machine. ...
2
votes
3answers
1k views

Excel / open/libre office formulae: number of full months left until date

I need a formula which equates to an integer value for the number months left until a set date (2011-10-16) based on the current date. e.g. on 2011-03-13 the answer would equate to 8 on 2011-03-17 ...
2
votes
1answer
4k views

Why is my Table of Contents created empty in OpenOffice/LibreOffice?

I have a document and I would like to create a Table of Content. I tried with Insert > Indexes and Tables > Indexes and Tables... and added a title, then I pressed OK. But I only got a title and no ...
0
votes
2answers
401 views

What's the difference between LibreOffice multi and all_lang packages?

There seem to be 2 different multi-language LibreOffice distributions available for Win32 platform: LibO_3.3.1_Win_x86_install_multi.exe (213 MB) LibO_3.3.1_Win_x86_install_all_lang.exe (248 MB) ...
1
vote
1answer
8k views

What is needed to invoke LibreOffice running just the macro without the GUI?

Invoking LibreOffice and running a macro via the GUI works as expected producing three HTML files, one for each spreadsheet page: $ libreoffice x.ods Tools>Macros>Run Macros... Library: ...
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 ...
0
votes
1answer
3k views

How to install Czech spell checker for LibreOffice 3.3?

When there was Go-OO everything was simple - just install the application and install all languages you need via language pack installers. Now, as OOo and LO 3.3 ar out and Go-OO seems to be ...
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?
4
votes
1answer
795 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 ...
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 ...
1
vote
2answers
599 views

Open source alternatives to iWork

After I spent few days getting familiar with usability and interface design field, I've got a question. Apple was the initial leader in GUI design research, and today most Mac users use OS X, ...