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
1answer
34 views

Recover a file with a wrong suffix? [closed]

I wrote a text Under Libre Office and wrongly named the file with a .txt suffix. And closed it. When I tried to open it. it was said corrupt. And was displayed in non understandable characters. What ...
4
votes
1answer
342 views

Is there a way to set the default quotation mark in LibreOffice Calc from smart quotes (“ ”) to dumb quotes (the straight kind)?

I use LibreOffice Calc to make lists of programs with different parameters to run on an hpc cluster. For each batch of commands I must do a find and replace on the smart quotes, as they cause errors ...
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 ...
0
votes
0answers
110 views

Latest version Libreoffice Headless CentOS

I am somewhat new to using Linux so my apologies if this seems like a simple question. The problem I am facing right now is an outdated version of Libreoffice. The server is running CentOS 6 ...
0
votes
0answers
96 views

Libreoffice PPT to PDF Place Holder Text Removal

I am using Libreoffice headless version for CentOS to convert .pptx to PDF. But the PDF produced have placeholder text that says "Click to edit master text styles", "First Level", "Second Level", etc. ...
3
votes
2answers
1k views

Is there a CLI-only package to convert MS Office files to PDF?

Is there a command-line interface only package to convert Microsoft Office files to PDF? Specifically, I need to be able to export doc/docx (Word), ppt/pptx (PowerPoint), xls/xlsx (Excel), and ...
0
votes
1answer
95 views

How to fix the strange character in libreoffice?

I have a docx file with mathtype 6.8 The docx only has this equation. But when I load in libreoffice 3.6.2.2, it becomes Here is the doc file: ...
2
votes
0answers
91 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 ...
3
votes
2answers
3k views

Convert file to PDF using LibreOffice under user apache (i.e. when using PHP)

I installed libreoffice-headless and can convert documents when logged on into the shell as a normal user. [root@desktop ~]# yum install libreoffice-headless [root@desktop ~]# yum install ...
1
vote
1answer
311 views

Effect of HOME on libreoffice to convert to pdf as non-root user

I installed libreoffice-headless and can convert documents when logged on as root. I then tried doing so as another user, and it didn't show an error, but didn't convert the file. I then found that ...
1
vote
1answer
4k views

How to fix X11 error: Can't open display

I installed libreoffice.x86_64 using yum from the CentOS repository on my CentOS basic server. When running the following command from the shell, I get the following X11 error. xhost is installed on ...
2
votes
0answers
160 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, ...
1
vote
1answer
2k views

PDF file opened with LibreOffice, now conversion to Word needed

Of all the software I ever tried to handle PDF files, I found LibreOffice by far the best (at least for the files tested). The number of codes when importing the odg file into DVX2 (this is a CAT ...
2
votes
1answer
429 views

What character encoding does ODT use?

Whenever I open an ODT file saved by LibreOffice with default settings, and open it in a plain text editor, I get a bunch of nonsense. Not a single trace of the text I typed. In what character ...
1
vote
0answers
273 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
53 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 ...
0
votes
1answer
76 views

How to get the average of the higher M values in N cells?

I have a spreadsheet with values in a matrix with several rows. For each row I have a N numbers. I want to calculate the average of the M higher values of the row. With M<N. Is there a common ...
0
votes
1answer
1k views

MS Excel Vba/Macro equivalent in LibreCalc or OpenOfficeCalc

is there an equivalent macro/vba in libre calc that does this routine; - Read/open xls files in a path and do a batch import/copy of read sheets and merge it with the current open workbook. Here's the ...
3
votes
2answers
1k views

Which fonts come with OpenOffice / LibreOffice? [closed]

Is there a list of all the fonts which come with OpenOffice / LibreOffice ?
3
votes
1answer
436 views

How compatible is LibreOffice with OpenOffice?

LibreOffice and OpenOffice both use the OpenDocument format, and LibreOffice is based on OpenOffice. But how compatible are they which each other?
0
votes
1answer
342 views

Can LibreOffice Base directly use MySQL syntax?

From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different ...
0
votes
1answer
472 views

How can I use extremely large numbers in my spreadsheet programs?

If I try to calculate large exponents in LibreOffice Calc or OpenOffice.org Calc, the results come out to be erroneous. See these two examples where I calculate 13^18, Using LibreOffice Calc Using ...
3
votes
2answers
378 views

LibreOffice: stop automatic formatting of text into a formula?

In LibreOffice, I'm entering some text into cells, which happens to look like a math problem: -5 / -10 / -15 The program assumes I want to calculate this, and sticks an equals sign automatically in ...
0
votes
1answer
29 views

Word Document has two footers after importing from LibreOffice

I am having a weird issue with word. It seems I have two footers in the document on a single page. I am using Word for mac, the document has been imported from LibreOffice. The issue persists in Word ...
4
votes
1answer
270 views

Is it possible to access and edit Google documents directly from Libreoffice?

I'd like to work with a Google spreadsheet directly inside Libreoffice, without having to export and import it, in order to automatically reflect the changes on the online file. Basically, I'm looking ...
3
votes
2answers
10k views

Is it possible to copy & paste a pivot table in a spreadsheet?

I have a spreadsheet where I use some pivot tables to summarize and highlight some relevant data. Since I have to use multiple pivot tables, all with nearly the same data input but with slight ...
0
votes
1answer
45 views

sandboxing libreoffice on Linux

I want to build multiple versions of libreoffice on a machine (Debian 6) and want to test these versions against a set of test cases automatically. I also want to test the given libreoffice version by ...
0
votes
1answer
552 views

Libre office: How to format title pages for book (avoiding the missing blank-page when pdf-file exported)

How do you set up the i, ii, iii, iv... followed by the 1, 2, 3, 4... pages of the usual book format in Libre office? What is the logic of it? Also how do you avoid the automatic BLANK PAGE appearing ...
2
votes
3answers
2k views

libreoffice what is a fast way to paste special > text and numbers only (aka paste special values)?

I copy and then paste values in excel quite a bit (when I use Excel). When I use LibreOffice you can do the same thing (see related question here) but it is oh so tedious! It gets especially tedious ...
0
votes
1answer
133 views

Attempting to open TSV file in Libreoffice Calc results in being opened by Writer

I have been working with TSV files for months, but I have one file that refuses to be opened in LibreOffice Calc. It instead brings it up in writer. This behavior is consistent across command line and ...
0
votes
0answers
66 views

Libreoffice won't let me have a read-only ComboBox

I have a database table with some entries. I want to display all the fields of this table as a ComboBox. I want the user to be able to select this any entry in this ComboBox without modifying the ...
2
votes
2answers
580 views

How do I prevent LibreOffice saving the file with the thumbnails?

I am using LibreOffice 4.0 on Windows 7 and I have noticed that it saves files (for example Writer) with a preview. (The icon of the file shows what's inside it, it looks like a page). How do I turn ...
1
vote
1answer
300 views

How to specify the target directory for LibreOffice 4.0.2.2 .msi file?

How can I specify the target directory for the LibreOffice 4.0.2.2 .msi installation? The .msi file is here: ...
2
votes
2answers
1k views

Installing LibreOffice 4.0.1 on Fedora 17

I downloaded 'LibreOffice_4.0.1.2_Linux_x86-64_rpm.tar.gz' from official site of libreoffice and follow the readme to install. The installation completed successfully, but when I entered ...
2
votes
2answers
1k views

Only root User is able to open LibreOffice

I am currently using Linux Mint 14 - Nadia as my Operating System. The biggest inconvenience right now is not being able to open Libreoffice as a normal user or simply by just double clicking it. ...
1
vote
0answers
225 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 ...
0
votes
1answer
66 views

Using LibreOffice and having problems, copying details

A staff member in our office is having trouble pasting details from a spreadsheet {In any format} to a template in .ott format. When pasting and details from the spreadsheet, it removes some of the ...
2
votes
1answer
686 views

How to prevent LibreOffice running 'recover' at each startup?

How to prevent LibreOffice running 'recover' at each start-up? On Ubuntu, each time I restart my computer, and then start LibreOffice, it asks me whether I want to recover documents. It does this ...
0
votes
1answer
3k views

Change date format in Libre Office

I have a column with date values with initial value as: '01.02.13' (in format DD.MM.YY) . Converted it to the required format (DD.MM.YYYY) '01.02.2013'. But when I focus on the cell it shows date as ...
1
vote
0answers
258 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 ...
0
votes
1answer
83 views

Where can I get pre-reform spelling correction for Brazilian Portuguese in LibreOffice?

I've just made the change from Open Office to Libre Office (Windows 7), and have a problem with Brazilian Portuguese spelling. Libre Office comes with dictionaries for the recently-reformed (some say ...
2
votes
3answers
199 views

Vim undoing text width formatting

I wrote a document in vim with textwidth=80. I would now like to paste this document into libreoffice for formatting. The problem is the line breaks. In libreoffice the lines are too short because of ...
4
votes
4answers
5k views

How to change the text direction in LibreOffice?

I need "right to left" text direction to write in Persian.
1
vote
1answer
2k views

init.d script for OpenOffice / LibreOffice headless does not stop process

I am using Ubuntu and found this init.d script for LibreOffice headless. Problem is that it does not seem to be stopping the process when asked to "stop". Any help greatly appreciated. Two other ...
1
vote
0answers
617 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 ...
0
votes
1answer
233 views

Batch Conversion to PDF with LibreOffice in Mac

I have LibreOffice installed on my new Mac. In Ubuntu you can directly access LibreOffice via command line. How do you access LibreOffice in mac via command line ?
4
votes
1answer
2k views

How to override GTK3 / Gnome Shell themes per application

I'm using both Cinnamon and Gnome Shell (Gnome 3) on Fedora 17 with the dark theme Blapple. Quite a few applications can't handle dark themes very good. In Gnome 2 I had a simple solution for these ...
1
vote
0answers
53 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 ...
0
votes
1answer
53 views

How to apply a page style to a specific set of pages?

I want to split my document in three parts. The first part is the first document which has the style "First Page". The other ones have "Default". Now, I want the appendix to have the "Index" page ...
4
votes
1answer
448 views

How to configure own shortcuts for styles?

When I Ctrl+B a selected text, it will become bold. Alas, this style is directly formatted, which means it gets lost once I default via Ctrl+M. Yet whenever I reset the whole document, I only want it ...