Docker

 docker build -t ubuntu.XXX .

docker image ls

docker rmi XXX

docker ps -a

docker rm XXX

docker pull ubuntu:14.04

docker run -v /xxx/xxx:/xxx -it ubuntu:14.04 bash

docker start XXX

docker stop XXX

docker restart XXX

docker exec -it XXX bash

docker export XXX > ubuntu_14.04.tar

docker import ubuntu_14.04.tar test/ubuntu:v1.0

Dockerfile

FROM ubuntu:18.04

MAINTAINER XXX XX <XXX@XXX>

LABEL description="Compile environment" version="1.0" owner="XXX"

ENV DEBIAN_FRONTEND noninteractive

COPY --chown=root:root .netrc ~/

RUN apt-get update && apt-get install -y apt-utils && apt-get upgrade -y \
&& apt-get install -y \
gawk wget git-core diffstat unzip texinfo xz-utils debianutils iputils-ping \
gcc-multilib build-essential g++ libstdc++6 lib32stdc++6 ninja-build \
python python3 python3-pip python3-pexpect python3-git python3-jinja2 \
libegl1-mesa libsdl1.2-dev pylint3 xterm libpulse-dev libevent-dev rpm2cpio \
chrpath socat cpio

Manjaro install Vivaldi

 sudo pacman -S base-devel git

sudo pacman -S kdialog

安裝

git clone https://aur.archlinux.org/vivaldi.git

cd vivaldi/

makepkg -si

更新

git pull

makepkg -si

電腦常見問題

1. Windows作業系統線上啟用失敗?
   系統時間不正確，改為正確時間。
2. Office線上啟用失敗?
   系統時間不正確，改為正確時間。
3. 瀏覽網頁出現網站憑證過期?
   系統時間不正確，改為正確時間。
4. 停止Microsoft OneNote開機自動啟動?
   執行msconfig，切換至啟動分頁，取消OneNote。
5. 安裝Windows出現0x80300001錯誤?
   將Windows安裝光碟放回去即可。
6. 刪除Windows networking profile?
   netsh wlan delete profile name="ProfileName"

Virtual Studio Code/GitHub

Putty複製貼上

複製: Ctrl-Insert  or Shift-Ctrl-C
貼上: Shift-Insert or Shift-Ctrl-V

wsl command

wsl.exe --export Ubuntu d:\ubuntu.tar
wsl.exe --import UbuntuD d:\wsl\UbuntuD d:\ubuntu.tar
wsl --unregister Ubuntu
wsl -d UbuntuD

libz.so.1: cannot open shared object file

apt install zlib1g:i386

WinCE Streaming Driver

WinCE Components

Platform Builder 4.2

Simulate Memory Management

Simulate ISR/IST

Program Touch

Program LCD

PCMCIA

GPIO

I2C

Unable to locate package msgfmt

sudo apt install gettext

Excel

獲取目前選取的儲存格位置: =ADDRESS(ROW(),COLUMN()) or =CELL("address")
儲存格位移: =OFFSET(reference, rows, cols, [height], [width])
儲存格位移的值: =OFFSET(INDIRECT(CELL("address")),0,-1)
判斷值: =IF(OFFSET(INDIRECT(CELL("address")),0,-1) = "??", ?, ?)
資料驗證: =COUNTIF(A:A,A1)=1
小寫大寫大小寫: LOWER、UPPER、PROPER

資料驗證範例:
=IF(OFFSET(INDIRECT(CELL("address")),0,-1) = "??", COUNTIF(B:B,B1)=1,)