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

1
vote
0answers
13 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
13 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
19 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
25 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
31 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
11 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
12 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
0answers
10 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
0answers
7 views

How to remove duplicate list numbering on one line in LibreOffice Writer

I am not sure how I ended up doing this (I just applied list numbering to some text) but somehow LibreOffice Writer decided that my first list item needs two number "1." labels applied, like this: ...
0
votes
1answer
16 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
0answers
43 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
35 views

LibreOffice 4.4.0.3 opening a PDF file displaying wrong Traditional Chinese characters

I have installed the LibreOffice 4.4.0.3 portable for Windows (my OS is 64-bit Windows 7 Home Premium Traditional Chinese version), hoping to use the PDF editing feature in the LibreOffice Draw. I ...
0
votes
0answers
17 views

Fonts broken in Libre/Open Office Math

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

LibreOffice missing rows in diagramm

I have some data: 02/27/15 12:12 AM 139 02/27/15 12:38 AM 136 02/27/15 01:04 AM 135 02/27/15 01:29 AM 135 02/27/15 01:53 AM 137 02/27/15 02:17 AM 136 02/27/15 02:40 AM 135 02/27/15 ...
0
votes
0answers
39 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
37 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 ...
0
votes
0answers
24 views

LIBREOFFICE WRITER - Changing some fontname throught a document

Normally the document use "COMIC SANS MS" font name. In my document I use four special characters ( club (U+2663), diamond (U+2666), heart (U+2665), spade (U+2660) ). These characters should come ...
0
votes
2answers
59 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 ...
0
votes
0answers
8 views

LibreOffice Send [file menu] to Desktop

In LibreOffice's File menu there is a Send submenu, a friend wants to "send" his documents to the Desktop yet I saw no options after going in to the customization / add command (just the same ...
1
vote
1answer
26 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, ...
0
votes
0answers
20 views

How can I properly print on lined paper?

I have some lined paper (either graph paper or looseleaf paper) and I'd like to be able to print/format a document (either with LibreOffice, LaTeX, or a PDF) so that every line of text is algined ...
1
vote
1answer
29 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 ...
0
votes
0answers
16 views

How to put higher levels number in the right side in outline-numbering of LibreOffice?

In LibreOffice Writer there is an outline numbering option that could be applied to a paragraph by defining a new style in "Styles and Formatting" window, in "number and bullet lists" tab and ...
1
vote
2answers
32 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 ...
1
vote
1answer
77 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
9 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
6 views

How to postpone document recovery in LibreOffice?

I am opening arbitrary document with LibreOffice Writer. It remembers, that it has some document to recover. I don't want to bother with this question now. How to postpone recovery? Currently I ...
0
votes
0answers
6 views

Can I have different heading/section numbering rules in different sections in LibreOffice?

Following this advice (Formst > Bullets and Numbering > Outline) I am able to get my headings formatted like this: 1 First Section 1.1 Alice 1.2 Bob 2 Second Section 2.1 Carol 3 Third Section 3.1 ...
0
votes
0answers
20 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
11 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 ...
0
votes
1answer
50 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
19 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
31 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
20 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
61 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
269 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
23 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
39 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
27 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
36 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
7 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
39 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
27 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
101 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
13 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
137 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
44 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
20 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
72 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
16 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 ...