Skip to content

Instantly share code, notes, and snippets.

View gmolveau's full-sized avatar

Grégoire MOLVEAU gmolveau

View GitHub Profile
@gmolveau
gmolveau / kobo-activate-no-account.md
Created February 7, 2026 14:23
Activer liseuse numérique Kobo sans compte / Activate Kobo reader without account - Fnac/Darty/Rakuten
@gmolveau
gmolveau / boot-windows11-grub.md
Last active January 16, 2026 14:48
boot on windows 11 from grub menu / add windows 11 to grub menu / xubuntu
GRUB_DISABLE_OS_PROBER=false
GRUB_TIMEOUT_STYLE=menu
GRUB_TIMEOUT=10
@gmolveau
gmolveau / howtodisablevscodeai.md
Last active January 15, 2026 19:50
how to disable vscode ai chat autocomplete suggestion tab
  • vscode://settings/chat.disableAIFeatures
  • settings / chat: Hide AI Features => check
@gmolveau
gmolveau / google_sheets_dropdown_condition.md
Created September 14, 2025 19:47
google sheets - dropdown conditions - how to check if certain values are selected for a dropdown cell ?

In Google Sheets, the dropdown cell store its value as a comma-separated list of string.

To check if a dropdown cell has value "A" and "B" selected, use the following formula :

=IF(REGEXMATCH(D2;"[\s]?A[,]?") * REGEXMATCH(D2;"[\s]?B[,]?");"YES";"NOPE")

The regex matches a string, prefixed by an optional space, and suffixed by an optional comma.

@gmolveau
gmolveau / signal_ubuntu_install.sh
Created July 3, 2025 16:01
Installing Signal on Ubuntu without gpg errors
# avoids the common error : The following signatures couldn't be verified because the public key is not available: NO_PUBKEY D980A17457F6FB06
sudo mkdir -m 0755 -p /etc/apt/keyrings/
wget -O- https://updates.signal.org/desktop/apt/keys.asc | gpg --dearmor | sudo tee /usr/share/keyrings/signal-desktop-keyring.gpg > /dev/null
sudo chmod 644 /usr/share/keyrings/signal-desktop-keyring.gpg
echo 'deb [arch=amd64 signed-by=/usr/share/keyrings/signal-desktop-keyring.gpg] https://updates.signal.org/desktop/apt xenial main' |\
sudo tee /etc/apt/sources.list.d/signal-xenial.list
@gmolveau
gmolveau / wsl_setup.md
Last active May 20, 2025 16:36
WSL install and setup + vscode

WSL setup

  • Open powershell with admin and run wsl --install
  • Enable virtualization in the BIOS if needed
  • Open the windows store and install Ubuntu 24
  • Run Ubuntu, create your user + password
  • Run mkdir dev
  • Run explorer.exe . to open an explorer window, create a shortcut of the dev folder and place it in My Documents
  • Install Windows Terminal
  • Run Windows Terminal, go to Settings and change the Default profile to Ubuntu 24, change the
@gmolveau
gmolveau / cli_best_practices.md
Created February 27, 2025 20:12
cli best practices #linux

CLI best practices

  • use the most common flags

    • the help flag : --help | -h | -?
     $ git --help
     usage: git [-v | --version] [-h | --help] [-C <path>] [-c <name>=<value>]
                [--exec-path[=<path>]] [--html-path] [--man-path] [--info-path]

[-p | --paginate | -P | --no-pager] [--no-replace-objects] [--bare]

@gmolveau
gmolveau / lit_palettes_europe.pdf
Last active February 10, 2025 20:24
Réaliser un sommier de lit en palettes europe pour matelas 140x200
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@gmolveau
gmolveau / openshot_installer.sh
Last active May 14, 2025 07:50
Openshot appimage installer
#!/usr/bin/env bash
set -o errexit
set -o pipefail
set -o nounset
# set -o xtrace
OPENSHOT_VERSION="3.3.0"
APPIMAGE_NAME="OpenShot-v${OPENSHOT_VERSION}-x86_64.AppImage"
APPIMAGE_URL="https://github.com/OpenShot/openshot-qt/releases/download/v${OPENSHOT_VERSION}/${APPIMAGE_NAME}"
@gmolveau
gmolveau / singlefile_config.json
Created November 30, 2024 08:40
Singlefile personal config (remove characters, FS friendly)
{
"profiles": {
"__Default_Settings__": {
"removeHiddenElements": true,
"removeUnusedStyles": true,
"removeUnusedFonts": true,
"removeFrames": false,
"blockScripts": true,
"blockVideos": true,
"blockAudios": true,