Journal of my recent activities

LibreOffice transpose rows to columns

  1. Copy to clipboard the cell range that you want to transpose.
  2. Paste Special, in the dialog, mark Paste all and Transpose.

Rotating Tables (Transposing) - LibreOffice Help


Automatic change of linux configuration files

sed -i 's/#Port 22/Port 123/' /etc/ssh/sshd_config


Dictionary of values with choices for select.

from enum import Enum

class ResourceType(Enum):
    HTML = 0
    VIDEO = 1
    AUDIO = 2
    IMAGE = 3
    PDF = 4
    HTTP = 5
    EPUB = 6

def get_choices():
    return [(r.value, for r in ResourceType]

Creating unit tests for Flask.

import unittest

from app import create_app, db
from config_tests import Config

class MmTestCase(unittest.TestCase):
    def setUp(self): = create_app(Config)
        self.appctx =
        self.client =

    def tearDown(self):
        self.appctx.pop() = None
        self.appctx = None
        self.client = None

How to Write Unit Tests in Python, Part 3: Web Applications

Downloading backups from remote hosts

rsync -av --delete -e 'ssh -p 223' user@host:/dir1 local_dir

#soft #linux

Symetric ant anti-symetric wave function

Google Sheets: Bulk delete

Tools > Script ediotr Set a breakpoint at console log sheet name and Debug.

function DeleteAllSheets() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  console.log("Doc: " + ss.getName());
  var sheets = ss.getSheets();
  for (i = 0; i < sheets.length; i++) {
    switch(sheets[i].getSheetName()) {
      case "21-01":  
        console.log("Delete: " + sheets[i].getSheetName());


Convert ssh2 public key to openssh format

If the pub key is in the format


then you can convert it with

ssh-keygen -i -f >> ~/.ssh/authorized_keys

#soft #linux