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
281 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
217 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
111 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
163 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
63 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
39 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
242 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
125 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
964 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
32 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
46 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
644 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
220 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
176 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
347 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
165 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
289 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
398 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
92 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
85 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
457 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
159 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
68 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
87 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
464 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
78 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
78 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
150 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 ...
0
votes
1answer
1k 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 ...
1
vote
1answer
10k 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 ...
2
votes
1answer
2k views

LibreOffice 4.2.1.1: do not display list of recent documents

Today I installed LibreOffice 4.2.1.1. When opening LO, it displays a list of recent documents with screenshots, similar to Firefox and Chrome. I don't want this. How can I disable this setting?
2
votes
1answer
2k views

How to create a new file from Finder's context menu?

Could you tell me how to add a menu item into Finder's contextual menu (the one I get when I Control-click in a folder)? When I create a document or spreadsheet using LibreOffice, I usually run ...
0
votes
1answer
60 views

Style not sticking in LibreOffice Writer

I'm using Writer to modify a .docx file. The file was originally a "template" made by my professor with pre-configured styles for different parts of the document (spacing and indentations, etc.). ...
4
votes
2answers
4k views

LibreOffice is saving CSV files with tabs as separators

I just opened a CSV file in LibreOffice, made a small change and hit save, saying "yes, keep using CSV". The file is now filled with tabs instead of commas. My scripts (using Python's CSV lib) won't ...
0
votes
1answer
45 views

Libre office Writer: image linking latex-like

As with latex, is it possible to write the path to an image and then get its content automatically updated by the program? I would need something like this tool without changing editor.
-1
votes
1answer
396 views

Change background fill of cells in LibreOffice worksheet containing specific text

How can I change the background fill of all the cells of a LibreOffice spreadsheet worksheet that contain a specified text? In Excel that could be done by configuring the settings in the find and ...
0
votes
0answers
24 views

Recover a lost LibreOffice document [duplicate]

I was working in LibreOffice Writer with an .odt document yesterday, was saving it regularly, but today it looks like I did nothing! I think, the reason is in me accidantally saving it in /tmp all the ...
-1
votes
1answer
43 views

How can I type certain days (such as Monday, Wednesday) in an easy way for the next 5 months without typing them one by one?

I am trying to input in a libreoffice calc file only Mondays and Wednesdays for the next 5 months, but I dont wanna do it typing the dates one by one. So..I thought I would type 4 dates like this: ...
3
votes
0answers
185 views

Default font and cell padding when opening files in LibreOffice/OpenOffice Calc

I've seen solutions for setting a default font when creating new files. What about a default font (and cellpadding) when opening an existing CSV file? LibreOffice seems to always default to Liberation ...
1
vote
0answers
131 views

Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc

Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...
0
votes
1answer
1k views

In two columns layout, how to keep text in each column separate from the other?

I am editing odt document in LibreOffice Writer. I have the following, very simple layout, it looks like this: I would like to text in each column to stay separate from the other column. So the ...
2
votes
1answer
895 views

Excel/Libreoffice returning TRUE for IF() instead of expression

See the following situation: For some Here cells A1:E3 have plain text data (no formulas), and C4:E4 have the same formula (i.e. typed in one cell and then autofilled to another ones). I wanted ...
0
votes
1answer
296 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 ...
1
vote
1answer
972 views

Printing problems with libreoffice and (remote) cups server

we have cups running on an ubuntu server managing all printing jobs. on the ubuntu clients the server is set in client.conf Printing works from every tested program, but not from libreoffice. (tested ...
1
vote
0answers
2k views

Libreoffice Base: How have a combobox linked to a related table linked to or in the form table control

I could not sum up, what I really want in the title. But here I am going to try to explain what is it about. I have switched from MS Access to Libreoffice Base because it is open source, free and ...
0
votes
1answer
355 views

Libre Calc error on a float in decimal notation. Err. 519 (#value error)

There is a problem with my libreoffice. I doesn't calculate cells with decimal points, possibly seeing them as text. I have checked my locale settings (you can see them in the picture above) that ...
3
votes
1answer
338 views

Open only the first 10 lines of large CSV file in LibreOffice Calc

I will start receiving many large CSV files, of which only the first few lines are of interest to me. I was hoping to open them by piping only the first few lines to Calc, but this doesn't work: $ ...
2
votes
2answers
60 views

How to autofilter for given strings in common spreadsheet softwares?

I know I can create an "autofilter" at the top of an XLS table.. But how can I create a filter that filters for given strings? example TABLE input: LASFD@FOO.COM LKXYCVER@FOO.COM ...