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.
309
questions with no upvoted or accepted answers
2
votes
0
answers
649
views
Typing math formulas in LaTex and getting them in MathType format?
I am asked to type some math formulas that can work in Microsoft Office and MathType equation editor.
But I only have access to Ubuntu 12.04 near me, there is LibreOffice available under Ubuntu as ...
- 17.3k
2
votes
0
answers
290
views
How are the 2010 OpenDocument Text (.odt) from OpenOffice and the 2012 one from LibreOffice different?
As you probably know when you're reading this question, an .odt file is just a .zip file containing some folders and .xml files.
I used to appreciate this, for I could make a document with keywords ...
- 564
2
votes
0
answers
312
views
Querying DB2 view from Libreoffice Base
I've created a view in DB2 that has the information I need for labels that I was hoping to print out from LibreOffice. When I query the view from the console ("SELECT * FROM ADDRBOOK.LABELS"), I get ...
- 166
2
votes
1
answer
837
views
LibreOffice Writer - Add footnotes outside of two-column layout?
I have a multi-page two-column document as shown
here. When I add footnotes by using Insert > Footnote, the footnotes end up inside the respective column. Is it possible to create footnotes (not ...
- 121
1
vote
0
answers
12
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 ...
1
vote
0
answers
19
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
0
answers
117
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
1
vote
0
answers
60
views
how to find the undesirable formatting in a presentation/slides such as bold or Symbol font
My manager told me he think in some places of my presentation file he noticed inappropriate formats such as bold and Symbol font. Is there an easy way, preferably free like in free beer way to search ...
- 155
1
vote
0
answers
588
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
1
vote
0
answers
2k
views
Open PDF in LibreOffice without (bad) OCR text
Whenever I open a PDF in LibreOffice Draw, it opens the PDF and adds some (bad) OCR text on top of it, making the document unreadable. I have to spend a long time selecting the text and deleting it, ...
- 755
1
vote
1
answer
38
views
How to style Bibliography codes
Consider inline bibliography in a document, created by Insert > Bibliography Entry > New. This way, I can insert a short code for each bibliography at a place in the document as i chose. See ...
- 127
1
vote
1
answer
538
views
Why is LibreOffice not detecting the theme?
https://draculatheme.com/libreoffice
I followed the instructions and put dracula.soc in C:\Program Files\LibreOffice\share\palette.
Closed and restarted LibreOffice Writer. Went into all the options. ...
- 11
1
vote
0
answers
67
views
Update styles automatically
When you open a document that is based on the template that has been changed since the last time you edited the document, there will be a warning message:
Is there a way to avoid this window and ...
- 873
1
vote
1
answer
531
views
Disable line correction in LibraOffice Draw's FreeForm line
I am using LibreOffice Draw's FreeForm line in order to achieve pencil-like drawing abilities in LibreOffice draw. I tried it and the main problem with it is that it doesn't draw exactly what I draw ...
- 141
1
vote
1
answer
37
views
Some elements in LibreOffice are black
I'm using Fedorea 34. All LibreOffice applications have some elements that are completely black. What can I do?
LibreOffice Writer:
LibreOffice Calc
- 13
1
vote
0
answers
98
views
(LibreOffice] Bootstrap variable for opening file in "Slide Sorter" tab
I want to open LibreOffice Impress files such that LO starts with the 'Slide Sorter' tab on top (selected?) rather than the "Normal" tab.
I am using linux and would like to do this using the ...
- 113
1
vote
2
answers
213
views
LibreOffice SUMIF specific time
I'd like to sum order totals and have 2 subtotals for orders taken before and after 17:00.
The formula: =SUMIF(C:C,">17:00",D:D)
where C and D columns are:
The formula does not work well....
- 111
1
vote
0
answers
226
views
LibreOffice Impress converts vector images to raster images
I am using LibreOffice Impress 7.1.2.2 on Arch Linux / Gnome and my problem is that Impress converts my vector images to blurry low resolution rastered images when changing and saving an existing ....
- 471
1
vote
1
answer
248
views
Create space AFTER each section in Libreoffice Writer
I want to leave some blank space at the end of each subsection of a document.
+---------------- Page 1/2 -+ +---------------- Page 2/2 -+
| 1. SECTION | | text text text ...
- 2,252
1
vote
0
answers
622
views
LibreOffice supporting links between slides in a PowerPoint presentation
When a PowerPoint presentation (.pptx file) has internal links between slides, it is possible to get LibreOffice Impress to support these — such that the user displaying the presentation can be taken ...
- 304
1
vote
1
answer
258
views
How to enter user and password for WebDAV server on LibreOffice?
I am trying to configure a NextCloud WebDAV remote location on LibreOffice Writer 7.0 following these instructions: https://help.libreoffice.org/latest/en-US/text/shared/guide/digitalsign_receive.html
...
- 169
1
vote
1
answer
204
views
Calc/Excel aggregating data with same ID
Hello i have to solve this problem in Libreoffice Writer or excel.
I have a table like this:
ID V1 V2 V3 ...
1 10 20 30 ...
1 30 40 50 ...
1 5 7 8 ...
.. .. .. ....
- 11
1
vote
1
answer
516
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 ...
- 11
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, ...
- 664
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 ...
- 11
1
vote
1
answer
620
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'...
- 113
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 ...
- 489
1
vote
1
answer
605
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 "%%...
- 11
1
vote
1
answer
176
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'...
- 111
1
vote
0
answers
448
views
Libreoffice converting docx to pdf in headless mode hangs
Libreoffice: 6.3.1.2
cmd: --headless --convert-to pdf \"$basePath\" --outdir \"$dirPath\"
Can we set timeout to operation? or any other suggestions. So I want result that operation is not successful.
- 21
1
vote
0
answers
54
views
Libreoffice: create multiple rows from 1, depending on row content
I have a style sheet in Libreoffice, like this:
DateA | DateB | DateC | DateD
---------------------------------------
John | 1 | 1 | 0 | 1
Mary | 0 | 1 | 0 | 1
...
1
vote
0
answers
591
views
LibreOffice Calc: conditional formatting with gradient only non-zero values
I have a set of cells which I would like to format conditionally. If they have a non-zero value, I want them to be formatted with a 3-color gradient (green for min, yellow for 0, red for max); if they ...
- 121
1
vote
0
answers
27
views
LibreOffice Calc stop slow search
I have attempted a text search on a large (500 000 row) spreadsheet that has crippled LibreOffice for the last 20 minutes. How can I stop it?
It has interrupted all open documents, not just the one ...
- 678
1
vote
0
answers
113
views
LibreOffice: Color world map based on spreadsheet
A few times I wanted to color a world map based on values in a spreadsheet.
Is there some way I can do that?
In general I will have a spreadsheet with 2 columns: Country and value. But I can often ...
- 4,809
1
vote
0
answers
234
views
Adding language (Dutch) to LibreOffice Writer
I'm having trouble doing a spelling check in LibreOffice (in Dutch). It supposed to come with the package but it doesn't show in my screen (see image: no abc mentioned before 'dutch').
I tried:
...
- 111
1
vote
0
answers
569
views
Fixed column width for CSV files
I use LibreOffice (6.1.6.3) Calc to work with CSV files.
Some of these files have very long text in their "cells". When I open such file in Calc, the Calc tries to make the column as wide as possible....
- 296
1
vote
1
answer
466
views
LibreOffice fails to export PDF containing arabic letters
I used LibreOffice to write an arabic document.
When exporting this document to PDF through the LibreOffice "File -> Export...", I get an unexpected result: the PDF is different from the original ...
- 11
1
vote
0
answers
38
views
Widowed pilcrow (non printable ¶ at line begining) in LibreOffice
I'm struggling with widowed pilcrows (i.e. non-printable ¶ at beginning of lines). This happens only in footnotes, on page-breaks, and it adds a space between the footnote's rule and the first ...
- 11
1
vote
0
answers
141
views
Updating GCC from 4.2.1 in XCode 9.4.1 while keeping the rest to be the same
I am trying to build LibreOffice, which indicated on its guide that I must use XCode 9.4.1 as follows:
NOTE: If you try to build LibreOffice on macOS Mojave 10.14, please use Xcode 9.4.1, otherwise,...
- 111
1
vote
1
answer
361
views
How do I replace all fragments of text written in uppercase with lowercase applying a particular style in LibreOffice Writer?
I've received a paper written in a plain text editor and I am to re-format it into a proper quality document. The original documents uses UPPERCASE to emphasize on particular elements of a sentence (...
- 7,523
1
vote
0
answers
219
views
Can I see the precise reason why LibreOffice thinks an .xlsx file is corrupt?
I've created a file using NPOI which Microsoft Excel can open, but which LibreOffice says is corrupt. It doesn't however give any kind of detailed explanation.
Is there a way to get more information ...
- 113
1
vote
0
answers
69
views
Why font is changed automatically in LibreOffice for Linux?
I'm using LibreOffice 6.1 on Linux Mint 17. I would like to create a presentation using Impress. I set the font to Droid Arabic Naskh. Then, I save and close the file. When I open it again, the font ...
- 269
1
vote
1
answer
634
views
Can I use Excel keybindings in Libreoffice Calc?
LibreOffice Calc has its own set of keybindings, which is different to those in Excel.
Is there a "compatibility mode", or some way to match Excel's keybindings?
I know I can change the bindings one ...
- 638
1
vote
1
answer
4k
views
How can I add duplicate rows to LibreOffice Calc to make there be one per day?
I have some data like this (it's stock market data)
29/07/2015 35972.82 32056.2 17751.39
30/07/2015 35961.86 32046.43 17745.98
31/07/2015 35848.13 31945.08 17689.86
03/08/2015 ...
- 2,148
1
vote
0
answers
204
views
mixing roman numbers and arabic numbers in page numbering in libreoffice
In libreoffice, my first couple pages should have page numbering in roman numbers: i, ii
Then, after a couple of pages later, it should start with arabic numbers; 1, 2 ...
I applied what is written ...
- 121
1
vote
1
answer
1k
views
How do I lock some columns and some rows in a Libreoffice Calc worksheet?
I am using Libreoffice Calc 5.2.0.4.
I am building an appointment book. This book has many sheets/ pages.
I am not experienced, so I was experimenting on different sheets. And now I have three ...
- 31
1
vote
1
answer
4k
views
Creating different headers for LibreOffice
I am trying to find out how to edit the header of two sections in a LibreOffice document, who apparently somehow have merged to be under just under ONE header. I want to split the two sections, so I ...
1
vote
1
answer
36
views
LibreOffice: Changing corporate colors in documents
We have a lot of corporate documents. These contain colors: colors of foregrounds, backgrounds, graphical elements. Let us assume management wants us to change colors.
Is it possible to search/...
- 4,809
1
vote
0
answers
251
views
Libre office pdf export is not correct
I am trying to export my libre draw file to PDF. When I do so, some text is removed, and the positioning of one of the boxes is off.
I have tried viewing in multiple pdf viewers.
I am running on ...
- 585