Libreoffice STUFF

1.) Splitting a the content inside a cell/cells in a column based on a value

Similar that the python.split() method you can split the content of a cell into two cells, or if applied to a column.

To do so, first select the column that you can to split.

Second, go to “Data” –> “Text to Columns”

A menu will appear, where you can specify the seperator, as if importing a .csv file.

Click “OK” –> Done

A mor complete description of that (with pictures!) can be found here: https://www.ryananddebi.com/2018/01/08/libreoffice-calc-splitting-contents-of-cells-into-multiple-columns-e-g-splitting-commas/

2.) Merging the content of cells.

Merging two cells is no problem.

First, select cells to merge.

Second, go to “Format” –> “Merge Cells” —> “Merge Cells” again. Click yes on whatever is says.

Unfortunately merging the values of whole columns row-wise isn’t as straight forward as splitting. 😦

3.) Superscript and Subscript

Crtl + Shift + P: superscript

Crtl + Shift + B: subscript

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s