Month: January 2025

Linux: Temporarily remap /tmp

In my case, I am using gogs on an Azure VM, which has a not-large main drive, but a rather large drive that only exists as long as the VM is running.

Given that the gogs backup is rather disk hungry, I found the need to move its use away from /tmp and onto the temporary disk.

# Since "resource" is owned by root, make a subfolder and make it world-usable
sudo mkdir /mnt/resource/TEMP && sudo chmod 777 /mnt/resource/TEMP
# Verify
ls -ld /mnt/resource/TEMP
# while TMP and TEMP did not affect gogs, TMPDIR DID, indicating that gogs uses mktemp
TMPDIR=/mnt/resource/TEMP ./gogs backup

Continue reading “Linux: Temporarily remap /tmp”

Excel : No more conversion of large numbers to Scientific Notation

To my extremely great surprise, Microsoft has finally fixed a very annoying feature in Excel.

When importing CSV-files to Excel that contained (what could look like) a number, Excel would without fail convert that to a number during import and, if it was large enough like 1000000000001234567, convert it to Scientific Notation (1.000E+18) and in the process remove precision in the number. Even if you later forced it back to text or similar, it had forever lost the precision (1000000000001234000) and was hence utterly useless.

That is happily a feature in the past for Office 365. Now you can disable this impressively stupid behaviour in “Options”

Continue reading “Excel : No more conversion of large numbers to Scientific Notation”