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
119 views

Can MS-Word open encrypted ODT-Files

Is it possible to open LibreOffice encrypted documents using MS-Word 2010? The data format is odt and the password is known. Is the encryption secure?
3
votes
0answers
46 views

Disabling spell checker in OpenOffice Calc (or LibreOfffice Calc)

Is there a way to disable the spell checker in OpenOffice Calc (or LibreOffice Calc) without disabling it for the other programs in the office suite? I would prefer to just disable it for a range of ...
3
votes
0answers
633 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 ...
3
votes
0answers
3k 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 ...
3
votes
0answers
322 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
127 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
19 views

Can LibreOffice Writer display information about the current cursor position?

Preferably in the status bar and spelled out in some distance units, but I'd settle for anywhere really. I'm really surprised it doesn't show such crucial information as default. I want something ...
2
votes
0answers
27 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
129 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
214 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 ...
2
votes
0answers
47 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
158 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
251 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
415 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
261 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
220 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
14 views

LibreOffice on OS X: running soffice keeps saying no Info.plist or no NSPrincipalClass in Info.plist

I'm trying to run LibreOffice 5.1.3 from the OS X terminal, to script some conversion tasks. However whenever I run soffice, I always get this error: No Info.plist file in application bundle or no ...
1
vote
0answers
11 views

How do I get LibreOffice Writer to start page numbers at 1 and not 0?

I have a book where the first page of actual content, after title pages and copyright notices and so on, is on the fifth page of the file. I want that page to be marked as page number 1. I set a ...
1
vote
0answers
10 views

Is there an accessible LOG of REPAIR procedure in OpenOffice.org or LibreOffice?

I'm developing a PL/SQL tool for Oracle to export a query result set to a ODS file. It seems to work but when I try to open the document, I get the message that something is wrong so OpenOffice ask me ...
1
vote
0answers
12 views

LibreOffice does not completely use Word's “standard” format for paragraphs

When opening existing Word documents with LibreOffice (current version: 5.0.5.2), most things look pretty well. But there is a problem: our Word's "standard" paragraph has single line spacing, and no ...
1
vote
0answers
15 views

How to edit google spreadsheet offline with Libre Office / Open Office

I am working with my team on a spreadsheet on google docs. Is it possible to edit this file offline (with e.g. LibreOffice) and sync and merge it later (like clone and push for github)? Platform ...
1
vote
0answers
12 views

convert old Staroffice Writer 3 file to readable document

I have an old SDW 3.0 Document wich mostly only contains text but the binary form seems to have no plain text included ... also libreoffice after 4.0 does not support that in reading anymore in ...
1
vote
0answers
55 views

Can't uninstall LibreOffice 4 and can't upgrade to LibreOffice 5

Context: Windows 10 64bit. I have LibreOffice 4.4.5.2 (32bit) installed and I want to upgrade to LibreOffice 5 (64bit). I find that I can't upgrade to 5 and can't remove 4 due to a registry key issue ...
1
vote
0answers
29 views

How to draw a Gaussian Curve with LibreOffice Draw?

I would like to draw a Gaussian curve as a vector graphic in LibreOffice Draw. With the "Curve" functions I was only able to get something parabola-like. Has anyone got an idea of how to do the ...
1
vote
0answers
24 views

How to prevent the loss of Jumplist items when LibreOffice is upgraded?

Every time LibreOffice is upgraded, all the Jumplist items which were manually added for each application within the suite are deleted. The operating system is Windows 7 SP1. Is there a way to ...
1
vote
0answers
32 views

Libre Office - merge sheets

In one file I have two sheets, which share some of the columns. I'd need to merge the sheets based on column name, if the column does not exist, add it. Ie. I have Sheet 1 ...
1
vote
0answers
39 views

Change color for all set borders

Having a table with some complex borders. How can I change the border color for all borders in the table? Know I can change one by one, but that is a hassle. For example: +-----+--+ |1A 2A|3A| |1B ...
1
vote
0answers
52 views

Convert text string to formula in LibreOffice Calc

I have a spreadsheet that generates formulae as text ex. =CONCATENATE("+B",ROW(),"*",ROUND(G5,2)) output: +B5*1464.41 I have a column of this type of text that I need to convert into ...
1
vote
0answers
127 views

OpenOffice / LibreOffice ugly font rendering

I'm using Calc to generate some graphs of data I have collected. But somehow the font looks increadibly ugly in all of LibreOffice. I'm using Noto Sans CJK JP Light in this chart but pretty much every ...
1
vote
0answers
84 views

LibreOffice Calc changes letter from uppercase to lowercase under certain circumstances

I want to enter SXer into a field, however the X gets automatically converted to x. If I only write SX, the X stays the way it is. If I write SXEr, all letters stay as they are. But somehow I can't ...
1
vote
0answers
44 views

LibreOffice Calc - Split one column into two

I'm moving user/customer details from my mother's old web store. Only problem is that exported .csv-file has name details in the same column like this: [ col A ] lastname, firstname ...
1
vote
0answers
25 views

Connect to running libreoffice instance and issue commands from command line

Is there a way to connect to a running libreoffice instance (specifically libre office Write) to issue commands? As an example of what I'm interested in, you can connnect to an open MS Word instances ...
1
vote
0answers
101 views

LibreOffice, odt files batch search and replace

I am using LibreOffice Writer (Version: 5.0.1.2) for Windows 7, and I have multiple files that I need to replace some text in them.. I can't find a way to search and replace in many files in bulk.
1
vote
0answers
30 views

How does copying and pasting realise and reveal a webpage's formatting?

Preface: This question is motivated by the last paragraph by a Francophone at French SE. Also, I use 'realise' to mean 'actuate' or 'actualise' or 'effectuate'. In the aforesaid post, I publicised ...
1
vote
0answers
43 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?
1
vote
0answers
184 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 ...
1
vote
0answers
141 views

How do I combine data in two tables in LibreOffice?

I have a spreadsheet with two sheets. SheetA has Customer number and location, and SheetB has Order number, Customer number. How do I combine the data so that one sheet has Order number and location? ...
1
vote
0answers
89 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
17 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
34 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
167 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
50 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
35 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
29 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
60 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
261 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
32 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
539 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
595 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
62 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 ...