Skip to content

Instantly share code, notes, and snippets.

View nd3w's full-sized avatar

nd3w

1 follower · 1 following
View GitHub Profile
@nd3w
nd3w / LibreOfficeCalcFormulasAndTips.md
Last active June 14, 2023 12:51
LibreOffice Calc Formulas and Tips

Calculate average value from B2 to B32 with B24 to B32 are blanks:

=SUM(B2:B32)/(ROWS(B2:B32)-COUNTBLANK(B2:B32))

or simply:

=AVERAGE(B2:B32)
@nd3w
nd3w / install-lapp-ubuntu-20.04.md
Last active December 11, 2023 04:00
Install Apache2, PostgreSQL and PHP-FPM on Ubuntu 20.04

Install Apache2, PostgreSQL and PHP-FPM 8.2 on Ubuntu 20.04

Install Apache

sudo apt install apache2

sudo ufw app list

sudo ufw allow in "Apache"
@nd3w
nd3w / vscode_ref.md
Last active April 15, 2024 03:36
VSCode Ref

Search and Replace

Search and replace PHP variable in if control structure using regex:

if \(isset\(\$([a-zA-Z_]+)\)\) \{

Replace pattern

if (isset($$$1) AND $$$1 !== '') {
@nd3w
nd3w / keyboard-shortcuts-in-linux-mint-cinnamon.md
Last active April 9, 2024 13:56
Keyboard Shortcuts in Linux Mint Cinnamon

Move a window to another workspace

Press Ctrl+Alt+Shift Left or Ctrl+Alt+Shift Right

Move a window to another monitor

Press Super+Shift Left or Super-Shift Right

Move active window around on the desktop