This is the guide - How to use the Ask site?

This is intended to help you use this website.
There will be additions to this website as we go along.
Bring a positive spirit to your posts, and thank you.

Attention, this is not a real question, but a description of how to use this Ask site.

Introduction / Basics

The community welcomes you.

Before you ask your first question, please read the FAQ.

Purpose of this site

The site serves as a platform for sharing questions and answers.

It allows LibreOffice community members to come together to ask and answer questions about LibreOffice TDF and related topics.

This description is intended to be maintained and improved by the community.

So if you want to improve something, edit the text.

If you want to ask questions or write answers go to the home page with category

Are there any answers to my question yet?

Please search the website before asking a question.

To do so, please use the search box.

Click on the search icon ( loupe).
EN Loupe Icon
There you enter a search term, e.g. “Calc”.

You will be presented with a drop-down list where you can search for and select similar questions.

If there is nothing for you, ask a new question.

1 Like
Ask/Getting Started from old to new?
After upgrade from 7.0 to 7.1 LO will not open
Where is the help on using Discourse, that is easily discoverable by users?
Personal messages
Error in exporting to PDF
New version Will not open
With LibreWriter 7,3 I click on remote files but after filling in the questions, I get a notice that it is not working
Would be useful to be able to Pin items to LibreOffice window
AskLO usability: search criteria
How to make elements visible in PDF but invisible at printing?
Temporary change line colour in DRAW
Looping through nested list to populate sheet
In calc, when recording a macro, Macro dialog doesn't appear
Hyperlink: New Bookmarks not showing
"APSO - Alternative Script Organizer for Python" UI is broken
[suggestion] Display number of selected rows/columns regardless of the way they're selected
Design your own horizontal line paragraph style
Supress display during processing
Ensure Upper case, Lower case matching while using Switch ()
Report - Summarize a detail field created by query
Newbie trying to make a fillable form
Report - Summarize a detail field created by query
Fehlermeldung bei Installation des Sprachpakets „Deutsch“
Pages don't end aligned, why?
Conditional formatting: match data validity errors
DBF file not open
How can I use Replace All to change the font size of a selected term in a document?
How to delete a reference used in table?
Base Form: How to make one input field mandatory if the value entered in another field is less than zero
Install Error - Warning 1946 - Can I fix this manually?
Broken Dropdown menu
Conditions could have an explanation comment attached
Failure of average function to calculate correctly
Needed: Impress in Normal and/or Slide Sorter view: Display synchronously at least 2 slides side by side at detailed resolution
Photos appearing in Draw
Change default print setting from "Automatic" to "Portrait"
Have Calc list the option to Save As Tab Separated Values?
EarnestAl, trying to reply but the forum isn't letting me comment any more
Download page giving wrong impression to users
Get hyperlinks inside OLE spreadsheet to work
Heading 1 numbering restarts from 1 in the middle of document after having incremented to 3
How can I use Replace All to change the font size of a selected term in a document?
Small template inside of sheet
LO Writer misses to paste "merge formatting" like MS Word (Deutsch: Einfügen Format zusammenführen
Paste Special of Fontwork Objects with Macros
End note will not open when I click on the number in the body of the text
LibreOffice is in read mode; how to get to edit mode
Issue with column width arrows of table properties dialogue
All my docs open minimized
Writer freezes :
How do I sort lines alphabetically?
Bullets Default color is always white
Adding right click options in context menus
Impress text box not showing in Powerpoint
Cannot set background color in libre calc
Ask/Getting Started from old to new?
Ask/Getting Started from old to new?
Numbered list with variable lettered sublists in writer
[FEATURE REQUEST] LibreOffice Writer - Review > Combine multiple documents with comments funtion (MS Word similar)
Ask/Getting Started from old to new?
Questions about poor sorting
Ask/Getting Started from old to new?
Ask/Getting Started from old to new?
Image in docx with wrap set to "behind text" works fine in microsoft but broken in libre
Lightproof not installed with
Main menu overlapping top menu bar, how to hide or fix?
Copy paste heading 3 and table , pastes to new page
Ask/Getting Started from old to new?

Ask a question

To do this, click on “+ New topic” in the top bar.

EN Button New Topic

The “Create a new topic” dialog appears.

In the “Type title, or paste a link here” line, enter as short a title as possible for the question.

In any case, avoid entering the entire content of your question in the “Title” line.

If you create your question in the “English” category, “English” will appear automatically.

To the right of “Select at least 1 item”, you can select one or more keywords, e.g. “Writer”, “Calc”, “Date format”, “Crash”, etc. This will make the search easier later.

In the question description, you can and should provide detailed information about your question.

Your details should also reflect what you are trying to accomplish.

Within the question opened for editing you can work with the following modifications:

EN Question opened for editing - with description

You can help us understand you better.

Please do not use references or comparisons to other software packages.

Most of the responders do not know them, because they mostly work with LibreOffice for many years.

Also, please do not use acronyms that are not commonly known.

Avoid writing entire sentences in capital letters, this is generally interpreted as shouting.

If you want to provide additional information, please prefer to append an Example-document but not taking Screenshots.

Thank you for your consideration.

More details

Please be sure to specify your operating system, LibreOffice version (at least 3 digits with dots, e.g. 7.1.3) and the file formats used.

If LibreOffice can still be started, you can enter the following information (here only as an example):

202108_EN Version Informations

by copying Help>About LibreOffice from the menu.

In the following dialog click on the button next to “Version information”.

Your information will be saved to the clipboard of your computer system and you can use it to complete your description for the question.

Depending on the question, further information may be required: other file formats, printer and type, interfaces, network connections, etc.

Bar below a question

The bar offers you the options described in the images.

202108_0101EN Bar below a question

If you click on “Show more”, you will have more options.

Feature requests

Feature requests should go directly to Bugzilla as Enhancements.


Bugs should be submitted directly to Bugzilla.

What is a bug?

  • Program crashes
  • Loss of function of a previous version of LibreOffice.
  • Performance problems (slow loading / processing; jitter; operations that take longer than in a previous version of LibreOffice).
  • During submission, the keyword “perf” should be added.
  • Unexpected behavior (note: this can be subjective)

Private information

How do I add to my question?

As a questioner, you edit the original question to add and clarify something.

To do this, click the pencil icon just below your question.
EN Pencil Icon
Alternatively, you can also write a comment.

Within the question opened for editing you can work with the following modifications:

EN Question opened for editing - with description

Write an answer

Write an answer to the question in such a way that it is also generally understandable.

An answer should always contain a solution or at least a workaround.

For other things, such as questions or additional information, please use the comment function.

How do I mark an answer as solved?

Below each answer you will find a bar with different icons.

202108_0101EN Bar below an answer

Click on the small square with the check mark, to the left of the “Solution” letter.

After that, the icon will be displayed in green.

202108_02EN Bar below an answer

How can I vote on answers?

Click on the arrow pointing up to vote on answers.

202108_01DE Stimme für Antwort

Only one vote is allowed per answer and user.
Answers that have been voted on are marked with the corresponding number of votes.

202108_02DE Stimme für Antwort

The top bar

In the top bar on the left is the LibreOffice logo.

If you click on it, you will see a page with all categories in a summarized overview.

With the Search icon you initiate the search.
EN Loupe Icon
When entering words (tags), you will be offered suggestions.
Select the most suitable one for you.

Next to it is the icon “Switch to another topic list or category”.
202108_EN Hamburger menu Icon

The top table header of the page

In the top table header you can see the category, e.g. “English”.

If you click on it you can select another category.

The selection of keywords follows.

Click on the small arrow.

In the Drop-down list you can search for a keyword or select a keyword.

In the next selection field you can choose the questions to be displayed according to the category “all”, “solved” or “unsolved”.

EN Drop-down Category all solved unsolved

In the next field you can switch between “Latest” and “Top”.
EN Latest or Top
On the right side you can click on “+ New topic” to ask a new question.

On the far right is the bell icon.
EN Bells icon

Click on it to set the watch mode and read what it means.

There you can choose between “Watching”, “Tracking”, “Watch first post”, “Normal” and “Muted”.

EN Watching

Default Text Box File Save
How to convert png files to text pages for a Writer doc?
SWITCH function shortcuts to #N/A
New extensions list
External data corrupted and refresh issue
LibreOffice Base Autofilling Junction Table
Can't delete input fields in writer - they are like zombie vampires
Line numbering in part of a document only
LibreOffice v7.2.5.2 crashes when i open a .CSV file
Impress hyperlink to an executable with its commandline argument
Delete versus cut graphics action
Divide number in %'s
Libreoffice usage Error in Manjaro Linux
MS Office RGB colors to LibreOffice CMYK colors
LO files uploaded to OneDrive are corrupted from mac
Impress failed to play embedded video
Trying to place two maps in a heart shape in LibreDraw
Validating Credentials / Account Credentials dialog box pops up in Calc, never hapened before. Is a major pain in the butt
LO 7.1 High CPU spike in Print, Options, Paragraph dialog use (see images)
LO 7.1 High CPU spike in Print, Options, Paragraph dialog use (see images)
Adding custom page number format
Unable to change file permissions on my manuscript
The upper bound of the for loop
COUNTIFS with "<>" expression and empty value returns different result in Windows and Linux, how do I fix it?
After upgrade, a couple of things are broken
Maintaining Font in DOCX to PDF Command Line Conversion - Ubuntu Server 20.04
Possible bug in LibreOffice Base
LibreOffice Impress will not hold text box position and size
First three words are not a sentence
Phone cell format with or without "+"
Reordering Conditional Formats (Not Conditions)?
Changing Slide In LibreOffice Impress
DRAW: Sticking drawing points
Old split hsqldb won't connect in new Linux Mint 20.2 and LO
Cannot save Draw file
Calc - Lock cell content before formatting to text, how?
Connector lines not straight
How do I submit suggestions in improving LO Writer?
How to sign macros in "My Macros"
Formula bar issue
File extensions
Any hope LO will actually run on High Sierra?
Protocol for creating a spreadsheet with compatible formatting for Excel?
LibreCalc: change default date format: feature request
Hyperlink: New Bookmarks not showing
Failure of average function to calculate correctly
Can I save print properties with a document?
Printing problem
Cannot turn AutoRecovery off
Libre calc calculations
"Version incompatibility" "incorrect file version" when opening pdf
Double-click doesn't select the space after a word. Can I change it?
How do I insert and display a pdf into a Calc spreadsheet?
EarnestAl, trying to reply but the forum isn't letting me comment any more
Change the size of multiple shapes at once?
Is LibreOffice an online application?
ReDim on custom type containing dynamic array
Feature Request: Save the last configuration of the "Send Email Messages" Mail Merge dialog
Random Cell backgroud color after conversion from Lotus123
MacOS-wide keyboard behavior on accents ignored/suppressed
Heading 1 numbering restarts from 1 in the middle of document after having incremented to 3
Impress Presentation Times-Out During RDP
Sheet name having a Ø ø symbol won't show
Justified text and forced line breaks in docx document
How to search for subscript
Image placement and display discripancies when MS Word document with image viewed/exported to PDF using LibreOffice
Docx writer document table content background coloer
How do I upload a sample file
Fourier transform - transform data to DFT and reconstruct it with IDFT in Libre Calc
LO Writer misses to paste "merge formatting" like MS Word (Deutsch: Einfügen Format zusammenführen
It is different at the binary level
Libreoffice update always wipes out my default settings
Localized shortcuts? (Why do I have to use strg+shift+f for bold?)
All my docs open minimized
Crashing upon Specific Task
Can not start Libre after installing 7.4 upgrade
How do I sort lines alphabetically?
LO not saving documents completely
Bullets Default color is always white
The automatic download of the update is currently not available
No autosave by default; are you guys high?
Calc Special paste process works as slowly on column with vlookup formulas
Impress text box not showing in Powerpoint
Cannot set background color in libre calc
Insert file into LO writer doc
Heading and body text styles getting switched around
Special characters are missing
Avoiding updates for help in non-wanted languages
LibreOffice (x64) "not responding" in Windows 10
Print Ranges fail to Save
How to define print area in calc LO
Need help turning off autocorrect in LibreOffice Calc
How to determine and use Process IDs of the different LibreOffice programs?
Main menu overlapping top menu bar, how to hide or fix?
How to create and Save Customized Bulleted List?
Libreoffice 7.2.2 crashing during start
One more conditional formatting issue
Installing in AWS EC2
Installing in AWS EC2

Discourse understands multiple ways of formatting (Markdown, BBCode and HTML), of which Markdown is the most convenient. See this Markdown Reference and tutorial and a Cheat Sheet and there also basic and extended syntax. And of course the original Markdown Syntax by one of its creators John Gruber.

A common task when formulating questions or answers is to create tables, for which specific help and an online table generator exist. The best method is though, that you can just copy-paste a cell range of a Calc spreadsheet that is automatically converted to markup, using the first row as column headers, like

Name Number
foo 1
bar 2
baz 3

When pasting code or spreadsheet formula expressions please format it as code to prevent misrepresentation of inline text formatting characters like the * asterisk (for italics or bold) and replacements of " quote characters with typographic quotes like “here”.

Code block formatting can be done with three backticks on their own line before and after the code block:


Usually a simple ``` without any trailing text (not even blanks) on its own line does some nicely automatically coloured formatting. One can force a language syntax like






but apparently not for Basic. Function blocks in a Basic code block containing the keywords EndIf or Wend somehow lead to an ugly all red formatting, so if possible avoid them and use End If instead, or Do...Loop which is cleaner than While...Wend anyway (see While...Wend Statement). Also reportedly with Dim var as Variant the (unnecessary) as Variant can lead to an overall-red formatting. Using


though forces a code block to monochrome to workaround.

To get correct coloring of Basic code with a plain


apparently the forum engine wants to see at least one comment starting with an ' apostrophe.