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
1answer
21 views

Why doesn't LibreOffice Writer have a feature like this? Or does it? [closed]

Frequently, I want to know if a word that I have marked is the first instance of that word in the document. It's anything but obvious how to do this, and due to the program's lack of any sane bookmark ...
0
votes
0answers
11 views

how to clear charater style in libreoffice?

I have loaded style sheets which contain all the paragraph styles. However, when I try to apply the style, it actually does not change the font. The reason is there is a second layer called character ...
0
votes
0answers
19 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
1answer
29 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
0answers
29 views

Is there really no *proper* bookmark feature in LibreOffice Writer?

Lately, I've got used to LibreOffice Writer and find it to be very helpful and nice to write in it, compared to the plaintext files I used before it with Notepad++. However, there is one seriously ...
0
votes
0answers
11 views

In LibreOffice Writer, how do I set the “new sentence indentation”?

I have found all features I need now, except for the "new sentence indentation". That is, the space between each sentence in a paragraph. This is an example. Here begins a new sentence. I want the ...
0
votes
1answer
32 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 ...
0
votes
1answer
32 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" ...
0
votes
0answers
15 views

LibreOffice Calc arbitrarily crops first and last two data points

I'm currently using LibreOffice 6.1.5.2 for Linux. When creating a chart from a simple XY dataset, the program just arbitrarily chops away the first and last few datapoints. I would like to restore ...
1
vote
1answer
15 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. ...
2
votes
1answer
225 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 , ...
0
votes
0answers
26 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
0answers
10 views

How to pivot multiple rows into one by placing them next to each other in LibreOffice Calc?

Let's say I have data like this, showing what video games each person owns (not my actual data but that's sensitive information): Name Game Publisher ---- ---- ----...
0
votes
1answer
73 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 ...
2
votes
0answers
32 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
0answers
15 views

gpgsm how to generate a key for signing a pdf

I am trying to sign using a gpgsm key. Anything wrong with or to improve with these steps? Trying to generate a key gpgsm --gen-key selecting existing key (from my gpg keyring) gpgsm asks for a ...
0
votes
1answer
26 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
0answers
20 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
1answer
18 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
0answers
18 views

How to add time as number format on libreoffice

Every time I add time with keyboard shortcut it always appear as time. How do I automatically get the number format when I add the time?
0
votes
0answers
6 views

How to fix phonetic symbols in LibreOffice Writer displayed as 0?

I have an ODT file of full of phonetic symbols in a table in an LibreOffice Writer 6.2.1.2 document on Windows 10. For unknown reasons, all the table entries containing one or more such symbols have ...
0
votes
0answers
17 views

Libreoffice Calc paste over filtered rows

I have a problem pasing text over filtered rows in Libreoffice calc. Imagine I have 1000 rows and, when I apply a filter over them, the result is 50 visible rows. Well, if I copy a text with 50 ...
0
votes
0answers
50 views

Can subdocuments be edited from a master document in LibreOffice?

I've got a master document with a large number of subdocuments linked to it. However, I am unable to edit any of them unless I open the individual files. I'm fine with doing this, but for convenience, ...
0
votes
0answers
50 views

LibreOffice Calc, how to start multiple instances with the same file open?

Say I have a spreadsheet file /home/amoe/foo.ods. Imagine that I already have this file open in Calc. I want some way, perhaps a command line option, that would enable me to run localc /home/amoe/...
0
votes
0answers
28 views

LibreOffice menu bar formatting condensed

At some point today my LibreOffice menu bar items were combined tightly next to each other. Also, the file save dialog changed such that I can't type in the item to be saved. This seems to be only ...
0
votes
0answers
21 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 ...
0
votes
0answers
64 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
1answer
132 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 "%%...
1
vote
0answers
55 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
2answers
98 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
0answers
43 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
1answer
80 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
1answer
41 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
0answers
20 views

how to debug the integration of ibus with libreoffice (redhat 7.6)

I'm running on a RHEL 7 system. I'm trying to get Japanese input to work in libreoffice applications. The input worked fine on the same system for RHEL 6 but I having issues now. When Japanese is ...
0
votes
1answer
28 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
1answer
45 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 ...
0
votes
0answers
88 views

Libreoffice wipes the PRIMARY buffer when un-selecting/de-selecting selected text. How do I prevent this?

In virtually all X-windows applications, selecting text effectively (see below) copies it to the PRIMARY selection buffer. In most, un-selecting that text (e.g., by left-clicking elsewhere in the same ...
2
votes
1answer
126 views

Libreoffice Calc: Pinning a column to multiple sheets?

I have a libreoffice calc document with multiple sheets. In the first sheet, I have a column that I want to be repeated as the first column in all other sheets. I know that I can reference cells ...
0
votes
3answers
41 views

Vlookup is not working fails with N/A return despite i have value

My Vlookup function isn't working, it fails with N/A despite the fact that I have values. Have a look in screenshots how can i solve it See File
0
votes
1answer
170 views

LibreOffice Writer: How to rapidly set some text to SMALL CAPS?

In LibreOffice Writer, whenever I need to transform some text to SMALL CAPS, I go through these steps: Select the excerpt that I need in Small Caps; Right-click on it and choose Character > ...
0
votes
0answers
4 views

Is it possible to generate an “inverted” table that swaps data and columns in LibreOffice?

For example, consider the table - _ _ A|B C X|B Y H|Y C J|G N I would like to transform this into: - _ _ B|A,X C| A,H G|J N| J Y|H X
0
votes
0answers
9 views

Exporting documents includes original filename

If I want to export an Excel sheet to PDF in LibreOffice, it always includes the original filename at the bottom of the PDF pages. Is there an option to disable this behaviour?
0
votes
0answers
86 views

Libreoffice Impress Does Not Display Full Screen Slide Properly?

I'm trying to display a slide as full screen, however it displays the slide like this instead of taking up the full screen: Strangely enough, it does the proper behavior (Showing the slide as full ...
0
votes
0answers
25 views

Convert LibreOffice Writer formula to plain text

Is there a way to automatically "flatten" all formula objects in a LibreOffice Writer document into plain text, e.g. to the plain-text representation one uses to type the formulae in the formula ...
1
vote
1answer
62 views

How to copy a new line from libreoffice calc to txt?

I have the following function in cell 'B2' a libreoffice calc document: =CONCAT(A1,CHAR(10),A2,CHAR(10),"end") Which, with in cell A1="function plotName = getPlotName(plotData)" and A2=" plotName ...
2
votes
1answer
146 views

How do I join 2 tables in LibreOffice Calc?

I looked up one of the other answers here but it's not helping me. I have 2 sheets and I'm trying to join 2 columns from my Sheet2 to my Sheet1 by joining on a common column- Sheet1- Sheet2- When ...
1
vote
1answer
33 views

Libre Calc: Creating Formula to Add Rows (D thru I) to Another Row (J)

LibreCalc: Help Creating a Formula to Add Rows ( under D thru I) to Another Row under(J)and would like to have descending Rows do the same thing with different input data. Say Row 2 (D to I) has a ...
0
votes
0answers
26 views

When a match is found, the whole cell is shown highlighted, but only the text found will be replaced in LibreOffice Calc

I want to replace the whole cell, can someone help? For example, searching for htmlPath will highlight a cell containing "htmlPath":"F:\amazon_mp3\1/1053",, and replacing with }, will leave the cell ...
1
vote
1answer
35 views

Forcefully Remove Documents from LibreOffice Document Recovery List

I've been having this issue with LibreOffice where whenever I open it I get the document recovery window below: LibreOffice Document Recovery The document it's referring to is unrecoverable and I don'...
0
votes
0answers
29 views

How Can I Break Up a Spreadsheet into X rows?

I'm using LibreOffice Calc on Linux Mint 19 and am trying to find an easy way of turning a 100k row spreadsheet into 10 10k spreadsheets. I tried seeing if an option was available in the Data menu ...

1
2 3 4 5
15