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.
891
questions
-2
votes
2
answers
473
views
How can I type in uppercase only in LibreOffice?
I know that I can use Format -> Text -> Case in LibreOffice to change text to uppercase when it is selected afterwards, but I would like to type directly in uppercase all the time, without ...
0
votes
1
answer
81
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:
...
- 2,883
5
votes
3
answers
3k
views
Is there a way to convert 1K to 1000 and 1M to 1,000,000 In LibreOffice Calc
I need to sum a large data set, but the values are entered as K or M. Is there a way to change these convert these to numerical values? I was thinking of using find and replace to change M to 000000, ...
- 1
3
votes
1
answer
4k
views
Specifying printing options to LibreOffice on the command line?
I'm attempting to come up with some means of converting .pptx files to a PDF format from the command line. I have set up a cups-pdf printer to which I can actually send jobs, and so far I have it ...
CommunityBot
- 1
0
votes
1
answer
65
views
Use a subset of system fonts for LibreOffice, on GNU/Linux
I have a lot of system fonts in my GNU/Linux distribution (in /usr/share/fonts/): most of them are useless for me when I'm using LibreOffice to write or to open a document.
I'm using my distribution ...
- 491
3
votes
1
answer
1k
views
Where is the <code> style in LibreOffice?
LibreOffice doesn't seem to have an equivalent to the HTML <code> style for paragraphs. (They have Preformatted text but that's for characters, not paragraphs.)
I am using the Styles and ...
- 2,252
0
votes
2
answers
18
views
Issues changing CSV column type to date in LibreOffice
I encountered some trouble changing cell types in LibreOffice Calc from text to dates.
This happens when I import a CSV file. The import into rows and columns works fine. However, the dates are not ...
- 29.7k
-1
votes
0
answers
21
views
How can I create a full page workspace in LibreOffice Writer?
I prefer working with web view in LibreOffice writer. I'm working on a single web page with text in a single table. Very simple. Is there a way to make the table span the entire workspace, instead of ...
1
vote
0
answers
11
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 ...
3
votes
1
answer
4k
views
Can MS-Word open encrypted ODT-Files
Is it possible to open LibreOffice encrypted documents using MS-Word 2010? The data format is odt and the password is known.
Is the encryption secure?
CommunityBot
- 1
3
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 ...
CommunityBot
- 1
-3
votes
1
answer
31
views
Libre Office writer How to print only page 2 of a 5 page writer document
My operating system is Windows 10, Printer is HP color laser jet CM1312nfi MPF, LibreOffice 7.5
I have created a Libre Office writer 5 page text document with 1 "picture" a screen shot of a ...
- 1,890
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
9
votes
2
answers
8k
views
What metadata does a LibreOffice file contain and how to remove it?
I am using LibreOffice on Linux. One way I know of viewing and removing metadata from a LibreOffice file is going to File -> Properties -> General, unchecking “apply user data” and click reset. ...
- 1
6
votes
4
answers
9k
views
Need today's date as default value in a form field in Libre Office
New to Libre Office Base.
I've found how to set the default value in a table to the current date. Now I need to have the current date show up in the corresponding field in a form.
I have tried ...
- 113
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 ...
CommunityBot
- 1
1
vote
1
answer
64
views
Automatically center Japanese ruby text in LibreOffice
I have activated Asian Phonetic Guide in LibreOffice to add furigana to Japanese words but every time I open it up, it adds the furigana on the left (which I assume is a result of the style I have ...
- 115
1
vote
1
answer
33
views
change language for pdf export in libreoffice calc
This must surely be obscure but I'd really like to fix it for an important document.
My system language is in one European language. Still, I managed to change all the languages for a Libreoffice Calc ...
- 175
0
votes
0
answers
33
views
Remove the dot before pages in the table of content entries in LibreOffice
I'm having a hard time removing the dots before the pages in the table of content entries in LibreOffice.
The automatically generated table of content from Headings results in the following:
1. Name .....
-1
votes
1
answer
32
views
How can remove the space between lines?
My libreoffice version is Libreoffice Community 7.4.7.2.
When i move cursor at the 'volume'] and press 'deletekey,and pressenter` key,it can't remove the space.
How can remove the space between the ...
- 83.1k
2
votes
2
answers
4k
views
How to delete last page in Libreoffice
I have document that contains two pages. At first I have table from top to bottom of page. Second page consists of single unprintable paragraph character. I cannot delete that character. I want to ...
- 1,722
0
votes
1
answer
83
views
Libreoffice macro has infinite loop
Can someone point out what's wrong with this macro please? I'm trying to search for paragraphs with the token "vv", then change their paragraph style to "_Verse". This macro works ...
- 69
5
votes
3
answers
11k
views
libreoffice what is a fast way to paste special > text and numbers only (aka paste special values)?
I copy and then paste values in excel quite a bit (when I use Excel). When I use LibreOffice you can do the same thing (see related question here) but it is oh so tedious!
It gets especially tedious ...
- 55.6k
0
votes
1
answer
46
views
LibreCalc 7.6.4 Menu and Toolbar
Just downloaded LibreOffice 7.6.4 and I have created a quick access bar. This shows up on the right side of the top menu bar. How do I make into a floating toolbar or a docked toolbar, always on ...
- 121
2
votes
1
answer
81
views
Can't find Developer Tools in LibreOffice Calc
I recently read that the Development Tools is available in LibreOffice since 7.2, but I can't find it in my 7.5.9.2 (and then updated to 7.6.4.1) installation... It should be found under menu item for ...
- 121
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 ...
CommunityBot
- 1
1
vote
1
answer
164
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. ...
1
vote
3
answers
131
views
Convert an Excel table from one structure to the other
Original table
I have this table in Excel or LibreOffice.
Unit number
Type
Name
1
Object
Top
1
Object
Bottom
1
Object
Left
1
Object
Right
1
Object
Back
1
Object
Front
1
Property
Right-Fixed
1
...
- 8,753
0
votes
1
answer
132
views
How can insert spaces at the beginning of another line in libreoffice?
There are two lines in one paragraph:
The cursor located at the beginning of the second line,ahead of the word long_window,now i want to add 4 spaces ahead of long_window as desired below:
,why can'...
- 445
0
votes
1
answer
10
views
How can I enable auto-replace patterns like :alpha: for "Language = [None]" text in LibreOffice Writer?
This question is written as Q&A after having found an answer.
The feature of LibreOffice of inserting unicode characters using sequences such as :alpha: or :_1: could be useful for writing ...
- 2,252
5
votes
3
answers
4k
views
How to prevent LibreOffice running 'recover' at each startup, on Ubuntu?
How to prevent LibreOffice running 'recover' at each start-up?
On Ubuntu, each time I restart my computer, and then start LibreOffice, it asks me whether I want to recover documents. It does this ...
- 573
3
votes
2
answers
990
views
Libreoffice, how to copy from Writer and pasting unformatted in Calc, by default?
I have the revision of a translated text, made by the client, I am the third party reviewer and have to fill up an .xls module with all the source texts, the translated one, and the amended by the ...
- 649
2
votes
0
answers
24
views
LibreOffice Writer: Change all four page magins to the same value AT ONCE?
Instead of changing one by one, can I change all four at once? Google Bard said press Ctrl+Enter, but that did not work.
- 8,328
2
votes
0
answers
36
views
How to update LibreOffice WEBSERVICE data automatically
I know I can force a manual update from Edit/Links.
Is it possible to have LibreOffice update this data automatically, for example once per day?
CommunityBot
- 1
1
vote
2
answers
598
views
Polynomial regression In libreoffice
If we have certain X-Y columns, and the data does not look linear when plotted, we may want to use a polynomial to fit the data.
How do we fit a polynomial model other than using a ax+b fit on the ...
- 1
1
vote
2
answers
524
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 ...
- 18.7k
1
vote
1
answer
96
views
LibreOffice Calc save to CIFS not working
I have an HP Compaq nx9420 that runs Debian 12/bookworm kernel 6.1.0-10-amd64. It's a default install with no extras or tweaks.
I mount a CIFS-drive (fstab-line: "//[ip]/[share] /[mnt]/[point] ...
- 8,328
1
vote
1
answer
58
views
How to clone conditional formatting to another column?
I want to highlight values that are in the bottom 5th percentile in each column, for about 60 columns. I set this conditional formatting for the first column, but I see no way to apply this to every ...
- 1,890
1
vote
2
answers
101
views
Associate .docx with swriter.exe LibreOffice (with PowerShell)
I would like to associate .docx with OpenOffice
$extension = ".docx"
$executable = "$MyPrograms\LibreOffice\program\swriter.exe"
$fileType = "docxfile"
if (Test-Path $...
- 9,630
2
votes
1
answer
3k
views
Libre Office Calc paste as column
I want to copy data from the clipboard to a column on Libre Office Calc
This is my data example
48032, 50201/C, 50286, 50285, 50254, 50253, 50252, 50251, 50250, 50248, 50206/C, 50204/C, >50202/C, ...
- 3,519
6
votes
1
answer
5k
views
LibreOffice / Openoffice or Scribus for book project?
I want to create a book and publish it later with an ondemand book printing provider.
I read that Libreoffice 3.4 and 3.5 have some more DTP features but dont know if I should take Scribus or ...
- 13.2k
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
0
votes
1
answer
46
views
Macro to keep 3 rows visible under the selected row in LibreOffice Calc
In Calc or MS Excel when one is finished editing a cell in a row, pressing Enter leads to the next row below. Keep doing that and eventually you arrive at the last row visible on the screen. Here when ...
- 1,890
1
vote
1
answer
714
views
How to apply the MATCH() function only to a filtered range? Or is there another way to do that?
I have a filtered list of values. Let's say I have the numbers from 0 to 5, and 2 is filtered out:
A (with auto-filter against "2")
0
1
3
4
5
Now I want to find out whether one of the ...
- 2,311
8
votes
3
answers
4k
views
How do I prevent LibreOffice saving the file with the thumbnails?
I am using LibreOffice 4.0 on Windows 7 and I have noticed that it saves files (for example Writer) with a preview. (The icon of the file shows what's inside it, it looks like a page).
How do I turn ...
- 459
0
votes
0
answers
60
views
Having problems with nested numbered and bulleted list
Using the LibreOffice Writer, I am formatting a rather long lists of items where the first level is numbered, and the most of the numbered items contain next level items -- with bullets in the case. ...
- 119
1
vote
1
answer
60
views
cannot scroll down to click okay in libreoffice settings
I tried to follow the instructions here -
LibreOffice 4.2.1.1: do not display list of recent documents
Open the LibreOffice config: Menu "Tools" -> "Config";
In the TreeView: &...
- 10.7k
3
votes
3
answers
5k
views
How to fix a corrupted LibreOffice spreadsheet
I have a substantial multi-sheet LibreOffice worksheet that seems to be throwing a lot of errors in LibreOffice, including crashes.
Any idea of how to get it to work as expected?
I'm thinking ...
- 3,519
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. ...
- 43
2
votes
2
answers
4k
views
Libre Office: Why can't I enter text?
I'm using a template on Libre Office. It has various boxes that I need to enter text in.
Things were going fine, but then for some reason, it stopped allowing me to enter text. It seems to think that ...
