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
191 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
286 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
125 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
13 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
87 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
411 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
42 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
1k 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
2k 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
130 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
204 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
348 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
250 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
207 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
28 views

How do I combine data in two tables in LibreOffice?

I have a spreadsheet with two sheets inside, SheetA has Customer number and location, SheetB has Order number, Customer number. How do I combine the data so that one sheet has Order number and ...
1
vote
0answers
30 views

LibreOffice doesn't install anything except Writer and Draw?

So I tried to install LibreOffice, because the free version of Microsoft Office I got for being a student has been giving my laptop a BSOD (separate problem, working on it). There was an older ...
1
vote
0answers
12 views

How do I fix my table of contents of LibreOffice/OpenOffice?

I've made a document on Google Drive and I want to add a Table of Content from LibreOffice to it, but all headers are seen as Content 10 by the program, so they are all on one line, instead of ...
1
vote
0answers
20 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
152 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
28 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
33 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
47 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
173 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
133 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
2k 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
31 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
366 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
484 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
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 ...
1
vote
0answers
289 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
379 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
868 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
71 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
468 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
119 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
14 views

How to undo autocorrect in libreoffice calc

I would like to prevent libreoffice calc to make autocorrecion in some cases in some cell. For example, sometimes libreoffice decides that some text I enter is a hyperlink and it formats the cell as a ...
0
votes
0answers
12 views

Switch off autocorrect in libreoffice calc for specific document, column, cell

There is a way to completely turn off autocorrect in libreoffice calc. However, I would prefer turn off autocorrect in less scale: document, worksheet, column/row, cell. How it can be obtained?
0
votes
0answers
9 views

libreoffice: using character style to add automatic text

I have a pre-generated document with many endnotes and footnotes that were generated instead of bibilographical entries. Long ago I gave up on converting them to proper bibliography but I still need ...
0
votes
0answers
13 views

OFFSET function in libreoffice

Let's say I have a huge column of data, for example H7 to H2000. How do I go about selecting every 150row? That is, I want to have the H7, H157, H307, etc. It should be something like ...
0
votes
0answers
12 views

LibreOffice Writer: Export PDF: varying page width

When I export my Writer document to PDF, the pages all have different widths, as if they were cropped to fit only the contents of each page. LibreOffice version 4.4.1.2, running under Linux. I can ...
0
votes
0answers
18 views

Extend selection in LibreOffice calc to match adjacent column

I'm using LibreOffice 4.4.3.2 on a Mac, and trying to get behavior that I know I used to have before I recently upgraded to a new Mac and a new version of ... everything. :) I want to select a region ...
0
votes
0answers
21 views

How to resolve conflict between hunspell and myspell?

I need to install English, Greek and Bulgarian spell checker for LibreOffice. I know myspell does the job but when trying to install it under Debian 8 Jessie it conflicts with hunspell. sudo aptitude ...
0
votes
0answers
17 views

Right-to-Left doesn't wok in Libreoffice on OS X Yosemite

In word processor in LibreOffice 4.4.3.2 on OS X Yosemite, Right-to-left doesn't work and even when I try to add the button to the toolbar and it doesn't add it. I searched the internet for solution ...
0
votes
0answers
11 views

Unwanted bullets in LibreOffice Impress

I'm cutting and pasting some ascii text into a LibreOffice Impress presentation. The text appears as a long bulleted list. How do I eliminate that, and have the text appear plain on the screen ?
0
votes
0answers
28 views

Convert PPTX to HTML while preserving text

I need to convert PowerPoint PPTX files into HTML using the command-line. The HTML file should preserve text as text (not image) while converting all Shapes, Smart-arts and Graphs into images (or if ...
0
votes
0answers
29 views

How to use Windows Libre office Macro In Linux environment

I have some macro which I have made in libre office by window 7 Now I want to run those macro in Linux system through some kind of command Now issue is that How can I save Macro in a single file..? ...
0
votes
0answers
70 views

Unable to start libre office from terminal

I need to start libre offices impress via SSH on various raspberry pies, each displaying a set of slides on its own screen. Now my problem is that, when I run loimpress --show file.odp it states ...