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
8 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 ...
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
1answer
58 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 ...
0
votes
0answers
7 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 ...
2
votes
4answers
4k views

How to change the text direction in LibreOffice?

I need "right to left" text direction to write in Persian.
0
votes
0answers
12 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
55 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
0answers
23 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 ...
1
vote
2answers
38 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?

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 ...
1
vote
1answer
31 views

Is there a way to change the query a report uses in Libreoffice Base or better yet to select the query at the time a report is run?

I have a standard set of data that I always want out of a report, however it could be based on a query of any of the values. Is it possible to set it up so I double click on a report and it would let ...
0
votes
0answers
21 views

Libre office impress is slow to convert pptx to pdf

I'm running Libre Office on my server to convert the powerpoint to a pdf file. Using a .ppt file: libreoffice --headless --convert-to pdf filename.ppt is running fine and take like 3 or 4 ...
0
votes
3answers
468 views

Can't install LibreOffice on Windows 7

I've just downloaded LibreOffice 4.1.3 (twice) on a newly refurbished Windows 7 Thinkpad. When I click the .msi to install, I get "This installation package could not be opened. Contact the ...
1
vote
2answers
627 views

Move rows with the keyboard in Calc

How might one move a row to a different location with the keyboard? I have found this guide for the mouse but due to disability I have trouble using the mouse for this. Note that I am not looking to ...
1
vote
0answers
21 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.
0
votes
1answer
54 views

restricting printing, editing and converting of pdf documents converted by libreoffice command line tool

I am trying to convert files to pdf using the libreoffice command line tool like this - libreoffice --headless --convert-to pdf filename Now I want to restrict the printing, editing and converting ...
0
votes
1answer
18 views

Arabic in LibreOffice: composite character chopped off at the top

I am running LibreOffice 4.1 on a PC and am using it to type Arabic. I have configured my keyboard as an Arabic (Egypt), Arabic (101) keyboard from the Windows 7 Control Panel. I have enabled complex ...
5
votes
4answers
55k views

How to open ods files in Excel?

What is the best way to open ods files in Excel 2003? Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)? The file I ...
4
votes
1answer
776 views

Custom CSV (.csv) filter for OpenOffice.org or LibreOffice?

Is it possible to create a some kind of 'custom CSV filter' for OpenOffice.org or LibreOffice spreadsheet program. What I need is to have the program to use predefined CSV settings for loading and ...
2
votes
0answers
26 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
2answers
4k views

Dark background in LibreOffice under Windows

I hate to write on with background, so i usally write my papers in a simple text editor, because I can have a dark background, but it's still annoying not to be able to use LibreOffice advanced ...
3
votes
1answer
27 views

Export LibreOffice Colour Scheme

I changed the colour scheme in LibreOffice (Tools → Options → Appearance) and defined my own colour scheme. I would like to know where (in which file or database) this new colour scheme was saved to ...
0
votes
2answers
30 views

Convert named months date text to date

I have a date text with named months like this 06:29 Mar. 17 2014 I tried this but obviously I need to convert Mar to a number =DATEVALUE(RIGHT(G1, 4) & "-" MID(G1,7,3) & "-" MID(G1,12,2)) ...
0
votes
0answers
23 views

Which version of LibreOffice is most stable?

I'm a bit confused by the version numbering system employed by Debian / LibreOffice. The version of LibreOffice that shipped with Wheezy was 3.x, and since it didn't have some features that I needed I ...
0
votes
1answer
9 views

How do I use named ranges in LibreOffice?

I'm guessing this is a bug but I thought I'd ask anyway. I'm using LibreOffice 4.2.4.2 on Debian Wheezy and have created some named ranges, one of which is Dates, another is Amounts. When I type ...
0
votes
1answer
469 views

How can I get the “After the Deadline” Libre Office extension to work

I have installed the "After the Deadline" extension for LibreOffice 3.6.3, but it does not pick up any grammatical errors, either as a wavy blue line while I type, or with a complete spell check of ...
0
votes
1answer
20 views

How can I set up a shortcut key for changing selected text to a preferred font in Libreoffice?

How can I set up a shortcut key for changing selected text to a preferred font in Libreoffice? Preferred font in my case is Segoe Print I have come this far: Tools → Customise → Keyboard selected ...
0
votes
1answer
70 views

How to get plain text, colon separated file into spreadsheet with data separated into columns

I received a digest of registrations for events. The fields are separated by colons and in plain text. Can I copy and paste this info into libreoffice spead and get it displayed in columns?
0
votes
1answer
22 views

Libreoffice suddenly missing on Fedora

On my Fedora 20, Libreoffice is suddenly missing. I did not make any changes to the system but it is still missing. It was running fine till yesterday. Its missing from my right click open with menu ...
2
votes
1answer
134 views

Multimedia keys don't work in Foobar2000 when LibreOffice is in focus (Winamp is not affected)

Multimedia keys are ignored while focus is on Calc from LibreOffice. Media keys work in foobar when it's focused, also while other programs are focused. I use Windows 7 Home Premium SP 1. My Foobar ...
0
votes
0answers
43 views

Find and replace in libreoffice writer formulas?

Is it possible to somehow find and replace expression in formulas (equations) inserted in a LibreOffice Writer document? I want to replace "vec" by "bold" in all my formulas in a book size document.
0
votes
1answer
54 views

SUMPRODUCT and IF conditional (LibreOffice) [closed]

I would like to multiply two cells in a same row, if a condition of a third adjacent cell is met; then sum the result to the next product in the next row (if condition is met), and so on. | A | B ...
0
votes
0answers
20 views

How to change footnote to right-to-left in Libreoffice?

I'm trying to change the footnotes in my Libre Office to right-to-left so the number will be on the right and the text will follow after. The rest of the document is already right-to-left, by the ...
0
votes
0answers
24 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 ...
2
votes
1answer
67 views

Is there a way to open TexMaths equations (.odt) in MS Word?

For writing documents with equations, I use LibreOffice with TexMaths. The majority of collaborators use MS Word 2007, so I am forced to save into .docx so that they can read the equations and edit ...
0
votes
0answers
19 views

Multi step shortcuts in LibreOffice Writer

There are some programs out (for example, Sublime Text) that allow multi step keyboard shortcuts, that is for example you can first click one key combination CTRL+K and then another another key ...
2
votes
0answers
109 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 ...
1
vote
1answer
57 views

How to install a Google web font onto my Linux computer?

I need to install a Google font for use in Libre Office. I search through the web and found a solution meant for Ubuntu. I am using Fedora, which works differently. And also, I only need one font, not ...
1
vote
1answer
666 views

LibreOffice / Openoffice or Scribus for book project?

I want to create a book and publish it later with an ondemand book printing provider. I read that Libreoffice 3.4 and 3.5 have some more DTP features but dont know if I should take Scribus or ...
0
votes
0answers
15 views

How to delete all occurrences of one index entry from the entire document?

While working on a document in LibreOffice, I have noticed that an index entry for a period (.) has been accidentally added to the list of index entries. It means that at the end of of every single ...
0
votes
0answers
34 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 ...
0
votes
1answer
163 views

How can I use indirect references for a pivot table's data source?

(This question is mostly about Excel, but it's also relevant for LibreOffice Calc, so I welcome answers about either.) I have this sheet with many rows, some of which only become relevant at certain ...
0
votes
0answers
22 views

LIBREOFFICE: Macro to convert LTR to RTL selectively. (BiDi issue)

I use Scrivener to write my essay that consists of BiDi text formatting. The sources I quote are in Arabic whereas the commentary is in English. I then export my file from Scrivener to ODT format. ...
0
votes
0answers
49 views

Libreoffice - change default zoom?

I don't understand how default zooming works in libreoffice. For example I like it to default zoom at 100%. One time I accidently zoomed (when trying to select lots of rows) and after that imidiatly ...
0
votes
0answers
10 views

Change tp paragraph style using chracter attributes in LibreOffice

I received a documnet here everything is in "default style". However, headers differ in font size and attributes, such as bold and italic. F&R allows me to find the respective headers by their ...
1
vote
1answer
34 views

How to use third column as identifier in line-graph

I want to draw a diagram(line-graph) from a three column sheet Input | Date | Value | Identifier | | ------------- | ------------- | ---------- | | 01-04-2014 | 1 | ...
0
votes
1answer
54 views

Which version of OpenOffice does TAILS have?

I can't find this information anywhere. TAILS is based on DEBIAN which at some point switched from OpenOffice to LibreOffice. How do I know before I download 0.23 or 1.0rc1 on my slow connection ...
0
votes
0answers
48 views

How to format pennies as dollars in LIbreOffice currency formatting?

I have data in a LibreOffice Calc spreadsheet with penny values, such as 001234 to represent $12.34 (twelve dollars and thirty-four cents). How can I define a format that will display these values as ...
0
votes
0answers
175 views

How to copy a column with conditional format by “value” - Libreoffice 4.1

I have a column that contains the data and a set of rules for the conditional format of the cells. i.e. the conditional format changes the background colour of some cells if they are negative. I ...
0
votes
0answers
32 views

Database columns dependent on another table column

For illustrate suppose I have two tables, let's say "Client" and "Cart": Client: ID; Primary; Autovalue Name; Debt; Cart: ID; Primary; Autovalue Client; value of Client->ID Product; Value; ...