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

3
votes
1answer
11 views

Libreoffice, how to copy from Writer and pasting unformatted in Calc, by default?

I have the revision of a translated text, made by the client, I am the third party reviewer and have to fill up an .xls module with all the source texts, the translated one, and the amended by the ...
1
vote
1answer
11 views

Duplicate existing table

I have created a table in a LibreOffice Write document. I want to duplicate the table in the same document and make a few small changes in the duplicate. The table is large and using the mouse to ...
2
votes
1answer
43 views

For either Libreoffice or Word, how do I insert chapter and scene fields?

I am writing a play, and I want to be able to insert two fields, much like Page #. Let me explain... Each time Scene 1, Scene 2, Scene 3, etc., I want the pages in that particular field to be named ...
-1
votes
0answers
11 views

Download icon not available for LibreOffice document in Google docs [migrated]

I have uploaded a document written using LibreOffice writer to google docs, but download icon is not visible. How to turn on the download mode. Iam using Ubuntu OS. File name is "Project", it does not ...
3
votes
0answers
20 views

Run a program and return value libreoffice calc [migrated]

I wrote an algorithm in c that takes input of double precision numbers and returns a double. I would like to use this in libreoffice calc. I tried making a macro function using shell but it only gives ...
0
votes
0answers
10 views

LibreOffice Writer's “Background Color” setting not working

I have recently upgraded to LibreOffice Writer Version: 5.0.2.2 on Ubuntu 15.10. Before, I was using an unknown version of LibreOffice Writer on Ubuntu 12 and I had a document (with a .doc extension) ...
0
votes
0answers
18 views

LibreOffice Writer in Windows missed images from Linux

I'm using LibreOffice Writer in Linux to edit a document with images. But when I move file created under Linux to Windows not show images inside the document. My LibreOffice version: LibreOffice ...
0
votes
1answer
18 views

Libreoffice calc how to filter by a list of ID

I have 2 spreadsheet: - one with 14000 raw that contains all the information, first column is the ID - one with the first column containing ID i'm interested in I need to get the first speedsheet ...
3
votes
2answers
32 views

Change text direction RTL in LibreOffice on mac

I have marked the checkbox for CTL on language options and I can choose the Right-To-Left button, But on OSX EL Capitan when I type in Hebrew the text gets choppy and the cursor jump the the beginning ...
0
votes
1answer
37 views

Using libreOffice Calc function in macro

I am trying to create a basic macro function in calc to perform a hexadecimal to binary conversion with more then 10 bits. But I've got a lot of troubles. First, where can I find actual ...
3
votes
2answers
108 views

How to make Windows Explorer preview panel to show LibreOffice files preview?

On my work, Windows Explorer can show preview of Microsoft Office documents using Windows Explorer's preview panel (View > Press "preview panel" icon and select a Microsoft Office file). That computer ...
3
votes
2answers
12 views

LibreOffice presentation: wider text background, like html padding?

When setting a text's background in a LibreOffice presentation, it may look like this: Is there a way to increase the background size, as in making it wider? I'm trying to get an effect similar to ...
-2
votes
1answer
20 views

Is there a RSS feed to subscribe to in order to receive information on new LibreOffice releases? [closed]

I am looking for a public RSS feed that informs me about new releases of LibreOffice. Is anyone aware of a respective RSS feed?
0
votes
0answers
16 views

Open linked document instead of current one

When clicking on a link (in MS Word) to another document, is there a way to have Word open the new one in the same window as the current one instead of the current one? If not, is there a way in ...
0
votes
1answer
11 views

LibreOffice - getting German spell checking to work (Debian)

I'm using Debian Jessie, LibreOffice is 4.3.3.2. I'm having a document for which the text language is 'German (Austria)', alternatively I tried 'German (Germany)'. I can't spell check my text. If I ...
1
vote
0answers
20 views

How can I supress zero values in a LibreOffice line line chart? [duplicate]

I'm making a line chart counting users of various releases of a piece of software over the years. This is a very spiky line chart, where as new versions come into existence and then retire, lines ...
0
votes
0answers
8 views

Display Chinese characters, Japanese characters or North East Asian characters vertically

I recently needed to type Chinese characters vertically on LibreOffice. So I was searching around the web, but the info is either outdated or not helpful. So I'd like to share how I did it. If you ...
3
votes
0answers
32 views

Can MS-Word open encrypted ODT-Files

Is it possible to open LibreOffice encrypted documents using MS-Word 2010? The data format is odt and the password is known. Is the encryption secure?
0
votes
0answers
23 views

Ubuntu Libre Office compatible to Word/Windows

I need to create a docx-File, which has a strong password read protection. Unfortunatelly I am writing in Ubuntu/Libre Office Writer. If I save the file in the docx-format (using Ubuntu and Libre ...
0
votes
2answers
31 views

Conditional Formatting based when equal/not equal to another cell in the same row

I have a spreadsheet like this in LibreOffice A | B | C | D -------+----------+---------+--------- 1 | A | 1 | B 2 | C | 2 | C 3 | D ...
0
votes
0answers
12 views

LibreOffice Impress Transition Error

currently I am creating a presentation with LibreOffice Impress and I have a problem with the given transitions between the slides. In edit-mode everything looks fine but some transitions seem to be ...
3
votes
1answer
19 views

Libreoffice Writer: how to enter data in a protected Word .doc form

I have a Word .doc file with form fields in it that I want to fill out in LibreOffice Writer. The file is protected (in MS Word), so only the fields can have data entered into them. However, none of ...
4
votes
2answers
134 views

How does the group feature in LibreOffice Calc work?

LibreOffice Calc has as Group feature. The official help site just tells you where to find the button and what hotkey to use, but doesn't explain what grouping actually does: ...
0
votes
0answers
26 views

I have installed Croatian language pack in Linux Mint but I can not configure it in a LO spell checker

I have added my language in Settings --> Language. However, when I go in LibreOffice in Tools --> Options --> Language Settings --> WritingAid -- > Language I can not set Croatian. I don't see it in a ...
0
votes
1answer
21 views

Libre Office: See the dictionary words?

I'm interested in browsing and seeing the complete list of words that make up the dictionary that is used to spelling-check and other similar language tasks in Libre office 4.3.3.2 , the english USA ...
4
votes
1answer
60 views

How can I disable LibreOffice document recovery for files in my Dropbox directory?

I'm running LibreOffice 4.2.8.2, and I also use Dropbox. My problem is that I often modify my documents on different machines: one at work and one at home (both run Ubuntu 14.04). After modifying ...
0
votes
1answer
22 views

Using INDIRECT in cell validity

I have a spreadsheet contain 3 sheets. I want to set validity of column E of the first sheet based on text in the column D. The relation between these two columns are placed in the second sheet as ...
3
votes
0answers
31 views

Disabling spell checker in OpenOffice Calc (or LibreOfffice Calc)

Is there a way to disable the spell checker in OpenOffice Calc (or LibreOffice Calc) without disabling it for the other programs in the office suite? I would prefer to just disable it for a range of ...
0
votes
0answers
13 views

How can I nest logical functions on LibreOffice?

This is my test formula: AND($E2<=10;OR($C2>=90;$D2>=90)) but nothing changes on my document. Just the OR/AND formula behaves fine, like in: OR($C2>=90;$D2>=90) Is this the ...
1
vote
1answer
41 views

How to fix a corrupted LibreOffice spreadsheet

I have a substantial multi-sheet LibreOffice worksheet that seems to be throwing a lot of errors in LibreOffice, including crashes. Any idea of how to get it to work as expected? I'm thinking ...
1
vote
1answer
42 views

Assigning rank in OpenOffice (or LibreOffice)

In OpenOffice (or LibreOffice), is there a way to rank rows? For example, let's say you have a spreadsheet where cell A1=20, A2=30, and A3=10. I want to B1 to get a value of 2, B2 to get a value of ...
1
vote
0answers
14 views

Libre Office - merge sheets

In one file I have two sheets, which share some of the columns. I'd need to merge the sheets based on column name, if the column does not exist, add it. Ie. I have Sheet 1 ...
1
vote
1answer
18 views

LibreOffice Writer - how to include content of config files?

I'd like to insert some config files as sample in a document (in a TextBox if it is possible). Can I do it without breaking the lines which are longer than the TextBox with? I'd like to see a ...
1
vote
0answers
23 views

Change color for all set borders

Having a table with some complex borders. How can I change the border color for all borders in the table? Know I can change one by one, but that is a hassle. For example: +-----+--+ |1A 2A|3A| |1B ...
0
votes
0answers
29 views

Force LibreOffice to open a PDF in Draw?

I'm trying to edit this PDF with LibreOffice Draw. However, when I open it - I get LibreOffice Writer, with text consisting of the initial octets of the PDF file, i.e. %PDF-1.6 %���� 2 0 obj ...
0
votes
0answers
27 views

can I somehow save the specification of a chart as kind of template

I have a LibreOffice Calc spreadsheet with 12 sheets, each sheet is one month. In column A I have entries of Category "Date" and in column B I have entries of Category "Time". I then make a Chart ...
0
votes
2answers
52 views

LibreOffice Calc IF Function returns True when should return cell

I have been successfully using the IF function up until the last few days. I used this statement to return one of 2 values depending on whether or not an item is shaped: ...
1
vote
0answers
22 views

Convert text string to formula in LibreOffice Calc

I have a spreadsheet that generates formulae as text ex. =CONCATENATE("+B",ROW(),"*",ROUND(G5,2)) output: +B5*1464.41 I have a column of this type of text that I need to convert into ...
1
vote
0answers
70 views

OpenOffice / LibreOffice ugly font rendering

I'm using Calc to generate some graphs of data I have collected. But somehow the font looks increadibly ugly in all of LibreOffice. I'm using Noto Sans CJK JP Light in this chart but pretty much every ...
0
votes
0answers
51 views

LibreOffice won't change printer settings

So we recently installed LibreOffice on one of our PCs (recently upgraded to Windows 10), and every time we print, it will ignore the settings that we have changed. I.e. When we want to print a file, ...
0
votes
0answers
10 views

How can I setup Libreoffice draw so objects added from the gallery are smaller?

I use the VRT gallery to produce network diagrams with a page setup of 24x36 inch and I find it very annoying to have to resize EVERY single objects that I add from the gallery. All the VRT objects ...
1
vote
0answers
36 views

LibreOffice Calc changes letter from uppercase to lowercase under certain circumstances

I want to enter SXer into a field, however the X gets automatically converted to x. If I only write SX, the X stays the way it is. If I write SXEr, all letters stay as they are. But somehow I can't ...
0
votes
0answers
14 views

LibreOffice Draw (Mac): word wrap doesn't work right

I'm using LibreOffice Draw on OS X Mavericks, and I'm trying to use a polygon as a text box. Unfortunately, the "Word wrap text in shape" option is grayed out, and "Fit to frame" doesn't exactly ...
0
votes
0answers
18 views

Remove empty paragraphs but leave images

I have a document that has been formatted by using extra blank lines between paragraphs that I want to remove in favour of using paragraph styles. So I did a regex find for ^$ and replace with the ...
1
vote
0answers
32 views

LibreOffice Calc - Split one column into two

I'm moving user/customer details from my mother's old web store. Only problem is that exported .csv-file has name details in the same column like this: [ col A ] lastname, firstname ...
0
votes
0answers
32 views

Libre Office Calc Issue: Summarizing columns with too many rows

I'm writing a script that reads data taken from a database. THe data is modified (de-duplicated) and put into a .csv file I have a problem as I want to find the sum of a particular column in excel. ...
1
vote
1answer
23 views

Setting a tiled background to the page edge in Libreoffice

I am hoping to release a short ebook that I have written in Libreoffice. I have created an image that is the same width as an A4 page. Under Format > Page > Background and changing from "as ...
0
votes
0answers
77 views

LibreOffice Impress presentation should play video on click, complains about no browser?

I have a LibreOffice Impress presentation, and one of the slides contains an image with an action: upon being clicked, it is supposed to play a video. Note that the video is just an external, local ...
1
vote
1answer
41 views

Spreadsheet formula to display most recent prices

I have created a LibreOffice Calc spreadsheet with columns A-C. In column A, I have a list of parts purchased (in chronologically ascending order). In column B, I have a list of corresponding ...
2
votes
1answer
86 views

LibreOffice dictionary and spell checking in other languages? (without Java)

Using LibreOffice (latest version) on OS X, everything in English. However I frequently work with documents in other languages (e.g. German, Dutch, French) and I would like to have spell checking for ...