Alt+DP C N I N (選範圍) Enter Enter
- Alt+D P 開啟舊的 pivote table wizard
- 選「多重彙總資料範圍」 -> 下一步
- 「我會自行建立分頁欄位」 -> 下一步
- 選擇 Table 範圍 -> 下一步 -> 完成
- 集中做完 unpivot 的資料
/* | |
Go on your labels page (https://github.com/user/repo/labels) | |
Edit the following label array | |
or | |
Use this snippet to export github labels (https://gist.github.com/MoOx/93c2853fee760f42d97f) | |
and replace it | |
Paste this script in your console | |
Press Enter!! |
const path = require('path') | |
const fs = require('fs') | |
function walkDirSync (dir) { | |
return fs.readdirSync(dir).reduce((filePaths, fileName) => { | |
const filePath = path.join(dir, fileName) | |
if (fs.statSync(filePath).isDirectory()) { | |
return filePaths.concat(walkDirSync(filePath)) | |
} |
import memoize from 'lodash/memoize' | |
function isNil (value) { | |
return value === undefined || value === null | |
} | |
function sallowCopy (obj) { | |
return Array.isArray(obj) ? [...obj] : { ...obj } | |
} | |
function toUpdateFunc (input) { |
/* | |
* 第 1 碼為 / | |
* 其餘 7 碼為 0-9 A-Z . - + | |
*/ | |
module.exports = (value) => { | |
// - 需放最後,不然要會跟 0-9 的 - 混淆 | |
const patt = /^\/[0-9A-Z.+-]{7}$/ | |
if (patt.test(value)) return null |