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
166 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
48 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
0answers
60 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
2answers
509 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 ...
0
votes
1answer
228 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
44 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 ...
1
vote
2answers
258 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 ...
0
votes
0answers
133 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 ...
1
vote
0answers
33 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
395 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 ...
1
vote
2answers
80 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
72 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 ...
0
votes
1answer
17 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
40 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?
2
votes
0answers
93 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
111 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 ...
0
votes
0answers
444 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: ...
1
vote
1answer
167 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
0answers
385 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 ...
1
vote
0answers
25 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
322 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 ...
3
votes
1answer
245 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
1answer
125 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 ...
3
votes
1answer
188 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
64 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
1answer
41 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
2answers
279 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 ...
0
votes
1answer
148 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
1k 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
33 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 ...
1
vote
0answers
47 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 ...
0
votes
1answer
715 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 ...
1
vote
1answer
254 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 ...
2
votes
1answer
200 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 ...
2
votes
1answer
363 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 ...
1
vote
0answers
196 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 ...
1
vote
1answer
337 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 ...
1
vote
1answer
47 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 | ...
2
votes
0answers
426 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 ...
0
votes
1answer
100 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
34 views

How to create a reference line between a name and a value in LibreOffice

In the figure (which is a part of the table of contents of some book) the doted lines help our eyes to easily spot the page number of the mentioned chapter. When creating similar contents using ...
1
vote
2answers
97 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
538 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
1answer
202 views

How to auto-resize and fit copy pasted content from a webpage into document file?

I copy pasted some text with tables into an OpenDocument Text file, but for some reason the text, tables and images run off the ride side of the pages. Is there any way to make LibreOffice to ...
0
votes
1answer
71 views

Dedupe drawing objects in SVG/vector graphics files

I have an exported image consisting of ~35000 objects (the only way to get it out of the source application was as a copy-pasted "metafile"). By pasting into libreoffice draw and converting to ...
0
votes
1answer
90 views

Automatic backups (history) in LibreOffice (OpenOffice)

LibreOffice can create a backup copy when you enable it in settings (Options > Load/Save > General), but it saves only the previous state (one only). It has also an versioning feature (File -> ...
1
vote
2answers
523 views

LibreOffice Calc, Fill in Differenet Numbers of Empty Cells with Above Value

I have two columns of data currently in data like this (i.e., varying number of blank cells in Column B): Column A       Column B ...
0
votes
1answer
95 views

Download LibreOffice 4.1.3 EXACT version [closed]

I need to quickly download LibreOffice 4.1.3 or I'll lose out on something important. I've tried renaming the older installs that are close to that version number. I'm not seeing any archives (like ...
0
votes
1answer
83 views

LibreOffice for Windows Security

I use Windows and would like to install LibreOffice. Is there a "security team" checking the code for malware? In Linux I think it's done by the security team of the linux distribution. Who is doing ...
1
vote
4answers
159 views

Source code line endings in LibreOffice Writer

I have a paragraph style called "Source". It has no spacing above and below, and it uses a mono-space font and gray background. I want to paste text with some longer lines into my document and it ...