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

2
votes
1answer
163 views

LibreOffice dictionary and spell checking in other languages? (without Java)

Using LibreOffice (latest version) on OS X, everything in English. However I frequently work with documents in other languages (e.g. German, Dutch, French) and I would like to have spell checking for ...
1
vote
0answers
26 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 ...
2
votes
1answer
25 views

Sheets in LibreOffice Writer (similar to that in Calc)?

I am writing a document on a subject, but with many sub-topics. I want to have each sub-topic in it's own individual sheet like you have in LibreOffice Calc, but I have not figured out a way to do ...
3
votes
1answer
152 views

How to print 8 copies of a one page LibreOffice document to 2 sheets of paper?

When printing a multi-page document I can print four pages to a single sheet of paper. It prints, for example, pages 1-4 on one sheet and pages 5-8 on the next sheet. I have a one page LibreOffice ...
1
vote
1answer
26 views

Add new hyphenation rule to MS Word/OpenOffice

I've noticed that the automatic hyphenation doesn't work optimally in MS Word. The problem is that it doesn't hyphenate some words that can be hyphenated. Can I somehow get it to hyphenate such words, ...
1
vote
1answer
1k views

Change page orientation of one specific page

I want to change the page orientation of one particular page in my LibreOffice document. I have followed the instructions given on the LibreOffice wiki, specifically To change the page orientation ...
0
votes
0answers
20 views

Libreoffice Dialogs Randomly Change Languages

Odd one here. I've got LibreOffice v5.0.1 installed on my wife's PC running Windows 8.1. The language of dialog box buttons (e.g. Ok / Cancel / Reset) is changing randomly and, she claims, without ...
1
vote
0answers
116 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.
0
votes
0answers
50 views

LibreOffice Impress Transitions Don't Work In PDF Files

I am using LibreOffice Impress. The Fade Smoothly Transition feature works fine. When I convert to PDF, the transitions are not smooth. What's more, sometimes they will be the Dissolve style ...
0
votes
1answer
341 views

LibreOffice Writer works very slow on Ubuntu 14.04

I have libreoffice from base repo. Some time ago libreoffice writer started working very slow - for example I have to wait about 10 seconds to close the file. I created newuser on the same ubuntu and ...
0
votes
0answers
25 views

How do I populate a LibreOffice column with data from another sheet

I am working with Volusion and want to change categories for products using LibreOffice. The problem is that my products download file shows categories only by id number (ie. 1, 2, 3, 4) But I can ...
3
votes
1answer
259 views

LibreOffice Impress, Can't Get Rounded Corners

I can't find the setting to make rounded corners. I have clicked everything that says "rounded". No effect. What do I do to get a box like this original author has ? ALT-H, ABOUT, ETC.... ...
1
vote
1answer
49 views

Import Libre Office Writer Document in Draw?

Is it possible to import a LibreOffice Writer Document with tables and pictures without layout modifications in LibreOffice Draw? It seems I can't insert the whole file at once. When trying to copy ...
0
votes
1answer
214 views

LibreOffice won't open a file

I tried to open a file which was fine last night. It’s a presentation file; Impress. I’m guessing it contains 70 or 80 slides. This morning I get this messasge. What can I do now ? LibreOffice 4....
0
votes
2answers
67 views

Entering notes into LibreOffice Calc and OpenOffice Calc

In LibreOffice Calc and OpenOffice Calc, there is often a need to quickly enter several rows of text that will not be part of any calculation area. This is often done to write notes relevant to the ...
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
1answer
193 views

Get LibreOffice to change the margins for all pages and not just the last page when select all pages is active?

I am using the template for a book from Createspace that is owned by Amazon. The template is a word document and there are various formatting styles in this template, and I want to change the margin ...
0
votes
1answer
164 views

How to color rows based on a check box - Open Office

How do you color the background of a cell based on a check box? More to the point, I have created a check box that is in a cell. I want that cell to be green when the check box is checked and red when ...
0
votes
0answers
40 views

How to fix a disordered figure numbering in LibreOffice Writer?

I am just using LibreOffice Writer to compose an essay for my collage. When I situate three figures, horizontally next to each other and numbered them, their order was just fine. But when moved one of ...
1
vote
1answer
43 views

In LibreOffice Calc is there a hotkey to edit the current cell?

I am wanting to edit a column of cells (for example, copy/pasted values have $0.005/hr and I want them to just be 0.005) I can navigate with arrow keys, I can click to edit the existing value, but ...
1
vote
2answers
68 views

Error 1327. Invalid Drive Windows 8

I'm trying to reinstall LibreOffice but getting the titular error. I think it's because I recombined a partitioned drive (D:\ and E:\ became D:) and LibreOffice was installed on the E:\ drive. So ...
1
vote
2answers
261 views

Libre Office 'crashes' printer

I am running Libre Office 4.4.3.2 on Win 8.1, recent Thinkpad, with a Samsung ML-2850 series printer connected via USB. Whereas printing from WordPad, Firefox, ... works nicely, I cannot print from ...
0
votes
0answers
255 views

How to open a password protected ODS file via command line / external script?

I created a password protected libreoffice's "calc" file (ods). Now I'd like to open it, or convert it to plaintext format, either via command line, or with an external script, e.g. python. What I ...
0
votes
0answers
9 views

Libreoffice - how to disable curly quotes? [duplicate]

I don't get it why my libreoffice puts curly quotes instead of straight ones. I'm using default English language, but still it writes curly quotes in a cell. But if write quote in for example find ...
0
votes
1answer
32 views

Is there a way to add a reference subsection after each section?

I'm using LibreOffice(Writer) + Zotero combo for my scientific writings. I'm recently writing a letter/conversation style document where I have several more or less independent sections. I was ...
5
votes
1answer
1k views

Libre Writer recognises 'Garamond' font when loading a document written in it, but does not have it as a selection

I am using Ubuntu 14, and am loading at Word .doc text file template provided by CreateSpacelink. The text in this template uses a font called Garamond. When I put a cursor over text in the template ...
0
votes
1answer
28 views

How do I look up data from another table?

In this fictional example, I have two tables; one with employee information and pay rate: The second with dates and the corresponding number of hours the employee has worked on that day (note that ...
0
votes
2answers
31 views

Getting Rid of Software Records for Software installed on an external disk?

So I'm cleaning out an old computer, and several of the programs it thinks it has were actually installed on an old drive, that's now gone. For some of them, it prompts to get rid of them because it ...
0
votes
1answer
77 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 ...
1
vote
0answers
49 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
1answer
171 views

MediaWiki extension hiding in LibreOffice?

I always used LibreOffice to write my MediaWiki-articles and saved it as MediaWiki .txt-file to use it on our Wiki. Since I upgraded my PC, I have the new LibreOffice 4.4.2.2, where it appears the ...
0
votes
2answers
77 views

Automatically fit document on smaller paper size (LibreOffice Writer)

The whole point of the system of European paper sizes is that all have exactly the same ratio. So, theoretically, you can print an A3 document on an A4 sheet and it will not be distorted — it will ...
0
votes
1answer
22 views

Hot to set the path for 'Help' in LiberOffice

I put the help files for LiberOffice on an external HD. When I click 'Help' in LiberOffice it goes to the WEB. I have tried the 'tools->options' but nothing there seems to be about the 'Help' files. I'...
3
votes
3answers
357 views

LibreOffice Writer … the ohm sign (Omega)

I am using LibreOffice Writer on Ubuntu 14.04 to do a class assignment and I need to use the Ω (Ohm sign, big letter omega) to show resistance. Unfortunately I can't seem to find the sign anywhere. ...
0
votes
2answers
308 views

LibreOffice shows me strange characters

My LibreOffice shows strange symbols and characters. I am using Debian8 with XFCE environment. For better understand I have uploaded the screenshot. How can I solve this problem? Thanks in advance.
0
votes
1answer
45 views

Impress won't save bullets or spacing

I make a nice neat Libre'Office Impress document. I put paragraphs on the page, with a quarter inch spacing after them. While I am working with the document, all is well. I then save the document ...
1
vote
1answer
550 views

Macro that will run in MS Excel and LibreOffice Calc

I have a spreadsheet that users will be working with in both Excel and LibreOffice Calc. I'd like to design macros that will work in both. I was thinking of code that would say: If Excel Then [VBA ...
8
votes
2answers
588 views

How to copy drawing from LibreOffice Draw to MS Word?

What is the best way to copy a drawing (complete document) from LibreOffice Draw into an MS Word document (using MS Word) on Windows? A "naive" copy&paste form Draw to Word gives next to useless ...
0
votes
2answers
59 views

How does libreoffice express a linebreak when saving a csv?

I’m attempting to save a CSV using LibreOffice Calc to be imported to a MySQL database. Saving it as a CSV is pretty straightforward in LibreOffice but I don’t know how the resulting document ...
1
vote
0answers
203 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
1answer
45 views

modify a view that other views depend on

I use LibreOffice Base to create weekly reports. I have one table (named time_spent) that contains a lot of normalized data, and I am using views to do the processing required to produce the reports I ...
0
votes
0answers
108 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..? ...
2
votes
2answers
56 views

Regex in LibreOffice Writer - finding “everything” but one thing

I have a text (html code) and need to find <p> tags with their classes, id, styles (if any) etc. I'm doing this using the following regexs: <p(.*?)> or (<p([^>]+))> The pattern ...
1
vote
0answers
161 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
95 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 ...
0
votes
0answers
241 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 ...
1
vote
1answer
54 views

Libreoffice: Import columns of spreadsheet as fields

I have a LibreOffice Calc spreadsheet with Columns A, B, C. I would like to create a document in LibreOffice Writer with format: A1 B1 C1 A2 B2 C2...
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 ...
2
votes
1answer
73 views

LibreOffice Calc/Spreadsheet – Delete unusual characters from cells so that I can export a valid CSV file

I received a spreadsheet for work and it has cells that are full of line breaks and excessive whitespace. Unfortunately, I need to export the spreadsheet to CSV format and these two are breaking the ...
0
votes
1answer
563 views

Can't launch LibreOffice 4.4 on Linux Mint 17

Uninstalled LibreOffice 4.2, downloaded the 64-bit LibreOffice 4.4 tar files and extracted them all into a folder on the 64-bit Cinnamon Mint 17 desktop, then installed, as per the README, from a ...