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.

image also available here : Ask/Guide - How to use the Ask site - The Document Foundation Wiki


![20240624 EN Previous structure of the Page Ask-LibreOffice|416x500](upload://kx1tTyPo77wQc43VDhF15Q7RuzR.png)

Introduction / Basics

The community welcomes you.

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

Purpose of this site

This site is not a forum here, but a questions / answers site.
The site serves as a platform for sharing questions and answers.
Answers come in the vast majority of cases from users like you.

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

Comment fields should always be used to clarify communication. Answer fields are always reserved for solutions or for workarounds.

You will be notified when someone mentions your name preceded by @ or replies to your post.



Here with this guide (question) is explained how to use AskLibreOffice page.

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.

4 Likes
Ask/Getting Started from old to new?
After upgrade from 7.0 to 7.1 LO will not open
Error in exporting to PDF
Where is the help on using Discourse, that is easily discoverable by users?
Personal messages
New version Will not open
Format cell > borders
Application stopped and not loading at all
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
Ask/Getting Started from old to new?
Can I export my document in PDF/X or PDF/X-1a? And will it embed the fonts used in the doc?
Connector text box disappearing (becoming invisible)
Nicht registrierte standardmäßige Dateiformate (message)
AskLO usability: search criteria
Duplicate Objects in Exported PDFs
Windows 11 - File Explorer - Search Contents fails
LibreOffice Draw, save .otg with text boxes of the form
How to make elements visible in PDF but invisible at printing?
Temporary change line colour in DRAW
Text surrounded by lines?
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
How to convert ODG file to ODT using LibreOffice Draw
Supress display during processing
URL "target_blank" not working when exported to pdf
I have had a power surge and non of the documents I have on Libre will open. can you help
Writer - Forms - Can't open Control Properties
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“
Getting Layers to Work
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
How to change page numbering
Page Number offset not working
Libreoffice Base ID auto increment problem printing reports
Install Error 7.2.5.2 - Warning 1946 - Can I fix this manually?
Calc crashes since 7.5 update when using Wingdings font in date validity
Broken Dropdown menu
Printer stop error using Libre Draw
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
The words in libreoffice writer are hidden
Paste unformatted text - does not work
Photos appearing in Draw
Test data for calc
Change default print setting from "Automatic" to "Portrait"
Jump to a specific paragraph
Have Calc list the option to Save As Tab Separated Values?
Broken image form?
EarnestAl, trying to reply but the forum isn't letting me comment any more
How to implement a uno:GotoLine Dispatcher in a Grid on a Dialog
Move endnotes to the end of the article
How do I set a full page background in Writer?
Document saved as garbage
How to get Find to actually find what I type in and not a million variations that use those letters somehow? (Ver 7.4.1.2 on Win7 64bit)
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
2 databases lost all data
Libreoffice writer + impress + all the rest (can't update)
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
Writer is not displaying documents correctly (Linux)
Issue with column width arrows of table properties dialogue
All my docs open minimized
Writer freezes :
How to programmatically create a sheet-specific submenu in the Calc menubar
How Do I Add Insert Anchor To The Context Menu?
How do I sort lines alphabetically?
Bullets Default color is always white
Adding right click options in context menus
Copy Paste Special Links - a range?
7.4 Dark Mode is a disaster
Impress text box not showing in Powerpoint
Cannot set background color in libre calc
How do I remove the dark background from the menus?
Libre Base Error
New user - excel spreadsheet edits not being saved properly
?Switch Libre from Disk C to Disk D?
MALWAREBYTES report PUP in Libre files when trying to print
I cannot get a new impress document
Writer crashing frequently when I use the Find function
Column format display issue
Macro to copy data between MariaBD database tables
Some PDF files will not open in LO Draw
Cannot type in text
Need help with a checkbox setup or maybe other solution (Very New)
Highlighting lines of text automatically
Transparent png not exporting to PDF correctly in Draw
Correcting abnormal large text appearance and lack of word wrap
Calc border and inner line draw order TAGS: CALC
Lists (a, b, c, etc.) in a document have disappeared
Poor colour rendering
Bookmarks Feature
Read Error. Format error discovered in the file in sub-document content.xml at 2,321994355(row,col)
How to overtype using a different color font
Writer: new style from selection automatically created as conditional and can't be changed
Show columns on formatted writer page
How to get libreoffice to find Java JRE file?
Base will not process one table in MySQL DB
Calc Find and Replace [Fax:]
The forum's front page does not help one to see how one can post questions in English
Cropping a stacked area chart
Mime icon is missing as always after new installing
New formatting tools for files?
New LibreOffice download tool bar not working
How to post questions
Problem with paragraph alignment in Writer
White Border around document when exporting a Calc File to a JPEG or PDF
If you want people to use "Comment" for regular replies, why use the quote icon there?
[ feature request ] please improve the interface
Dragging .png files into Draw shapes
TOC (Index) has letters instead of page numbers
Paragraph skips page
Relocating and resizing images within a text document
Pad the data from other cells (used via formula) with leading zeroes
When using Record, Deleted text disappearing instead of Red-Lining, Please help!
Opening a new text document
How to change code LibreOffice impress and draw to achive translucent effect top layer text on vidoe object
Function OR "Conditional Formatting" to Change only the Fontcolor
How do I control the way navigator expands and collapses?
New, confused, user who broke the menu bar
Libre Office document window not seen
Why am i not able to Type Something in this Section? (Libre Office Writer)
Class内のObjectをDestructできない
LibreOffice Calc Inserts Dates Not in Range
Slow Clipboard Copy In Writer
Bugs in LibreOffice 7.6
Need help getting this basic macro working
Odt. file corrupted with message: SAXExeption: Word/document.xml line2
Upgrade request - sheet grouping
How find validity range on 1 sheet out of many
Can It Stop Checking for Smart Quotes?
Glue points toolbar not working
Custom gallery themes cannot be restored
Deleteing pages
Writing a book, page numbering
Inserting columns after doesn't preserve width of before columns
Uploads: Images vs example files / HowTo
Can't recover my .odt restored files
Change background colour of multiple slides in Impress
All URLs Not Being Displayed in Write
How to automatically select specific buyers and add only their purchases in calc
Can't copy-past formula in new calc installation
How do I edit the text in an L/O .odt text document?
Ask/Getting Started from old to new?
Image map not at the same size at original
Ask/Getting Started from old to new?
Numbered list with variable lettered sublists in writer
Font color of specific row keeps reverting
[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
Using date separators in forms
Stock-chart not saved correctly
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 7.2.3.2
Main menu overlapping top menu bar, how to hide or fix?
Copy paste heading 3 and table , pastes to new page

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.

Answer or comment?

Please only write an answer solution if you have a solution to the initial question.
For all other cases, please use comments.
In the following image, the creation of solutions is marked in blue.
You can call up comments using the buttons marked in yellow.

Feature requests

Feature requests should go directly to Bugzilla as Enhancements.

Bugs

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

5 Likes
SWITCH function shortcuts to #N/A
Default Text Box File Save
Locked document file
Libreoffice 7.2.2 crashing during start
One more conditional formatting issue
Installing in AWS EC2
Image exported to pdf is not cropped
Installing in AWS EC2
Bold text is in cyrillic
Disable the "Add spacing between Asian and non-Asian text" feature
Connector text box disappearing (becoming invisible)
Nicht registrierte standardmäßige Dateiformate (message)
Libreoffice writer hangs whenever I copy/paste
Open Office doc migration - blank hyperlinks, page boarders, headers
Spellcheck not working
Bad image quality after rotating image in LibreOffice Impress
Draw file. I opened tonight and it appears each page of text is packed in one line
How can I report a bug that is only reproducible with a very long document?
How to convert png files to text pages for a Writer doc?
Libre Office extremely slow since updating
Windows 11 - File Explorer - Search Contents fails
New extensions list
Libre office keeps crashing crashing (7.3.0.3, macbook air 2015)
External data corrupted and refresh issue
LibreOffice Base Autofilling Junction Table
Can't delete input fields in writer - they are like zombie vampires
Table-row and table-column ignore common styles
Line numbering in part of a document only
LibreOffice v7.2.5.2 crashes when i open a .CSV file
Bookmarks - hold sort
Impress hyperlink to an executable with its commandline argument
Compound (hyphenated) words flagged as spelling error revisted
Where to report a bug in a pre-release version?
Delete versus cut graphics action
DDE link not working 7.4.5
Divide number in %'s
Controlling output pdf size when converting via command line
LibreOffice Draw, save .otg with text boxes of the form
Libreoffice usage Error in Manjaro Linux
Copy does not work
Pasting (previous) images from clipboard impossible into LO
MS Office RGB colors to LibreOffice CMYK colors
LO files uploaded to OneDrive are corrupted from mac
Impress failed to play embedded video
Track changes mysterious colours
Text surrounded by lines?
Problem exporting to XLS format
How to save cursor position in Writer?
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
Unable to print from LibreOffice Files
Contents Did not Showing ...In LibreOffice Calc - > DATA - > Validity -> Under Input Help?
LO 7.1 High CPU spike in Print, Options, Paragraph dialog use (see images)
Page numbers change when exporting as PDF
LO 7.1 High CPU spike in Print, Options, Paragraph dialog use (see images)
How to convert ODG file to ODT using LibreOffice Draw
Adding custom page number format
Printing in Calc
Unable to change file permissions on my manuscript
Is spreadsheet corrupt or not?
URL "target_blank" not working when exported to pdf
UTF-8 file loses page break
Two columns Text with 1 columns image
I have had a power surge and non of the documents I have on Libre will open. can you help
Complex writer document frozen in LO24.2
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
Images anchord to page missing in master document
Maintaining Font in DOCX to PDF Command Line Conversion - Ubuntu Server 20.04
Possible bug in LibreOffice Base
LibreOffice Impress 7.3.5.2 will not hold text box position and size
First three words are not a sentence
Request for Sort Dialog change
Phone cell format with or without "+"
Reordering Conditional Formats (Not Conditions)?
PositionX & PositionY no longer working for Dialog position on screen
Getting secure coding warning when running --headless
Dark Mode and Tool Bar
Writer function to remove cropped image parts?
Changing Slide In LibreOffice Impress
DRAW: Sticking drawing points
Password removed from Writer file
Application stopped and not loading at all
Old split hsqldb won't connect in new Linux Mint 20.2 and LO 6.4.7.2
How to reset default print quantity to 1 after each print job
Word 365 Docx file with a table is getting a strange rendering when opened and converted to PDF using LibreOffice Writer
Assigning functions to shortcut keys
Getting Layers to Work
Cannot save Draw file
Paste and undo breaks conditional format
Calc - Lock cell content before formatting to text, how?
New version of Impress screws up 10 years of saved presentations? :(
Merge issue Writer omitting DB Field Intermittently
Connector lines not straight
How do I submit suggestions in improving LO Writer?
Writer - UNO API - Java - Cursor error when creates a table with start and end dynamic fields
Round Down is Rounding Up
Libre Impress - Anregungen: Notes + Video
Convert odm to pdf using via cli
Pilcrow 'open' changed my spacing? or What causes this bug i'm having?
Writer memory leak (LibreOffice 7.3.0)
How to sign macros in "My Macros"
How to change page numbering
Libreoffice Impress: The gradient angle always automatically returns to the default value
Formatting a field from a database
Dark Mode Text is Black - Can't Change?
LibreCalc - Ctrl + Enter = Horrible Shortcut
Porting workbooks from Excel to Calc
Formula bar issue
Calc crashes since 7.5 update when using Wingdings font in date validity
MSI Installers issue
Libreoffice command line convert docx to pdf , The character line spacing has changed
Lost PUA chars with xlsx/ods formats
The clipboard does not work correctly
File extensions
Printer stop error using Libre Draw
Any hope LO will actually run on High Sierra?
Windows Narrator and Libre Office Writer
How do you get syntax highlighting, and parenthesis scope in the equation/formula bar?
Protocol for creating a spreadsheet with compatible formatting for Excel?
LibreCalc: change default date format: feature request
Hyperlink: New Bookmarks not showing
Why can't I resize math formulas in Impress?
Failure of average function to calculate correctly
Can I save print properties with a document?
The words in libreoffice writer are hidden
Paste unformatted text - does not work
All Headings are numbered 0
Calc does not ask for password to open a password protected xlsx file
Undo and redo properties
Printing problem
Basic mistreats Function name in Function body (sometimes)
Cannot turn AutoRecovery off
Notification when someone changes a Document on a another PC (networkacces)
Jump to a specific paragraph
Update runs before macro
Libre calc calculations
"Version incompatibility" "incorrect file version" when opening pdf
Bug/regression with kashidas in 7.5.0.3 - but thread-starter no longer interested / therefore his "Please close this account"
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?
Several display bugs in calc since 24.2.3.2 update
Broken image form?
Move endnotes to the end of the article
EarnestAl, trying to reply but the forum isn't letting me comment any more
Allow selecting Japanese word to check for alternative kanji
Change the size of multiple shapes at once?
Is LibreOffice an online application?
Document saved as garbage
ReDim on custom type containing dynamic array
Vertical text in Word document doesn't convert to PDF
Feature Request: Save the last configuration of the "Send Email Messages" Mail Merge dialog
Random Cell backgroud color after conversion from Lotus123
How to convert from Writer to pdf without distortion
Opening the "Edit Style" menu crashes LibreOffice Writer on Windows
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
Text Cell Displays Formula and NOT Value?
2 databases lost all data
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
Nat Instruments TDMS Support for Calc
LO Writer misses to paste "merge formatting" like MS Word (Deutsch: Einfügen Format zusammenführen
Trouble converting large excel spreadsheet
It is different at the binary level
How do I change the color of a border
Custom style not showing in writer document
Libreoffice update always wipes out my default settings
Localized shortcuts? (Why do I have to use strg+shift+f for bold?)
Pictures add double their file size to writer document
Writer is not displaying documents correctly (Linux)
How Do I Add Insert Anchor To The Context Menu?
All my docs open minimized
Crashing upon Specific Task
Calc Chart SVG missing X-axis Labels
Calc macros in IDE separated from Spreadsheet macros
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
LibreOffice Calc macro to select specific cells, find regular expressions and replace
No autosave by default; are you guys high?
Has anyone else observed a change in the frequency of crashes?
Header fields not tracking header values
*The Case of Missing OLE Objects*
Named Functions - Reduce Formula complexity / Low hanging Fruit to enable functional Programming in Calc
Calc Special paste process works as slowly on column with vlookup formulas
Must click the mouse when opening a writer doc, otherwise keyboard short cut Ctrl+f does not work
Impress text box not showing in Powerpoint
Conversion pdf to docx in libreoffice 7.6, collapsing all in one page
Cannot set background color in libre calc
File protected by a password is opened as a text and there isn't password window
Writer: how to change the external tool to edit images
Insert file into LO writer doc
Is there a symbol sorting standard? Calc and Excel are different.
Can Libre Draw (v5) flip a page (Lt > Rt transposition) complete with all texts & objects?
New user - excel spreadsheet edits not being saved properly
Libreoffice calc Tabbed layout is too compact (visually complex)
Export to PDF does not embed fonts "flattened"
5.5" x 8.5" Paper
Add regex support to find
Images SHRINK itty bitty when exporting a text document to PDF
MALWAREBYTES report PUP in Libre files when trying to print
More CPU background use than expected
How to Get the Width of a Text Table Cell at the Cursor
Problems with other files after using --headless
Column format display issue
Bibliography does not update after changing entry structure
Ctrl+Shift+U+hexcode not working in Writer comments on Ubuntu - bug or feature?
Librecalc solver cant do products
Some PDF files will not open in LO Draw
keep text together?
Need help with a checkbox setup or maybe other solution (Very New)
Unable to use RETURN key when using conditional format
Support for search and run commands
Toolbar cuts of at right instead of wrapping to a new toolbar line
LO and Defender Mitigations
Highlighting lines of text automatically
Comments with Author name but without date and timestamp?
Is this bug? broken table content in pdf/printing when enumeration is enabled
Libre Office 7.3.2 cannot copy bank content + paste to writer as characters are lost and not correct
Libreoffice Writer - Some marks in the Unicode font shows dotted circle
Version Control Information
Transparent png not exporting to PDF correctly in Draw
Unable to shrink/reduce size of chart in Writer
Insert/edit table of contents causes crash
Does multi-threading only work in Calc?
Correcting abnormal large text appearance and lack of word wrap
Calc border and inner line draw order TAGS: CALC
Sort won't save in xlsx
Circular image contains a rectangular frame while converting from pdf to word
Lists (a, b, c, etc.) in a document have disappeared
Poor colour rendering
Amazing! But... (Feedback)
How to modify colour of line?
Why does LibreOffice Calc take so long to save changes to a file?
Read Error. Format error discovered in the file in sub-document content.xml at 2,321994355(row,col)
Read Error. Format error discovered in the file in sub-document content.xml at 2,321994355(row,col)
Writer 'New Window' disabled
Japanese Furigana does not work as I want them to
How to overtype using a different color font
Can libreoffice show CND window when i boot up my PC, or is libreoffice responsible for this action?
Writer: new style from selection automatically created as conditional and can't be changed
Use a Java runtime env can't be disabled
Must all Basic calc macros be in "Standard?"
BaseDocumenter error
Show columns on formatted writer page
How to get libreoffice to find Java JRE file?
Two-key sequences
How to set Writer Paragraph Gradient Transparency using macro?
Creating List Formats
Calc Find and Replace [Fax:]
Styles are updated automatically while I open Writer document
Cropping a stacked area chart
Mime icon is missing as always after new installing
Opening Recent Documents
Comment box does not point to the correct cell
New formatting tools for files?
SVG support in LO Writer
New LibreOffice download tool bar not working
Rulers and tabs in Calc cells
Please add support for SI prefixes in number formats
Lost Paragraph Styles when copying Impress Outline into Writer Outline since version 24.8.2.1
When will the program-code of Libre Office allow preview of ODT-1.2-files in Windows (File-)Explorer Preview Pane without having (newest) MS Word installed?
Blank page or envelope printed by LOwriter v7.3.7.2
Numbers appear as time in Calc
Unsolved problem with tables in impress?
White Border around document when exporting a Calc File to a JPEG or PDF
Font isue in Calc
Formatting Issues in Master Document: Footnotes and Page Backgrounds Lost
Formula object shortcut on MacOS doesn't work by default
[ feature request ] please improve the interface
Updated Changes to Libre Office
Cursor pops to *beginning* of word
Macro conversion?
removeRange error
Calc-active cell indicator is outside the cell framework 24.2.3.2 -> 24.8.0.3
TOC (Index) has letters instead of page numbers
Paragraph skips page
Problem with ODS file generated by third party software.
Converting Xlsx documents
Calc: How to change conditional formatting priority
How to run soffice.bin in headless mode on a IPV6
When using Record, Deleted text disappearing instead of Red-Lining, Please help!
Impress won't execute link in Powerpoint file (Windows 11)
Adding an attachement ....?
Adding an attachement ....?
Docs save to Drafts, attempts to recover Fail then finally Doc opens
GTK+3 integration breaks imported mpeg4 and avi videos in Impress
How do I control the way navigator expands and collapses?
Error saving - General Error. General input/output error
How do I control the way navigator expands and collapses?
Line Break in Bibliography
Libre Office document window not seen
Automatic locale when importing HTML into Calc
Format cell > borders
Can I turn off "Update Styles / Keep Old Style" Notification when opening old documents that haven't been modified?
mail merge with variable images
Writer: grey squares in far page corners?
How to add embedded images from extension into Writer doc
Floating chapter heading
Opening windows on wrong virtual desktop on rhel7 KDE
How to hide or disable the minimize, maximize and close buttons in the title bar?
Validation keeps switching error action back to stop
Stop "copy cell" from deleting the contents of the copied cell
Suggestions for AI Tools for Writer
Saving edited files opened from a zip files with the portable version
LibreOffice Writer using Integrated GPU instead of Dedicated after monitor change
LibreOffice UI customization
Request for exporting Calc spreads in iCal format
CSV import crashing in Calc / LibreOffice 7.6
Surpressing command line output
New Feature to allowe Impress show Normal and Notes in same view
Import seperated layers
Libre Write Send / Document not attachment created in Thunderbird
Chart axes disappear on refresh; Columns need to be re-formatted frequently
Move an object and/or exact object position
Unexpected change to date format
Draw image import and default page size
LibreOffice Calc 7.5 refuses to save as Unified Office Format .uos
Python in calc (not macro)
Connection to MariaDB via Connector C not working
Format messed up on different PC, large doc with photos
Header formatting is off when docx file is opened and converted in the writer v7.x
Printing Named Ranges not functioning L O Calc 28.8.2
Bugs in LibreOffice 7.6
Range.Find VBA method does not handle the "#" properly
Possible bugs - calc
insertControlCharacter - nControlCharacter parameter optional?
Libreoffice crashes upon trying to save/convert to PDF in writer
Why is LibreOffice Writer No Longer Following/Focusing on my Cursor?
Inserting images in document
Is there a pencil tool to draw borders in calc, like in Excel?
How to protect the cells of only the first two rows of a Calc sheet
SQL Statement Edit
Is there an alternative to SUMIF for arrays?
Calc chart not refreshing when data changes _Latest_Update
Change background of active cell when entering data
Weird Gray Spaces Between Words
Exported PDF from LibreOffice crashes right after opening. File not stable
LibreOffice removes additional space in URLs when opening saved docx file or after convert to PDF
Is this a bug in script invoke: passing Integer-sized Long argument as 0
Why does Array Function get reset to non-Array Function?
Please add a lock zoom feature on LibreOffice
Are unicode collation rules are kept up to date automatically?
I need the ability to see where I am in the search results
Regex not replacing text in Calc macro editor
Older Stable Version numbering question
PDF Encoding Issues with page-image matching when converting DOCX to PDF
How to avoid including sections from other documents when saving?
User-defined date formatting not printing as displayed in spreadsheet
Libre Office not printing my documents
How to set the Selection parameter to convert to pdf using the command line
LibreOffice freezes on save
Autoinput key combinations on macOS
Libreoffice Writer imports images too dark
Unexpected decimal precision error in Calc
Can't save a hot key assignment, ctrl+end = insert table
Libreoffice command line convert docx to pdf , The character line spacing has changed
Global LibreOffice scrollbar accessibility
Full screen mode in Calc
How to make 14 border styles available under format tab like there is under the toolbar button/icon?
Calc Crash on Second RegEx Matches Access (VB Macro)
Disable "Wraparound" of next/previous sheet shortcut in Calc
I can no longer modify/edit my org charts in LibreOffice. Please help
Option "Ignore system input language" should be default
Macro ThisComponent.getSheets() invocation fails during autorecovery
Hyperlink Buttons to Folders instead of directly to files
One Click to Insert rows in a calc spreadsheet. CALC needs a solution for 2024
Table with inner tables causes crash when CTRL+A
Why are ODS documents are over sized? Can fix?
How can I prevent long lines from being split during export to PDF
Docx file: Only header and footer are visible, no content, page blank
How to re-open initial window?
Regular expression matching empty string with lookahead/lookbehind cannot be found
The wizard was interrupted before LibreOffice 7.6.6.3 could be completely installed
Writer: how to fully embed font in PDF?
Plus sign not accepted
Adding more options to booklet print mode
Impress: Image filter not found
LibreOffice Calc, typing in a cell constantly overwrites the same character over and over?
I can't get the Formatting Toolbar to show In LO Writer
How to disable Asian Typography option "Apply spacing between Asian and non-Asian text" when using command line to convert file to pdf
How to adjust size of formula box
GIF animation makes LibreOffice Impress slow
LibreOffice 24.2.3 can't control font colours in Application Colours
libreDraw cannot open tif file, it says image filter not found;
Calc loads slowly
Java method can be invoked from Run Macro but not from execute action
LibreOffice Writer feature regression: why remove No Character Style from Applied Styles?
Libreoffice Calc not working properly [artifacts in the headers and status bar]
Uploads: Images vs example files / HowTo
Avoiding that Libreoffice affects specific file formats like .stw
Using the Draw program- How to mirror image text
Remove Sidebar icons
Auto-reload files, if changed on drive?
LibreOffice 24.2.0 Portable not starting
Suddenly can't open password-protected docx. files
Is there (still) no function to access Current Sheet minus one
Crash with macro on GridControl
LibreOffice deletes folder with structure.xml (.dotx)
Is this a bug? Unprotected Cell turns protected after pasting in text from a web page
.xlsx format: Value highlighting always enabled
Missing rows in calc
Digital Signature in Windows client is shown as valid although it shouldn't
Drop down created in Word displays key instead of value
Non-Text Items not being saved in Writer
LibreOffice Calc cells format differently on different PCs
Can't freeze top row
My documents come up in a window stuck to the top of the screen and I can't move it
Any Chance You Can Add Auto-Naming of URL Hyperlinks?
Pyuno convert docx to pdf
Import dBase Files works on LO 7.6.2.1, but not on LO 24.2.5.2?
PPTX to PDF conversion
Saving an odt file without any modification changes the styles in content.xml
Format is messed up when replacing text
Why does LibreOffice Calc take so long to save changes to a file?
Add search to options
Automate Text Import of clipboard content without the dialog
Calc: understanding styles (problem: style not expressed)
Optimal size of named ranges
Hyphenation does not appear in PDF
Dark | Light | System? Can I access if System Color is in Dark Or Light Mode via LibreOffice API?
How do I group two images as one image in Libre Office Writer version 7.6.4.1.?
Base ODB files now 0 bytes and opening in writer
Purging all instances of LibreOffice
Problem installing via msi
How do I edit the text in an L/O .odt text document?
Countdown in Presentation mode Impress
Heading and body text styles getting switched around
Special characters are missing
Avoiding updates for help in non-wanted languages
LibreOffice 7.3.3.2 (x64) "not responding" in Windows 10
Font color of specific row keeps reverting
Can Libreoffice import old Adobe Pagemaker .pm6 files
Print Ranges fail to Save
Libre Spreadsheet Errors (saving format)
How to define print area in calc LO 7.2.6.2
PNG/JPG Export of calc sheet with shapes = shapes shifted vertically
Need help turning off autocorrect in LibreOffice Calc
Stock-chart not saved correctly
Using date separators in forms
How to determine and use Process IDs of the different LibreOffice programs?
Problem in Paragraph - Line Spacing for rtl docs
Low visibility Icons
Main menu overlapping top menu bar, how to hide or fix?
Libre (7.5.1.2) runs sooo slooow when I open an existing 1-page file
How to create and Save Customized Bulleted List?
Calc: Convert Image URLs To Actual Images - sometimes it doesn't work

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”.

Format short inline expressions as `expression` by enclosing them in backticks or grave.

Fenced code blocks are formatted 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

```cpp

```bash

```python

```xml

```java

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

```text

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.

Formatting Calc spreadsheet formulas usually works with just ``` but if there’s odd colouring of function names and string literals like "foo" are not highlighted in red then forcing

```python

helps and shouldn’t interfere.

6 Likes
Create a shortcut on desktop
Calc, efficiency gap, external workbook, parametric URL
Can typographic quotes be switched off for ask.libreoffice.org?
Err504 in If formula
Simple macro to open URL in sCalc
Calc, efficiency gap, external workbook, parametric URL
Export .pdf file that shows tracked changes
Calc Functionality Lost
Convert-to ODS / XLSX from HTML with style parameter
WEBSERVICE authorization in URL
Help with converting VBA code to Calc code
Sum function and Math Equation Help
Query syntax for subtotals and total in Base
How to add/remove a duration in seconds to a datetime field, ex: 2023-01-16 22:50 + 865secs?
Calc - Update external / internal links - locked cells - problem
Calc: Delete button created via macro via macro
Anyway thoose macros work in Libreoffice too?
Calc VBA Cell.Formula = "...", Formel nicht ausgewertet
Are some actions disallowed in CALC Macros?
Updating cells with "last date used"
Webservice Returns #Value from Valid Url
=if()elseif() help?
=if()elseif() help?
Hyperlinks Not Functioning Properly
Get filename from a cell
Sorting across rows in libreoffice
How to filter out rows with formula?
Spreadsheet Cells Will Only Show Formula Not Results
Dies ist die Anleitung - Wie benutze ich die Ask Seite?
Substitute wizard produces error when quotes are involved
Modify User Defined Data in A Function
Query with like using a parameter to a MSSQL database
How to open a subform from a searchform via doubleclick
Need help changing working code
How to manipulate the web browser based on data in libre calc?
Conditional Statements IF, THEN with 3 Conditions
Calculating value from math in different cell
Using indirection to calculate a variable cell reference in SUMIF and COUNTIF
Macro returning sum as "0"
Setting Default Styles for Writer
How do you Ref two cells with an IF,OR statment?
Libreoffice calc Conditional Formatting not working as expected with formula
Macro, create folders from sheet columns, error at MkDir
Macro doesn't work properly from button, but works from macro presssing F8
How to enter double-quotes and a cell reference in a calc formula
Calc Number Color
Principles for building a large spreadsheet
Calc basic macro function passing cell fails after Libre Office upgrade
Need help dealing with dates in SUMIFS formulas (after updating LO from 6.3 to 7.6.2)
LibreOffice PDF Export Results in Large File Size After Version Upgrade
LibreOffice PDF Export Results in Large File Size After Version Upgrade
Excel makro doesn't work in LibreCalc
Find first value in a range greater than a reference cell value
Using userform in Libre calc
Object Library contains foreign language text
Trouble using UNOIDL library in C# on Windows 11: uno.Any[] argsArray = new uno.Any[] { new uno.Any(context)};
When I fill down a formula, libreoffice calc is not updating the reference cell number
Compatibility issues with Microsoft Excel 2019
Copy paste bug in libre writer
Converting an excel spread sheet to Libre Calc "macros will not work"
Find first value in a range greater than a reference cell value
How to write data into NamedRange
How to add a "scale sheet to fit number of pages" button?

How can I change my password for Ask-LibreOffice?

You can reset (i.e. reassign) your password during the login process.

  1. start Ask-LibreOffice in your internet browser and choose your preferred language.



  2. click on the “Log in” button.



  3. the login page will open. Click the “Reset my password” button.



    If you have changed your password, you can log in again as usual.

2 Likes