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

1
vote
1answer
46 views

How to accept LibreOffice Calc autocomplete suggestion without leaving the cell edit mode?

Whenever I start typing a sentence in a LibreOfice Calc cell it suggests autocomplete options based on other cells contents. I usually would like to accept it and make a slight modification but when I ...
1
vote
1answer
2k views

Exporting UTF-8 text from LibreOffice without byte order mark

In LibreOffice, if I save a document as file type "encoded text" and select "Unicode (UTF-8)" as the encoding, it always writes a byte order mark (BOM) at the start of the text. It does this even when ...
0
votes
0answers
3 views

Line-up in-text math formula in LibreOffice Writer

I'm having trouble positioning mathematical formulas inside a paragraph of text. What I get while the formula editor is opened is: However, when I turn the formula editor off, I'm getting this: ...
0
votes
0answers
5 views

How to pass parameters between fields in libreoffice base

I’m trying to allow users to enter data into a database. I’d like to give each user an ID which will be submitted along with the data, so that i know which user entered data, I thought the best way ...
2
votes
3answers
214 views

How to embed formulas in a line of text using OpenOffice Impress?

I want to create a presentation in Impress and need to embed a formula in text. I only found very old forum posts (over five years old), which said it is not possible. Has this changed by now? How ...
9
votes
3answers
18k views

How to edit a read-only document in LibreOffice?

I need to fill a form (which I received in .doc format and saved as .odt). The file is read-only except for the fields where I can enter the information. Unfortunately, with the fields filled it ...
0
votes
0answers
3 views

Libreoffice quits immediately in shell

I'm trying to get libreoffice4.3 (4.3.4.1) to work on CentOS Linux release 7.0.1406. When I'm trying to do a file conversion: /usr/bin/libreoffice4.3 --headless --convert-to pdf filename.ppt I get ...
0
votes
0answers
8 views

Convert Formula to Text in Libreoffice Writer

I have a Libreoffice Writer file. I have near to 1000 mathematical formulas. I want modify them because all of them have small font. So I want convert them (formulas) to normal text then I should be ...
0
votes
1answer
24 views

How to save single sheet, as separate file in LibreOffice?

When I have multiple sheeet in LibreOffice document, how to save specific sheet as new .ods file in LibreOffice?
0
votes
0answers
12 views

Why LibreOffice control is not updated?

I have created a few simple macros that create a dialog and read one of the controls text. The ReadWrite Macro is attached to a button. It reads a text from textfield and prints it. However when I ...
1
vote
0answers
22 views

LibreOffice has ugly PNG import

I'm trying to import a PNG graphic exported from Inkscape (I tried importing the SVG directly but it doesn't work: the text is missing and replaced by black boxes) in a LibreOffice document, but it ...
0
votes
1answer
7 views

Libreoffice in-text citation numbering

I am writing a paper that has in-text citations spread throughout that are just sequential numbers. Is there a way to do this so that if I add something in the middle, I don't have to go and manually ...
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 ...
1
vote
0answers
18 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 ...
0
votes
1answer
21 views

Insert formula for each row in Excel or LibreOffice

I have the following data in LibreOffice: As you can see there are 3 sets of measurement. I want to automatically feel in the D column with the following formula automatically. For example D2 will ...
0
votes
1answer
501 views

Spacing before the paragraph right after a table?

My Body Text style has space below, but not above, and I want it to stay that way. Now, when I insert a table between two paragraphs of Body Text, I get no space between the table and the subsequent ...
2
votes
3answers
641 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
0answers
29 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 ...
0
votes
0answers
15 views

How to make caption not connected to figure in OpenOffice / LibreOffice (like in MS Word)?

When adding a caption to figure in LibreOffice (and I expect also in Apache OpenOffice.org), it is automatically "glued" to the figure, and stays with figure. From what I understand, it is done using ...
1
vote
1answer
35 views

shortcut changing in libreoffice (ubuntu 14.04)

im writing in Hebrew and Arabic with libreoffice and say i want to toggle bold so ctrl+b turns into ctrl+נ (nun in Hebrew) . so if id like to toggle bold i will need to change lang to English then ...
0
votes
0answers
11 views

assign string “tags” based on numeric interval in Libreoffice Calc

I'm struggling with an easy issue. I'm working in Libreoffice Calc and I have a numeric column with values from 0 to 365. What I would like to do is to create another column assigning string values ...
0
votes
1answer
29 views

Libreoffice calc export to pdf. Some characters appear different

I'm having the following problem: when I try to export a .ods file to .pdf on Libreoffice Calc 4.3.2.2, I use some Unicode characters. Most of the time they appear in the pdf just fine, but in some ...
3
votes
1answer
90 views

Arabic: Unicode: how to stack fatha kasra damma

I am using LibreOffice to type arabic, but if what I am asking cannot be obtained with LibreOffice then I would like to know whether it is possible in LaTeX, because I have seen this in a book, but do ...
1
vote
0answers
13 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 ...
0
votes
1answer
6k views

Add automatic page numbers in LibreOffice

How can I add an automatic page number to all pages in a LibreOffice .odt file? I've already tried the following: Insert > Header > (name of page style) and Insert > Footer > (name of page style) ...
0
votes
0answers
24 views

How to remove a JRE link from LibreOffice?

I have LibreOffice 4.3 on Windows 7 64bit. I have both 64-bit and 32-bit version of JRE there. For the first time I have mistakenly linked the 64bit version as the JRE for the LibreOffice; this caused ...
0
votes
0answers
21 views

Copy distinct values in calc

I have some text data in column A, adding data to that column is the standard use case. I would like Calc to dynamically copy only unique values to, say, column D. I am aware of OpenOffice: get ...
0
votes
2answers
57 views

How to change the default font in LibreOffice 4

How do I change the default font in LibreOffice / OpenOffice. So that when I open a new spreadsheet document it doesn't revert to use the standard default font (Liberation Sans/Serif) How to set the ...
2
votes
0answers
59 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 ...
0
votes
1answer
7k views

Unzip error “End-of-central-directory signature not found”

I have a ZIP file that open in Windown/MS Word, (actually it is a .DOCX file). Opening it with LibreOffice / Mac produces: General Error. General input/output error. File says: ../Commission ...
0
votes
1answer
42 views

.odt vs .fodt: which is most space effective for git repositories?

Which is most space effective for git repositories: LibreOffice/OpenOffice .odt files or .fodt files? I think that it should be .fodt, since with the uncompressed XML format .fodt the repository ...
1
vote
1answer
604 views

Creating fillable PDF form with dynamically updated fields

Is there a way to create fillable PDF forms where a set of fields gets their data when one of the fields is filled out? The normal use case would be application form, where your name or membership ...
0
votes
1answer
35 views

How to adjust the Y Axis maximum value on a bar chart in LibreOffice Calc

How do I change a chart so that the highest values actually are at the top of the chart? Say the chart goes to 1600, but I want it to go to 1500?
0
votes
0answers
15 views

Serial printing on LibreOffice Writer is not working

I have written this document and linked the corresponding fields from a LibreOffice Calc database (spreadsheet) correctly, and when I try to print it I am being prompted about "Serial printing" the ...
4
votes
9answers
13k views

Registering a program to show in the “Open With” list

After installing LibreOffice and then unistalling OpenOffice, all the files for the many office document types (odt, ods, doc, xls, rtf and a dozen more) are unassociated with any application. When I ...
0
votes
0answers
64 views

Import multi-line CSV records into spreadsheet as column data

Any standard fixes to convert multi-line CSV records into column data (as CSV or LibreOffice)? I'm using ArchLinux and I have LibreOffice (and Python, for what that's worth). I have a CSV file with ...
0
votes
0answers
113 views

How to convert html to doc/docx with OpenOffice or LibreOffice?

I am trying to convert a html to doc or docx. I used some of the available php classes but the results are not good. I wonder if I can convert a html file to doc using some office software like ...
5
votes
7answers
6k views

Which doc format should I use in LibreOffice if other users open it in MS Office

I often share documents with colleagues. I use LibreOffice (and OpenOffice). But my colleagues use Microsoft Office. My documents always look differently when opened in MS Office (.doc and .odt ...
0
votes
0answers
26 views

Hotkey (or similar) to quickly switch to a monospace font (“teletype”) in either LibreOffice or Microsoft Office

I find myself doing a lot of writing where I would have to change fonts for certain parts of the text. The obvious example is writing code documentation, where you'd have to reference code frequently, ...
0
votes
0answers
38 views

Centering piece-wise function equation in LibreOffice

I'm sorry if this is off-topic. I am using the TexMaths extension in LibreOffice and I'm attempting to center an equation. However, the equation simply gets displayed and I am unable to alter its ...
6
votes
1answer
3k views

How can I save my styles' modifications for eternity in LibreOffice?

Every time I modify or create a new style in Libreoffice Text Document it works great while I'm in the document. Yet, every time I go out from Libreoffice and then I go back, all my modifications and ...
1
vote
1answer
103 views

zotero not working with libreoffice 4.3 in linux mint 16

As title, I tried to use zotero in libreoffice, after I installed zotero, I found from zotero's preference that the add-in was not installed, I click the button to install but nothing happen. I ...
0
votes
1answer
16 views

how to get cell number as a result of a function

i need to get № of a cell that contains the result of MAX(J4:J24) and write a word from the same row instead of the actual max number the word can be written i guess via =INDIRECT("A"&formula ...
0
votes
2answers
25 views

LibreOffice Delete Solid Line

In LibreOffice a solid line is created when you enter three dashes (---) and press enter. These lines may become stuck to parts of the page. How do I remove them?
0
votes
1answer
130 views

Hide slide numbers and slide footer on first and second slide in LibreOffice Impress

I use LibreOffice Impress for to create my presentations. I am wondering how I can choose not to show the slide footer (including e.g. the slide numbers, presentation title and date) not only on the ...
8
votes
4answers
6k views

How to change the text direction in LibreOffice?

I need "right to left" text direction to write in Persian.
0
votes
0answers
158 views

LibreOffice calc countifs with date

I got 3 columns. 1 column(D) text, 1 column(T) 0 or 1, 1 column date(A) 01.01.2010 till 31.12.2014 . I want to count up until a specific date, for example 10.10.2011: ...
0
votes
2answers
113 views

How do I get out of full-screen mode?

I'm using LibreOffice 4.2.4.2 (Calc) in debian wheezy. In an attempt to hide the window title bar I have enabled full-screen mode, which has hidden both the window title bar of Calc and the menu bar ...
1
vote
2answers
54 views

Book like page numbering in LibreOffice

How can I achieve the following goals using LibreOffice Writer? The first few pages should be numbered in Roman numbers (like i, ii, iii, iv, ...), but the very first page number should be hidden, ...
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 ...