LibreOffice: Use XLOOKUP instead of VLOOKUP

=IFERROR(XLOOKUP(C2,'file:///mnt/marks.ods'#$Sheet1.$C$2:$C$115,'file:///mnt/marks.ods'#$Sheet1.$AC$2:$AC$115,""),"")

vscodium in flatpak golang not found

Install SDK extensions:

flatpak install flathub org.freedesktop.Sdk.Extension.golang

and then set env variable `FLATPAK_ENABLE_SDK_EXT`:

#in fish in ~/.config/fish/config.fish
set -U FLATPAK_ENABLE_SDK_EXT 'golang'

https://gist.github.com/pojntfx/2e1ea30df020924e5d40f823adc6ae09

Ansys 25 R2 and SolidWorks plugin not working

Create `SolidWorksAddIn_Ansys252.bat`:
@echo on
copy /Y "%AWP_ROOT252%\Framework\bin\Win64\Xalan-C_1_12.dll" "%AWP_ROOT252%\aisol\CADIntegration\SolidWorks\winx64"
copy /Y "%AWP_ROOT252%\Framework\bin\Win64\XalanMessages_1_12.dll" "%AWP_ROOT252%\aisol\CADIntegration\SolidWorks\winx64"
copy /Y "%AWP_ROOT252%\Framework\bin\Win64\xerces-c_3_2.dll" "%AWP_ROOT252%\aisol\CADIntegration\SolidWorks\winx64"
copy /Y "%AWP_ROOT252%\Framework\bin\Win64\zlib1.dll" "%AWP_ROOT252%\aisol\CADIntegration\SolidWorks\winx64"

and run as Administrator

pandoc: Word to markdown

pandoc input.docx -t markdown_strict -o output.md

Join lines in a file with a comma

paste -sd ',' myfile.txt

Add Browser MCP to Claude Code

claude mcp add-json browsermcp '{ "type": "stdio", "command": "npx", "args": ["@browsermcp/mcp@latest"]}'
https://github.com/browsermcp/mcp

Linux: convert docx to markdown using pandoc

pandoc -f docx -t markdown_strict input.docx -o foo.md From: https://stackoverflow.com/a/33149947/248823

Linux: join pdf files into one file in a reverse order

pdftk $(ls -r *.pdf) output joined.pdf

Arch Linux: Failed to start Virtual Console Setup

`/etc/vconsole.conf` should be:

KEYMAP=us
FONT=lat9w-16

terminator: size and location in xfce4

terminator --geometry=2100x650+250+1150

Convert all pdf files to txt files

find . -name '*.pdf' -print0 | xargs -0 -n1 pdftotext