Super User Stack Exchange
Super User Stack Exchange

Questions tagged [libreoffice]

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.

LibreOffice Logo

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.

LibreOffice was forked from due to developer dissatisfaction with Oracle's management of that project, and many Linux distributions have switched their default to LibreOffice.

LibreOffice competes with , OpenOffice, and others.

892 questions
35
votes
1 answer

How to disable automatic capitalization in LibreOffice Calc?

LibreOffice Calc Version 5.2.7.2. I have everything I can find under Tools -> AutoCorrect turned off. However, I still see capitalizations in certain cases. Is there anything more I need to turn off to completely disable it? It seems to be related…
AlphaCentauri
  • 737
27
votes
2 answers

How to disable the built-in advertising on LibreOffice 6.1+?

With version 6.1, LibreOffice now incorporates a distracting nag bar/infobar to interfere with the user interface while requesting that users "Get Involved" and "Donate" (presumably on the theory that people will donate, then keep donating each time…
Lexible
  • 472
19
votes
2 answers

LibreOffice: count distinct values from column

I have a column with some repeatable values, like color names in a list of a material objects. How could I count a number of each unique value occurrences (e.g. for the 100 rows given there are 5 red, 15 green and 80 black)? I cant use COUNTIF since…
AntonioK
  • 356
5
votes
4 answers

Can I split the editing window in Libreoffice Writer?

In MS-Word, you can split a window with a horizontal bar, so that you can look at, and edit, two places in the same file (sort of) simultaneously. I vaguely seem to recall LibreOffice should also have had this kind of feature, and yet I can't find…
einpoklum
  • 9,443
5
votes
1 answer

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 Windows? Edit: Additional information: I am on…
Roy Tang
  • 443
5
votes
3 answers

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 individual formulae. Right now, I copy the text to a new…
smilingfrog
  • 251
4
votes
1 answer

Is it possible to create a custom language for LibreOffice?

For a very specific reason, I want to have a custom language. For example, since my name here is JSV, this language should be called JSV. Is it possible at all? And how? I suppose that it will be easier to create it by altering one of the existing…
user90726
  • 873
3
votes
2 answers

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?
John
  • 2,137
3
votes
1 answer

Export LibreOffice Colour Scheme

I changed the colour scheme in LibreOffice (Tools → Options → Appearance) and defined my own colour scheme. I would like to know where (in which file or database) this new colour scheme was saved to reuse it on other computers or if there is a way…
Nicolas
  • 1,037
3
votes
0 answers

How to prepare organization chart in Libre Office?

It is very difficult to draw an organization chart in Libreoffice. Is there a function similar to Microsoft word or excel?
Muneer
  • 39
2
votes
2 answers

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 I want to edit the template. When mouse hovers…
David
  • 21
2
votes
0 answers

Libreoffice convert-to set outfile name

I'm trying to convert a file with libreoffice, but I know I can use the -outdir but that puts in a directory, is there any way to have it actually output the filename as I suggest? Currently I'm using this command libreoffice --convert-to pdf…
nadermx
  • 745
  • 1
  • 13
  • 36
2
votes
1 answer

How to hide the menubar in LibreOffice with the standard toolbar UI?

Posted in order to provide the answer. Can the menus (titles of menus with options) be hidden behind one single button? I see that at least in some of the "User interfaces" (a newer feature that can be enabled as "experimental" under…
user162573
2
votes
1 answer

I want to feature faded images behind the text on some pages in LibreOffice

Can anyone tell me please how to simply insert one specific image behind the text etc on single page in LibreOffice 5.0.4/2? I've tried various configurations and looked at many forums, but I keep getting the image either on all pages or on…
regan
  • 21
2
votes
1 answer

Subheading at start of paragraph in LibreOffice

I'm currently writing my master thesis in LibreOfficeWriter, and the formatting is specified by the American Psychology Association. Basically, there are different levels of headings, where level three is indented, bold, upper and lower case and…
julmoser
  • 23
1
2 3 4 5