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.
933 questions
0
votes
1
answer
62
views
How to combine multiple lists into one column?
I have multiple columns of dates.
Col 1
Col 2
July 1
June 1
July 2
June 2
July 3
June 3
July 4
June 4
The goal is to combine both lists into a single list (order doesn't matter)
Goal
July 1
June 1
...
2
votes
0
answers
53
views
How do I specify what character to use as a list level separator in LibreOffice Writer?
Problem: I want my Heading 1 style to be numbered 1, 2, 3... and I want my Heading 2 style to be numbered a, b, c... with sublevels 2, so that I get my headings like this:
1 Heading 1
1a Heading 2
1b ...
- 116
-1
votes
3
answers
168
views
Replace some symbols and text in cell and leave the rest
I'm doing a project using LIbreOffice 25.2.3.2 on a MacBook Air which is running OS Sequoia 15.6.1.
I have a spreadsheet in which U.S. states are assigned a region. It looks like this:
What would be ...
- 107
2
votes
1
answer
219
views
How to debug LibreOffice no being able to validate a signature (on signed documents) on Linux?
I'm trying to sign documents and macro code in LibreOffice (Writer) using a X.509 certificate. I've tried two different ways to provide the certificate and the issuing CAs to LibreOffice (Version: 24....
- 10.7k
0
votes
0
answers
71
views
LibreOffice PDF export: font in "Default Appearance" string
I have a .odt file that I'm using as a "blank" table of contents page. It's not really blank, though: it has a number of form fields that, once I export as PDF, I intend to use pypdf to ...
- 137
1
vote
0
answers
177
views
Windows Subsystem for Linux (WSL): After using clipboard in LibreOffice Calc, weston (as part of wslg) crashes
I've installed WSL on a Microsoft Surface Pro 7+ after updating to Windows 11.
Whenever I try to cut (C-x) or copy (C-c) something in Libreoffice Calc, the program crashes. Other programs like ...
- 11
1
vote
0
answers
27
views
Libreoffice Impress animations: turn object opaque on click?
I regularly use the Entrance > Appear option in Libreoffice Impress presentations.
However, instead of objects appearing out of no where, I would like to display objects translucently in the ...
- 111
0
votes
1
answer
62
views
Image imposes over footer and doesn't change page like text
I included an image in LiberOffice writer but the image doesn't correctly change page after it has run out of space and instead imposes over the footer.
The following screenshot shows the problem, the ...
- 651
3
votes
2
answers
616
views
How to change the background behind the page in LibreOffice 25.8?
I don't remember what I did to set an image background to a document. Any new document I create in LibreOffice has now this background image, which I would like to change or delete:
Format- page ...
- 33
0
votes
1
answer
287
views
LibreOffice not working on standard Windows account, notwithstanding changing permissions
I don't know my way around windows at all these days, been on Linux for a decade. However my wife insists on using it, currently Windows 24H2 26100.6584. My general computer knowledge means I'm IT ...
- 178
0
votes
1
answer
320
views
How can I perform an automated LibreOffice installation with auto update disabled?
I'm trying to install LibreOffice from a PowerShell script with auto update disabled, but it fails
download an older version of LibreOffice, this one for example (Oct 2024)
Open PowerShell as ...
- 93
3
votes
1
answer
77
views
Can I Print/Export Sparklines to PDF?
I have a spreadsheet. It uses sparklines (type: line) to help summarize some data. When I try to print[preview] or export to PDF, the sparklines do not show.
I have gone back into the sparklines ...
- 173
0
votes
0
answers
108
views
How to have the array returned by the FILTER function expand dynamically in LibreOffice?
General Question:
I am trying to create an accounting journal (in one sheet) that automatically updates the ledgers (in other sheets). To do so I use =FILTER() to only keep the rows (ie. journal ...
- 31
1
vote
1
answer
93
views
How to have IFERROR return an array in LibreOffice?
I noticed =IFERROR({10,15,20} / {2,0,5}, "Error") would return 5 in a single cell instead of {5, "Error", 4} which I would have expected and excel returns.
Is there a way to have ...
- 31
1
vote
1
answer
179
views
Why doesn’t the “loook” search tool recognize an ASCII special character (e.g. a single quote mark)?
I have two LibreOffice documents.
The contents of /home/user/foo1.odt are:
foo bar
The contents of /home/user/foo2.odt are:
foo 'bar
Now, using the loook tool (ver. 0.8.6) with a search phrase of ...
- 175