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
166 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 ...
3
votes
0answers
273 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
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
0answers
11 views

Is it possible to style number/bullet lists separately in LibreOffice?

The "Text Body" style in my LibreOffice document uses a large margin above and below each paragraph. This is causing problems in my bulleted and numbered lists since each list item is considered to be ...
2
votes
0answers
73 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 ...
2
votes
0answers
351 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
39 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
982 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 ...
2
votes
0answers
1k views

How to copy a column with conditional format by “value” - Libreoffice 4.1

I have a column that contains the data and a set of rules for the conditional format of the cells. i.e. the conditional format changes the background colour of some cells if they are negative. I ...
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
116 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
188 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
325 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 ...
2
votes
0answers
242 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
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 ...
1
vote
0answers
10 views

Format to generate .tex, .pdf and .md from?

I've used pandoc to generate .md, .tex, .pdf from .tex and .xhtml files. In tex I am using BibTeX and in odt (save-as xhtml) I am using Zotero to insert my citations. Currently neither .tex nor ...
1
vote
0answers
39 views

Anti-Aliasing LibreOffice Writer 4.x Under Windows

I have the 4.x version of LibreOffice installed on Ubuntu and its Writer renders the text so smoothly, but nothing like that is under Windows. I am using Windows 8.1 Update 64-bit, and tried to ...
1
vote
0answers
97 views

LibreOffice has ugly PNG import

I'm trying to import a PNG graphic exported from Inkscape (I tried importing the SVG directly but it doesn't work: the text is missing and replaced by black boxes) in a LibreOffice document, but it ...
1
vote
0answers
136 views

Libre Office Won't Give Me A Black Font

I am trying to edit a document in Libre'Office which was... Originally created by me in Libre'Office Sent to another person who edited it in Microsoft Word Returned to me with her request that I ...
1
vote
0answers
25 views

LibreOffice Writer: Inserting a figure into a two column document

I edit a two column document in LibreOffice. I need to to add a figure (frame?) with a program listing. I want it to be of the width of two columns. I can make it either the width of a column (what ...
1
vote
0answers
31 views

What are 'line-arrest' symbols? (Microsoft Word)

I recently send in a document for correction I created with LibreOffice. I received the correction with the remark that all "line-arrests" have to be removed. Apparently they are introduced because ...
1
vote
0answers
25 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
41 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 ...
1
vote
0answers
150 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 ...
1
vote
0answers
123 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 ...
1
vote
0answers
1k 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
30 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
321 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
431 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
58 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
264 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
331 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
760 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
63 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
451 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
113 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
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. ...
0
votes
0answers
2 views

How to reference cells by name in Libreoffice 4.2

In the Libreoffice version that came with Ubuntu 12.04, I could select a column, name it, and then construct a formula that referenced this name. e.g. Say I had two columns A=Price and B=Quantity. If ...
0
votes
0answers
19 views

Concatenate a reversed range in Libre Office

I'm kind of new with programming, but I have to make an excel document, that I can use interactively because the output of one of my programs doesn't fit with the input of the others... I have lot of ...
0
votes
0answers
23 views

finding the difference between two times in libreoffice

I'd like to know how to solve the problem: in cell A(n) is the first time in cell B(n) is the second time in cell C(n) is difference of times I don't want to put each time into cell C(n) function ...
0
votes
0answers
10 views

How to create a form checkbox without a label on LibreOffice Writer

In default the checkbox seems to have a label assigned to it. For creating an fillable PDF I'm looking for just a plain checkbox which can be clicked -- the description is done at another column, as ...
0
votes
0answers
9 views

How to avoid delete confirmation in LibreOffice Calc for OSX

Windows users can avoid the pesky delete confirmation dialog in Calc by using their Delete key instead of Backspace (according to the documentation) My Macbook only has a Delete key and so I can't ...
0
votes
0answers
7 views

How to remove duplicate list numbering on one line in LibreOffice Writer

I am not sure how I ended up doing this (I just applied list numbering to some text) but somehow LibreOffice Writer decided that my first list item needs two number "1." labels applied, like this: ...
0
votes
0answers
30 views

LibreOffice 4.4.0.3 opening a PDF file displaying wrong Traditional Chinese characters

I have installed the LibreOffice 4.4.0.3 portable for Windows (my OS is 64-bit Windows 7 Home Premium Traditional Chinese version), hoping to use the PDF editing feature in the LibreOffice Draw. I ...
0
votes
0answers
17 views

Fonts broken in Libre/Open Office Math

Can't enter any complex formula like sigma summation: How to fix?
0
votes
0answers
7 views

LibreOffice missing rows in diagramm

I have some data: 02/27/15 12:12 AM 139 02/27/15 12:38 AM 136 02/27/15 01:04 AM 135 02/27/15 01:29 AM 135 02/27/15 01:53 AM 137 02/27/15 02:17 AM 136 02/27/15 02:40 AM 135 02/27/15 ...
0
votes
0answers
37 views

How can I get my printer to duplex on the long edge?

My HP Photosmart 6525 printer refuses to duplex on the long edge. Whenever it's asked to duplex, it duplexes along the short edge even if asked specifically to duplex on the long edge. I'm printing ...
0
votes
0answers
23 views

LIBREOFFICE WRITER - Changing some fontname throught a document

Normally the document use "COMIC SANS MS" font name. In my document I use four special characters ( club (U+2663), diamond (U+2666), heart (U+2665), spade (U+2660) ). These characters should come ...
0
votes
0answers
7 views

LibreOffice Send [file menu] to Desktop

In LibreOffice's File menu there is a Send submenu, a friend wants to "send" his documents to the Desktop yet I saw no options after going in to the customization / add command (just the same ...
0
votes
0answers
20 views

How can I properly print on lined paper?

I have some lined paper (either graph paper or looseleaf paper) and I'd like to be able to print/format a document (either with LibreOffice, LaTeX, or a PDF) so that every line of text is algined ...