[Travel] Volendam

[Travel] Brussels

[Travel] Delft & Den Haag

[Travel] kinderdijk

[Travel] Giethoorn

[Travel] Amsterdam

[Mac] [Mojave] Welly 無法上 ptt

Problem
當我的 Mac OS 更新為 Mojave 以後，就無法連上 ptt，出現以下錯誤：
/usr/bin/telnet: No such file or directory

How-To
網址列改為 ssh bbs@ptt.cc 即可

[Apache POI] How to set formula in Excel via Apache POI?

Problem
How to set formula in Excel via Apache POI?

How-To
Sample code:

    // 1. create sheet from workbook
    Sheet sheet= workbook.createSheet("Goal");

    // 2. create row
    Row row = sheet.createRow(rowCount++);

    // 3. create cell and set formula
    row.createCell(13).setCellFormula("SUM(B8:M8)");

[Apache POI] How to set merge cell in Apache POI ?

Problem
I would like to merge A4 and B4 

How-To
According to Apache POI quick guide, we can use addMergedRegion to fulfill this requirement:

Code snippet:

Reference
[1] http://poi.apache.org/components/spreadsheet/quick-guide.html

[Windows 10] 忘記登入密碼怎麼辦？

Steps:
1. 用安全模式進入 windows，打開命令提示字元
2. 切換目錄到 C:\windows\system32
3. 將 Magnify.exe 易名為 Magnify1.exe ：ren Magnify.exe Magnify1.exe
4. 將 cmd.exe 易名為 Magnify.exe ： ren cmd.exe Magnify.exe
5. 重開機，進入Windows 登入畫面，選擇「放大鏡程式」就會開啟「命令提示字元」的視窗
6. 重設密碼為 123456：net user <輸入你的登入帳號> 123456
7. 重開機，進入Windows 登入畫面，用新密碼登入
8.  將 Magnify.exe 易名為  cmd.exe： ren Magnify.exe cmd.exe
9. 將 Magnify1.exe 易名為  Magnify.exe：ren Magnify1.exe Magnify.exe

[Windows 10] 如何進入安全模式