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
0answers
237 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 ...
3
votes
0answers
122 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
0answers
25 views

Arabic: Unicode: how to stack fatha kasra damma

I am using LibreOffice to type arabic, but if what I am asking cannot be obtained with LibreOffice then I would like to know whether it is possible in LaTeX, because I have seen this in a book, but do ...
2
votes
0answers
108 views

Specifying printing options to libreoffice on the command line?

I'm attempting to come up with some means of converting .pptx files to a pdf format from the command line. I have set up a cups-pdf printer to which I can actually send jobs, and so far I have it ...
2
votes
0answers
185 views

Open only the first 10 lines of large CSV file in LibreOffice Calc

I will start receiving many large CSV files, of which only the first few lines are of interest to me. I was hoping to open them by piping only the first few lines to Calc, but this doesn't work: $ ...
2
votes
0answers
21 views

Evenly-spaced table rows, where table encompasses entire available height

Consider a page which may have a header, footer, and a list of questions with a heading: Some Company Header These are your questions: 1. What is your name? 2. What is your quest? 3. ...
2
votes
0answers
30 views

Libreoffice calc: pagebreak within row?

When printing a LibreOffice Table, LibreOffice will automaticaly place the pagebreaks so that they appear after/before a row. When having many tall rows this results in a heavy paper-usage. How can I ...
2
votes
0answers
82 views

How to change size of embedded openoffice/libreoffice draw object in ms word document?

I am using MS Office 2010 and LibreOffice 4.1.0.4. I wanted to embed a few draw diagrams in my Word document (copy pasting from LibreOffice Draw into MS Word is not an option for me because I want to ...
2
votes
0answers
150 views

Numbering sheets (not pages) in MS Word or LibreOffice

I work at a Brazilian government office. Our paper processes, which are due to retirement in favour of an eletronic one but just not yet®, require us to number sheets, not pages. So pages 1, 2, 3, ...
2
votes
0answers
223 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 ...
2
votes
0answers
195 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 ...
1
vote
0answers
22 views

zotero not working with libreoffice 4.3 in linux mint 16

As title, I tried to use zotero in libreoffice, after I installed zotero, I found from zotero's preference that the add-in was not installed, I click the button to install but nothing happen. I ...
1
vote
0answers
21 views

Button to add one in LibreOffice

I want to create a button to add "1" to a number in a cell. I want a way to quickly increase the total of certain cells by one. I'm stumped on how to do it easily.
1
vote
0answers
78 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 ...
1
vote
0answers
680 views

Libreoffice Base: How have a combobox linked to a related table linked to or in the form table control

I could not sum up, what I really want in the title. But here I am going to try to explain what is it about. I have switched from MS Access to Libreoffice Base because it is open source, free and ...
1
vote
0answers
29 views

Optimal format for office suites portability

I really don't know how to ask this a better way. I have tried googling, but even Google isn't of much help if you don't know what exactly to search for. For some reason, LibreOffice seems to ...
1
vote
0answers
449 views

Exporting high quality PNG from LibreOffice Draw

I need to generate a PNG file of an image composed in LibreOffice Draw. When I export to PNG directly, the quality is almost perfect, but it's just slightly blurry. However, when I export directly ...
1
vote
0answers
181 views

How can I debug formatting in LibreOffice?

I am using LibreOffice Writer 4.0.2.2 to edit a Word document sent to me by a Microsoft user. It contains certain formatting that I can't figure out how to change (a gray background on some of the ...
1
vote
0answers
238 views

Libre Office Calc, User-defined Number format permille

I know that LibreOffice allows you to define custom number formats. I have a spreadsheet that displays some smallish percentages (all are less than 1%). I would like to use permille ‰ instead. ...
1
vote
0answers
51 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 ...
1
vote
0answers
217 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 ...
1
vote
0answers
233 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 ...
1
vote
0answers
544 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 ...
1
vote
0answers
51 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 ...
1
vote
0answers
498 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 ...
1
vote
0answers
249 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
408 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] ...
1
vote
0answers
96 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 ...
1
vote
0answers
61 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. ...
0
votes
0answers
7 views

How to customize default CSV format in LibreOffice?

Every time I export my data to CSV (and I do it often) I have tick the "Edit filter settings" checkbox, choose UTF-8 for the encoding, and semicolon for the fields separator manually. I do this ...
0
votes
0answers
7 views

How to accept LibreOffice Calc autocomplete suggestion without leaving the cell edit mode?

Whenever I start typing a sentence in a LibreOfice Calc cell it suggests autocomplete options based on other cells contents. I usually would like to accept it and make a slight modification but when I ...
0
votes
0answers
10 views

LibreOffice calc countifs with date

I got 3 columns. 1 column(D) text, 1 column(T) 0 or 1, 1 column date(A) 01.01.2010 till 31.12.2014 . I want to count up until a specific date, for example 10.10.2011: ...
0
votes
0answers
20 views

Libre office impress is slow to convert pptx to pdf

I'm running Libre Office on my server to convert the powerpoint to a pdf file. Using a .ppt file: libreoffice --headless --convert-to pdf filename.ppt is running fine and take like 3 or 4 ...
0
votes
0answers
22 views

Which version of LibreOffice is most stable?

I'm a bit confused by the version numbering system employed by Debian / LibreOffice. The version of LibreOffice that shipped with Wheezy was 3.x, and since it didn't have some features that I needed I ...
0
votes
0answers
24 views

Return an array from a lookup

I have a table with column A containing vendors and column B containing product codes. One vendor has many product codes. In another place I need an array of product codes for a specific vendor. The ...
0
votes
0answers
19 views

Multi step shortcuts in LibreOffice Writer

There are some programs out (for example, Sublime Text) that allow multi step keyboard shortcuts, that is for example you can first click one key combination CTRL+K and then another another key ...
0
votes
0answers
14 views

How to delete all occurrences of one index entry from the entire document?

While working on a document in LibreOffice, I have noticed that an index entry for a period (.) has been accidentally added to the list of index entries. It means that at the end of of every single ...
0
votes
0answers
33 views

updating links in LibreOffice Calc xlsxfile results in err:509

I have just started to use Libreoffice so I am totally new to the system and immediately encountered a problem with a calc document. The document has originally been made in Excel (but on a Mac) and ...
0
votes
0answers
21 views

LIBREOFFICE: Macro to convert LTR to RTL selectively. (BiDi issue)

I use Scrivener to write my essay that consists of BiDi text formatting. The sources I quote are in Arabic whereas the commentary is in English. I then export my file from Scrivener to ODT format. ...
0
votes
0answers
49 views

Libreoffice - change default zoom?

I don't understand how default zooming works in libreoffice. For example I like it to default zoom at 100%. One time I accidently zoomed (when trying to select lots of rows) and after that imidiatly ...
0
votes
0answers
10 views

Change tp paragraph style using chracter attributes in LibreOffice

I received a documnet here everything is in "default style". However, headers differ in font size and attributes, such as bold and italic. F&R allows me to find the respective headers by their ...
0
votes
0answers
47 views

How to format pennies as dollars in LIbreOffice currency formatting?

I have data in a LibreOffice Calc spreadsheet with penny values, such as 001234 to represent $12.34 (twelve dollars and thirty-four cents). How can I define a format that will display these values as ...
0
votes
0answers
30 views

Database columns dependent on another table column

For illustrate suppose I have two tables, let's say "Client" and "Cart": Client: ID; Primary; Autovalue Name; Debt; Cart: ID; Primary; Autovalue Client; value of Client->ID Product; Value; ...
0
votes
0answers
25 views

How to create a reference line between a name and a value in LibreOffice

In the figure (which is a part of the table of contents of some book) the doted lines help our eyes to easily spot the page number of the mentioned chapter. When creating similar contents using ...
0
votes
0answers
21 views

LibreOffice calc: Can I create a yearly sum out of monthly sheets?

As a simplified example, let's say I have the expenses of a small company in one file per year, and every file has 12 sheets (one per month). The sheets have these columns: date|department|amount ...
0
votes
0answers
22 views

Read pptx/ppsx links with Impress

A friend of mine sent me a presentation in pptx format, I'm using LibreOffice Impress to read it. When I start it, it should behave like a website, my friend placed some link in every page that ...
0
votes
0answers
39 views

Automatic backups (history) in LibreOffice (OpenOffice)

LibreOffice can create a backup copy when you enable it in settings (Options > Load/Save > General), but it saves only the previous state (one only). It has also an versioning feature (File -> ...
0
votes
0answers
47 views

Search and replace with different formatting style

In LibreOffice or OpenOffice Calc spreadsheet, is it possible to search-replace while changing formatting of the replacement text to subscript or superscript at the same time? I have a spreadsheet ...
0
votes
0answers
14 views

Quickly paste image inline

Sometimes I want to paste an image into a LibreOffice Writer document inline ("as character") at the current cursor position. One way to do this is: Paste the image. LibreOffice pastes it as a ...
0
votes
0answers
61 views

Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc

Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...