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

0
votes
0answers
6 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
9 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
132 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
14 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
23 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
0answers
15 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
1answer
28 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
24 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
19 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. ...
3
votes
3answers
43 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
1answer
33 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
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
1answer
14 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 ...
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 ...
1
vote
1answer
68 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 ...
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 ...
7
votes
2answers
114 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
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
2answers
15 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 ...
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
1answer
20 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
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..? ...
2
votes
2answers
40 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
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 ...
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 ...
1
vote
1answer
23 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...
0
votes
0answers
10 views

How to fill table contents in subsequent slides in LibreOffice?

I'm interested in making a slideshow featuring a 3 column chart someone like the photo above, using libre/open office. So far what I've done is create a 3 column table in writer. And my plan is to ...
0
votes
0answers
19 views

Enable LibreOffice “smart” single quotes?

I was wondering how to make a curly single quote instead of a straight one. I found a 3-year-old forum post [Open]from back when LibreOffice was called OpenOffice, but not anything newer. Of course, ...
1
vote
0answers
13 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
29 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
173 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 ...
1
vote
1answer
107 views

LibreOffice application background is black and cannot be changed

Since I updated to Ubuntu 15.04 the application background and the background in the context menus is black in LibreOffice: View full size So far I have not succeeded in turning it back to the ...
0
votes
1answer
26 views

Remove vertical lines from openoffice table

As a follow up question to How to make a 3 column chart with dividers using openoffice , I created a table which looks like: Is it possible to make horizontal lines invisible, to give the effect of ...
0
votes
0answers
30 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
38 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
1answer
73 views

Conditional sum in Excel or Libreoffice calc

As an example, in the table above, I want to populate the empty column titled 'Totals' with the corresponding sum of all the Values in the left tables 'Values' column belonging to the category ...
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 ...
0
votes
0answers
51 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
1answer
25 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
8 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
1answer
18 views

Libre Office issue

I saved a Page of Excel to Libre Office. However the page seems wider than the page on screen. When I print it loses part of he last column. Any ideas where I am going wrong and, more importantly, how ...
1
vote
1answer
168 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 ...
0
votes
0answers
76 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
26 views

Fonts broken in Libre/Open Office Math

Can't enter any complex formula like sigma summation: How to fix?
0
votes
0answers
8 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 ...