Enlarging Libreoffice window completely with command

 You can open the LibreOffice window completely by pressing the CTRL+Shift+J keys together.

Excel: maand afschriften van de bank

Maand afschriften van de bank:
1. Komma's vervangen door punten
2. Het sorteren van de namen (met de bedragen erbij)
3. Een rij toevoegen zodat je AF en BIJ scheidt
4. Het gebruik maken van filter en refilter om bedragen naar naam te berekenen

How to import data tables from an Internet site and have them automatically updated

 https://wiki.documentfoundation.org/Faq/Calc/113

1. Create a new LibreOffice Calc document.
2. Click on a cell in the table (A1 for example)
3. Go to Sheet ▸ Link to external data.
4. After a few seconds (sometimes a bit longer) a new window appears:
5. Check the Detect special numbers box.
6. Click OK.

Libreoffice regex

^$ Finds an empty paragraph.

$ or $0
Adds the string that was found by the search criteria in the Search for box to the term in the Replace with box when you make a replacement.
For example, if you enter "window" in the Search for box and "&frame" in the Replace with box, the word "window" is replaced with "windowframe".
You can also enter an "&" in the Replace with box to modify the Attributes or the Format of the string found by the search criteria.

https://help.libreoffice.org/4.4/Common/List_of_Regular_Expressions

Using Google Sheets to translate batches of words

GOOGLETRANSLATE(a2, "en", "es")

Reddit link

Making a database with txt, csv or dbf file

You can open Access database from a txt file.:
Menu/File/New/Database - Connect to an existing database.
Select the Access type, and follow the wizard.

https://ask.libreoffice.org/en/question/9305/base-when-importing-txt-files-the-database-is-not-relational/

Entering_a_Number_with_Leading_Zeros in spreadsheets

https://help.libreoffice.org/Calc/Entering_a_Number_with_Leading_Zeros/nl

New style for Libreoffice Writer

Creating a new style for Libreoffice Writer:
1. Style/New Style/
Give a name to the new style.
Then Modify and assign values to it in Font.

2. Assign a new shortcut for it by Tools/Customize/Keyboard/Styles/Paragraph/Monaco.
And then Modify: F4

Creating multiple empty slides at once.

Create an additional slide. Then select both of the slides and copy them.

Paste those two slides underneath the two existing ones. Now you have four slides.
Copy them and paste them underneath the existing four etc. etc.

How to make a Table of Contents in LibreOffice

You can do it in two ways: manually or automatically.
In this text only the manual way is discussed.
These are the steps to be taken:

In the text itself you select and bookmark the headings that you want in the Table of Contents. (Select text/Insert/Bookmark)

Then add the text that you bookmarked to the Table of Contents. When you have done that,hyperlink the text of the table of content to the bookmarks (Insert/Hyperlink/Document/Target).

It should look like this:

Shave his belly with a rusty razor (this text is hyperlinked to the bookmark)

Put him in a longboat till his sober

Stick him in a barrel with a hosepipe on him

Put him in the bed with the captains daughter

And the original text:

What will we do with the drunken sailor

What will we do with the drunken sailor

What will we do with the drunken sailor

Early in the morning

Way hay and up she rises

Way hay and up she rises

Way hay and up she rises

Early in the morning

Shave his belly with a rusty razor (this text is bookmarked)

Shave his belly with a rusty razor

Shave his belly with a rusty razor

Early in the morning

Way hay and up she rises

Way hay and up she rises

Way hay and up she rises

Early in the morning

Put him in a longboat till his sober (this text is bookmarked)

Put him in a longboat till his sober

Put him in a longboat till his sober

Early in the morning

Way hay and up she rises

Way hay and up she rises

Way hay and up she rises

etc. etc.

Layout van een samenvatting van Lynda.com

• Het kopiëren en plakken uit qutebrowser of een andere browser (maar niet Firefox).
• Het weghalen van de minuten en seconden met Find and Replace.
• Het weghalen van de lege lijnen.
• Het weghalen van de woorden die er niet toe doen zoals Bookmark.
• Het opslaan als een txt file en deze vervolgens invoeren in template2 in de map Miscel en deze file opslaan als pl file (perl).
• Het runnen van perl file.pl en de resultaten invoeren in Word.
• Het dupliceren van deze inleiding en deze bold maken.
• Ervoor zorgen dat er een lijn tussen de tekst komt en een streepje aan het begin van de lijn. ( (.*) en $1\n ) en vervolgens de formule hieronder.
• NB: zorg ervoor dat je het symbool " ^ " gebruikt wanneer je Find and Replace gebruikt.

Find als Find and Replace

Neem bijvoorbeeld dit rijtje:

1. Understanding and Installing QGIS

-

1.1 Overview of QGIS features

-

1.2 Understanding the types of QGIS installs

-

1.3 Installing QGIS

-

1.4 Exploring the QGIS browser

-

2. Vector Data with QGIS

-

2.1 Understanding types of vector data in QGIS

-

2.2 Adding shapefiles to QGIS

-

2.3 Adding WFS data to QGIS

-

3. Raster Data with QGIS

-

3.1 Exploring types of raster data in QGIS

-

3.2 Adding ECW data

En je wilt dat de streepjes aan het begin van elke lijn niet bold zijn.

Je gebruikt dan Find -/ Find all/ en gebruik dan de dikgebruikte B om de streepjes

niet dikgedrukt te maken.

How to delete empty lines in LibreOffice

There is a way to delete empty lines in LibreOffice with regex. 
It is this command: ^$
But sometimes this doesn't work. Because the above mentioned command actually deletes a paragraph and not a line.
What to do in a case like this one:

Marco Borsato
Wat is mijn hart

De Dijk
Niemand in de stad

The above mentioned command doesn't work and doesn't erase the line between the two texts.

What you need to do, is to clear formatting.
Also make sure that after clearing lines, there are no spaces left at the beginning of the lines.

How to combine two sets of data.

How to combine two sets of data?

There are two lists:

A (a1, a2, a3, a4, a5 etc.)

B (b1, b2, b3, b4, b5 etc.)

In this case, it was text that was to be combined, so I made use of Excel:

C1 = a1&b1

Then drag the corner of the rectangle down and I got the combination that I wanted.

Supposedly, it can be done differently:

>>> a = ['a1', 'a2', 'a3', 'a4', 'a5']<br>
>>> b = ['b1', 'b2', 'b3', 'b4', 'b5']<br>
>>> [elem for pair in zip(a, b) for elem in pair]<br>
['a1', 'b1', 'a2', 'b2', 'a3', 'b3', 'a4', 'b4', 'a5', 'b5']<br>