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.
901
questions
2
votes
0
answers
16
views
How to scroll down in cell with a lot of text
I have a dataset with extremely long text data (and many newlines).
I've created a mock-up here:
You can see that there's a 5th Lorem Ipsum paragraph at the top, but I can't seem to get it to display ...
- 429
2
votes
0
answers
12
views
Enlarging suggestions font size on spellcheck on LibreOffice Writer
I want to make the Suggestions on spellcheck dialog larger because they are too small to see.
Thanks.
- 21
0
votes
2
answers
123
views
X11 forwarding - Putty - Xming: Why app run on the server instead of the client side?
I am trying to understand a few details about X11 forwarding using Putty and Xming.
I have an Ubuntu 24.04 LTS machine and am connecting to it from the same network using Windows 10 with Putty and ...
1
vote
1
answer
135
views
Calculate best possible lineup from a team of players using performance ratings in Libreoffice/Excel
I'm stuck at what I suppose is an optimization problem.
Here my spreadsheet is showing two tables, the one at the top displays the performance ratings of various players at different football ...
- 13
0
votes
1
answer
42
views
Nested If statement. working in two sheets
its been a long time since I used Excell so my thinking may be complety wrong, but this wont work. Am I using the wrong Syntax for LibreOffice Calc
=IF(M3>$'Shipping Profile'.$A$3,then $'Shipping ...
0
votes
0
answers
17
views
LibreOffice Impress - add margins to text highlighted area
I am trying to add some margin around the highlighted area of a text within a table cell.
Something along the line of LibreOffice presentation: wider text background, like html padding?. The problem ...
- 119
0
votes
1
answer
32
views
Libreoffice: Exit mail merge preview mode
I have made a mailmerge document. It looks like this:
When I click > it previews the document with the first element:
This is great, but how do I go back?
I have tried manually entering -1 or 0 ...
- 4,881
0
votes
0
answers
58
views
How Can LibreOffice Convert Milliseconds To Timestamp Or DateTime?
In LibreOffice I had converted timestamps into milliseconds because I didn't find a built-in way to naturally handle a standard time format. But now for real people, I want to convert that time easily ...
- 103
0
votes
0
answers
109
views
MS Word performance issues when editing large files [duplicate]
The problem: MS Word is very slow and freezes for a few minutes when editing large document [.DOCX] (1000+ pages). I've been unable to work on this document due to this issue for a couple of months ...
- 21
0
votes
0
answers
25
views
How to specific dark colour (color) scheme for all LibreOffice applications except LibreOffice Draw? (Linux)
I find dark mode most suitable for all the LibreOffice applications except LibreOffice Draw.
How can one specify to use a dark application colour (color) scheme for all LibreOffice applications, ...
- 8,439
0
votes
0
answers
10
views
How do I put the series labels overlaying the graphics series lines in Libreoffice Calc?
As they say, a picture is worth a thousand words... so here goes:
I want the series labels of my Libreoffice Calc spreadsheet to be like this:
Instead of this
Is this possible ? How do I do it ? I'...
- 167
0
votes
0
answers
51
views
Running several instances of headless libreoffice: where's race?
I'm running libreoffice (headless) to make several hundreds of pdfs from odts. It's too slow, so I've tried to run some in parallel.
SOME pdf files are generated without any error but with zero size. ...
- 101
0
votes
1
answer
103
views
Use a subset of system fonts for LibreOffice, on GNU/Linux
I have a lot of system fonts in my GNU/Linux distribution (in /usr/share/fonts/): most of them are useless for me when I'm using LibreOffice to write or to open a document.
I'm using my distribution ...
0
votes
2
answers
36
views
Issues changing CSV column type to date in LibreOffice
I encountered some trouble changing cell types in LibreOffice Calc from text to dates.
This happens when I import a CSV file. The import into rows and columns works fine. However, the dates are not ...
1
vote
0
answers
22
views
Libreoffice Scatter Plot - Gradient Fill Points
I'm using LibreOffice Calc and I'm trying to create a scatter plot with some data that I have.
This is what my graph looks like so far
I want to color the individual points by a gradient of their ...
-3
votes
1
answer
38
views
Libre Office writer How to print only page 2 of a 5 page writer document
My operating system is Windows 10, Printer is HP color laser jet CM1312nfi MPF, LibreOffice 7.5
I have created a Libre Office writer 5 page text document with 1 "picture" a screen shot of a ...
- 11
1
vote
0
answers
23
views
How to change font of all conditional styles?
I want to change a spreadsheet's font. The conditional styles are still using the old font. There are too many to change manually one at a time. What's a practical way to update all the conditional ...
- 21
1
vote
1
answer
44
views
change language for pdf export in libreoffice calc
This must surely be obscure but I'd really like to fix it for an important document.
My system language is in one European language. Still, I managed to change all the languages for a Libreoffice Calc ...
- 175
0
votes
0
answers
53
views
Remove the dot before pages in the table of content entries in LibreOffice
I'm having a hard time removing the dots before the pages in the table of content entries in LibreOffice.
The automatically generated table of content from Headings results in the following:
1. Name .....
-1
votes
1
answer
49
views
How can remove the space between lines?
My libreoffice version is Libreoffice Community 7.4.7.2.
When i move cursor at the 'volume'] and press 'deletekey,and pressenter` key,it can't remove the space.
How can remove the space between the ...
- 161
0
votes
1
answer
99
views
Libreoffice macro has infinite loop
Can someone point out what's wrong with this macro please? I'm trying to search for paragraphs with the token "vv", then change their paragraph style to "_Verse". This macro works ...
- 69
2
votes
1
answer
162
views
Can't find Developer Tools in LibreOffice Calc
I recently read that the Development Tools is available in LibreOffice since 7.2, but I can't find it in my 7.5.9.2 (and then updated to 7.6.4.1) installation... It should be found under menu item for ...
- 131
1
vote
3
answers
138
views
Convert an Excel table from one structure to the other
Original table
I have this table in Excel or LibreOffice.
Unit number
Type
Name
1
Object
Top
1
Object
Bottom
1
Object
Left
1
Object
Right
1
Object
Back
1
Object
Front
1
Property
Right-Fixed
1
...
- 270
0
votes
1
answer
164
views
How can insert spaces at the beginning of another line in libreoffice?
There are two lines in one paragraph:
The cursor located at the beginning of the second line,ahead of the word long_window,now i want to add 4 spaces ahead of long_window as desired below:
,why can'...
- 161
0
votes
1
answer
13
views
How can I enable auto-replace patterns like :alpha: for "Language = [None]" text in LibreOffice Writer?
This question is written as Q&A after having found an answer.
The feature of LibreOffice of inserting unicode characters using sequences such as :alpha: or :_1: could be useful for writing ...
- 2,342
2
votes
0
answers
24
views
LibreOffice Writer: Change all four page magins to the same value AT ONCE?
Instead of changing one by one, can I change all four at once? Google Bard said press Ctrl+Enter, but that did not work.
- 3,974
0
votes
1
answer
60
views
LibreCalc 7.6.4 Menu and Toolbar
Just downloaded LibreOffice 7.6.4 and I have created a quick access bar. This shows up on the right side of the top menu bar. How do I make into a floating toolbar or a docked toolbar, always on ...
2
votes
0
answers
44
views
How to update LibreOffice WEBSERVICE data automatically
I know I can force a manual update from Edit/Links.
Is it possible to have LibreOffice update this data automatically, for example once per day?
- 159
1
vote
1
answer
124
views
LibreOffice Calc save to CIFS not working
I have an HP Compaq nx9420 that runs Debian 12/bookworm kernel 6.1.0-10-amd64. It's a default install with no extras or tweaks.
I mount a CIFS-drive (fstab-line: "//[ip]/[share] /[mnt]/[point] ...
- 21
1
vote
1
answer
76
views
How to clone conditional formatting to another column?
I want to highlight values that are in the bottom 5th percentile in each column, for about 60 columns. I set this conditional formatting for the first column, but I see no way to apply this to every ...
- 163
1
vote
2
answers
137
views
Associate .docx with swriter.exe LibreOffice (with PowerShell)
I would like to associate .docx with OpenOffice
$extension = ".docx"
$executable = "$MyPrograms\LibreOffice\program\swriter.exe"
$fileType = "docxfile"
if (Test-Path $...
- 939
0
votes
1
answer
55
views
Macro to keep 3 rows visible under the selected row in LibreOffice Calc
In Calc or MS Excel when one is finished editing a cell in a row, pressing Enter leads to the next row below. Keep doing that and eventually you arrive at the last row visible on the screen. Here when ...
- 103
1
vote
1
answer
1k
views
How do I apply the MATCH() function only to a filtered range? Or is there another way to do that?
I have a filtered list of values. Let's say I have the numbers from 0 to 5, and 2 is filtered out:
A (with auto-filter against "2")
0
1
3
4
5
Now I want to find out whether one of the ...
- 2,431
0
votes
0
answers
68
views
Having problems with nested numbered and bulleted list
Using the LibreOffice Writer, I am formatting a rather long lists of items where the first level is numbered, and the most of the numbered items contain next level items -- with bullets in the case. ...
- 119
1
vote
1
answer
65
views
cannot scroll down to click okay in libreoffice settings
I tried to follow the instructions here -
LibreOffice 4.2.1.1: do not display list of recent documents
Open the LibreOffice config: Menu "Tools" -> "Config";
In the TreeView: &...
- 175
1
vote
1
answer
89
views
Automatically center Japanese ruby text in LibreOffice
I have activated Asian Phonetic Guide in LibreOffice to add furigana to Japanese words but every time I open it up, it adds the furigana on the left (which I assume is a result of the style I have ...
- 111
0
votes
1
answer
141
views
Can libreoffice differentiate between .txt and .csv files?
Can libreoffice differentiate between .txt and .csv files?
I have two file's that have a mime type of 'plain text document' text/plain detected.
One file ends in .txt and the other ends in .csv.
Is it ...
- 101
1
vote
2
answers
6k
views
Upgrading from Ubuntu 16.04 to Ubuntu 22.04
My friend is going to help me upgrade my operating system tomorrow, from Ubuntu 16.04 to Ubuntu 22.04 (or perhaps Lubuntu, I'm not quite sure). I'm going to back up all my files tonight and put them ...
- 61
1
vote
1
answer
118
views
Procedure to update portable LibreOffice
Having "installed" (i.e.: unpacked) LibreOfficePortable, I got a message that an update is availble.
So far, so good.
However when I clicked the button to get the update, the "normal&...
- 695
0
votes
0
answers
102
views
LibreOffice Impress: master slide font size not respected?
I am trying to create a default master slide in LibreOffice Impress, where I want to set color/font size of the title and of the first level list. This works for the title, as well as for the color of ...
- 141
1
vote
1
answer
118
views
Access LibreOffice Autotext templates from command line
I want to use the Autotext templates from the command line. The location are this:
%APPDATA%\LibreOffice\4\user\autotext\mytexts.bau
C:\Program Files\LibreOffice\share\autotext\en-US\template.bau
C:\...
- 59
0
votes
0
answers
129
views
LibreOffice Impress: Distorted image in presentation mode
When using the SlideShow option in LibreOffice Impress, some images that were totally fine on the document appear distorted on the slide show (see example below). The problem doesn't happen when ...
- 141
0
votes
0
answers
68
views
Does libre office writer encrypt temp files when .odt file is encrypted?
I used Libre Office Writer to create an encrypted .odt file. LibreOffice uses temp files by default.
Are the temp files encrypted while working with the file if the file has been encrypted in the ...
- 173
1
vote
1
answer
228
views
Is there a way I can get previous messages from a mailing list into my mailbox?
I've just joined a certain mailing list. The list has a web archive, which is nice, but I would like to have past messages from that list - all of them or a just a few months back - in my own mailbox, ...
- 9,751
0
votes
1
answer
91
views
LibreOffice Impress macro is only half functional when used in presentation as opposed to outside
I made an .odp file that contains two slides.
In Slide 1, there is a single circle that when clicked on moves to Slide 2. This circle uses a simple interaction and no macro.
In Slide 2, there is a ...
- 1
1
vote
0
answers
161
views
Converting RTF to PDF in LibreOffice changes the margins
When converting from RTF to PDF in LibreOffice, the bottom margin moves up about 3% of the page, leaving 3% more blank space at the bottom of the page. This causes some text to flow onto the next page,...
- 111
0
votes
0
answers
92
views
How to write a macro that iterates an array of strings and displays one of them at any given time in LibreOffice Impress?
I teach Spelling at an elementary school. To make class more entertaining, I decided to add interactive content.
In this example, students are given a presentation. The picture in the slide is an ...
- 1
0
votes
1
answer
148
views
How to make an object permanently disappear after clicking on it once in Libreoffice Impress?
I am hosting a trivia night in my middle school next week. I plan to use LibreOffice Impress. In the first slide there are multiple topics to choose from. When I click on one, it moves to the slide ...
- 1
1
vote
1
answer
104
views
LibreOffice Calc clears clipboard
My use case is: I am running Chrome and filling in a web form. For one text box that I need to fill, I need to get the data from a spreadsheet. So I open the spreadsheet using LibreOffice Calc, copy ...
- 307
2
votes
1
answer
60
views
Postscript mutilates font
I am using the DejaVu Serif font in LibreOffice 7.5.4.2. An exported PDF looks like this:
However, when I print that PDF (or export it into PostScript), it transforms to:
The italic "M" is ...
- 811