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
2answers
9 views

Can I have multiple views of spreadsheet data which extract and sort from a larger set?

Supposing I have a spreadsheet (Libreoffice ideally but Excel is ok) which has data like this ______| Age | Height | Shoe Size | etc... Adam | 14 | 180 | 11 | ... Beth | 21 | 205 | ...
0
votes
0answers
20 views

can openoffice and libreoffice installed in parallel?

someone said install them both in ubuntu is going to mess up the system: https://forum.openoffice.org/en/forum/viewtopic.php?f=16&t=62509 ...
0
votes
0answers
14 views

Show deleted cell values (Track changes in Libreoffice Calc)

I was looking for this feature for a while now: If I turn tracking the changes on and delete the value in a cell it just highlights the border around the cell in red, meaning it has changed. Is it ...
0
votes
1answer
26 views

LibreOffice Calc Error 518

I'm trying to achieve the following in LibreOffice (did it with Excel already, but importing this excel-created file produces the same error). I have 3 columns (A) (B) (C) ECTS Mark ...
1
vote
1answer
41 views

Libreoffice Writer: restart page numbering and include total pages

I have a LibreOffice Writer document with 6 pages. At page 5 I want to restart numbering at 1 and have total page count reset as if the document started there. Page 1 Page 2 Page 3 Page 4 Page ...
0
votes
1answer
15 views

Calculating total salary

I store my working time in Libre Office Calc like this: Start End Hours 10:00 15:00 05:00 11:00 14:00 03:00 09:30 15:30 06:00 Total 14:00 Now I want to calculate my salary, i.e. ...
0
votes
0answers
24 views

Excel xlsx protected view import into ods libreoffice

On a website I get data from, I can download the query results in Excel .XLSX file format only. This is OK at my office where I have MS-Excel. I open the file and always get this warning message ...
0
votes
0answers
12 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
12 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 ...
0
votes
0answers
4 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
11 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
0answers
16 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
31 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
10 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
0answers
19 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
24 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
0answers
18 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
43 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
14 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
43 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 ...
1
vote
0answers
16 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
34 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
25 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
27 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
77 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
44 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
21 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 ...
0
votes
1answer
68 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
87 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
30 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
146 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 ...
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
43 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
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
27 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
64 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
65 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
185 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
114 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
176 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
24 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
169 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
99 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
55 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
93 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
49 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
38 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
31 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
128 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
65 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 ...