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.
892
questions
0
votes
0
answers
723
views
How to set the color of the input bar in LibreOffice Calc spreadsheets (for dark theme/mode)?
In LibreOffice Calc, I have been able to almost configure a usable dark theme/mode.
To accomplish this, go to Tools > Options... > LibreOffice > Personalization and set the dark theme, and ...
1
vote
1
answer
94
views
Table of Contents - page numbers separated using fixed number of spaces
Is there a way to create a following table of contents?
Aaa 1
Bbbbb 15
Cc 25
Page numbers should be separated from text using spaces, not tabs.
With tabs, it looks ugly:
Aaa1
Bbbbb 15
...
3
votes
1
answer
10k
views
How do you draw freehand (like a pencil tool) in LibreOffice Writer?
How do you draw freehand in LibreOffice Writer? Is there a "pencil tool"? I have a Wacom tablet and I want to use it there.
0
votes
1
answer
280
views
Cross-referencing from a master document: "Error: Reference source not found"
When creating a cross-reference (in my case a reference to a numbered list item) in a master document to an item in a subdocument, the reference appears to work correctly but when the master document ...
1
vote
1
answer
507
views
in libreoffice, find and search columns when one has something, the other is empty
one column has nothing, the cell is empty, the other column has a string
how do I find those? there are columns A and B in my sheet, and I need to find the rows in column A that have something ...
0
votes
1
answer
1k
views
Libre Office Sign a PDF with PGP key
I'm currently facing an issue with the "Sign" feature of Libre Office. I can digital sign my ODT files without a problem. That means I can select my pgp key in the list of keys and sign the ...
0
votes
1
answer
2k
views
Insert "Copy" button in pdf
I want to add a button to a pdf that will copy some text to clipboard when clicked. Is it possible? If yes, how? I'm using LibreOffice Writer.
0
votes
1
answer
35
views
XLS: 'if statement' calculation
I have a cell B19 which consists of taking the value of another cell and dividing it by 5:
=B15/5
However I'd like to change it so that it only divides it by 5 if the B15 is more than 1000... and for ...
0
votes
1
answer
216
views
How to generate a combination of cells in LibreOffice?
I want to generate a cell with a combination of data I've insterted in specific cells in LibreOffice. Can anyone comment?
This is what I'm after ( I'd like a slash in between the data):
example
2
votes
1
answer
233
views
How prevent objects from snapping back into position in LibreOffice Writer?
How can I disable this super-annoying "feature" causing objects (e.g. a drawn rectangle) to snap back into its original position when doing drag & drop? I simply want to translate a ...
0
votes
0
answers
80
views
Hide scrollbar in Libre-Office Draw
I know for sure, you can hide the scrollbars in Calc and Writer.
Is this also possible in Draw?
I am running:
windows 10
draw Version: 6.4.4.2 (x64)
2
votes
0
answers
807
views
LibreOffice download disallowed by Chrome
I'm rebuilding my PC and therefore have the latest version of Chrome. I tried downloading LibreOffice but Chrome continually stops the download with "This file can't be downloaded securely". ...
1
vote
1
answer
2k
views
Export LibreOffice document comments as PDF annotations
I would like to export to PDF a particular LibreOffice document that has many comments without losing them. According to the manual this should be possible:
Comments as PDF annotations
Select to ...
3
votes
2
answers
1k
views
Libre Office - Single Column Pie Chart
I want to create a pie chart, for a single column that looks like this:
I tried to select the range, click on Insert -> Chart -> Pie-Chart, but regardless of what I try, I always get an empty ...
0
votes
0
answers
1k
views
LibreOffice Writer - Create and apply table style
I have a bunch of tables in a Writer document that I would like to style in the same way. I selected a table, then opened "Table Properties" and modified the borders and background colors.
...
0
votes
2
answers
142
views
Sum of column if the value in that column's cell is the maximum in the row?
I have a spreadsheet with eight columns and many rows. Each column represents a price with a vendor. Each row represents a product.
I'd like to add a top row that is the sum of each product at that ...
1
vote
1
answer
8k
views
How can I escape commas in a CSV file?
I thought there were two ways to do this: either enclose the field containing the comma in quotes, or place a backslash before the comma. However neither of these is working; when I load up the CSV ...
1
vote
1
answer
120
views
How to integrate LibreOffice Help files with a portable version of LibreOffice?
I've downloaded LibreOffice Help .MSI package and installed it into a separate folder. Now, how to make Help run on F1? I need to learn how to create Writer documents in landscape mode. Strangely, in ...
1
vote
0
answers
48
views
Why can't Libreoffice on FreeBSD save to Google Drive?
There are instructions out there on configuring "Remote Files" in LibreOffice.
However, in my case, the Google Drive is not among the available options. Indeed, the instructions say, ...
1
vote
1
answer
1k
views
How to format only the odd (or even) rows in LibreOffice Writer
I want to create a table like the one in this image in LibreOffice.
Is it possible in LibreOffice?
1
vote
2
answers
3k
views
Detect duplicate values in an unsorted column in LibreOffice calc? (Q&A)
I have a table, where one column is intended to represent unique IDs. Is it possible, to check with a formula, if the uniqueness criterion is fulfilled?
For instance, let's say the table is currently ...
1
vote
1
answer
286
views
Censoring/pixelizing sensitive information with MS Paint?
I need to post a screenshot for a bug report or superuser/stackoverflow question, that contains sensitive information, and have only MS Paint available at the PC at hand.
Since layout issues are part ...
0
votes
1
answer
143
views
Libre Office spellchecking actions gone after reloading
I'm working on a Libre Office Writer Document where I want to be able to use multiple languages. 10 % of the document are in language X and 90 % are written in language Y. So I set my Writer Language ...
0
votes
1
answer
69
views
Count all occurrences matching categories of list
I use a spreadsheet for budgeting and have individual sheets containing transactions for each year and another sheet categorising strings for my outgoings.
For example:
A2=Food | B2=ALDI
A3=Food | B3=...
0
votes
0
answers
270
views
OpenOffice: different font weights
I'm using OO for Mac, although I've had this same problem with LibreOffice and I think maybe MS Office too.
And the problem is that, for fonts that have a lot of different weights, I can only use ...
0
votes
1
answer
923
views
How to retrieve currently open documents in LibreOffice (calc, writer, etc.)
I need to read / retrieve / get / enumerate currently open documents in any LibreOffice app (Writer, Calc, Present, Draw), on linux.
What I tried:
Searching the command line history is not helpful: ...
0
votes
1
answer
674
views
Conditional formatting with Libreoffice Calc activated with a letter and the condition being applied to more than one cell
Is there a way to do condition formatting based on a letter and having that format apply to more than one cell?
The desired result is shown below, where typing either A, B, or C in column "B"...
8
votes
3
answers
8k
views
The maximum number of columns per sheet was exceeded
When i tried to open some MS Excel files in LibreOffice Calc i get this warn. I searched solution of this issue but i did not find useful things. How can i increase number of column limit?
1
vote
1
answer
1k
views
Can LibreOffice be told to enter some kind of "focus mode"?
I'm sitting here trying to go through this massive document that I have written, and it's Hell.
I keep wishing that I could somehow easily enter a mode in which the entire document, except for the ...
1
vote
1
answer
616
views
how to change address based on a value in another cell in Libreoffice Calc?
I need to pull data from the source spreadsheet $Units_Weekly, from a changing column.
The start is column O ----> $Units_Weekly.$O2
Column name changes in A50. The next column name will be P,
it'...
0
votes
1
answer
383
views
How come LibreOffice is lacking a desktop publishing program?
I've looked through all the applications now and none of them seem suitable for creating an e-zine or newspaper or magazine or something. Maybe Writer comes the closest, but it would be a very limited ...
3
votes
3
answers
9k
views
How do I make LibreOffice Writer use page numbers?
I've spent an hour now going through every single menu in the entire LibreOffice Writer program, and searching online. There is no way to set it to use page numbers. It lets you select which "style" ...
1
vote
1
answer
162
views
libreoffice writer - default spacing between sections
When I write libreoffice docs (.odt files) I usually like to organize content into separate sections (Insert -> Section).
I also would like to leave a minimum space of one line between each others. ...
5
votes
1
answer
2k
views
Both '.' and ',' for decimal separator in LibreOffice Calc?
I have read How to set decimal separator in Libre Office Calc? but I haven't found an option for this:
Is it possible to set both . and , as decimal separator in LibreOffice Calc?
In France it's , ...
2
votes
2
answers
4k
views
Export to PDF with LibreOffice command-line, selecting an output filename
This works to export a PDF:
C:\Program Files\LibreOffice\program\soffice.exe --headless --convert-to pdf test.doc --outdir .
but it doesn't allow to change the output filename. I found the option to ...
0
votes
1
answer
1k
views
How to combine multiple jpg/image files into a single PDF using LibreOffice
I'm used to working with Adobe Acrobat and really enjoyed the "Combine files in Acrobat" context menu in Windows 10.
I have recently installed LibreOffice 6.3.5 but I haven't been able to find a ...
4
votes
0
answers
475
views
libreoffice how to digitally sign pdf export with gpg key
I am trying to export as a pdf and add a signature, or add a signature to an existing pdf, but whenever I try to export, after selecting a gpg key to use for the certificate (I don't fill in any of ...
0
votes
1
answer
340
views
Runtime error when iterating over cells in LibreOffice Calc
I have a table where the values are very large, in order of millions. Basically I want to iterate through all the cells(In a particular column) and divide each of them by some number (like 10,00,000).
...
1
vote
0
answers
42
views
Can LibreOffice render images in HTML without the "file:///" path prefix?
I have a bunch of HTML docs with images stored a local JPEG files specified as follows:
<img src="c:/data/image.jpg" alt="FOO">
When I load these HTML into LibreOffice, the images are not ...
0
votes
1
answer
322
views
Opening a file, Writer complains "unable to lock file"
Using Windows 10 I had to change my user with one that uses Active Directory (AD), meaning I got a new SID and %userprofile% path.
After copying and adjusting hopefully all files, settings, and some ...
0
votes
0
answers
219
views
libreoffice replace paragraph breaks
I have a songbook, but at the end of each line, there is a paragraph break. Any song, that exceeds one page gets split up somewhere in the middle of a verse. I could manually fix each song, there is ...
2
votes
0
answers
858
views
Libreoffice convert-to set outfile name
I'm trying to convert a file with libreoffice, but I know I can use the -outdir but that puts in a directory, is there any way to have it actually output the filename as I suggest?
Currently I'm ...
1
vote
1
answer
597
views
Output converted file in same folder as input file
I'm using the following command in a batch file, to convert to .odt format:
for /r %%i in (*.docx) do start /wait "" "c:\program files\libreoffice\program\soffice.exe" --headless --convert-to odt "%%...
2
votes
1
answer
3k
views
Setting libreoffice UI font size in LO 6.1.5.2
How can I make the UI (menu bar in particular) font size larger? The LO 6.0 user guide, which seems to match the 6.1.5.2 interface, claims there's a "User Interface - Scaling" control under Tools / ...
0
votes
2
answers
3k
views
Is there an equivalent of "non breaking spaces" for line breaks?
Non-breaking spaces are a small piece of whitespace that can be used to keep two words united in a line.
In Microsoft Word or Libre Office Writer, how do people use line feeding/breaking in a way ...
0
votes
0
answers
198
views
LibreOffice Calc - Get the value of a cell of the next empty row in calc
I have a four-column table with multiple rows with headings Weeks Amount Balance and True.
How can I get the Amount of the row that the last column that doesn't equal true?
0
votes
1
answer
784
views
Open/read sheet-password protected `.ods` using vba from excel?
Scenario
In an attempt to read cells from an .ods file that is readible and editable without requiring any password, but which has some data validation cells, I am experiencing slight technical ...
1
vote
1
answer
68
views
Can I get this Perl command on Windows to not generate dates with apostrophes in LibreOffice?
Based on the help I got on this question, I have this Perl command that I run in Windows 10 PowerShell:
ls |% { $_.Name } | perl -pe 's/(.)(.*)_(\d{4})(\d{2})(\d{2})_(\d+).jpg/\u$1$2,$3-$4-$5,$6,$&...
0
votes
1
answer
40
views
100Mb X.odt file on my computer converted to a 20Kb X.odt folder
recently a 100Mb X.odt file on my computer converted to a 20Kb X.odt FOLDER!!
i made that file years ago via microsoft word and recently edited it with libreoffice in linux
is there anything related ...
0
votes
1
answer
634
views
How to Install LibreOffice Python on MacOS
I'd like to use Python to manipulate LibreOffice documents using the UNO API. I have LibreOffice 6.3.4.2 and Python 3.7 on MACOS (OS X).
I find doc which says UNO is available in the Python shipped ...