Tagged Questions

LibreOffice is a cross-platform office suite that originated as a fork of OpenOffice.

learn more… | top users | synonyms

0
votes
0answers
15 views

Making all LibreOffice shortcuts same as MSWord

Is there any way to change all of LibreOffice's shortcuts so that they mirror those of MSWord without having to go through them and change their values one by one?
1
vote
3answers
34 views

Search for variable in OpenOffice/LibreOffice

I am using OpenOffice.org Writer to write a book. I foresee the possibility of some characters' names changing, so I am using variables where their names go "Insert > Fields > Other". However, I ...
1
vote
1answer
180 views

Converting documents to text with UTF-8 encoding

unoconv uses LibreOffice to convert any file that LibreOffice can convert. Now I need export to text with the UTF-8 character encoding. I use the following command: unoconv -f txt -e ...
1
vote
0answers
40 views

How to paste an HTML table into Libre Office Calc without losing structure

I want to paste an HTML table into Libre Office Calc. The HTML table rows contain images (in column 1) that should stay with their appropriate row. However, when I paste my HTML into Calc, the images ...
1
vote
1answer
844 views

Headless use of open office or libreoffice in Ubuntu 14.04

I want to install openoffice headless in Ubuntu 14.10, but when I try to install it, it says there is no package for that name. I installed libreoffice-common using apt-get, but I can't find ...
0
votes
0answers
42 views

Cube not working in Fedora 20 KDE

When I switch desktops on my Fedora 20 system, with the "desktop cube" it doesn't work. Instead of showing the cube effect, it displays briefly LibreOffice with an open document which I closed 10 ...
2
votes
1answer
51 views

LibreOffice Writer Go to page

Is there a go to page feature in LibreOffice writer so one can type a page number to go to that page? There similar feature in MS Word.
2
votes
2answers
86 views

Converting .odm to .odt

How can I convert LibreOffice Master Document which consists of several .odt files into a single .odt file‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌?
2
votes
1answer
47 views

Document save instead of autorecovery save

In a LibreOffice Writer document, I want to disable autorecovery save but I want automatic save be enabled. Is there any way to do this? Saving takes time for large documents. Saving both the ...
1
vote
0answers
20 views

Language change macro in LibreOffice Writer

As the cursor moves in a LibreOffice Writer document, the status below the window shows the language of the characters around the cursor (e.g. English(USA)). Is there a way to run a Macro (named e.g. ...
1
vote
1answer
83 views

Upload libreoffice impress presentation to youtube?

I am interested in creating a presentation in Libreoffice Impress, exporting in X format, and uploading it to Youtube with little hassle. How do I do this? What should X be? Have you done this ...
1
vote
1answer
317 views

Run terminal commands from within LibreOffice's Basic programming?

Is there a way to run system commands in LibreOffice Basic macros so that macros will be able to do things outside LibreOffice (e.g. changing keyboard layout)?
2
votes
1answer
46 views

LibreOffice Calc Didn't Read Data with a formula (Error?)

So I have a data like this : (First Number) (=RIGHT(A1, 3)) 19132 132 56112 112 So, the second column formula is =RIGHT(A1,3) and so on. When I created the graph, it's show zero data, there are no ...
0
votes
1answer
50 views

Accents not working on LibreOffice. How to report bug

When I try to write an accent (spanish in my case) in Libre Office, it just won't write it. I know everything else is fine since I can write accents on other programs (i.e my console). What is ...
1
vote
2answers
145 views

Can't start presentation on remote computer console session from an SSH session

Basically I am executing this script remotely via an SSH session. It works fine on Linux Mint, but not on Debian (7.5). It looks like the export display or nohup command isn't working, but I'm not ...
3
votes
0answers
50 views

Why does selecting text only “copy” it (as in copy and paste) circumstantially?

One of the most user-friendly features of Linux is that highlighting or selecting text will automatically copy it so that it can be pasted upon a middle- click. However, this can also be a point of ...
2
votes
1answer
68 views

How to convert .doc to ODF with a command line?

I'd like to convert many Microsoft Word documents to ODF (the OO.org formata with a command line (because there are many of them). (I need them for reading afterwards on a device where reading OO.org ...
1
vote
1answer
39 views

How to do arithmetic manipulations on entire rows in LibreOffice

I have a table of data which I want to do some arithmetic manipulations on. If I want to subtract say 11B from 3B I just do =$B3-$B11. But if I want to subtract each row 11 value from its ...
1
vote
2answers
53 views

Attaching different LibreOffice Writer documents

I have a lot of .odt documents. How can I attach them together without hurting their contents? Copy and paste in LibreOffice is not safe and may change the format. For example, the position of ...
1
vote
2answers
41 views

LibreOffice 4.2 PPA archive size?

Can anyone give me an idea of the total download size for LibreOffice 4.2 PPA? Am using Mint 14 Nadia (Ubuntu 12.10) Current LO version 3.6.2.2 from the repo, and I have a problem with this bug, ...
8
votes
5answers
707 views

saving in /tmp is not really saving?

Open e.g. a mail attachment from Firefox (without previously saving it); this is a Libre Office document, you edit it, and then push save (not save as) and close both text editor and browser. Then the ...
0
votes
0answers
79 views

Why are my system preferences not saved when changing file associations?

Every time I open a .csv file it tries to open in LibreOffice Calc which I don't want it to, so I changed the default program to Kate, and it updates the system preferences. But then the next time I ...
1
vote
2answers
55 views

if an exploit is affecting MS office does it affect also LibreOffice? [closed]

This question is really annoying me a lot and I want a reasonable, certain, logical... response for it
1
vote
2answers
337 views

Most lightweight distro that runs LibreOffice Writer

I've got an old PC with a 400 Mhz CPU and 256 Mb RAM. I just need to run LibreOffice Writer on it (or another word processor that opens .doc just as good, no Abiword). I'm looking for a light distro ...
0
votes
1answer
248 views

Spell check fails in LibreOffice Word 4.1.2.3 in Linux Mint 16 Petra

I am using LibreOffce 4.1.2.3 in Linux Mint 16 Petra. When I try to run a spell check, no checking occurs, and I immediately get this response: It seems to indicate my language and location aren't ...
1
vote
1answer
186 views

LibreOffice from RPM looks ugly

I'm using x86-64 Fedora 18 (my desktop is KDE), that ships with LibreOffice 3.6. I wanted to install LibreOffice 4.0, thus I installed the RPMs (from here). It works, but looks ugly. Compare: ...
7
votes
1answer
688 views

Open/Libre Office: Restricting Impress to PowerPoint-compatible content?

Is there a way to restrict the Open/Libre Office presentation-program Impress to just PowerPoint-compatible content? Preferably in a way that "shadows-out" or removes non-compatible animations and ...
3
votes
1answer
468 views

Libreoffice document recovery automatization

I am wondering if there is a way I can launch libreoffice so it does document recovery or exits. I want this so when my computer boots up and I log in I am immediately prompted with document recovery. ...
1
vote
1answer
452 views

How to show only the last two digits of a number in LibreOffice Calc?

I have a spreadsheet like this in LibreOffice Calc: 1 2 A 012345678 Henry B 012345679 George The first column displays some ID numbers. I need to display a shorter form of this ...
0
votes
0answers
424 views

Why is my interface font larger with LibreOffice than with other GTK applications?

I installed LibreOffice and the libreoffice-gtk package. The GUI has the same appearance as other GTK applications, however, the fonts in the interface appear to be 1.5 to 2 times larger than those in ...
3
votes
2answers
2k views

LibreOffice 4.0 looks ugly in KDE

I installed recent LibreOffice version (4.0) but it looks so ugly in my KDE on Linux Mint, as shown in the following picture... how can I fix this issue?
5
votes
1answer
156 views

Wrong emblem used for PDFs created by LibreOffice

If I create a test pdf file in a directory, by using something like ls -al > testpdf.pdf the file is shown in Caja 1.4.0 with an understandable emblem that is 'acrobat-like'. If I create a ...
5
votes
3answers
8k views

Linux PPTX presentation Viewer

Besides Open Office, is there any solution for opening .pptx presentations on Linux (Debian to be more precise)?
1
vote
0answers
351 views

Getting a digital signature from an eToken/smart card into LibreOffice

I successfully managed to make use of digital signatures in LibreOffice Writer by following flatmtn.com/creating-pkcs12-certificates But now I want to use a digital certificate from an eToken/smart ...
5
votes
0answers
1k views

How do I recover/use Powerpoint speaker notes after import to LibreOffice Impress? [closed]

I have several MS Office Powerpoints that I would like to view in LibreOffice Impress. The slides import without any problems, but the speaker notes appear to be missing. How do I recover/access the ...
4
votes
1answer
421 views

Libreoffice Writer, how to get read-only a document part

I am writing a document with Libreoffice Writer. I would like to set a part of it as read-only, while the rest of the document as non-read-only. Is it possible to do it? How?
2
votes
0answers
626 views

Viewing .doc and .docx documents with MathType equations on Linux

Is there a way to view .doc and .docx documents with embedded MathType equations on Linux? When I try to open them with LibreOffice, I get blank boxes where the math is supposed to be - the same ...
2
votes
2answers
944 views

How to install LibreOffice on Scientific Linux 6.1?

How can I install (from a repository?*) a fresh but still stable version of LibreOffice under Scientific Linux 6.1 64bit? * = this means I need updates too, so if there will be a newer stable version ...
1
vote
1answer
497 views

How do I get LibreOffice to run on Ubuntu 11.10?

Recently I upgraded to Ubuntu 11.10 and I have had three problems, screen flickering in some of my games, Banshee freezing, and LibreOffice which wont even load (I know it's a cheap shot to include so ...
17
votes
4answers
36k views

Convert a .xlsx (MS Excel) file to .csv on command line with semicolon separated fields

I realize that this is not an entirely unix/linux related question. But since this is something I'll do on linux, I hope someone has an answer. I have an online excel file (.xlsx) which gets updated ...
3
votes
3answers
816 views

Lightweight feature-rich alternatives to OpenOffice and LibreOffice

I really like LibreOffice however I'm having issues with it freezing up and I can't seem to start a new instance of the writer on multiple desktops (I'm using dwm and want several documents open). ...
2
votes
1answer
3k views

Is there an easy way to list the number of unique values in a column in LibreOffice calc?

In LibreOffice calc I have a column with thousands of values. Is there an easy way to list the number of UNIQUE values? e.g. a column which had red red red green green blue blue blue would ...
7
votes
1answer
1k views

Reduce the space around in-line formulas in LibreOffice

When inserting a formula into LibreOffice, there is a whole lot of padding between it and other words. How can I modify the formatting of formulas to make the padding much smaller? LibreOffice 3.3.1 ...
1
vote
1answer
4k views

How to calculate percentages in LibreOffice Calc?

I am currently calculating percentages in LibreOffice Calc using the function =PART/TOTAL where PART and TOTAL are cell coordinates of a same column. Dragging-down the formula won't do, because the ...
24
votes
1answer
19k views

How to maintain (top) row visible while scrolling?

I did it once, but cannot find out how any more: how to keep the top row of my LibreOffice Calc sheet visible when scrolling? (Intuitively it should be either in view or format, at best in ...
1
vote
1answer
4k views

How to count similar results in several columns in Libre Office Calc?

On LibreOffice Calc, I have seven columns filled with any one of the non-numerical values a, b or c. For each line, I want to count how many times the a value has been entered. How can I do that? I ...
1
vote
4answers
4k views

Libre Office change printer language type from PDF to Postscript

I have a problem printing from Libre Office (3.4.0 build 12). OS: Arch Linux, CUPS version 1.4.6 Printer: Description: Brother HL-2040 Location: Home Driver: Brother HL-2040 ...
3
votes
1answer
2k views

Are there any MathType clones for Open/Libre - Office?

Are there any OpenOffice.org/LibreOffice equation editor/makers, similar to MathType?
2
votes
1answer
323 views

How does one find and replace text in all open files with LibreOffice?

How does one find and replace text in all open files with LibreOffice?