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
1answer
15 views

Fill right in open/libreoffice

I'm using Libreoffice calc for an application where it's necessary form me to fill right. I know that fill down is Ctrl d but is there a way to fill across to the right? Thanks in advance
3
votes
1answer
19 views

conditional formatting doesn't affect all desired cells

I am using LibreOffice Calc on Linux. In my budget spreadsheet I have set up conditional formatting to color the font of a row that matches the condition, as follows: formula: column (E2:E200)="x", ...
1
vote
1answer
45 views

On Windows, can I prevent LibreOffice from prompting for document recovery when it launches or I open a file?

I basically never want to use the feature. How to? There's another question here that answers how to disable it in Linux via a command-line option in .bashrc, but I don't think that can be done in ...
3
votes
1answer
70 views

How does one use LibreOffice FILTERXML function on XML documents with namespaces?

I'm struggling to get the value of an XML node using the FilterXML() function when the XML document's document element has a namespace specified. Example: <?xml version="1.0" encoding="UTF-8"?&...
3
votes
2answers
63 views

Are the Liberation fonts 100% compatible with Microsoft Office?

In LibreOffice in Linux, I can create a text document (.doc or .docx) which contains only Liberation fonts. If I send this document to someone who opens it in Microsoft Word in Windows, and they don'...
0
votes
0answers
30 views

Touchscreen clicks not advancing slides in libreoffice

I'm using an Xubuntu touchscreen box to run an interactive LibreOffice Impress presentation. I want the user to be able to click on the slide, and hyperlinks in the slide to be able to advance to more ...
1
vote
1answer
17 views

Decimal chapter numbering in Libreoffice

I am trying to number my chapters in Libreoffice decimally. The best way to illustrate what I mean is by an example: 1 Chapter One 1.1 Chapter One Sub One 1.2 Chapter One Sub Two 1.2.1 Chapter One ...
1
vote
1answer
41 views

Generating unique number in LibreOffice Calc

So I have a document that allows a user to select a site/department from a dropdown list. Each site/Department has a unique extension prefix e.g. 10, 11, 12, 13, etc. When a user selects the desired ...
0
votes
1answer
23 views

How to switch quickly between corrector languages in LibreOffice?

If a document has already multiple languages setting, these might appear in the taskbar language selection list or the right-click menu 'Set language...'. But when that setting for multiple languages ...
0
votes
1answer
15 views

LibreOffice custom list of languages (for document, selection, paragraph)

(This was also posted on the ask.libreoffice site, which is not a stackexchange site, so don't hurry closing or down-voting for that reason. But if you do, for whatever reason, please mention that ...
1
vote
1answer
47 views

LibreOffice auto-correction: lowercase i is corrected to uppercase (I) in other languages

I have to cross-post here a question already posted on ask.libreoffice.org because I don't have an answer to a small but nasty problem (I'll delete one of these questions when I get a satisfying ...
3
votes
1answer
24 views

Advance to Non-sequential slide in LibreOffice Impress?

I am using LibreOffice Impress to play a video, and then when the video is done playing, go back to the "main menu" slide. I am using the "advance slide automatically after [duration of video]" option ...
0
votes
2answers
43 views

How do I change date origin in libreoffice writer?

I am copying a chart from a Calc file to a Writer file. The Calc file has a date origin of 1904. When I copy the chart to the writer file, all the dates get shifted because the origin is (I suppose) ...
1
vote
0answers
29 views

How to prevent the loss of Jumplist items when LibreOffice is upgraded?

Every time LibreOffice is upgraded, all the Jumplist items which were manually added for each application within the suite are deleted. The operating system is Windows 7 SP1. Is there a way to ...
0
votes
0answers
12 views

LibreOffice Math: How to control spacing between operators and terms in a polynomial?

If I enter a set of equations in MS Word using the Equations Editor, the space between operators and terms is even. However, when I input the same equations in LO Writer 5.0.4.2 using LO Math, the ...
3
votes
1answer
25 views

Add glue points to table in Libreoffice Draw

Is there a way to add glue points to table in Libreoffice Draw ? There are 4 standard glue points but I cannot add extra ones. By table I mean the object that you obtain by clicking Insert->Table.
3
votes
1answer
98 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
21 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
57 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 ...
0
votes
0answers
43 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
21 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
37 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 ...
4
votes
2answers
71 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
156 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 documentation?...
3
votes
2answers
710 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 ...
4
votes
2answers
32 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
43 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
18 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
41 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
30 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
187 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
42 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
109 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
38 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
31 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
372 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: https://help.libreoffice....
0
votes
0answers
48 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
39 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
113 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
61 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
58 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
19 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
136 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
166 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
44 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
19 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
56 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
42 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
31 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 ...