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

1
vote
0answers
60 views

Header from top equivelant in LibreOffice

I try to follow some formation instructions for a few documents I need to deliver to a customer. The documentation instructions are set for Office 2007 but I need to write the documentation in ...
0
votes
1answer
101 views

How to get the average of the higher M values in N cells?

I have a spreadsheet with values in a matrix with several rows. For each row I have a N numbers. I want to calculate the average of the M higher values of the row. With M<N. Is there a common ...
0
votes
1answer
2k views

MS Excel Vba/Macro equivalent in LibreCalc or OpenOfficeCalc

is there an equivalent macro/vba in libre calc that does this routine; - Read/open xls files in a path and do a batch import/copy of read sheets and merge it with the current open workbook. Here's the ...
4
votes
2answers
3k views

Which fonts come with OpenOffice / LibreOffice? [closed]

Is there a list of all the fonts which come with OpenOffice / LibreOffice ?
2
votes
1answer
854 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?
1
vote
2answers
550 views

Can LibreOffice Base directly use MySQL syntax?

From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different ...
0
votes
1answer
914 views

How can I use extremely large numbers in my spreadsheet programs?

If I try to calculate large exponents in LibreOffice Calc or OpenOffice.org Calc, the results come out to be erroneous. See these two examples where I calculate 13^18, Using LibreOffice Calc Using ...
4
votes
2answers
694 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 ...
0
votes
1answer
33 views

Word Document has two footers after importing from LibreOffice

I am having a weird issue with word. It seems I have two footers in the document on a single page. I am using Word for mac, the document has been imported from LibreOffice. The issue persists in Word ...
5
votes
2answers
481 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 ...
3
votes
3answers
21k 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 ...
0
votes
1answer
53 views

sandboxing libreoffice on Linux

I want to build multiple versions of libreoffice on a machine (Debian 6) and want to test these versions against a set of test cases automatically. I also want to test the given libreoffice version by ...
0
votes
1answer
885 views

Libre office: How to format title pages for book (avoiding the missing blank-page when pdf-file exported)

How do you set up the i, ii, iii, iv... followed by the 1, 2, 3, 4... pages of the usual book format in Libre office? What is the logic of it? Also how do you avoid the automatic BLANK PAGE appearing ...
2
votes
3answers
3k 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 ...
0
votes
1answer
279 views

Attempting to open TSV file in Libreoffice Calc results in being opened by Writer

I have been working with TSV files for months, but I have one file that refuses to be opened in LibreOffice Calc. It instead brings it up in writer. This behavior is consistent across command line and ...
0
votes
0answers
77 views

Libreoffice won't let me have a read-only ComboBox

I have a database table with some entries. I want to display all the fields of this table as a ComboBox. I want the user to be able to select this any entry in this ComboBox without modifying the ...
3
votes
3answers
862 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 ...
1
vote
1answer
403 views

How to specify the target directory for LibreOffice 4.0.2.2 .msi file?

How can I specify the target directory for the LibreOffice 4.0.2.2 .msi installation? The .msi file is here: ...
2
votes
2answers
1k views

Installing LibreOffice 4.0.1 on Fedora 17

I downloaded 'LibreOffice_4.0.1.2_Linux_x86-64_rpm.tar.gz' from official site of libreoffice and follow the readme to install. The installation completed successfully, but when I entered ...
3
votes
2answers
3k 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. ...
1
vote
0answers
292 views

LibreOffice lock files and Dropbox

I use Dropbox for collaborative work between Windows workstations. One of the use is to share LibreOffice documents. Concurrent editings are normally forbidden by LibreOffice by creating a lock file ...
0
votes
1answer
69 views

Using LibreOffice and having problems, copying details

A staff member in our office is having trouble pasting details from a spreadsheet {In any format} to a template in .ott format. When pasting and details from the spreadsheet, it removes some of the ...
3
votes
1answer
1k views

How to prevent LibreOffice running 'recover' at each startup?

How to prevent LibreOffice running 'recover' at each start-up? On Ubuntu, each time I restart my computer, and then start LibreOffice, it asks me whether I want to recover documents. It does this ...
0
votes
1answer
4k views

Change date format in Libre Office

I have a column with date values with initial value as: '01.02.13' (in format DD.MM.YY) . Converted it to the required format (DD.MM.YYYY) '01.02.2013'. But when I focus on the cell it shows date as ...
1
vote
0answers
389 views

unoconv: export Excel file to PDF without any scripting

How to hide page header and footer during the Excel file export with unoconv? I've tried to use a template (narrow margins, disabled header, disabled footer), but it does not work. I mean: margins ...
0
votes
1answer
103 views

Where can I get pre-reform spelling correction for Brazilian Portuguese in LibreOffice?

I've just made the change from Open Office to Libre Office (Windows 7), and have a problem with Brazilian Portuguese spelling. Libre Office comes with dictionaries for the recently-reformed (some say ...
2
votes
3answers
312 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 ...
15
votes
4answers
10k views

How to change the text direction in LibreOffice?

I need "right to left" text direction to write in Persian.
1
vote
1answer
3k views

init.d script for OpenOffice / LibreOffice headless does not stop process

I am using Ubuntu and found this init.d script for LibreOffice headless. Problem is that it does not seem to be stopping the process when asked to "stop". Any help greatly appreciated. Two other ...
1
vote
0answers
899 views

Creating a template for a Writer-based calendar (diary)

I'm currently working on a calendar for the new year – a daily planner, a diary! Something for GTD (Getting things done) based on a diary with planner options. It is created in OpenOffice or ...
0
votes
1answer
373 views

Batch Conversion to PDF with LibreOffice in Mac

I have LibreOffice installed on my new Mac. In Ubuntu you can directly access LibreOffice via command line. How do you access LibreOffice in mac via command line ?
5
votes
1answer
3k 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 ...
1
vote
0answers
74 views

How do I prevent LibreOffice update from reassigning the default program for .doc?

When using Ninite to silently update Windows XP computers in a lab environment, LibreOffice reassigns the default program for the .doc file type from MS Office 2010 to LibreOffice. How can this be ...
0
votes
1answer
61 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
781 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
654 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
722 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
743 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
48 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
148 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
2k 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
356 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
469 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
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 ...
5
votes
5answers
984 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
121 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
5k 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 ...
4
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 ...