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
563 views

Can't launch LibreOffice 4.4 on Linux Mint 17

Uninstalled LibreOffice 4.2, downloaded the 64-bit LibreOffice 4.4 tar files and extracted them all into a folder on the 64-bit Cinnamon Mint 17 desktop, then installed, as per the README, from a ...
1
vote
1answer
652 views

LibreOffice application background is black and cannot be changed

Since I updated to Ubuntu 15.04 the application background and the background in the context menus is black in LibreOffice: View full size So far I have not succeeded in turning it back to the ...
0
votes
1answer
126 views

Remove vertical lines from openoffice table

As a follow up question to How to make a 3 column chart with dividers using openoffice , I created a table which looks like: Is it possible to make horizontal lines invisible, to give the effect of ...
0
votes
0answers
94 views

Concatenate a reversed range in Libre Office

I'm kind of new with programming, but I have to make an excel document, that I can use interactively because the output of one of my programs doesn't fit with the input of the others... I have lot of ...
0
votes
0answers
241 views

finding the difference between two times in libreoffice

I'd like to know how to solve the problem: in cell A(n) is the first time in cell B(n) is the second time in cell C(n) is difference of times I don't want to put each time into cell C(n) function ...
0
votes
1answer
254 views

Conditional sum in Excel or Libreoffice calc

As an example, in the table above, I want to populate the empty column titled 'Totals' with the corresponding sum of all the Values in the left tables 'Values' column belonging to the category ...
1
vote
0answers
34 views

Format to generate .tex, .pdf and .md from?

I've used pandoc to generate .md, .tex, .pdf from .tex and .xhtml files. In tex I am using BibTeX and in odt (save-as xhtml) I am using Zotero to insert my citations. Currently neither .tex nor ....
0
votes
0answers
207 views

How to create a form checkbox without a label on LibreOffice Writer

In default the checkbox seems to have a label assigned to it. For creating an fillable PDF I'm looking for just a plain checkbox which can be clicked -- the description is done at another column, as ...
0
votes
1answer
81 views

How to avoid delete confirmation in LibreOffice Calc for OSX

Windows users can avoid the pesky delete confirmation dialog in Calc by using their Delete key instead of Backspace (according to the documentation) My Macbook only has a Delete key and so I can't ...
0
votes
1answer
19 views

Libre Office issue

I saved a Page of Excel to Libre Office. However the page seems wider than the page on screen. When I print it loses part of he last column. Any ideas where I am going wrong and, more importantly, how ...
1
vote
1answer
721 views

Anti-Aliasing LibreOffice Writer 4.x Under Windows

I have the 4.x version of LibreOffice installed on Ubuntu and its Writer renders the text so smoothly, but nothing like that is under Windows. I am using Windows 8.1 Update 64-bit, and tried to ...
0
votes
0answers
33 views

Fonts broken in Libre/Open Office Math

Can't enter any complex formula like sigma summation: How to fix?
0
votes
0answers
232 views

How can I get my printer to duplex on the long edge?

My HP Photosmart 6525 printer refuses to duplex on the long edge. Whenever it's asked to duplex, it duplexes along the short edge even if asked specifically to duplex on the long edge. I'm printing ...
1
vote
2answers
537 views

How to change LibreOffice settings without GUI

Is there a way to change Libre Office settings through command line or some configuration file? We would want to change the measurement units from imperial to metric while converting to HTML in ...
1
vote
2answers
336 views

Is there a tool to put a phone number into E.164 format?

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example: (123)456-7890 fred ...
1
vote
1answer
117 views

libreoffice writer figure cross-refencence

In LibreOffice Writer I cannot create a cross-reference to an image, it is only possible to create cross-reference to it's caption. By using the created link in PDF the screen jumps to the caption, ...
2
votes
1answer
483 views

Libre Office: Why can't I enter text?

I'm using a template on Libre Office. It has various boxes that I need to enter text in. Things were going fine, but then for some reason, it stopped allowing me to enter text. It seems to think that ...
1
vote
2answers
313 views

How to copy table contents from LibreOffice writer to plain text?

If I select a table's contents and try to paste it into a plain text document, the layout gets severely broken. +-----+----+ |one |two | +-----+----+ |three|four| +-----+----+ becomes, regardless ...
3
votes
1answer
1k views

Export from Libreoffice Draw to PDF with autocrop?

In Libreoffice Draw when using File → Export and choosing an image format, notably when using EPS to preserve the vector character of the figure, there is a checkbox "selection" which causes the ...
1
vote
0answers
16 views

Writer: Cross-reference with illustrations [closed]

My problem is that if I reference to any parts of an illustration (image) in Writer (by the I would like that as Reference), the screen every time jumps to bottom part of the image. I would like to ...
0
votes
0answers
41 views

LibreOffice SpreadSheet Conditionally copy value from one cell into a second cell?

I'd like to have the calculated value of a cell be carried over to another cell if the result is less than a given value. For instance, cell A2 is defined as =A1*.75 If the result is less than x, I'd ...
2
votes
0answers
28 views

Is it possible to style number/bullet lists separately in LibreOffice?

The "Text Body" style in my LibreOffice document uses a large margin above and below each paragraph. This is causing problems in my bulleted and numbered lists since each list item is considered to be ...
1
vote
1answer
260 views

Export first few pages of Doc to PDF using LibreOffice

I have been using LibreOffice in my rails app to convert my Doc to PDF using the command /Applications/LibreOffice.app/Contents/MacOS/soffice --headless --convert-to pdf --outdir ...
0
votes
2answers
78 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
1answer
173 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 Done-...
2
votes
2answers
3k 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
69 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
100 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 ...
4
votes
0answers
488 views

LibreOffice has ugly PNG import [closed]

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
43 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
167 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
276 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 ...
1
vote
1answer
127 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
1answer
360 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
53 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
540 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
2answers
1k 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
503 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?
1
vote
2answers
546 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
200 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
36 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 ...
1
vote
1answer
1k 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 ...
3
votes
2answers
430 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
116 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
31 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
59 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
130 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
2answers
225 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
634 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: =COUNTIFS($D$1:$D$1000;"Law";...
1
vote
1answer
189 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 ...