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,)

Build OpenWRT出現Please install the openssl library錯誤

Build dependency: Please install the openssl library (with development headers)

apt install libssl-dev

target extra/locale/wctables.h failed

uClibc-XXX/extra/locale/gen_wctype.c

while (--argc) {
++argv;
if (!strcmp(*argv, "-v")) {
++verbose;
continue;
}

#if 0
if (!setlocale(LC_CTYPE, *argv)) {
verbose_msg("setlocale(LC_CTYPE,%s) failed! Skipping this locale…\n", *argv);
continue;
}
#endif

Ping 127.0.0.1不通

先確定是否有lo設備

ifconfig lo 127.0.0.1 up

Ubuntu收Microsoft Exchange Mail，使用evolution

安裝evolution ＆ evolution-ews

Exchange Web Services URL
https://exchange-server/EWS/Exchange.asmx

chroot下執行java找不到libjli.so

sudo mount --bind /proc <chroot dir>/proc

Ubuntu路徑

1. Old Ubuntu release
   http://old-releases.ubuntu.com/ubuntu/
2. Ubuntu Updates
   https://www.ubuntuupdates.org/
3. gnu
   ftp://ftp.gnu.org/