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.
855
questions
0
votes
1
answer
26
views
How to set printing page size in LibreOffice application-wide?
Seems LibreOffice saves the paper size in a per-document manner. Can I override this and tell LO to print all documents in an A4 size?
Note: I know I can set a default print size for newly created ...
- 1,611
0
votes
0
answers
11
views
Interaction with Libreoffice Impress: how to identify relevant slide when using "Go to page or object"?
In Libreoffice Impress, I am using the Interaction command to create button/links between slides. When clicking on Interaction then Go to page or object, this open a dialog with
Slide 1
Slide 2,
etc
...
- 131
0
votes
1
answer
19
views
How to calculate the sorted position of a value in a range?
I we have a computed value (i.e. a formula) for each row (column value)
name
value
position
a
1.2
b
0.9
c
1.3
d
1.1
how do I find out the sorted position for each row?, this is:
name
value
...
- 113
0
votes
1
answer
39
views
How to redo filtering with LibreOffice Calc?
In Microsoft Excel, I can reapply a filter with these commands:
I put this command via shortcut in the top bar and can redo the filtering with just one click:
How could I do the same with ...
- 111
0
votes
0
answers
25
views
Windows 10 forces dark mode on Libre Office [duplicate]
Starting from the latest version of LibreOffice (7.5.2.2) I'm having a problem, which is that the interface appears as follows:
I thought that LibreOffice now came pre-installed with the dark theme, ...
- 101
0
votes
0
answers
27
views
Libreoffice in Ubuntu not converting symbols in ppt slide
I have a software which uses libreoffice to convert documents to pdf. I ran into a bug where I uploaded one of my course's slides and some mathematical symbols were removed and not displayed
I opened ...
- 1
0
votes
0
answers
59
views
Multiple Format Conditions with Conditional Formatting
I have conditional formatting applied to a column in LibreOffice Calc. There are two conditions. The first bolds the text and the second sets the background color. If the first condition is true the ...
- 1
0
votes
1
answer
39
views
Why can't I type a single quote at the beginning of a cell in LibreOffice Calc when editing a CSV file?
When editing a CSV file in LibreOffice Calc, I have found that it is not possible to type a single quote at the beginning of a cell for both numbers and strings. When attempting to do so, the quote is ...
- 133
0
votes
1
answer
23
views
How to set 2 criteria in LibreOffice
What I want to do is print column C to column H if A=F and B=G
LibreOffice:
- 5
0
votes
1
answer
76
views
Cannot execute LibreOffice macro on Docker Linux
I want to execute a macro file on Linux created by Docker with the following docker file.
from ubuntu:22.04
run apt-get update \
&& apt-get -y install --no-install-recommends \
default-jre ...
1
vote
1
answer
34
views
Subscript affects line spacing in Libreoffice
I've seen the following behaviour in Impress and Draw, and also in Writer when using text frames, but not in normal text:
Type a few lines in a text frame, then create a subscript in the text → the ...
- 209
0
votes
1
answer
38
views
Fonts in LibreOfficePortable\Data\fonts are not used
Having installed the portable LibreOffice, I found the fonts folder with the file named add_fonts_here.txt.
So I put some TrueType fonts in there and restarted LibreOffice.
However the fonts are not ...
- 466
5
votes
1
answer
194
views
Long enumerations with roman alphabet. Get aa, ab, ac instead of aa, bb, cc after x, y, z
Similar to this unanswered question about footnotes in MS Word.
When using an ordered list in LibreOffice Writer, the counter is incremented as:
a, b, c, ..., z, aa, bb, cc, ..., zz, aaa, bbb, ccc, ......
- 171
1
vote
2
answers
73
views
How do I kill libre writer from the cmd prompt? I tried killing swriter.exe but libre writer is still there
How do I kill libre writer from the cmd prompt? I tried killing swriter.exe but libre writer is still there
I've noticed that libre writer has a tendency to crash when I have quite a bit open on my ...
- 23.2k
0
votes
0
answers
40
views
Unsetting bash function having name of executable prevents further use of executable
I created a function to enable me to run libreoffice from the command line (under MacOS):
libreoffice () { open -a libreoffice "$@"; }
Wanting access to the base functionality of libreoffice,...
- 123
0
votes
0
answers
27
views
Combining sheets with different number of colums and rows
How can I combine two sheets with different number of rows and columns in Excel, Libre Office or Google Sheets? Example:
Sheet 1:
Name
Age
Phone
Mike
35
197 158 348
Dave
38
394 953 429
Sheet 2:
...
- 1
3
votes
1
answer
577
views
LibreOffice on Windows 11 - no light mode
I just installed LibreOffice 7.5.0.3, and out of the box, it looks very unpleasant - everything is black and high contrast.
I don't think it is supposed to look like this. I've tried changing Tools &...
- 143
0
votes
0
answers
17
views
How do I select every single Bézier curve in LibreOffice Draw?
As part of a cleanup process on a corrupted PDF, I need to delete every single Bézier curve from all pages. (Those are text objects which were erroneously converted to outlines, if you're wondering ...
- 125
-1
votes
1
answer
267
views
How do you move cells in LibreOffice Calc
I want to move cells in a LibreOffice calc document. For example, suppose I have:
a
b
c
d
I want to use the mouse or keyboard to select cell 'b' and get to:
a
c
b
d
I've tried various key ...
- 758
0
votes
0
answers
9
views
Is possible to format an XML text as in the web browser in a LibreOffice document? [duplicate]
I'm creating a manual of an XML service and I have an XML text that I copied from the web browser and want to conserve the format and colors that have in the browser on the document so is more easy ...
- 713
0
votes
0
answers
24
views
Installed and functional JDK declared 'defective' by LibreOffice
There are two accounts on my MacbookPro (10.13 ‘High Sierra’), users A and B. Both have admin privileges. LibreOffice Package 7.4.3.2 was installed with install option 'for all users' and has worked ...
- 19
1
vote
2
answers
119
views
Auto-generate page numbers next to hyperlinks for printing
I have a large (780 page) document which contains a huge number of hyperlinks. These work fine when reading electronically, but this is ultimately going to be printed. I'd like to turn the ...
- 21
0
votes
1
answer
38
views
LibreOffice Interior.ColorIndex hides cell borders
I've ported an Excel spreadsheet to LibreOffice 7.4 (on Windows).
The spreadsheet uses VBA / StarBasic to set the background color to yellow on 'warning' conditions, then sets the background color to ...
- 540
0
votes
1
answer
28
views
How to disable the built-in update nag on LibreOffice 7.3?
The good people making LibreOffice have built in a "Hey there's a new version" pop-up nag and toolbar indicator. It does this several times a day, even though I click to dismiss it every ...
- 452
0
votes
1
answer
98
views
Libre Office crashed but not closed. Will I lose unsaved changes?
Libre Office crashed. Will I lose unsaved changes.
I was doing my thing on the computer.. I tried pasting some pic into mspaint, rotating it, went back into mspaint.. maybe tried a paste.Suddenly a ...
- 23.2k
0
votes
1
answer
34
views
Can Libre Office Writer set alternate page identifiers in an exported PDF?
Some PDF documents I use show a variety of identifiers in the "Page" widget for the PDF. For example, I'm looking at a mass-media college textbook right now, and the Page widget shows:
&...
1
vote
1
answer
87
views
How can I add a new or custom toolbar in LibreOffice?
There is the so-called "Quick Access toolbar" (link to its Microsoft's Excel help page for it) in Microsoft Office products available. It consists of little icons for the included functions.
...
- 306
1
vote
1
answer
58
views
Open unzipped MS Office and LibreOffice files
MS Excel xlsx (and also ODS), are zip files containing XML files and folders of XML files:
[Content_Types].xml
_rels
docProps
xl
In order to track changes in Git, I have created a repo with the XML ...
- 109
0
votes
1
answer
120
views
Strange characters inserted by Libreoffice when opening a .csv file and then saving it (on Linux)
Here is what I did:
touch file.csv
Open this file in Libreoffice.
Pasted a tabular text from the internet.
Saved it in Libreoffice in Text csv format.
When I do the above, Libreoffice inserts 2 ...
- 103
0
votes
1
answer
36
views
Can I create multi-paragraph footnotes in LibreOffice Writer?
For a writing project I need to be able to do slightly complex footnotes, with multiple paragraphs that are justified and images that are centered.
While typing the text of, say, footnote 13, pressing ...
- 11
0
votes
1
answer
81
views
How can I copy and paste a string of characters into libreoffice calc with one character per cell?
ACDAEACCDDAEFFAFCCDFABAADACCCDDAFEDGABEGFCADEHBHACAGHACDEDECDAFAFAFCACDCDEAFCDFCGHDDFF
1 ACD.E..........F......................................................................
2 ...A...CD...F...........
- 224
0
votes
0
answers
36
views
LibreOffice python on Debian
My colleague has LibreOffice 7 installed on Debian 10 (linux 5.10). Python is installed as part of Debian. I also understand the LibreOffice was part of the default install.
There does not appear to ...
- 540
0
votes
0
answers
65
views
Why doesn't LibreOffice generate identical PDFs on different computers?
I have a batch file in Windows 10 to convert a PDF to a PDF/A using LibreOffice headless command like this:
@echo off
c:
cd "\Program Files\LibreOffice\program"
echo Please wait...
echo [**.....
- 1
1
vote
0
answers
183
views
macOS: how to verify software downloads with public key? [LibreOffice_7.3.7]
sry for wall of text... noob here (^.^) trying to learn about PGP / verifying download ‘LibreOffice_7.3.7_MacOS_x86-64.dmg’ on macOS? I think I know how to verify the download(?) but trying to ...
- 33
0
votes
0
answers
26
views
Update causing an issue
My Bullguard security system was recently bought over by Norton and the changeover was fine. Norton informed me that my Libre Office program was in need of an update. I clicked on 'Update' and my ...
1
vote
2
answers
97
views
How can I find which cells in a column (or at least the first one) are greater than a threshold in a LibreOffice spreadsheet.?
I have a LibreOffice spreadsheet (actually a CSV file open in spreadsheet).
It has several columns.
Something like this:
1,3,4
2,4,6
1,3,4
10,3,4
2,4,5
0,3,4
-10,3,4
I want to find in a column (say ...
- 748
0
votes
1
answer
142
views
How to highlight all cells that contain formulas
In LibreOffice Calc, I want to be able to quickly distinguish between cells that contain input data and formulas. Enabling "View → Value Highlighting" changes the font color in cells such ...
- 189
0
votes
0
answers
38
views
LibreOffice keeps crashing on Macbook when changing files?
I have issue where I will be organising docs, mostly Calc, and need to switch files, to copy data from one file to another.
While having Calc file open I will go to Dock and right click LibreOffice, ...
0
votes
1
answer
89
views
Spacing justify in Libreoffice writer: gaps between words
Using justify writing a text on libreoffice writer I obtain this
also the shape of the airfoil is
determined by requirements
contrasting.
I want to obtain this
also the shape of the airfoil is
...
- 306
0
votes
0
answers
65
views
How do you break large number of external links in LibreOffice?
I've created a large LibreOffice spreadsheet analysis project with a single Raw data file linked to multiple workbooks. The workbooks take a very long time to load/update/save, so I'm trying to ...
0
votes
1
answer
66
views
Creating a sortable monthly "period" formula in libreoffice
Every month I export data into a CSV format from a 3rd party site. The data is rows of daily data, the first column being a date field. Each month I have to manually add a new "Month Period" ...
- 101
0
votes
0
answers
34
views
Ubuntu Server Convert .xls/.xlsx to .csv Date format is being changed libreoffice/gnumeric
issue is: xls/xlsx file contains dates as d-m-Y (12-11-1997), but when i use libreoffice or gnumeric via the terminal to convert to csv, it changes the dates to d/m/Y (12/11/1997), and in some cases Y/...
- 1
2
votes
1
answer
248
views
What file extension do OpenOffice Dictionary files have?
I have a program that supports importing OpenOffice Dictionary files for use with its own spell checker, which I would like to do since the language I want to write in isn't available as a built-in ...
- 137
0
votes
1
answer
442
views
Change the orientation of just one page in Libreoffice?
I'm trying to change the second page of my document from portrait to landscape orientation without affecting the rest.
I found this question but none of the referenced tips work because they were from ...
- 158
0
votes
2
answers
493
views
How do I address a column in a named cell range
I have a named multi-column, labeled cell range. How do I access values from one of the columns?
Here's an example of the range:
Now, Calc will help me get the entire cell-range:
But what do I do to ...
- 246
0
votes
1
answer
104
views
Libre Office Calc List every wednesday
I'm trying to list the date every Wednesday in a column for a budget sheet. I think I need the DATE function, but I don't know how to find the "day" value of Wednesdays in an arbitrary month....
0
votes
1
answer
64
views
How to set the resolution of a macro exporting images of LibreOffice Writer pages?
Previously I've asked how to export all pages of a LibreOffice Writer document to images. I've got this answer.
I've adapted the macro towards my needs and this is my current code:
Sub ...
- 592
0
votes
2
answers
496
views
How to export all LibreOffice Writer pages in one go as images?
I've generated a serial letter with 300 pages. Each page is different and each page contains emojis. Due a bug in LibreOffice, emojis won't be displayed in the exported pdf: https://bugs....
- 592
0
votes
1
answer
41
views
My table in word document got compressed
I have created a table in a word document, but when I closed the file and re-opened the cells got compressed.
But my table had proper content earlier :
I tried expanding it sevral times , but I am ...
- 103
0
votes
0
answers
21
views
How can I delete a "content" box in a serially converted .odp file without LibreOffice Impress automatically resizing the "title" box
I have a .odp file with a single slide (representing a poster) that started life as "Title and 4 Content." The "Title" box has been resized, and the internal formatting changed. ...
- 41