2022 Developer Survey is open! Take survey.

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.

Filter by
Sorted by
Tagged with
0 votes
2 answers
27 views

Excel - Sum row conditionally based on employee name

I need to create a sheet that will allow me to summarise the total cost per employee depending on their name. So, in the following sample, I would want to have a column which summarises the costs for &...
user avatar
0 votes
0 answers
15 views

How do I use a `TRUNC` function in a LibreOffice Basic script?

I have to write my own custom function that converts number of days since Jan 1, 1900 to a date. I am recreating some legacy code that does this but uses 32 days a month, 384 days a year (I am not ...
user avatar
  • 170
0 votes
2 answers
22 views

How to save same ODT file with different styles in libre office writer

I have this odt document. I need to save it with two different styles. One for reading (which includes sans font, bigger size ..) and one for printing(with smaller serif font). I created two templates ...
user avatar
  • 5
0 votes
0 answers
24 views

Headless Libre: Specify Sheets that should be converted into single PDF

Per this method I am able to convert .xlsx to a PDF using the following command on the command line: (linux system) /usr/bin/libreoffice \ --headless \ --convert-to pdf:calc_pdf_Export \ --...
user avatar
  • 101
0 votes
1 answer
15 views

How do I print a large page across multiple pages in LibreOffice Draw?

I've got a sign with text that needs to be 12 inches square. When I go to print it and select "Distribute on multiple sheets" in the LibreOffice Draw tab of the print dialog it is resizing ...
user avatar
  • 4,551
0 votes
1 answer
20 views

How to select text vertically in LibreOffice Writer

In word processors like MS Word, one can select text vertically and horizontally using the pointer. For example, on macOS one would hold down the <OPTION> key, and then <CLICK> to start a ...
user avatar
  • 413
0 votes
0 answers
16 views

How to call from OO Basic the print menu (with preview) in LibreOffice with preset values?

We have an example code like this: Sub TPrint(Optional PrintedDoc as Object) ' For testing on already open document: If IsMissing(PrintedDoc) Then PrintedDoc=ThisComponent DocFrame=PrintedDoc....
user avatar
  • 11
0 votes
0 answers
17 views

What's (if any) the formula to get multiple matching values in LibreOffice Calc? [duplicate]

Suppose I have the following data: A B 1 idx1 VAL1 2 idx2 VAL2 3 idx3 VAL3 4 idx4 VAL1 5 idx5 VAL4 6 idx6 VAL1 7 idx7 VAL1 8 idx8 VAL2 9 idx9 VAL5 10 idx10 VAL3 Is there a LibreOffice Calc ...
user avatar
  • 167
2 votes
1 answer
26 views

How to return in a cell all the matching values present in a column?

Suppose I have the following data: A B 1 idx1 VAL1 2 idx2 VAL2 3 idx3 VAL3 4 idx4 VAL1 5 idx5 VAL4 6 idx6 VAL1 7 idx7 VAL1 8 idx8 VAL2 9 idx9 VAL5 10 idx10 VAL3 For each "VAL[n]" ...
user avatar
  • 167
0 votes
0 answers
5 views

Remove section from Navigator, not from document

In LibreOffice Writer sometimes (the circumstances required for it to happen have long been elusive to me) the paragraphs I write (or paste) get added to the document outline displayed in Navigator. ...
user avatar
  • 111
2 votes
1 answer
45 views

How to populate a cell with a comma separated list version of a list-like text?

Suppose I have the following data in a cell (note: list-like text with minus signs and line breaks): - val1 - val2 - val3 How can I populate another cell with a comma separated list version of the ...
user avatar
  • 167
26 votes
2 answers
5k views

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" (...
user avatar
  • 413
0 votes
1 answer
33 views

LibreOffice Calc: How to make AutoFilter changes permanent?

When I apply an AutoFilter to my LibreOffice Calc spreadsheet, it's natural to have some rows removed, like in this screenshot. However, it's been clunky dealing with it, and I don't like this ...
user avatar
2 votes
2 answers
47 views

How to return multiple match results and output them to a cell as concatenated text?

Suppose I have the following data: A B C D 1 val1 Str1 2 ValM Str2 3 val2 Str3 4 ValM Str4 5 ValM Str5 6 val3 Str6 7 ValM Str7 8 val4 Str8 9 val5 Str9 10 ValM Str10 I would like to: find ...
user avatar
  • 167
1 vote
1 answer
17 views

Remove extra spacing around formulas

When I make formulas (ctrl + alt + =) in LibreOffice Writer, they have a bit of extra space on either side. How do I remove this?
user avatar
  • 206
0 votes
0 answers
22 views

concatenate text to create math that can be calculated

I'm not sure if the title is descriptive enough! I've used the CONCATENATE formula to create the following: =$'2022'.a17 It goes like this: =CONCAT("=$'";TEXT(A20;"YYMM");"'....
user avatar
0 votes
1 answer
30 views

Why does nerd-dictation not work in LibreOffice Writer with Ubuntu 21.10?

When I upgrade to Ubuntu 21.10 suddenly nerd-dictation stops working for some windows, particularly LibreOffice Writer. Why is this?
user avatar
1 vote
0 answers
66 views

Why is LibreOffice not detecting the theme?

https://draculatheme.com/libreoffice I followed the instructions and put dracula.soc in C:\Program Files\LibreOffice\share\palette. Closed and restarted LibreOffice Writer. Went into all the options. ...
user avatar
0 votes
2 answers
56 views

Equations in LibreOffice Writer?

I want to use LibreOffice Writer to insert equations (phonological rules) of the following kind: Here is someone's tutorial on doing this in Microsoft Word. I've seen tutorials for including Latex in ...
user avatar
  • 3
0 votes
1 answer
29 views

How can I enable/restore left sidebar for setting margin in LibreOffice Writer?

I still have top sidebar that allows to easily change margins. But something happened with left one. How can I restore it? I tried deleting settings, it have not helped. LibreOffice 7.2.5.2 on Lubuntu ...
user avatar
0 votes
0 answers
24 views

List objects in libreoffice which are separated by text

I want to number the figures I use in the text. For example: Some text (here a drawing) "Figure 1" More text (here another drawing) "Figure 2" More text (here another drawing) &...
user avatar
0 votes
2 answers
68 views

How to get the type of a cell in Libreoffice Calc?

I would like to know if a cell is a date, a number, a string or what. It would help a lot, exactly what/how should be done with it. I think, librecalc knows it, because it affects the behavior of the ...
user avatar
  • 2,362
0 votes
1 answer
139 views

How to transpose and skip cells?

thanks for being so helpful. I have columns where every 6th column had an alphabet letter: a b c d e f, so that column 1 has letter a, column 7 has letter b. I want to transpose that into rows of a b ...
user avatar
0 votes
1 answer
266 views

How to generate a column of unique IDs (UUIDs) in LibreOffice Calc?

How to insert a column of unique codes (UUIDs) in LibreOffice? If that's not possible with LibreOffice itself, how could one generate UUIDs in a way so that they can be simply copy and pasted into a ...
user avatar
0 votes
2 answers
61 views

How to paste numbers with a different separator in LibreOffice Calc

I tried selecting the cells and setting their format as “Text, English (USA),” and set the language in the status bar to “English (USA)” as well, but when I paste data from this page, e.g. Food kcal ...
user avatar
0 votes
0 answers
58 views

Can I attach (embed) a file to a pdf using LibreOffice/OpenOffice such that it appears in the "Attachments" tab in Acrobat Reader?

With Adobe Acrobat Pro DC, which is paid software, one can attach files to a pdf, and they nicely display in the Attachments tab of the Reader when the pdf is opened: link to image. Is it possible to ...
user avatar
0 votes
1 answer
143 views

PNG image is blurry

The following is the sreenshot from a test document with a png image inserted into it: And here is the same image opened in the Windows Photo Viewer (the default program to view images on Windows 7): ...
user avatar
  • 823
1 vote
0 answers
26 views

Update styles automatically

When you open a document that is based on the template that has been changed since the last time you edited the document, there will be a warning message: Is there a way to avoid this window and ...
user avatar
  • 823
3 votes
1 answer
323 views

Include an "at" symbol ("@") in a text cell

I'm organizing some stuff in a spreadsheet. None of it should be interpreted as anything other than than text, but it does contain a lot of non-alphanumeric characters. If I include the character @ in ...
user avatar
4 votes
1 answer
562 views

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 ...
user avatar
  • 823
0 votes
1 answer
51 views

Disable line correction in LibraOffice Draw's FreeForm line

I am using LibreOffice Draw's FreeForm line in order to achieve pencil-like drawing abilities in LibreOffice draw. I tried it and the main problem with it is that it doesn't draw exactly what I draw ...
user avatar
  • 101
0 votes
1 answer
62 views

Sort LibreOffice Calc rows through all columns

I have a list of items with set of properties. Some of the properties are unique, some are the same. I want to sort the properties through all items to see which items have equal properties. Maybe it'...
user avatar
  • 1
0 votes
2 answers
236 views

How to solve freezing of LibreOffice 7 on Mac OS X Sierra issue?

Using LibreOffice 7 (Calc) on Mac OS X High Sierra. It constantly freezes (turning colored wheel) so I have to force quit it. How should I proceed to find the cause? Is there a log somewhere that I ...
user avatar
  • 954
0 votes
1 answer
23 views

List item with Multiple paragraphs and sublists in LibreOffice writer

Posted as Q&A after I found a solution. I sometimes need complex lists, where e.g. a list contains hierarchical sub-items, and mixed with regular paragraphs. Using Shift+Enter provides only an ...
user avatar
  • 1,740
-1 votes
1 answer
57 views

How can I type in uppercase only in LibreOffice?

I know that I can use Format -> Text -> Case in LibreOffice to change text to uppercase when it is selected afterwards, but I would like to type directly in uppercase all the time, without ...
user avatar
  • 1,249
0 votes
1 answer
23 views

LibreOffice Calc - do not apostrophe-escape dates when opening a file

I have switched system, and the old system had locale en_DK with reasonable ISO formats, the new one currently has en_US with "imperial" stuff, bad date formats etc. While I try to figure ...
user avatar
  • 111
0 votes
0 answers
50 views

How to make LibreOffice Calc correctly interpret the desired number format for Time

I am appending to a CSV file programmatically with Python, which currently contain timings in the format: 0:1:10 (e.g. representing 0 hour, 1 minute, 10 seconds). When I open the CSV file in ...
user avatar
  • 1,327
0 votes
0 answers
7 views

Libreoffice: Use autocorrect in "Language=None" environments?

In order to be able to paste mathematics to Emails or Jira, I am trying to write approximations of the expressions in LibreOffice writer with inline text formatting, since equations are not pastable. ...
user avatar
  • 1,740
0 votes
0 answers
20 views

Retrieve missing ODF file

I am using Ubuntu 20.04. I was searching for an ODT file I have created recently. Sadly I couldn't find it in the folder where I thought I had saved it, neither anywhere else or in the trash bin. It ...
user avatar
0 votes
0 answers
28 views

Libre Calc - color code a number of columns based on one column

I have a number of columns of data (one for each month) that I would like to color code based on the average value for all months. So each row in each column should be compared to the row in the '...
user avatar
0 votes
1 answer
87 views

Why LanguageTool is not working on LibreOffice?

I am using LibreOffice 7.2.2.2. I have installed LanguageTool 5.4, then 5.5.1, but none of them are working. They only add buttons to the toolbar, though they do not react. What would you suggest?
user avatar
0 votes
0 answers
44 views

LibreOffice Writer "toggle character style" command?

Summary Does LibreOffice have a function to toggle character styles, switching back between a character style and a default style? I want to have a way to toggle inline code formatting ON/OFF via a ...
user avatar
  • 1,740
2 votes
1 answer
83 views

How do I return a column value based on whether another column is within an array range - Libreoffice Calc

If I have a comparison array like so on sheet "A"... Size Min Max SM 0 99 MD 100 199 LG 200 999 ...and on sheet "B" I Have... Val Size 50 ?? 250 ?? 150 ?? ... ... How ...
user avatar
  • 267
1 vote
1 answer
36 views

LibreOffice Writer: How can portion numbers be automated?

So that when the page is duplicated, the following page will display the next numbers and so on?
user avatar
  • 13
1 vote
1 answer
151 views

Address labels with LibreOffice

A few times a year, I have to print mailing labels from an Excel spreadsheet. I use Ubuntu, so I have LibreOffice instead of Microsoft Office. Unfortunately, it's a little tricky to get mailing labels ...
user avatar
0 votes
1 answer
59 views

Prevent Writer from splitting line in a footnote

Create a new document, type "see the footnote", insert a footnote, and in the footnote text type the following: This is a footnote . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ...
user avatar
  • 823
0 votes
1 answer
67 views

How to move values in a list with common fileds

I want to convert: From a list of columns that has a common label, to a row where labels are not repeated and all the values are listed under them. Is there a way to do it ?
user avatar
1 vote
1 answer
160 views

How to highlight the min and max value in a row wise manner?

In LibreOffice Calc (6.0) I try to highlight the minimum and maximum of each row in group of column (col A to E)? Any idea how to solve this?
user avatar
0 votes
1 answer
51 views

How can I increase letters gap?

How can I increase the gap between two letters in the same word in libreoffice writer (version 7.2 and above)? For instance, the word "word" would have each letters more spaced between each ...
user avatar
  • 1,033
1 vote
1 answer
34 views

Why "Enable word completion" and "Collect words" settings are separated?

What is the purpose to have Enable word completion and Collect words settings separated? (Tools > AutoCorrect > AutoCorrect Options > Word Completion.) Both settings are global are stored ...
user avatar
  • 823

1
2 3 4 5
16