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.

Filter by
Sorted by
Tagged with
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 ...
End Anti-Semitic Hate's user avatar
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 ...
user90726's user avatar
  • 873
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.
Aria P74's user avatar
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 ...
Jon Bentley's user avatar
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 ...
Nestor M's user avatar
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 ...
White's user avatar
  • 111
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.
AmirSina Mashayekh's user avatar
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 ...
user avatar
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
uhl's user avatar
  • 1
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 ...
david's user avatar
  • 337
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)
ahk_user99's user avatar
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". ...
Lefty's user avatar
  • 172
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 ...
Luís de Sousa's user avatar
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 ...
Kyu96's user avatar
  • 127
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. ...
Davide_sd's user avatar
  • 101
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 ...
JoshuaD's user avatar
  • 875
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 ...
ekolis's user avatar
  • 479
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 ...
Mirza Beglerović Raven's user avatar
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, ...
Mikhail T.'s user avatar
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?
Max's user avatar
  • 135
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 ...
kdb's user avatar
  • 2,252
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 ...
kdb's user avatar
  • 2,252
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 ...
Paul Erlenmeyer's user avatar
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=...
grogoreo's user avatar
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 ...
user avatar
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: ...
Berry Tsakala's user avatar
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"...
plu's user avatar
  • 481
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?
Mesut Çiftçi's user avatar
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 ...
Mor A.'s user avatar
  • 11
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'...
LetzerWille's user avatar
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 ...
Tysheim's user avatar
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" ...
Kypton Henin's user avatar
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. ...
xyx's user avatar
  • 253
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 , ...
Basj's user avatar
  • 1,789
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 ...
Basj's user avatar
  • 1,789
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 ...
quant's user avatar
  • 484
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 ...
SultanLegend's user avatar
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). ...
neel g's user avatar
  • 103
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 ...
I Z's user avatar
  • 489
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 ...
U. Windl's user avatar
  • 609
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 ...
aky-her's user avatar
  • 123
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 ...
nadermx's user avatar
  • 745
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 "%%...
Porte's user avatar
  • 11
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 / ...
Jon's user avatar
  • 41
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 ...
174140's user avatar
  • 94
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?
bckelley's user avatar
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 ...
a.t.'s user avatar
  • 393
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,$&...
Questioner's user avatar
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 ...
Raul's user avatar
  • 1
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 ...
Kevin Kleinfelter's user avatar

1
3 4
5
6 7
18