Word 簡繁轉換,日文編碼的簡體字?

使用 Word 簡轉繁功能 要注意是否文件中含有文字方塊(無法一起轉換)及是否所有的文字內容皆為簡體字的編碼,日文編碼的簡體字是無法轉成繁體字的

如何使用 VLOOKUP 或 HLOOKUP 尋找完全相同的值

出至:http://support.microsoft.com/kb/181213/zh-tw

這些函數的語法定義如下。

VLOOKUP 函數

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

其中:
Argument 引數的定義
———————————————————————

Lookup_value 在陣列第一欄中所要尋找的值。

Table_array 查閱資料中的資訊表格。

col_index 相符數值應該傳回的 table_array
應傳回相符的值。

Range_lookup 無論您想要尋找完全相符或近似的相符值,
其為指定的邏輯值。
如果是 TRUE 或是省略,就會傳回近似的相符值;
也就是說,如果沒有找到完全相符的值,
就會傳回下一個小於 Lookup_value 的最大值
。如果是 FALSE,VLOOKUP 則會尋找完全相符值。如果
找不到完全相同的值,就會傳回 #N/A 錯誤值。

注意 如果 Range_lookup 是 TRUE 或是省略 (近似的相符值),在 Table_array 第一欄中所要尋找的值必須以遞增順序排序。如果 Range_lookup 是 FALSE (完全相符值),Table_array 就不需要排序。
使用 FALSE 做為 Range_lookup 引數的範例

下列清單包含一些水果及個別的顏色。請注意第一欄未排序:
A1:水果 B1:色彩
答 2:奇異果 B2:Green
答 3:香蕉 B3:Yellow
答 4:葡萄 B4:紫
答 5:蘋果 B5:紅色

下列公式尋找相對應於蘋果的顏色 (紅色)。您可以在工作表上的任何儲存格中輸入公式:
=VLOOKUP(“Apple",A2:B5,2,FALSE)

請注意,如果您將 range_lookup 引數變更為 TRUE,Excel 會傳回 #N/A 錯誤,因為第一欄未排序。

HLOOKUP 函數

=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

其中:
Argument 引數的定義
———————————————————————

Lookup_value 在陣列第一欄中所要尋找的值。

Table_array 查閱資料中的資訊表格。

col_index 相符數值應該傳回的 table_array
應傳回相符的值。

Range_lookup 無論您想要尋找完全相符或近似的相符值,
其為指定的邏輯值。
如果是 TRUE 或是省略,就會傳回近似的相符值;
也就是說,如果沒有找到完全相符的值,
就會傳回下一個小於 Lookup_value 的最大值
。如果是 FALSE,VLOOKUP 則會尋找完全相符值。
找不到完全相同的值,就會傳回 #N/A 錯誤值

注意 如果 Range_lookup 是 TRUE 或是省略 (近似的相符值),在 Table_array 第一欄中所要尋找的值必須以遞增順序排序。如果 Range_lookup 是 FALSE (完全相符值),Table_array 就不需要排序。
使用 FALSE 做為 Range_lookup 引數的範例

下列清單包含一些水果及個別的顏色。請注意第一欄未排序:
A1:水果 B1:色彩
答 2:奇異果 B2:Green
答 3:香蕉 B3:Yellow
答 4:葡萄 B4:紫
答 5:蘋果 B5:紅色

下列公式會尋找「顏色」欄,並且傳回標題「黃色」的第三個項目。您可以在工作表上的任何儲存格中輸入公式:
=HLOOKUP(“Color",A1:B5,3,FALSE)

請注意,如果您將 range_lookup 引數變更為 TRUE,Excel 會傳回 #N/A 錯誤,因為第一欄未排序。

另類的office問題: 無法啟動 轉換程式 ,在 Word2007 開啟 doc 檔案時

有同事反應開某個Word檔會出現無法啟動轉換程式mswrd632的錯誤訊息!

原本以為是檔案損壞或是程式衝突
所以參考
Word 無法啟動轉換程式 mswrd632
http://support.microsoft.com/kb/973904/zh-tw

Word 無法啟動轉換程式 mswrd632.wpc
http://plog.tcc.edu.tw/post/530/69784

仍無法解決該問題,甚至用LibreOffice、OpenOffice、Office2007等軟體嘗試開啟,也顯示為亂碼!

經其他同事提醒後,用Notepad++開啟時顯示檔案的標頭部份
才知道該檔案是pdf格式,疑似被誤改副檔名,所以用Word開啟會無法啟動轉換程式得到 mswrd632的錯誤訊息!

於是將副檔名改回pdf格式,之後就可以用Adobe Reader 9正常開啟顯示。

一次刪除 excel 裏所有的文字方塊包含文字藝術師

轉貼:http://tw.myblog.yahoo.com/jw!3QH6dXaFGRvLjngfyDp82rOE/article?mid=176

要刪除 EXCEL 工作表裹的文字方塊(數量很多時,又不知在那),
可依下列方式一次通通刪除:

1. 打開 EXCEL 檔,選好要刪除文字方塊的那個工作表。

2. 按 F5,出現一個視窗,按左下的 特殊 按鈕。

3. 又出一現個 特殊目標 的視窗,然後選擇 物件 ,就會將所有的 文字方塊 都選起來了。

4. 按 刪除 就全部將文字方塊 都刪除掉了。

雙擊 WORD 文件可啟動 WORD 應用程式,卻無法開啟文件的解決辦法

下面是網路上某位先進所遇到的狀況。

有一次我採用克隆盤安裝了系統,裡面自帶OFFICE2007的幾個常用組件,但不適合自己;我採取了安裝OFFICE多版本的辦法,又在計算機中安裝OFFICE2003,然而還是不理想;使用中老是要提示插入安裝盤重新安裝部分文件。我乾脆徹底卸載掉兩個OFFICE版本,然後,重新啟動系統單獨安裝OFFICE2003,安裝好後形式上也正常;不過使用中發現直接雙擊WORD文檔可以啟動WORD但不能正常隨啟動WORD而打開文檔,除非是再執行WORD窗口的「打開」命令,選擇要打開文檔再打開;這顯然不是真正的正常。

在摸索查找原因時,偶然查看WORD文檔的屬性,發現了是其文檔(文件類型)關聯不正確(沒有指定用來打開文檔的程序)。於是,在WORD文檔屬性對話框中的打開方式裡修改指定了打開文檔的程序為Winword.exe,單擊「確定」之後解決了問題。確實一切OK!

總歸一句「Word文件檔案關聯不正確,需要重新指定用word.exe開啟!」。

Convert Between any Document Format – Unoconv

Convert Between any Document Format – Unoconv

UNOCONV(1)                                                                                          UNOCONV(1)

NAME
       unoconv - convert any document from and to any OpenOffice supported format

SYNOPSIS
       unoconv [options] file [file2 ..]

       unoconv --listener [--server SRV] [--port PRT] [--connections CON]

DESCRIPTION
       unoconv is a command line utility that can convert any file format that OpenOffice can import, to any
       file format that OpenOffice is capable of exporting.

       unoconv uses the OpenOffice’s UNO bindings for non-interactive conversion of documents and therefor
       needs an OpenOffice instance to communicate with. Therefore if it cannot find one, it will start its
       own instance for temporary usage. If desired, one can start a “listener” instance to use for subsequent
       connections or even for remote connections.

OPTIONS
       -c, --connection
              UNO connection string to be used by the client to connect to an OpenOffice instance, or used by
              the listener to make OpenOffice listen.

              Default connection string is "socket,host=localhost,port=2002;urp;StarOffice.ComponentContext"

       -d, --doctype
              Specify the OpenOffice document type of the backend format. Possible document types are:
              document, graphics, presentation, spreadsheet.

              Default document type is 'document'.

       -e, --export
              Set specific export filter options (related to the used OpenOffice filter).

              eg. for the PDF output filter one can specify: -e PageRange=1-2

       -f, --format
              Specify the output format for the document. You can get a list of possible output formats per
              document type by using the --show option.

              Default document type is 'pdf'.

       -i, --import
              Set specific import filters options (related to the used OpenOffice filter).

              eg. for some input filters one can specify: -i utf8

       -l, --listener
              Start unoconv as listener for unoconv clients to connect to.

       -o, --outputpath
              Directory to put converted documents.

       --pipe Use a pipe as an alternative connection mechanism to talk to OpenOffice.

       -p, --port
              Port to listen on (as listener) or to connect to (as client).

              Default port is '2002'.

       -s, --server
              Server (address) to listen on (as listener) or to connect to (as client).

              Default server is 'localhost'.

       --show List the possible output formats to be used with -f.

       --stdout
              Print converted output file to stdout.

       -t, --template
              Specify the template to use for importing styles from. This can be very useful if you have a
              corporate identity you have to apply to every document you distribute.

       -T, --timeout
              When unoconv starts its own listener, try to connect to it for an amount of seconds before
              giving up. Increasing this may help when you receive random errors caused by the listener not
              being ready to accept conversion jobs.

       -v, --verbose
              Be more and more and more verbose.

ARGUMENTS
       You can provide one or more files as arguments to convert each of them to the specified output format.

EXAMPLES
       You can use unoconv in standalone mode, this means that in absence of an OpenOffice listener, it will
       starts its own:

       unoconv -f pdf some-document.odt
       One can use unoconv as a listener (by default localhost:2002) to let other unoconv instances connect to
       it:

       unoconv --listener &
       unoconv -f pdf some-document.odt
       unoconv -f doc other-document.odt
       unoconv -f jpg some-image.png
       unoconv -f xsl some-spreadsheet.csv
       kill -15 %-
       This also works on a remote host:

       unoconv --listener --server 1.2.3.4 --port 4567
       and then connect another system to convert documents:

       unoconv --server 1.2.3.4 --port 4567

BUGS
       unoconv uses the UNO bindings to connect to OpenOffice, in absence of a usable socket, it will start
       its own OpenOffice instance with the correct parameters.

       Note
       Please see the TODO file for known bugs and future plans.

SEE ALSO
       convert(1), file(1), odt2txt

REFERENCES
       unoconv is very useful together with the following tools:

       Asciidoc
              [1]http://www.methods.co.nz/asciidoc/

       docbook2odf
              [2]http://open.comsultia.com/docbook2odf/ A list of possible import and export formats is
              available from:

       OpenOffice 2.1
              [3]http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_2_1

       OpenOffice 3.0
              [4]http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_3_0

AUTHOR
       Written by Dag Wieers, <[5]dag@wieers.com>

RESOURCES
       Main web site: [6]http://dag.wieers.com/home-made/unoconv/

COPYING
       Copyright (C) 2007 Dag Wieers. Free use of this software is granted under the terms of the GNU General
       Public License (GPL).

AUTHOR
       Dag Wieers <dag@wieers.com>.

REFERENCES
       1. http://www.methods.co.nz/asciidoc/
          http://www.methods.co.nz/asciidoc/

       2. http://open.comsultia.com/docbook2odf/
          http://open.comsultia.com/docbook2odf/

       3. http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_2_1
          http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_2_1

       4. http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_3_0
          http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_3_0

       5. dag@wieers.com
          mailto:dag@wieers.com

       6. http://dag.wieers.com/home-made/unoconv/
          http://dag.wieers.com/home-made/unoconv/

  0.4                                           20 october 2010                                     UNOCONV(1)

The floowing list of all file formats currently availabe:

jerry@jerry-P5Q-office:~$ unoconv --show
The following list of document formats are currently available:

  bib      - BibTeX [.bib]
  doc      - Microsoft Word 97/2000/XP [.doc]
  doc6     - Microsoft Word 6.0 [.doc]
  doc95    - Microsoft Word 95 [.doc]
  docbook  - DocBook [.xml]
  html     - HTML Document (OpenOffice.org Writer) [.html]
  odt      - ODF Text Document [.odt]
  ott      - Open Document Text [.ott]
  ooxml    - Microsoft Office Open XML [.xml]
  pdf      - Portable Document Format [.pdf]
  rtf      - Rich Text Format [.rtf]
  latex    - LaTeX 2e [.ltx]
  sdw      - StarWriter 5.0 [.sdw]
  sdw4     - StarWriter 4.0 [.sdw]
  sdw3     - StarWriter 3.0 [.sdw]
  stw      - Open Office.org 1.0 Text Document Template [.stw]
  sxw      - Open Office.org 1.0 Text Document [.sxw]
  text     - Text Encoded [.txt]
  mediawiki - MediaWiki [.txt]
  txt      - Text [.txt]
  uot      - Unified Office Format text [.uot]
  vor      - StarWriter 5.0 Template [.vor]
  vor4     - StarWriter 4.0 Template [.vor]
  vor3     - StarWriter 3.0 Template [.vor]
  xhtml    - XHTML Document [.html]

The following list of graphics formats are currently available:

  bmp      - Windows Bitmap [.bmp]
  emf      - Enhanced Metafile [.emf]
  eps      - Encapsulated PostScript [.eps]
  gif      - Graphics Interchange Format [.gif]
  html     - HTML Document (OpenOffice.org Draw) [.html]
  jpg      - Joint Photographic Experts Group [.jpg]
  met      - OS/2 Metafile [.met]
  odd      - OpenDocument Drawing [.odd]
  otg      - OpenDocument Drawing Template [.otg]
  pbm      - Portable Bitmap [.pbm]
  pct      - Mac Pict [.pct]
  pdf      - Portable Document Format [.pdf]
  pgm      - Portable Graymap [.pgm]
  png      - Portable Network Graphic [.png]
  ppm      - Portable Pixelmap [.ppm]
  ras      - Sun Raster Image [.ras]
  std      - OpenOffice.org 1.0 Drawing Template [.std]
  svg      - Scalable Vector Graphics [.svg]
  svm      - StarView Metafile [.svm]
  swf      - Macromedia Flash (SWF) [.swf]
  sxd      - OpenOffice.org 1.0 Drawing [.sxd]
  sxd3     - StarDraw 3.0 [.sxd]
  sxd5     - StarDraw 5.0 [.sxd]
  tiff     - Tagged Image File Format [.tiff]
  vor      - StarDraw 5.0 Template [.vor]
  vor3     - StarDraw 3.0 Template [.vor]
  wmf      - Windows Metafile [.wmf]
  xhtml    - XHTML [.xhtml]
  xpm      - X PixMap [.xpm]

The following list of presentation formats are currently available:

  bmp      - Windows Bitmap [.bmp]
  emf      - Enhanced Metafile [.emf]
  eps      - Encapsulated PostScript [.eps]
  gif      - Graphics Interchange Format [.gif]
  html     - HTML Document (OpenOffice.org Impress) [.html]
  jpg      - Joint Photographic Experts Group [.jpg]
  met      - OS/2 Metafile [.met]
  odg      - ODF Drawing (Impress) [.odg]
  odp      - ODF Presentation [.odp]
  otp      - ODF Presentation Template [.otp]
  pbm      - Portable Bitmap [.pbm]
  pct      - Mac Pict [.pct]
  pdf      - Portable Document Format [.pdf]
  pgm      - Portable Graymap [.pgm]
  png      - Portable Network Graphic [.png]
  pot      - Microsoft PowerPoint 97/2000/XP Template [.pot]
  ppm      - Portable Pixelmap [.ppm]
  ppt      - Microsoft PowerPoint 97/2000/XP [.ppt]
  pwp      - PlaceWare [.pwp]
  ras      - Sun Raster Image [.ras]
  sda      - StarDraw 5.0 (OpenOffice.org Impress) [.sda]
  sdd      - StarImpress 5.0 [.sdd]
  sdd3     - StarDraw 3.0 (OpenOffice.org Impress) [.sdd]
  sdd4     - StarImpress 4.0 [.sdd]
  sxd      - OpenOffice.org 1.0 Drawing (OpenOffice.org Impress) [.sxd]
  sti      - OpenOffice.org 1.0 Presentation Template [.sti]
  svg      - Scalable Vector Graphics [.svg]
  svm      - StarView Metafile [.svm]
  swf      - Macromedia Flash (SWF) [.swf]
  sxi      - OpenOffice.org 1.0 Presentation [.sxi]
  tiff     - Tagged Image File Format [.tiff]
  uop      - Unified Office Format presentation [.uop]
  vor      - StarImpress 5.0 Template [.vor]
  vor3     - StarDraw 3.0 Template (OpenOffice.org Impress) [.vor]
  vor4     - StarImpress 4.0 Template [.vor]
  vor5     - StarDraw 5.0 Template (OpenOffice.org Impress) [.vor]
  wmf      - Windows Metafile [.wmf]
  xhtml    - XHTML [.xml]
  xpm      - X PixMap [.xpm]

The following list of spreadsheet formats are currently available:

  csv      - Text CSV [.csv]
  dbf      - dBASE [.dbf]
  dif      - Data Interchange Format [.dif]
  html     - HTML Document (OpenOffice.org Calc) [.html]
  ods      - ODF Spreadsheet [.ods]
  ooxml    - Microsoft Excel 2003 XML [.xml]
  ots      - ODF Spreadsheet Template [.ots]
  pdf      - Portable Document Format [.pdf]
  sdc      - StarCalc 5.0 [.sdc]
  sdc4     - StarCalc 4.0 [.sdc]
  sdc3     - StarCalc 3.0 [.sdc]
  slk      - SYLK [.slk]
  stc      - OpenOffice.org 1.0 Spreadsheet Template [.stc]
  sxc      - OpenOffice.org 1.0 Spreadsheet [.sxc]
  uos      - Unified Office Format spreadsheet [.uos]
  vor3     - StarCalc 3.0 Template [.vor]
  vor4     - StarCalc 4.0 Template [.vor]
  vor      - StarCalc 5.0 Template [.vor]
  xhtml    - XHTML [.xhtml]
  xls      - Microsoft Excel 97/2000/XP [.xls]
  xls5     - Microsoft Excel 5.0 [.xls]
  xls95    - Microsoft Excel 95 [.xls]
  xlt      - Microsoft Excel 97/2000/XP Template [.xlt]
  xlt5     - Microsoft Excel 5.0 Template [.xlt]
  xlt95    - Microsoft Excel 95 Template [.xlt]