谨以此网站,向Godick致敬

Const MYCONSTANT = 100

 

上圖中狗仔像給禁錮在一個box之中, stickout就是將box壓扁,令到狗仔部份外漏出box之外, 狗仔頓時就躍于紙面. 下面接收如何通過PPT製作類似效果

PPT 2010:

1. 點擊圖片, 格式 – 刪除背景

2. 軟件會自動識別出背景, 假如背景是純色, 軟件會好好地識別出來, 該例中軟件都基本上識別出狗仔, 通過拖拽方框, 狗仔大抵就出來了, 如果要更完美可以通過Ribbon中的兩個按鈕,添加刪除標記的區域.

3. 將原圖crop去一半, 再疊加上去,就可以出現stickout的效果

* 更簡單的做法是,不對全圖做去背景的操作,而是將圖片分為上下兩部份,分為兩圖. 只對上面的圖片做去背景.

PPT – 2003

1. 用圖示工具繪製一個任意多邊形

2. 填充繪製的多邊形

3. 將多邊形同圖片Group在一起, 剪切 – 選擇性粘貼 – 粘貼為圖片

4. 去背景

 

從worksheet中cell取數,常見辦法如

with sheet1
    name = .cells(i,1)
    company = .cells(i,2)
end with

此方法直接,但是欠缺機動性,假如日後worksheet有任何改動,令到name不是出現在col 1,全部代碼都需要改.

方法1

將各col在代碼頂部定義為常數, 日後需要修改就在頂部定義中修改.修改地方集中到一處,但是還是麻煩

const nameCol = 1 , companyCol = 2
with sheet1
    name = .cells(i,nameCol)
    company = .cells(i,companyCol)
end with

Private Enum AllCols
  nameCol = 1
  companyCol
End Enum

with sheet1
    name = .cells(i,AllCols.nameCol)
    company = .cells(i,AllCols.companyCol)
end with

方法2

充分利用Table (Excel 2007 or higher).

先在worksheet中定義Table,再在VBA中通過ListObjects訪問

Const nameCol = "name", companyCOl = "company"

set tbl = Sheet1.ListObjects("tableName")
with sheet1
  For each row in tbl.ListRows
    name = row.range(, col(nameCol))
    company = row.range(, col(companyCol))
    'do something
  next row
end with

方法3

利用ADO, 對於Excel2003, 連本workbook的時候慎防內存洩露

 

1.定義

Javascript中,定義正則表達式的方法有兩個:

1) RegExp Literal

/* /pattern/flags; */
var re = /mac/i;

2) RegExp Object Constructor

/* new RegExp("pattern","flags"); */
var re = new RegExp(window.prompt("Please input a regex.","yes|yeah"),"g");

2. Flag

1) Global Search

g     The global search flag makes the RegExp search for a pattern throughout the string, creating an array of all occurrences it can find matching the given pattern.

2) Flags

i     The ignore case flag makes a regular expression case insensitive. For international coders, note that this might not work on extended characters such as ?, ü, ?, ?.

3) Multiline Input

m     This flag makes the beginning of input (^) and end of input ($) codes also catch beginning and end of line respectively.

3. Pattern

參閱此處

4. 應用

1) RegExp.exec(string)

Applies the RegExp to the given string, and returns the match information.

var match = /s(amp)le/i.exec("Sample text")
//match then contains ["Sample","amp"] 

2) RegExp.test(string)

Tests if the given string matches the Regexp, and returns true if matching, false if not.   

var match = /sample/.test("Sample text")
//match then contains false 

3) String.match(pattern)

Matches given string with the RegExp. With g flag returns an array containing the matches, without g flag returns just the first match or if no match is found returns null.   

var str = "Watch out for the rock!".match(/r?or?/g)
//str then contains ["o","or","ro"] 

4) String.search(pattern)

Matches RegExp with string and returns the index of the beginning of the match if found, -1 if not.   

var ndx = "Watch out for the rock!".search(/for/)
//ndx then contains 10 

5) String.replace(pattern,string)

Replaces matches with the given string, and returns the edited string.   

var str = "Liorean said: My name is Liorean!".replace(/Liorean/g,'Big Fat Dork')
//str then contains "Big Fat Dork said: My name is Big Fat Dork!" 

6) String.split(pattern)

Cuts a string into an array, making cuts at matches.   

var str = "I am confused".split(/\s/g)
//str then contains ["I","am","confused"]

Example:

var s='<div style="text-align:center;width:inherit;text-color:blue;">SOME TEXT</div>'
var rx=new RegExp("<div .*?>(.*?)</div>","i");
s=s.replace(rx,"$1");

// s="SOME TEXT"
// http://www.tek-tips.com/viewthread.cfm?qid=1231301

 

Sharepoint在某些時候,部份的元素實屬多餘,例如Quick Launch Bar等. 要將其去除,最好當然是通過SharePoint Designer. 然而很多時候, 無法通過底層修改SharePoint的模板. 於是,只能求助于CSS.

1. SharePoint 2007 Cheat Sheet
2. Cheat Sheet Tool
3. Style Under Cursor 下載此webpart,并加載到閣下頁面,就可以通過hover的方式,獲取鼠標所指元素的class或者id

下面是Hide Quick Launch Bar代碼

<style>
     .ms-navframe { display: none }
</style>