Excel 檔案異常大 2007(xlsx) 存成2003(xls)

Excel xlsx 另存 xls 檔案異常的大

最有可能的原因可能是該檔案是由office2007以上的版本所建立的。但為了讓office2003可以讀取該檔,所以將它另存為xls(2003版本的檔案),但新版有許多新功能或樣式,然而舊版卻沒有。所以另存時會有一堆看不見的物件加到舊版格式的檔案中。因此新版檔案(xlsx)另存舊版檔案類型(xls)就變大很多很多。

解決辦法:利用 libreoffice 讀取被另存舊版的檔案,再做一次另存新檔的動作。但不變更目前的檔案格式。

libreoffice (xls) -> 另存 (xls) 檔案回復正常。

 

廣告

另類的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]

Windows 7 PPT 2010 修改圖表可能造成當機解決嘗試

Win7 and Office 2010 在 ppt 上編修圖片會當機(圖片來源可能是來自於 excel 圖表或是一般的照片、圖片等)。

測試1:重新註冊 Win7 所有的 DLL 。(無效)

運行裡輸入CMD,然後輸入for %1 in (%windir%\system32\*.dll) do regsvr32.exe /s %1

測試2: 移除office2010重新安裝 (無效)

測試3: 移除 lingoes 翻譯軟體 (正常)

可能是 lingoes 造成編修PPT上圖表或是圖檔時當機。