001    /*
002     * Copyright (c) 2009 The openGion Project.
003     *
004     * Licensed under the Apache License, Version 2.0 (the "License");
005     * you may not use this file except in compliance with the License.
006     * You may obtain a copy of the License at
007     *
008     *     http://www.apache.org/licenses/LICENSE-2.0
009     *
010     * Unless required by applicable law or agreed to in writing, software
011     * distributed under the License is distributed on an "AS IS" BASIS,
012     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
013     * either express or implied. See the License for the specific language
014     * governing permissions and limitations under the License.
015     */
016    package org.opengion.hayabusa.report2;
017    
018    import java.io.BufferedReader;
019    import java.io.BufferedWriter;
020    import java.io.File;
021    import java.io.FileInputStream;
022    import java.io.FileNotFoundException;
023    import java.io.FileOutputStream;
024    import java.io.IOException;
025    import java.io.InputStreamReader;
026    import java.io.OutputStreamWriter;
027    import java.io.UnsupportedEncodingException;
028    import java.nio.channels.FileChannel;
029    import java.util.ArrayList;
030    import java.util.HashMap;
031    import java.util.List;
032    import java.util.Locale;
033    import java.util.Map;
034    import java.util.Set;
035    
036    import org.opengion.fukurou.model.NativeType;
037    import org.opengion.fukurou.util.Closer;
038    import org.opengion.fukurou.util.FileUtil;
039    import org.opengion.fukurou.util.QrcodeImage;
040    import org.opengion.hayabusa.common.HybsSystem;
041    import org.opengion.hayabusa.common.HybsSystemException;
042    
043    /**
044     * 謖?ｮ壹＆繧後◆繝代せ縺ｫ蟄伜惠縺吶ｋODS縺ｮ蜷ЧML繝輔ぃ繧､繝ｫ繧偵ヱ繝ｼ繧ｹ縺励?蟶ｳ逾ｨ螳夂ｾｩ蜿翫?
045     * 蟶ｳ逾ｨ繝??繧ｿ縺九ｉ譖ｸ縺肴鋤縺医∪縺吶?
046     * 譖ｸ縺肴鋤縺医?隱ｭ縺ｿ蜿悶ｊ蜈医→蜷後§繝輔ぃ繧､繝ｫ縺ｧ縺ゅｋ縺溘ａ縲∽ｸ?率隱ｭ縺ｿ蜿悶▲縺溷推XML繧?
047     * 繝｡繝｢繝ｪ荳翫↓譬ｼ邏阪＠縺溘°繧峨ヱ繝ｼ繧ｹ蠕後?XML繝輔ぃ繧､繝ｫ縺ｮ譖ｸ縺崎ｾｼ縺ｿ繧定｡後＞縺ｾ縺吶?
048     *
049     * 繝代?繧ｹ蟇ｾ雎｡縺ｨ縺ｪ繧九ヵ繧｡繧､繝ｫ縺ｯ莉･荳九?3縺､縺ｧ縺吶?
050     *  content.xml 繧ｷ繝ｼ繝医?荳ｭ霄ｫ繧貞ｮ夂ｾｩ
051     *  meta.xml    繝｡繧ｿ繝??繧ｿ繧貞ｮ夂ｾｩ
052     *  style.xml   蟶ｳ逾ｨ繝倥ャ繝??繝輔ャ繧ｿ繝ｼ繧貞ｮ夂ｾｩ
053     *
054     * content.xml縺ｮ繝代?繧ｹ蜃ｦ逅?→縺励※縲√∪縺噎ml繝輔ぃ繧､繝ｫ繧偵す繝ｼ繝?陦悟腰菴阪↓蛻?ｧ｣縺励∪縺吶?
055     * 縺昴?蠕後?蛻?ｧ｣縺輔ｌ縺溯｡梧ｯ弱↓蟶ｳ逾ｨ繝??繧ｿ繧貞沂繧∬ｾｼ縺ｿ縲∝?蜉帛?縺ｮXML縺ｫ譖ｸ縺崎ｾｼ縺ｿ繧定｡後＞縺ｾ縺吶?
056     * 譖ｸ縺崎ｾｼ縺ｿ縺ｯ陦悟腰菴阪↓陦後ｏ繧後∪縺吶?
057     *
058     * 縺ｾ縺溘?Calc縺ｮ迚ｹ諤ｧ縺ｨ縺励※縲?未謨ｰ縺ｮ蠑墓焚縺ｫ荳肴ｭ｣縺ｪ蠑墓焚縺梧欠螳壹＆繧後◆蝣ｴ蜷医?(Text髢｢謨ｰ縺ｮ
059     * 蠑墓焚縺ｫnull縺梧欠螳壹＆繧後◆蝣ｴ蜷育ｭ?縲√お繝ｩ繝ｼ:XXX縺ｨ縺?≧譁?ｭ励′陦ｨ遉ｺ縺輔ｌ縺ｾ縺吶?
060     * 縺薙％縺ｧ縺ｯ縲√％繧後ｒ蝗樣∩縺吶ｋ縺溘ａ縲∝?縺ｦ縺ｮ髢｢謨ｰ縺ｫisError髢｢謨ｰ繧貞沂繧∬ｾｼ縺ｿ縲√お繝ｩ繝ｼ陦ｨ遉ｺ繧?
061     * 陦後ｏ縺ｪ縺?ｈ縺?↓縺励※縺?∪縺吶?
062     *
063     * @og.group 蟶ｳ逾ｨ繧ｷ繧ｹ繝?Β
064     *
065     * @version  4.0
066     * @author   Hiroki.Nakamura
067     * @since    JDK1.6
068     */
069    class OdsContentParser {
070    
071            //======== content.xml縺ｮ繝代?繧ｹ縺ｧ菴ｿ逕ｨ ========================================
072            /* 繧ｷ繝ｼ繝医?髢句ｧ狗ｵゆｺ?ち繧ｰ */
073            private static final String BODY_START_TAG = "<table:table ";
074            private static final String BODY_END_TAG = "</table:table>";
075    
076            /* 陦後?髢句ｧ狗ｵゆｺ?ち繧ｰ */
077            private static final String ROW_START_TAG = "<table:table-row ";
078    
079            /* 繝壹?繧ｸ繧ｨ繝ｳ繝峨き繝?ヨ縺ｮ髫帙↓縲∬｡後ｒ髱櫁｡ｨ遉ｺ縺ｫ縺吶ｋ縺溘ａ縺ｮ繝??繝悶Ν螳｣險?*/
080            private static final String ROW_START_TAG_INVISIBLE = "<table:table-row table:visibility=\"collapse\" ";
081    
082            /* 繧ｻ繝ｫ縺ｮ髢句ｧ九ち繧ｰ */
083            private static final String TABLE_CELL_START_TAG = "<table:table-cell";
084            private static final String TABLE_CELL_END_TAG = "</table:table-cell>";
085    
086            /* 繧ｷ繝ｼ繝亥錐繧貞叙蠕励☆繧九◆繧√?髢句ｧ狗ｵゆｺ?枚蟄?*/
087            private static final String SHEET_NAME_START = "table:name=\"";
088    
089            /* 繧ｪ繝悶ず繧ｧ繧ｯ繝医?邨ゆｺ?ｽ咲ｽｮ(繧ｷ繝ｼ繝亥錐)繧定ｦ九▽縺代ｋ縺溘ａ縺ｮ髢句ｧ区枚蟄?*/
090            private static final String OBJECT_SEARCH_STR = "table:end-cell-address=\"";
091    
092            /* 蜊ｰ蛻ｷ遽?峇謖?ｮ壹?髢句ｧ狗ｵゆｺ?枚蟄?*/
093            // 4.3.3.5 (2008/11/08) 遨ｺ逋ｽ繝壹?繧ｸ蟇ｾ遲悶〒霑ｽ蜉?
094            private static final String PRINT_RANGE_START = "table:print-ranges=\"";
095            private static final String PRINT_RANGE_END = "\"";
096    
097            /* 陦ｨ邏吝魂蛻ｷ逕ｨ縺ｮ繝壹?繧ｸ蜷咲ｧｰ */
098            private static final String FIRST_PAGE_NAME = "FIRST";
099    
100            /* 繧ｷ繝ｼ繝医ヶ繝ｬ繧､繧ｯ逕ｨ縺ｮ繧ｭ繝ｼ 5.1.7.0 (2010/06/01) */
101            private static final String SHEET_BREAK = "SHEETBREAK";
102    
103            /* 螟画焚螳夂ｾｩ縺ｮ髢句ｧ狗ｵゆｺ?枚蟄怜所縺ｳ蛹ｺ蛻?ｊ譁?ｭ?*/
104            private static final String VAR_START = "{@";
105            private static final String VAR_END = "}";
106            private static final String VAR_CON = "_";
107    
108            /* 繝壹?繧ｸ繧ｨ繝ｳ繝峨き繝?ヨ縺ｮ繧ｫ繝ｩ繝?枚蟄怜? */
109            private static final String PAGE_END_CUT = "PAGEENDCUT";
110    
111            /* 繝壹?繧ｸ繝悶Ξ繧､繧ｯ縺ｮ繧ｫ繝ｩ繝?枚蟄怜? */
112            private static final String PAGE_BREAK = "PAGEBREAK";
113    
114            /* 繝壹?繧ｸ逡ｪ蜿ｷ蜃ｺ蜉帷畑譁?ｭ怜? 5.1.6.0 (2010/05/01) */
115            private static final String PAGE_NO= "PAGENO";
116    
117            /* 陦檎分蜿ｷ蜃ｺ蜉帷畑譁?ｭ怜? 5.1.6.0 (2010/05/01) */
118            private static final String ROW_NO= "ROWNO";
119    
120            /* 逕ｻ蜒上?繝ｪ繝ｳ繧ｯ繧貞叙蠕励☆繧九◆繧√?髢句ｧ狗ｵゆｺ?枚蟄?*/
121            private static final String DRAW_IMG_START_TAG = "<draw:image xlink:href=\"";
122            private static final String DRAW_IMG_END_TAG = "</draw:image>";
123            private static final String DRAW_IMG_HREF_END = "\"";
124    
125            /* 逕ｻ蜒上ヵ繧｡繧､繝ｫ繧剃ｿ晏ｭ倥☆繧九◆繧√?繝代せ */
126            private static final String IMG_DIR = "Pictures";
127    
128            /* QR繧ｳ繝ｼ繝峨ｒ蜃ｦ逅?☆繧九◆繧√?繧ｫ繝ｩ繝?錐 */
129            private static final String QRCODE_PREFIX = "QRCODE.";
130    
131            /* 菴懈?縺励◆QR繧ｳ繝ｼ繝峨?繝輔か繝ｫ繝?錐蜿翫?諡｡蠑ｵ蟄?*/
132            private static final String QRCODE_FILETYPE = ".png";
133    
134            /* 4.3.3.5 (2008/11/08) 蜍慕噪縺ｫ逕ｻ蜒上ｒ蜈･繧梧崛縺医ｋ縺溘ａ縺ｮ繝代せ繧定ｨ倩ｿｰ縺吶ｋ繧ｫ繝ｩ繝?錐 */
135            private static final String IMG_PREFIX = "IMG.";
136    
137            /* 繝輔ぃ繝ｳ繧ｯ繧ｷ繝ｧ繝ｳ螳夂ｾｩ繧定ｦ九▽縺代ｋ縺溘ａ縺ｮ髢句ｧ狗ｵゆｺ?枚蟄?*/
138            private static final String OOOC_FUNCTION_START = "oooc:=";
139            private static final String OOOC_FUNCTION_START_3 = "of:="; // 4.3.7.2 (2009/06/15) ODS莉墓ｧ伜､画峩縺ｫ縺､縺崎ｿｽ蜉?
140            private static final String OOOC_FUNCTION_END = ")\" ";
141    
142            /* 繧ｻ繝ｫ蜀??謾ｹ陦後ｒ螳夂ｾｩ縺吶ｋ譁?ｭ怜? 5.0.2.0 (2009/11/01) */
143            private static final String OOO_CR = "</text:p><text:p>";
144    
145            /* 繧ｰ繝ｩ繝輔が繝悶ず繧ｧ繧ｯ繝医?譖ｸ縺肴鋤縺医ｒ陦後≧縺溘ａ縺ｮ髢句ｧ狗ｵゆｺ?枚蟄?5.1.8.0 (2010/07/01) */
146            private static final String GRAPH_START_TAG = "<draw:frame ";
147            private static final String GRAPH_END_TAG = "</draw:frame>";
148            /* 繧ｰ繝ｩ繝輔?遽?峇謖?ｮ壹?譖ｸ縺肴鋤縺医ｒ陦後≧縺溘ａ縺ｮ髢句ｧ狗ｵゆｺ?枚蟄?5.1.8.0 (2010/07/01) */
149            private static final String GRAPH_UPDATE_RANGE_START = "draw:notify-on-update-of-ranges=\"";
150            private static final String GRAPH_UPDATE_RANGE_END = "\"";
151            /* 繧ｰ繝ｩ繝輔?繧ｪ繝悶ず繧ｧ繧ｯ繝医∈縺ｮ繝ｪ繝ｳ繧ｯ縺ｮ譖ｸ縺肴鋤縺医ｒ陦後≧縺溘ａ縺ｮ髢句ｧ狗ｵゆｺ?枚蟄?5.1.8.0 (2010/07/01) */
152            private static final String GRAPH_HREF_START = "xlink:href=\"./";
153            private static final String GRAPH_HREF_END = "\"";
154            private static final String GRAPH_OBJREPL = "ObjectReplacements";
155            /* 繧ｰ繝ｩ繝輔?繧ｪ繝悶ず繧ｧ繧ｯ繝域ｯ弱?content.xml縺ｫ險倩ｿｰ縺励※縺ゅｋ繧ｷ繝ｼ繝亥錐縺ｮ譖ｸ縺肴鋤縺医ｒ陦後≧縺溘ａ縺ｮ髢句ｧ狗ｵゆｺ?枚蟄?5.1.8.0 (2010/07/01) */
156            private static final String GRAPH_CONTENT_START = "-address=\"";
157            private static final String GRAPH_CONTENT_END = "\"";
158            /* 逕滓?縺励◆繧ｰ繝ｩ繝輔?繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒMETA-INF/manifest.xml縺ｫ逋ｻ骭ｲ縺吶ｋ縺溘ａ縺ｮ髢句ｧ狗ｵゆｺ?枚蟄怜? 5.1.8.0 (2010/07/01) */
159            private static final String MANIFEST_START_TAG = "<manifest:file-entry ";
160            private static final String MANIFEST_END_TAG = "/>";
161    
162            /* 謨ｰ蛟､繧ｿ繧､繝礼ｽｮ縺肴鋤縺育畑縺ｮ譁?ｭ怜? 5.1.8.0 (2010/07/01) */
163            private static final String TABLE_CELL_STRING_TYPE = "office:value-type=\"string\"";
164            private static final String TABLE_CELL_FLOAT_TYPE = "office:value-type=\"float\"";
165            private static final String TABLE_CELL_FLOAT_VAL_START = "office:value=\"";
166            private static final String TABLE_CELL_FLOAT_VAL_END = "\"";
167    
168            /* 繝?く繧ｹ繝域枚蟄怜?縺ｮ髢句ｧ狗ｵゆｺ?枚蟄怜? 5.1.8.0 (2010/07/01) */
169            private static final String TEXT_START_TAG = "<text:p>";
170            private static final String TEXT_END_TAG = "</text:p>";
171    
172            /* 繧ｳ繝｡繝ｳ繝?繧｢繝弱ユ繝ｼ繧ｷ繝ｧ繝ｳ)繧貞?逅?☆繧九◆繧√?繧ｫ繝ｩ繝?錐 5.1.8.0 (2010/07/01) */
173            private static final String ANNOTATION_PREFIX = "ANO.";
174            private static final String TEXT_START_ANO_TAG = "<text:p"; // 繧｢繝弱ユ繝ｼ繧ｷ繝ｧ繝ｳ縺ｮ蝣ｴ蜷医?鄂ｮ縺肴鋤縺医ｒ
175            private static final String TEXT_START_END_ANO_TAG = ">"; // 繧｢繝弱ユ繝ｼ繧ｷ繝ｧ繝ｳ縺ｮ蝣ｴ蜷医?鄂ｮ縺肴鋤縺医ｒ
176    
177            /* 繧ｳ繝｡繝ｳ繝?繧｢繝弱ユ繝ｼ繧ｷ繝ｧ繝ｳ)縺ｮ髢句ｧ九?邨ゆｺ?ち繧ｰ 5.1.8.0 (2010/07/01) */
178            private static final String ANNOTATION_START_TAG = "<office:annotation";
179            private static final String ANNOTATION_END_TAG = "</office:annotation>";
180    
181            /* 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ讀懃ｴ｢縺吶ｋ縺溘ａ縺ｮ譁?ｭ怜? 5.1.8.0 (2010/07/01) */
182            private static final String DRAW_START_KEY = "<draw:";
183            private static final String DRAW_END_KEY = "</draw:";
184    
185            /* 繧ｷ繝ｼ繝医?髢句ｧ狗ｵゆｺ?ち繧ｰ 5.2.2.0 (2010/11/01) */
186            private static final String STYLE_START_TAG = "<style:style ";
187            private static final String STYLE_END_TAG = "</style:style>";
188    
189            /* 繧ｷ繝ｼ繝亥錐遘ｰ 5.2.2.0 (2010/11/01) */
190            private static final String STYLE_NAME_START_TAG = "style:name=\"";
191            private static final String STYLE_NAME_END_TAG = "\"";
192    
193            /* 繝??繝悶Ν蜀?す繝ｼ繝亥錐遘ｰ 5.2.2.0 (2010/11/01) */
194            private static final String TABLE_STYLE_NAME_START_TAG = "table:style-name=\"";
195            private static final String TABLE_STYLE_NAME_END_TAG = "\""; // 5.6.3.1 (2013/04/05)
196    
197            //===========================================================================
198    
199            //======== meta.xml縺ｮ繝代?繧ｹ縺ｧ菴ｿ逕ｨ ===========================================
200            /* 邱上す繝ｼ繝医き繧ｦ繝ｳ繝域焚 */
201            private static final String TABLE_COUNT_START_TAG = "meta:table-count=\"";
202            private static final String TABLE_COUNT_END_TAG = "\"";
203    
204            /* 邱上そ繝ｫ繧ｫ繧ｦ繝ｳ繝域焚 */
205            private static final String CELL_COUNT_START_TAG = "meta:cell-count=\"";
206            private static final String CELL_COUNT_END_TAG = "\"";
207    
208            /* 邱上が繝悶ず繧ｧ繧ｯ繝医き繧ｦ繝ｳ繝域焚 */
209            private static final String OBJECT_COUNT_START_TAG = "meta:object-count=\"";
210            private static final String OBJECT_COUNT_END_TAG = "\"";
211            //===========================================================================
212    
213            /*
214             * 蜃ｦ逅?ｸｭ縺ｮ陦檎分蜿ｷ縺ｮ迥ｶ諷?
215             * NORMAL : 騾壼ｸｸ
216             * LASTROW : 譛?ｵり｡?
217             * OVERFLOW : 邨ゆｺ?
218             */
219            private static final int NORMAL = 0;
220            private static final int LASTROW = 1;
221            private static final int OVERFLOW = 2;
222            private int status = NORMAL;
223    
224            /*
225             * 蜷?屁蠖｢繝輔ぃ繧､繝ｫ繧貞?逅?☆繧矩圀縺ｮ蝓ｺ貅悶→縺ｪ繧玖｡梧焚
226             * 蛻晄悄>0 2陦?{&#064;XXX_1}縺ｾ縺ｧ)蜃ｦ逅?ｾ?2 繝ｻ繝ｻ繝ｻ
227             * 蜷?屁蠖｢縺ｧ螳夂ｾｩ縺輔ｌ縺ｦ縺?ｋ陦檎分蜿ｷ + [baseRow] 縺ｮ蛟､縺轡BTableModel荳翫?陦檎分蜿ｷ縺ｫ逶ｸ蠖薙☆繧?
228             * currentMaxRow縺ｯ蜷?す繝ｼ繝亥?逅?ｾ後?[baseRow]縺ｨ蜷後§
229             */
230            private int currentBaseRow = 0;
231            private int currentMaxRow = 0;
232    
233            /* 蜃ｦ逅?＠縺溘?繝ｼ繧ｸ謨ｰ */
234            private int pages = 0;
235    
236            /* 蜃ｦ逅?｡後′繝壹?繧ｸ繧ｨ繝ｳ繝峨き繝?ヨ縺ｮ蟇ｾ雎｡縺九←縺?° */
237            private boolean isPageEndCut = false;                   // 4.3.1.1 (2008/08/23) 繝ｭ繝ｼ繧ｫ繝ｫ螟画焚蛹?
238    
239            /* 繝壹?繧ｸ繝悶Ξ繧､繧ｯ縺ｮ蜃ｦ逅?ｸｭ縺九←縺?° */
240            private boolean isPageBreak = false;
241    
242            /* XML螳｣險??譁?ｭ怜?縲ょ推XML縺ｧ蜈ｱ騾壹↑縺ｮ縺ｧ繧ｯ繝ｩ繧ｹ螟画焚縺ｨ縺励※螳夂ｾｩ */
243            private String xmlHeader = null;
244    
245            /* 繧ｷ繝ｼ繝医ヶ繝ｬ繧､繧ｯ蟇ｾ雎｡縺九←縺?° 5.1.7.0 (2010/06/01) */
246            private int sheetBreakClm = -1;
247    
248            /* 繧ｷ繝ｼ繝亥錐繧ｫ繝ｩ繝?5.7.6.2 (2014/05/16) */
249            private int sheetNameClm = -1;                                          // 莉翫?縲√?繝ｼ繧ｸ繝悶Ξ繧､繧ｯ繧ｫ繝ｩ繝?→蜷後§繧ｫ繝ｩ繝?ｒ菴ｿ逕ｨ縺励※縺?∪縺吶?
250    
251            /* 繧ｷ繝ｼ繝医?繝倥ャ繝??驛ｨ蛻??蜀阪ヱ繝ｼ繧ｹ繧定｡後≧縺九←縺?°  5.2.2.0 (2010/11/01) */
252            private boolean isNeedsReparse = false;
253    
254            /* 繝壹?繧ｸ蜷阪?繝槭ャ繝斐Φ繧ｰ(蜈??繧ｷ繝ｼ繝亥錐縺ｫ蟇ｾ縺吶ｋ譁ｰ縺励＞繧ｷ繝ｼ繝亥錐) 5.2.2.0 (2010/11/01) */
255            private final Map<String,List<String>> pageNameMap = new HashMap<String,List<String>>();
256    
257            /* 繝壹?繧ｸ蜷阪↓萓晏ｭ倥＠縺ｦ縺?ｋ繧ｹ繧ｿ繧､繝ｫ蜷咲ｧｰ縺ｮ繝ｪ繧ｹ繝?5.2.2.0 (2010/11/01) */
258            private final List<String> repStyleList = new ArrayList<String>();
259    
260            /* manifest.xml縺ｫ霑ｽ蜉?′蠢?ｦ√↑繧ｪ繝悶ず繧ｧ繧ｯ繝医?繝槭ャ繝?5.3.1.0 (2011/01/01) */
261            private final Map<String,String> addObjs = new HashMap<String,String>();
262    
263            private final ExecQueue queue;
264            private final String path;
265    
266            /**
267             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ
268             *
269             * @og.rev 5.1.2.0 (2010/01/01) 蜃ｦ逅?＠縺溯｡梧焚繧嘆ueue繧ｪ繝悶ず繧ｧ繧ｯ繝医°繧牙叙蠕?繧ｷ繝ｼ繝域焚縺?56繧定ｶ?∴縺溷?蜷医?蟇ｾ蠢?
270             *
271             * @param qu ExecQueue
272             * @param pt String
273             */
274            OdsContentParser( final ExecQueue qu, final String pt ) {
275                    queue = qu;
276                    path = pt;
277    
278                    currentBaseRow = queue.getExecRowCnt();
279            }
280    
281            /**
282             * 繝代?繧ｹ蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺?
283             *
284             * @og.rev 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
285             * @og.rev 5.3.1.0 (2011/01/01) OpenOffice3.2蟇ｾ蠢?霑ｽ蜉?＠縺溽判蜒上ｒmanifest.xml縺ｫ逋ｻ骭ｲ縺吶ｋ
286             */
287            public void exec() {
288                    /*
289                     * 髮帛ｽ｢繝倥ャ繝??繝輔ャ繧ｿ繝ｼ縺ｮ螳夂ｾｩ
290                     * OOo縺ｧ縺ｯ繝壹?繧ｸ豈弱↓繝倥ャ繝??繝輔ャ繧ｿ繝ｼ縺瑚ｨｭ螳壹〒縺阪↑縺?ｈ縺??
291                     * 縺ｪ縺ｮ縺ｧ縲∝?縺ｦ繝倥ャ繝??謇ｱ縺?〒蜃ｦ逅?
292                     */
293                    execStyles();
294    
295                    /* 荳ｭ霄ｫ縺ｮ螟画鋤 */
296                    execContent();
297    
298                    /* 繝倥ャ繝??驛ｨ蛻?↓繧ｷ繝ｼ繝域ュ蝣ｱ縺後≠繧句?蜷医↓譖ｸ縺肴鋤縺?*/
299                    if( isNeedsReparse ) {
300                            /* 繝倥ャ繝??繝輔ぃ繧､繝ｫ縺ｮ蜀阪ヱ繝ｼ繧ｹ */
301                            execContentHeader();
302                            /* 繝倥ャ繝??繝輔ぃ繧､繝ｫ縺ｨ縺昴ｌ莉･髯阪?繝輔ぃ繧､繝ｫ縺ｮ騾｣邨?*/
303                            execMergeContent();
304                    }
305    
306                    /* 繝｡繧ｿ繝??繧ｿ縺ｮ螟画鋤 */
307                    execMeta();
308    
309                    // 5.3.1.0 (2011/01/01) OpenOffice3.2蟇ｾ蠢?霑ｽ蜉?＠縺溽判蜒上ｒmanifest.xml縺ｫ逋ｻ骭ｲ縺吶ｋ
310                    /* 霑ｽ蜉?＠縺溽判蜒上?繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒmanifest.xml縺ｫ霑ｽ蜉?*/
311                    if( addObjs.size() > 0 ) {
312                            execManifest();
313                    }
314            }
315    
316            /**
317             * 蟶ｳ逾ｨ蜃ｦ逅?く繝･繝ｼ繧貞?縺ｫ縲…ontent.xml繧呈嶌縺肴鋤縺医∪縺吶?
318             * 縺ｾ縺壹?XML繧剃ｸ?率繝｡繝｢繝ｪ荳翫↓螻暮幕縺励◆蠕後?繧ｷ繝ｼ繝亥腰菴阪↓蛻?ｧ｣縺励?繝??繧ｿ縺ｮ蝓九ａ霎ｼ縺ｿ繧定｡後＞縺ｾ縺吶?
319             *
320             * @og.rev 4.3.0.0 (2008/07/18) 繝壹?繧ｸ謨ｰ縺?56繧定ｶ?∴縺溷?蜷医?繧ｨ繝ｩ繝ｼ蜃ｦ逅?
321             * @og.rev 5.0.0.2 (2009/09/15) LINECOPY讖溯?霑ｽ蜉?
322             * @og.rev 5.1.2.0 (2010/01/01) 蜃ｦ逅?＠縺溘?繝ｼ繧ｸ謨ｰ縲∬｡梧焚繧嘆ueue繧ｪ繝悶ず繧ｧ繧ｯ繝医↓繧ｻ繝?ヨ(繧ｷ繝ｼ繝域焚縺?56繧定ｶ?∴縺溷?蜷医?蟇ｾ蠢?
323             * @og.rev 5.1.7.0 (2010/06/01) 隍?焚繧ｷ繝ｼ繝亥ｯｾ蠢?
324             * @og.rev 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
325             * @og.rev 5.7.6.2 (2014/05/16) PAGEBREAK繧ｫ繝ｩ繝??蛟､繧偵?繧ｷ繝ｼ繝亥錐縺ｨ縺励※菴ｿ縺??蜷医?蜃ｦ逅?ｿｽ蜉?
326             * @og.rev 5.7.6.3 (2014/05/23) PAGEBREAK繧ｫ繝ｩ繝??蛟､繧偵?繧ｷ繝ｼ繝亥錐縺ｨ縺励※菴ｿ縺??蜷医?縲：IRST髮帛ｽ｢縺ｸ縺ｮ驕ｩ逕ｨ
327             */
328            private void execContent() {
329                    String fileName = path + "content.xml";
330                    String content = readOOoXml( fileName );
331                    // 繝輔ぃ繧､繝ｫ縺ｮ隗｣譫舌＠縲√す繝ｼ繝?陦悟腰菴阪↓蛻?ｧ｣
332                    String[] tags = tag2Array( content, BODY_START_TAG, BODY_END_TAG );
333    
334                    // 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
335                    // content.xml縺ｮ繝倥ャ繝??驛ｨ蛻??縺ｿ譖ｸ縺榊?縺?
336                    String contentHeader = tags[0];
337                    BufferedWriter bw = null;
338                    try {
339                            bw = getWriter( fileName );
340                            bw.write( xmlHeader );
341                            bw.write( '\n' );
342                            bw.write( contentHeader );
343                            bw.flush();
344                    }
345                    catch ( IOException ex ) {
346                            queue.addMsg( "[ERROR]PARSE:error occurer while content.xml(header) " + fileName + HybsSystem.CR );
347                            throw new HybsSystemException( ex );
348                    }
349                    finally {
350                            Closer.ioClose( bw );
351                            bw = null;
352                    }
353    
354                    String contentFooter = tags[1];
355                    List<OdsSheet> firstSheets = new ArrayList<OdsSheet>();
356                    Map<String, OdsSheet> sheets = new HashMap<String,OdsSheet>();
357                    OdsSheet defaultSheet = null;
358                    for( int i = 2; i < tags.length; i++ ) {
359                            OdsSheet sheet = new OdsSheet();
360                            // sheet.analyze( tags[i] );
361                            sheet.analyze( tags[i],queue.getBody().getRowCount() ); // 5.0.0.2 (2009/09/15)
362                            // 5.1.7.0 (2010/06/01) 隍?焚繧ｷ繝ｼ繝亥ｯｾ蠢?
363                            String sheetName = sheet.getSheetName();
364                            if( sheetName.startsWith( FIRST_PAGE_NAME ) ) {
365                                    firstSheets.add( sheet );
366                            }
367                            else {
368                                    sheets.put( sheetName, sheet );
369                                    // 荳?分蛻昴ａ縺ｫ隕九▽縺九▲縺溯｡ｨ邏吩ｻ･螟悶?繧ｷ繝ｼ繝医ｒ繝?ヵ繧ｩ繝ｫ繝医す繝ｼ繝医→縺励※險ｭ螳?
370                                    if( defaultSheet == null ) {
371                                            defaultSheet = sheet;
372                                    }
373                            }
374    
375                            // 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
376                            if( !isNeedsReparse && contentHeader.indexOf( "=\"" + sheet.getOrigSheetName() + "." ) >= 0 ) {
377                                    isNeedsReparse = true;
378                            }
379    
380                            // 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
381                            pageNameMap.put( sheet.getOrigSheetName(), new ArrayList<String>() );
382                    }
383    
384                    // content.xml縺ｮ譖ｸ縺榊?縺?
385                    try {
386                            // 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
387                            if( isNeedsReparse ) {
388                                    // 繝倥ャ繝??繧貞?繝代?繧ｹ縺吶ｋ蝣ｴ蜷医?縲√?繝?ぅ驛ｨ蛻?ｒ
389                                    // content.xml.tmp縺ｫ譖ｸ縺榊?縺励※縲∝ｾ後〒繝槭?繧ｸ縺吶ｋ
390                                    bw = getWriter( fileName + ".tmp" );
391                                    getRepStyleList( contentHeader );
392                            }
393                            else {
394                                    // 繝倥ャ繝??繧貞?繝代?繧ｹ縺吶＠縺ｪ縺??蜷医?縲√?繝?ぅ驛ｨ蛻?ｒ
395                                    // content.xml霑ｽ蜉?Δ繝ｼ繝峨〒譖ｸ縺崎ｾｼ縺ｿ縺吶ｋ
396                                    bw = getWriter( fileName, true );
397                            }
398    
399                            // 5.7.6.3 (2014/05/23) PAGEBREAK繧ｫ繝ｩ繝??蛟､繧偵?繧ｷ繝ｼ繝亥錐縺ｨ縺励※菴ｿ縺?°縺ｩ縺?°縲?
400                            if( queue.isUseSheetName() ) {
401                                    sheetNameClm = queue.getBody().getColumnNo( PAGE_BREAK, false );
402                            }
403    
404                            // 陦ｨ邏吶?繝ｼ繧ｸ縺ｮ蜃ｺ蜉?
405                            if( queue.getExecPagesCnt() == 0 ) {
406                                    for ( OdsSheet firstSheet : firstSheets ) {
407                                            if ( currentBaseRow >= queue.getBody().getRowCount() ) {
408                                                    break;
409                                            }
410                                            writeParsedSheet( firstSheet, bw );
411                                    }
412                            }
413    
414                            // 5.1.7.0 (2010/06/01) 隍?焚繧ｷ繝ｼ繝亥ｯｾ蠢?
415                            sheetBreakClm = queue.getBody().getColumnNo( SHEET_BREAK, false );
416    
417                            // 5.7.6.3 (2014/05/23) 陦ｨ邏吶?繝ｼ繧ｸ繧ゅ?PAGEBREAK繧ｫ繝ｩ繝??蛟､繧偵?繧ｷ繝ｼ繝亥錐縺ｨ縺励※菴ｿ縺医ｋ繧医≧縺ｫ縺吶ｋ縲?
418    //                      // 5.7.6.2 (2014/05/16) PAGEBREAK繧ｫ繝ｩ繝??蛟､繧偵?繧ｷ繝ｼ繝亥錐縺ｨ縺励※菴ｿ縺?°縺ｩ縺?°縲?
419    //                      if( queue.isUseSheetName() ) {
420    //                              sheetNameClm = queue.getBody().getColumnNo( PAGE_BREAK, false );
421    //                      }
422    
423                            // 郢ｰ繧願ｿ斐＠繝壹?繧ｸ縺ｮ蜃ｺ蜉?
424                            while ( currentBaseRow < queue.getBody().getRowCount() ) {
425                                    // 4.3.0.0 (2008/07/18) 繝壹?繧ｸ謨ｰ縺?56繧定ｶ?∴縺溷?蜷医↓繧ｨ繝ｩ繝ｼ縺ｨ縺吶ｋ
426                                    // 5.1.2.0 (2010/01/01) 256繧ｷ繝ｼ繝医ｒ雜?∴縺溷?蜷医?蟇ｾ蠢?
427                                    if( pages >= ExecQueue.MAX_SHEETS_PER_FILE ) {
428                                            queue.setEnd( false );
429                                            break;
430                                    }
431    
432                                    OdsSheet sheet = null;
433                                    if( sheetBreakClm >= 0 ) {
434                                            String sheetName = queue.getBody().getValue( currentBaseRow, sheetBreakClm );
435                                            if( sheetName != null && sheetName.length() > 0 ) {
436                                                    sheet = sheets.get( sheetName );
437                                            }
438                                    }
439                                    if( sheet == null ) { sheet = defaultSheet; }
440    
441                                    writeParsedSheet( sheet, bw );
442                            }
443    
444                            // 5.1.2.0 (2010/01/01) 256繧ｷ繝ｼ繝医ｒ雜?∴縺溷?蜷医?蟇ｾ蠢?
445                            queue.addExecPageCnt( pages );
446                            queue.setExecRowCnt( currentBaseRow );
447    
448                            // 繝輔ャ繧ｿ繝ｼ
449                            bw.write( contentFooter );
450                            bw.flush();
451                    }
452                    catch ( IOException ex ) {
453                            queue.addMsg( "[ERROR]PARSE:error occurer while write Parsed Sheet " + fileName + HybsSystem.CR );
454                            throw new HybsSystemException( ex );
455                    }
456                    finally {
457                            Closer.ioClose( bw );
458                    }
459            }
460    
461            /**
462             * 繧ｷ繝ｼ繝亥腰菴阪↓繝代?繧ｹ縺輔ｌ縺滓枚譖ｸ繝??繧ｿ繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺?
463             * 蜃ｺ蜉帙＆繧後ｋ繧ｷ繝ｼ繝亥錐縺ｫ縺ｯ縲√?繝ｼ繧ｸ逡ｪ蜿ｷ縺ｨ蝓ｺ蠎輔→縺ｪ繧玖｡檎分蜿ｷ繧偵そ繝?ヨ縺励∪縺吶?
464             *
465             * @og.rev 4.2.4.0 (2008/07/04) 陦悟腰菴阪↓繝輔ぃ繧､繝ｫ縺ｫ譖ｸ縺崎ｾｼ繧?ｈ縺?↓螟画峩
466             * @og.rev 5.2.0.0 (2010/09/01) 陦ｨ邏吶?蝣ｴ蜷医?縲。ODY驛ｨ蛻??繝??繧ｿ縺悟性縺ｾ繧後※縺?↑縺上※繧０K
467             * @og.rev 5.2.1.0 (2010/10/01) 繧ｷ繝ｼ繝亥錐螳夂ｾｩ蟇ｾ蠢?
468             * @og.rev 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
469             * @og.rev 5.7.6.2 (2014/05/16) PAGEBREAK繧ｫ繝ｩ繝??蛟､繧偵?繧ｷ繝ｼ繝亥錐縺ｨ縺励※菴ｿ縺??蜷医?蜃ｦ逅?ｿｽ蜉?
470             * @og.rev 5.7.6.3 (2014/05/23) FIRST髮帛ｽ｢繧ｷ繝ｼ繝亥錐縺後?FIRST**** 縺ｮ蝣ｴ蜷医?**** 驛ｨ蛻?ｒ繧ｷ繝ｼ繝亥錐縺ｫ菴ｿ縺??
471             *
472             * @param sheet
473             * @param bw
474             * @throws IOException 譖ｸ縺崎ｾｼ縺ｿ縺ｫ螟ｱ謨励＠縺溷?蜷?
475             */
476            private void writeParsedSheet( final OdsSheet sheet, final BufferedWriter bw ) throws IOException {
477                    // 繧ｷ繝ｼ繝亥錐
478                    String outputSheetName = null;
479    
480                    // 5.7.6.2 (2014/05/16) PAGEBREAK繧ｫ繝ｩ繝??蛟､繧偵?繧ｷ繝ｼ繝亥錐縺ｨ縺励※菴ｿ縺?°縺ｩ縺?°縲?
481                    if( sheetNameClm >= 0 ) {
482                            String sheetName = queue.getBody().getValue( currentBaseRow, sheetNameClm );
483                            if( sheetName != null ) {
484                                    outputSheetName = sheetName;
485                            }
486                    }
487    
488                    // 5.7.6.3 (2014/05/23) FIRST髮帛ｽ｢繧ｷ繝ｼ繝亥錐縺後?FIRST**** 縺ｮ蝣ｴ蜷医?**** 驛ｨ蛻?ｒ繧ｷ繝ｼ繝亥錐縺ｫ菴ｿ縺??
489                    if( outputSheetName == null ) {
490                            String sheetName = sheet.getSheetName();
491                            if( sheetName.startsWith( FIRST_PAGE_NAME ) ) {
492                                    sheetName = sheetName.substring( FIRST_PAGE_NAME.length() ).trim();
493                                    // 蟆冗ｴｰ蟾･縲?FIRST_****" 縺ｮ蝣ｴ蜷医?縲?_" 繧貞､悶☆縲る聞縺包ｼ仙愛螳壹?蜑阪↓陦後≧縲?
494                                    if( sheetName.startsWith( "_" ) ) { sheetName = sheetName.substring( 1 ); }
495                                    // 髟ｷ縺包ｼ舌?蝣ｴ蜷茨ｼ井ｾ九∴縺ｰ縲：IRST縺?￠縺ｨ縺具ｼ峨?縲∬ｨｭ螳壹＠縺ｪ縺??
496                                    if( sheetName.length() > 0 ) { outputSheetName = sheetName; }
497                            }
498                    }
499    
500                    // 蠕捺擂縺九ｉ縺ゅｋ繧ｷ繝ｼ繝亥錐縺ｮ蛟､
501                    if( outputSheetName == null ) {
502                            if( sheet.getConfSheetName() == null ) {
503    //                              outputSheetName = "Page" + ( queue.getExecPagesCnt() + pages ) + "_" + "Row" + currentBaseRow + "";
504                                    outputSheetName = "Page" + ( queue.getExecPagesCnt() + pages ) + "_Row" + currentBaseRow ;
505                            }
506                            else {
507    //                              outputSheetName = sheet.getConfSheetName() + queue.getExecPagesCnt() + pages + 1 ;
508                                    outputSheetName = sheet.getConfSheetName() + ( queue.getExecPagesCnt() + pages + 1 ) ;
509                            }
510                    }
511                    // 繝壹?繧ｸ繝悶Ξ繧､繧ｯ螟画焚繧貞?譛溷喧
512                    isPageBreak = false;
513    
514                    // 繧ｷ繝ｼ繝医?繝倥ャ繝??驛ｨ蛻?ｒ譖ｸ縺崎ｾｼ縺ｿ(繧ｷ繝ｼ繝亥錐繧よ嶌縺肴鋤縺?
515                    String headerStr = sheet.getHeader().replace( SHEET_NAME_START + sheet.getOrigSheetName(), SHEET_NAME_START + outputSheetName );
516    
517                    // 蜊ｰ蛻ｷ遽?峇謖?ｮ夐Κ蛻??繧ｷ繝ｼ繝亥錐繧貞､画峩
518                    // 4.3.3.5 (2008/11/08) 遨ｺ逋ｽ繝壹?繧ｸ蜃ｺ蜉帙?蟇ｾ遲悶?蜊ｰ蛻ｷ遽?峇縺ｮ繧ｷ繝ｼ繝亥錐譖ｸ縺肴鋤縺医ｒ霑ｽ蜉?
519                    int printRangeStart = headerStr.indexOf( PRINT_RANGE_START );
520                    if( printRangeStart >= 0 ) {
521                            int printRangeEnd = headerStr.indexOf( PRINT_RANGE_END, printRangeStart + PRINT_RANGE_START.length() );
522                            String rangeStr = headerStr.substring( printRangeStart, printRangeEnd );
523                            rangeStr = rangeStr.replace( sheet.getOrigSheetName(), outputSheetName );
524                            headerStr = headerStr.substring( 0, printRangeStart ) + rangeStr + headerStr.substring( printRangeEnd );
525                    }
526    
527                    bw.write( headerStr );
528    
529                    // 繧ｷ繝ｼ繝医?繝懊ョ繧｣驛ｨ蛻?ｒ譖ｸ縺崎ｾｼ縺ｿ
530                    String[] rows = sheet.getRows();
531                    for( int i = 0; i < rows.length; i++ ) {
532                            // 4.3.4.4 (2009/01/01)
533                            writeParsedRow( rows[i], bw, sheet.getOrigSheetName(), outputSheetName );
534                    }
535                    // {@XXXX}縺悟沂繧∬ｾｼ縺ｾ繧後※縺?↑縺??蜷医?繧ｨ繝ｩ繝ｼ
536                    // 5.2.0.0 (2010/09/01) 陦ｨ邏吶?蝣ｴ蜷医?縲。ODY驛ｨ蛻??繝??繧ｿ縺悟性縺ｾ繧後※縺?↑縺上※繧０K
537                    if( currentBaseRow == currentMaxRow && !sheet.getOrigSheetName().startsWith( FIRST_PAGE_NAME ) ) {
538                            queue.addMsg( "[ERROR]PARSE:No Data defined on Template ODS(" + queue.getListId() + ")" + HybsSystem.CR );
539                            throw new HybsSystemException();
540                    }
541                    currentBaseRow = currentMaxRow;
542    
543                    // 繧ｷ繝ｼ繝医?繝輔ャ繧ｿ繝ｼ驛ｨ蛻?ｒ譖ｸ縺崎ｾｼ縺ｿ
544                    bw.write( sheet.getFooter() );
545    
546                    pages++;
547    
548                    // 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
549                    pageNameMap.get( sheet.getOrigSheetName() ).add( outputSheetName );
550            }
551    
552            /**
553             * 陦悟腰菴阪↓繝代?繧ｹ縺輔ｌ縺滓枚譖ｸ繝??繧ｿ繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺?
554             *
555             * @og.rev 4.2.3.1 (2008/06/19) 髢｢謨ｰ繧ｨ繝ｩ繝ｼ繧定｡ｨ遉ｺ縺輔○縺ｪ縺?◆繧√?ISERROR髢｢謨ｰ繧貞沂繧∬ｾｼ縺ｿ
556             * @og.rev 4.2.4.0 (2008/07/04) 陦悟腰菴阪↓繝輔ぃ繧､繝ｫ縺ｫ譖ｸ縺崎ｾｼ繧?ｈ縺?↓螟画峩
557             * @og.rev 4.3.0.0 (2008/07/17) ?幢ｼ?→?昴?謨ｴ蜷域?繝√ぉ繝?け霑ｽ蜉?
558             * @og.rev 4.3.0.0 (2008/07/22) 陦梧怙蠕後??幢ｼ?ｽ晄紛蜷域?繧ｨ繝ｩ繝ｼ繝上Φ繝峨Μ繝ｳ繧ｰ霑ｽ蜉?
559             * @og.rev 4.3.3.5 (2008/11/08) 逕ｻ蜒上?蜍慕噪縺ｪ蜈･繧梧崛縺医↓蟇ｾ蠢?
560             * @og.rev 5.1.8.0 (2010/07/01) 繝代?繧ｹ譁ｹ豕輔?蜀?Κ螳溯｣?､画峩
561             * @og.rev 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
562             * @og.rev 5.4.2.0 (2011/12/01) 繝壹?繧ｸ繝悶Ξ繧､繧ｯ縲√す繝ｼ繝医ヶ繝ｬ繧､繧ｯ荳ｭ縺ｧ繧ゅ?繝ｼ繧ｸ繧ｨ繝ｳ繝峨き繝?ヨ縺碁←逕ｨ縺輔ｌ繧九ｈ縺?↓縺吶ｋ縲?
563             * @og.rev 5.6.3.1 (2013/04/05) 譚｡莉ｶ莉俶嶌蠑上?螻樊?邨ゆｺ?枚蟄怜ｯｾ蠢?
564             *
565             * @param row
566             * @param bw
567             * @param sheetNameOrig
568             * @param sheetNameNew
569             * @throws IOException 譖ｸ縺崎ｾｼ縺ｿ縺ｫ螟ｱ謨励＠縺溷?蜷?
570             */
571            private void writeParsedRow( final String row, final BufferedWriter bw, final String sheetNameOrig, final String sheetNameNew ) throws IOException {
572                    isPageEndCut = false;
573    
574                    String rowStr = new TagParser() {
575                            @Override
576                            protected void exec( final String str, final StringBuilder buf, final int offset ) {
577                                    String key = TagParser.checkKey( str, buf );
578    
579                                    // 4.3.0.0 (2008/07/15) "<"縺悟?縺｣縺ｦ縺?◆蝣ｴ蜷医↓縺ｯ{@荳肴紛蜷?繧ｨ繝ｩ繝ｼ
580                                    if( key.indexOf( '<' ) >= 0 ){
581                                            queue.addMsg( "[ERROR]PARSE:{@縺ｨ}縺ｮ謨ｴ蜷域?縺御ｸ肴ｭ｣縺ｧ縺吶?螟画焚蜀??迚ｹ螳壹?譁?ｭ怜?縺ｫ譖ｸ蠑剰ｨｭ螳壹′縺輔ｌ縺ｦ縺?ｋ蜿ｯ閭ｽ諤ｧ縺後≠繧翫∪縺吶?繧ｭ繝ｼ=" + key + HybsSystem.CR );
582                                            throw new HybsSystemException();
583                                    }
584    
585                                    // QR繧ｳ繝ｼ繝峨?蜃ｦ逅??蜃ｦ逅?ｾ後?offset縺碁?繧?◆繧√?offset繧貞?繧ｻ繝?ヨ
586                                    if( key.startsWith( QRCODE_PREFIX ) ) {
587                                            setOffset( makeQRImage( row, offset, key.substring( QRCODE_PREFIX.length() ), buf ) );
588                                    }
589                                    // 逕ｻ蜒冗ｽｮ縺肴鋤縺医?蜃ｦ逅??蜃ｦ逅?ｾ後?offset縺碁?繧?◆繧√?offset繧貞?繧ｻ繝?ヨ
590                                    else if( key.startsWith( IMG_PREFIX  ) ) {
591                                            setOffset( changeImage( row, offset, key.substring( IMG_PREFIX.length() ), buf ) );
592                                    }
593                                    // 繧ｳ繝｡繝ｳ繝?繧｢繝弱ユ繝ｼ繧ｷ繝ｧ繝ｳ)縺ｫ繧医ｋ鄂ｮ縺肴鋤縺亥?逅??蜃ｦ逅?ｾ後?offset縺碁?繧?◆繧√?offset繧貞?繧ｻ繝?ヨ
594                                    else if( key.startsWith( ANNOTATION_PREFIX ) ) {
595                                            setOffset( parseByAnnotation( row, offset, key.substring( ANNOTATION_PREFIX.length() ), buf ) );
596                                    }
597                                    else {
598                                            String val = getValue( key );
599                                            // 5.5.2.4 (2012/05/16) String key 縺ｯ菴ｿ繧上ｌ縺ｦ縺?↑縺??縺ｧ縲∝炎髯､縺励∪縺吶?
600                                            changeType( row, offset, val, getNativeType( key, val ), buf );
601                                            buf.append( val );
602                                    }
603    
604                                    // 蜃ｦ逅?｡後′繝壹?繧ｸ繧ｨ繝ｳ繝峨き繝?ヨ縺ｮ蟇ｾ雎｡縺?
605                                    if( queue.isFgcut() && PAGE_END_CUT.equals( key ) ) {
606                                            isPageEndCut = true;
607                                    }
608                            }
609                    }.doParse( row, VAR_START, VAR_END, false );
610    
611                    //==== 縺薙％縺九ｉ縺ｯ蠕悟?逅?=========================================================
612                    /*
613                     * 繝壹?繧ｸ繧ｨ繝ｳ繝峨き繝?ヨ縺ｮ蛻､螳壹?譛?ｾ後〒蜃ｦ逅?☆繧九?
614                     * {&#064;PAGEENDCUT}縺瑚｡後?譛??縺ｫ譖ｸ縺九ｌ縺ｦ縺?ｋ蝣ｴ蜷医?縲＾VERFLOW縺ｫ縺ｪ縺｣縺ｦ縺?↑縺?庄閭ｽ諤ｧ縺?
615                     * 縺ゅｋ縺溘ａ陦後?騾比ｸｭ縺ｧ縺ｯ蛻､譁ｭ縺ｧ縺阪↑縺?
616                     */
617                    // 5.4.2.0 (2011/12/01) 繧ｷ繝ｼ繝医ヶ繝ｬ繧､繧ｯ荳ｭ縺ｧ繧ゅ?繝ｼ繧ｸ繧ｨ繝ｳ繝峨き繝?ヨ縺碁←逕ｨ縺輔ｌ繧九ｈ縺?↓縺吶ｋ縲?
618                    // (騾壼ｸｸ縺ｮ繝壹?繧ｸ繝悶Ξ繧､繧ｯ縺ｯ蜈郁ｪｭ縺ｿ蛻､螳壹?縺溘ａ繝壹?繧ｸ繧ｨ繝ｳ繝峨き繝?ヨ縺吶ｋ縺ｨ縲√ヶ繝ｬ繧､繧ｯ逋ｺ逕溯｡瑚?霄ｫ縺?
619                    //  蜑企勁縺輔ｌ縺ｦ縺励∪縺?◆繧∫樟譎らせ縺ｧ縺ｯ譛ｪ蟇ｾ蠢?
620                    if( isPageEndCut && ( status == OVERFLOW || ( sheetBreakClm >= 0 && isPageBreak ) ) ) {
621                            // 繝壹?繧ｸ繧ｨ繝ｳ繝峨き繝?ヨ縺ｮ蝣ｴ蜷医?縲?撼陦ｨ遉ｺ迥ｶ諷九↓縺吶ｋ縲?
622                            rowStr = rowStr.replace( ROW_START_TAG, ROW_START_TAG_INVISIBLE ) ;
623                    }
624    
625                    /*
626                     * 繧ｪ繝悶ず繧ｧ繧ｯ繝医〒螳夂ｾｩ縺輔ｌ縺ｦ縺?ｋ繝??繝悶Ν蜷阪ｒ螟画峩
627                     */
628                    if( rowStr.indexOf( OBJECT_SEARCH_STR ) >= 0 ) {
629                            rowStr = rowStr.replace( OBJECT_SEARCH_STR + sheetNameOrig, OBJECT_SEARCH_STR + sheetNameNew );
630                    }
631    
632                    /*
633                     * 髢｢謨ｰ繧ｨ繝ｩ繝ｼ繧定｡ｨ遉ｺ縺輔ｌ縺ｪ縺?◆繧√?ISERROR髢｢謨ｰ繧貞沂繧∬ｾｼ縺ｿ 4.2.3.1 (2008/06/19)
634                     */
635                    rowStr = replaceOoocError( rowStr );
636    
637                    /*
638                     * 繧ｰ繝ｩ繝輔ｒ繧ｷ繝ｼ繝域ｯ弱↓繧ｳ繝斐? 5.1.8.0 (2010/07/01)
639                     */
640                    rowStr = replaceGraphInfo( rowStr, sheetNameOrig, sheetNameNew );
641    
642                    /*
643                     * 繧｢繝弱ユ繝ｼ繧ｷ繝ｧ繝ｳ(繧ｳ繝｡繝ｳ繝?繧貞炎髯､ 5.1.8.0 (2010/07/01)
644                     * (繧ｳ繝｡繝ｳ繝医′蟄伜惠縺吶ｋ縺ｨ襍ｷ蜍輔′逡ｰ蟶ｸ縺ｫ驕?￥縺ｪ繧?
645                     */
646                    if( rowStr.indexOf( ANNOTATION_START_TAG ) >= 0 ) {
647                            rowStr = new TagParser() {}.doParse( rowStr, ANNOTATION_START_TAG, ANNOTATION_END_TAG );
648                    }
649    
650                    /*
651                     * 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?5.2.2.0 (2010/11/01)
652                     * 繝??繝悶Ν蜀?↓蟄伜惠縺吶ｋ繧ｹ繧ｿ繧､繝ｫ蜷咲ｧｰ繧呈嶌縺肴鋤縺?
653                     */
654                    if( isNeedsReparse ) {
655                            for( String name : repStyleList ) {
656                                    // 5.6.3.1 (2013/04/05) 螻樊?邨ゆｺ?ｿｽ蜉?
657                                    if( rowStr.indexOf( TABLE_STYLE_NAME_START_TAG + name + TABLE_STYLE_NAME_END_TAG ) >= 0 ) {
658                                            rowStr = rowStr.replace( TABLE_STYLE_NAME_START_TAG + name + TABLE_STYLE_NAME_END_TAG, TABLE_STYLE_NAME_START_TAG + name + "_" + sheetNameNew + TABLE_STYLE_NAME_END_TAG );
659                                    }
660                            }
661    
662                    }
663                    //==============================================================================
664    
665                    bw.write( rowStr );
666            }
667    
668            /**
669             * 蟶ｳ逾ｨ繝??繧ｿ縺ｫ蠢懊§縺ｦ縲√き繝ｩ繝??螻樊?繧貞､画峩(譁?ｭ怜梛竍呈焚蛟､蝙?縺ｫ螟画峩縺励∪縺吶?
670             *
671             * @og.rev 5.1.8.0 (2010/07/01) 譁ｰ隕丈ｽ懈?
672             * @og.rev 5.5.2.4 (2012/05/16) String key 縺ｯ菴ｿ繧上ｌ縺ｦ縺?↑縺??縺ｧ縲∝炎髯､縺励∪縺吶?
673             *
674             * @param row
675             * @param curOffset
676             * @param val
677             * @param type
678             * @param sb
679             */
680            private void changeType( final String row, final int curOffset
681                                                            , final String val, final NativeType type, final StringBuilder sb ) {
682                    if( val == null || val.length() == 0 ) {
683                            return;
684                    }
685                    // 譖ｸ縺肴鋤縺亥ｯｾ雎｡縺ｯ謨ｰ蛟､蝙九?縺ｿ
686                    if( type != NativeType.INT && type != NativeType.LONG && type != NativeType.DOUBLE ) {
687                            return;
688                    }
689                    // 蜃ｦ逅?ｯｾ雎｡縺後そ繝ｫ縺ｧ縺ｪ縺?繧ｪ繝悶ず繧ｧ繧ｯ繝?縺ｯ譖ｸ縺肴鋤縺医＠縺ｪ縺?
690                    if( !isCell( row, curOffset ) ) {
691                            return;
692                    }
693    
694                    // 繧ｻ繝ｫ縺ｮ譁?ｭ励′{@xxxx_n}縺ｮ縺ｿ縺ｧ縺ゅ▲縺溷?蜷医□縺代?謨ｰ蛟､螳夂ｾｩ縺ｮ蛻､螳壹ｒ陦後≧縲?
695                    // (髢｢謨ｰ蜀?↓{@xxxx_n}遲峨′縺ゅ▲縺溷?蜷医?縲∝愛螳壹＠縺ｪ縺?<text:p>{@xxxx_n}</text:p>縺ｮ蝣ｴ蜷医?縺ｿ))
696                    if( sb.lastIndexOf( TEXT_START_TAG ) + TEXT_START_TAG.length() == sb.length()
697                            && row.indexOf( TEXT_END_TAG, curOffset ) == curOffset ) {
698                            int typeIdx = sb.lastIndexOf( TABLE_CELL_STRING_TYPE );
699                            int cellIdx = sb.lastIndexOf( TABLE_CELL_START_TAG );
700                            if( typeIdx >= 0 && cellIdx >= 0 && typeIdx > cellIdx ) {
701                                    // office:value-type="string" 繧?office:value-type="float" office:value="xxx" 縺ｫ螟画鋤
702                                    sb.replace( typeIdx, typeIdx + TABLE_CELL_STRING_TYPE.length()
703                                            ,TABLE_CELL_FLOAT_TYPE + " " + TABLE_CELL_FLOAT_VAL_START + val + TABLE_CELL_FLOAT_VAL_END );
704                            }
705                    }
706            }
707    
708            /**
709             * 蠑墓焚縺ｫ謖?ｮ壹＆繧後◆譁?ｭ怜?縺ｮNative繧ｿ繧､繝励ｒ霑斐＠縺ｾ縺吶?
710             *
711             * 繝ｪ繧ｽ繝ｼ繧ｹ菴ｿ逕ｨ譎ゅ?縲∝推DBType縺ｧ螳夂ｾｩ縺輔ｌ縺櫻ative繧ｿ繧､繝励ｒ縲?
712             * 譛ｪ菴ｿ逕ｨ譎ゅ?縲∝?縺九ｉNative繧ｿ繧､繝励ｒ蜿門ｾ励＠縺ｦ霑斐＠縺ｾ縺吶?
713             *
714             * @og.rev 5.1.8.0 (2010/07/01) NativeType#getType(String) 縺ｮ繝｡繧ｽ繝?ラ繧剃ｽｿ逕ｨ縺吶ｋ繧医≧縺ｫ螟画峩縲?
715             *
716             * @param key
717             * @param val
718             *
719             * @return  NATIVE縺ｮ蝙九?隴伜挨繧ｳ繝ｼ繝?
720             * @see org.opengion.fukurou.model.NativeType
721             */
722            private NativeType getNativeType( final String key, final String val ) {
723                    if( val == null || val.length() == 0 ) {
724                            return NativeType.STRING;
725                    }
726    
727                    NativeType type = null;
728                    if( queue.isFglocal() ) {
729                            String name = key;
730                            int conOffset = key.lastIndexOf( VAR_CON );
731                            if( conOffset >= 0 ) {
732                                    int rownum = -1;
733                                    try {
734                                            rownum = Integer.valueOf( name.substring( conOffset + VAR_CON.length(), name.length() ) );
735                                    }
736                                    // '_'莉･髯阪?譁?ｭ励′謨ｰ蟄励〒縺ｪ縺??蜷医?縲?_'莉･髯阪?譁?ｭ励ｂ繧ｫ繝ｩ繝?錐縺ｮ荳?Κ縺ｨ縺励※謇ｱ縺?
737                                    catch ( NumberFormatException ex ) {}
738                                    if( rownum >= 0 ) {
739                                            name = name.substring( 0, conOffset );
740                                    }
741                            }
742                            int col = queue.getBody().getColumnNo( name, false );
743                            if( col >= 0 ) {
744                                    type = queue.getBody().getDBColumn( col ).getNativeType();
745                            }
746                    }
747    
748                    if( type == null ) {
749                            // ,縺ｯ蜑企勁縺励◆迥ｶ諷九〒蛻､螳?
750                            String repVal = val.replace( ",", "" );
751                            type = NativeType.getType( repVal );                    // 5.1.8.0 (2010/07/01) NativeType#getType(String) 縺ｮ繝｡繧ｽ繝?ラ繧剃ｽｿ逕ｨ
752                            // 謨ｴ謨ｰ蝙九〒縲?nnn縺ｨ縺ｪ縺｣縺ｦ縺?ｋ蝣ｴ蜷医?縲∵枚蟄怜?繧偵＠縺ｦ謇ｱ縺?
753                            if( type == NativeType.INT && repVal.length() >= 2 && repVal.charAt(0) == '0' ) {
754                                    type = NativeType.STRING;
755                            }
756                    }
757    
758                    return type;
759            }
760    
761            /**
762             * 繧ｳ繝｡繝ｳ繝?繧｢繝弱ユ繝ｼ繧ｷ繝ｧ繝ｳ縺ｫ繧医ｋ鄂ｮ縺肴鋤縺亥?逅?ｒ陦後＞縺ｾ縺?
763             * 縺薙?蜃ｦ逅?〒縺ｯ縲｛ffset繧帝?繧√ｋ縺溘ａ縲∵綾繧雁?縺ｨ縺励※蜃ｦ逅?ｾ後?offset繧定ｿ斐＠縺ｾ縺吶?
764             *
765             * @og.rev 5.1.8.0 (2010/07/01) 譁ｰ隕丈ｽ懈?
766             *
767             * @param row
768             * @param curOffset
769             * @param key
770             * @param sb
771             *
772             * @return 蜃ｦ逅?ｾ後?繧ｪ繝輔そ繝?ヨ
773             */
774            private int parseByAnnotation( final String row, final int curOffset, final String key, final StringBuilder sb ) {
775                    int offset = curOffset;
776                    boolean isCell = isCell( row, offset );
777    
778                    // 繧ｻ繝ｫ縺ｮ蝣ｴ蜷医?縺ｿ鄂ｮ縺肴鋤縺医?蛻､螳壹ｒ陦後≧(繧ｪ繝悶ず繧ｧ繧ｯ繝医?蝣ｴ蜷医?蛻､螳壹＠縺ｪ縺?
779                    if( isCell ) {
780                            int cellStrIdx = sb.lastIndexOf( TABLE_CELL_START_TAG, offset );
781                            // office:value-type="float" office:value="xxx" 繧?office:value-type="string" 縺ｫ螟画鋤
782                            // 謨ｰ蛟､蝙九?蝣ｴ蜷医?縲∝ｾ後〒蜀榊ｺｦ螟画鋤繧定｡後≧縲?
783                            // (譁?ｭ怜梛縺ｫ螟画鋤縺励※縺翫°縺ｪ縺?→縲∝?縺系ull縺ｮ蝣ｴ蜷医〒繧?0"縺瑚｡ｨ遉ｺ縺輔ｌ縺ｦ縺励∪縺?◆繧?
784                            int floatIdx = sb.indexOf( TABLE_CELL_FLOAT_TYPE, cellStrIdx );
785                            if( floatIdx >= 0 ) {
786                                    sb.replace( floatIdx, floatIdx + TABLE_CELL_FLOAT_TYPE.length(), TABLE_CELL_STRING_TYPE );
787    
788                                    int floatStrIdx = sb.indexOf( TABLE_CELL_FLOAT_VAL_START, floatIdx );
789                                    if( floatStrIdx >= 0 ) {
790                                            int floatEndIdx = sb.indexOf( TABLE_CELL_FLOAT_VAL_END, floatStrIdx + TABLE_CELL_FLOAT_VAL_START.length() );
791                                            if( floatEndIdx >= 0 ) {
792                                                    sb.replace( floatStrIdx, floatEndIdx + TABLE_CELL_FLOAT_VAL_END.length(), "" );
793                                            }
794                                    }
795                            }
796                    }
797    
798                    // 繧｢繝弱ユ繝ｼ繧ｷ繝ｧ繝ｳ縺ｮ蛟､縺九ｉ縲√そ繝ｫ縺ｮ譁?ｭ怜?驛ｨ蛻?ｒ鄂ｮ縺肴鋤縺?
799                    int endIdx = isCell ? row.indexOf( TABLE_CELL_END_TAG, offset ) : row.indexOf( DRAW_END_KEY, offset );
800                    if( endIdx >= 0 ) {
801                            int textStrIdx = row.indexOf( TEXT_START_ANO_TAG, offset );
802                            // 繧ｻ繝ｫ縺ｮ繧ｳ繝｡繝ｳ繝医?蝣ｴ蜷医?<text:p縺ｧ讀懃ｴ｢縺吶ｋ縺ｨ縲√が繝悶ず繧ｧ繧ｯ繝医?繝?く繧ｹ繝医′讀懃ｴ｢縺輔ｌ縺ｦ縺?ｋ蜿ｯ閭ｽ諤ｧ縺後≠繧九?
803                            // 縺薙?縺溘ａ縲√そ繝ｫ縺ｮ<text:p縺瑚ｦ九▽縺九ｋ縺ｾ縺ｧ讀懃ｴ｢繧堤ｹｰ繧願ｿ斐☆
804                            if( isCell ) {
805                                    while( !isCell( row, textStrIdx ) && textStrIdx >= 0 ) {
806                                            textStrIdx = row.indexOf( TEXT_START_ANO_TAG, textStrIdx + 1 );
807                                    }
808                            }
809                            if( textStrIdx >= 0 && textStrIdx < endIdx ) {
810                                    // 繧ｻ繝ｫ縺ｮ繧ｳ繝｡繝ｳ繝医?蝣ｴ蜷医?</text:p>縺ｧ讀懃ｴ｢縺吶ｋ縺ｨ縲√が繝悶ず繧ｧ繧ｯ繝医?繝?く繧ｹ繝医′讀懃ｴ｢縺輔ｌ縺ｦ縺?ｋ蜿ｯ閭ｽ諤ｧ縺後≠繧九?
811                                    // 縺薙?縺溘ａ縲√そ繝ｫ縺ｮ</text:p>縺瑚ｦ九▽縺九ｋ縺ｾ縺ｧ讀懃ｴ｢繧堤ｹｰ繧願ｿ斐☆
812                                    int textEndIdx = row.lastIndexOf( TEXT_END_TAG, endIdx );
813                                    if( isCell ) {
814                                            while( !isCell( row, textEndIdx ) && textEndIdx >= 0  ) {
815                                                    textEndIdx = row.lastIndexOf( TEXT_END_TAG, textEndIdx - 1 );
816                                            }
817                                    }
818                                    if( textEndIdx >= 0 && textStrIdx < textEndIdx && textEndIdx < endIdx ) {
819                                            // <text:p xxxx> 縺ｮ xxxx> 縺ｮ驛ｨ蛻?style螳夂ｾｩ縺ｪ縺ｩ)繧呈嶌縺崎ｾｼ縺ｿ
820                                            int textStyleEnd = row.indexOf( TEXT_START_END_ANO_TAG, textStrIdx + TEXT_START_ANO_TAG.length() ) + TEXT_START_END_ANO_TAG.length();
821                                            sb.append( row.substring( offset, textStyleEnd ) );
822    
823                                            // <text:p縺ｮ荳ｭ霄ｫ(span繧ｿ繧ｰ縺ｪ縺ｩ繧貞叙繧企勁縺?◆迥ｶ諷九?譁?ｭ怜?
824                                            String textVal = TagParser.checkKey( row.substring( textStyleEnd, textEndIdx ), sb );
825                                            // 蜿門ｾ励＠縺溘ユ繧ｭ繧ｹ繝亥?縺ｫ繧ｿ繧ｰ譁?ｭ励′蜷ｫ縺ｾ繧後※縺?ｋ蝣ｴ蜷医?縲∝?逅?＠縺ｪ縺?
826                                            if( textVal.indexOf( '<' ) < 0 && textVal.indexOf( '>' ) < 0 ) {
827                                                    // <text:p xxxx>繧呈嶌縺榊?縺?
828                                                    String val = getValue( key );
829                                                    // 5.5.2.4 (2012/05/16) String key 縺ｯ菴ｿ繧上ｌ縺ｦ縺?↑縺??縺ｧ縲∝炎髯､縺励∪縺吶?
830                                                    changeType( row, textEndIdx, val, getNativeType( key, textVal ), sb );
831                                                    sb.append( val );
832                                            }
833                                            offset = textEndIdx;
834                                    }
835                            }
836                    }
837    
838                    return offset;
839            }
840    
841            /**
842             * 迴ｾ蝨ｨ縺ｮ繧ｪ繝輔そ繝?ヨ縺後そ繝ｫ縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
843             *
844             * true縺ｮ蝣ｴ蜷医?繧ｻ繝ｫ繧偵?false縺ｮ蝣ｴ蜷医?繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ諢丞袖縺励∪縺吶?
845             *
846             * 繧ｻ繝ｫ縺ｨ縺励※蛻､螳壹＆繧後ｋ縺溘ａ縺ｮ譚｡莉ｶ縺ｯ莉･荳九?騾壹ｊ縺ｧ縺吶?
847             *  迴ｾ蝨ｨ縺ｮoffset繧貞渕貅悶→縺励※縲?
848             *  竭?燕縺ｫ<draw:(繧ｪ繝悶ず繧ｧ繧ｯ繝医?髢句ｧ?縺瑚ｦ九▽縺九ｉ縺ｪ縺?
849             *  竭｡蜑阪↓<table:table-cell(繧ｻ繝ｫ縺ｮ蟋九∪繧?縺?draw:(繧ｪ繝悶ず繧ｧ繧ｯ繝医?蟋九∪繧?繧医ｊ蠕梧婿縺ｫ縺ゅｋ
850             *  竭｢蠕後↓</draw:(繧ｪ繝悶ず繧ｧ繧ｯ繝医?邨ゅｏ繧?縺瑚ｦ九▽縺九ｉ縺ｪ縺?
851             *  竭｣蠕後↓</draw:(繧ｪ繝悶ず繧ｧ繧ｯ繝医?邨ゅｏ繧?縺?/table:table-cell>(繧ｻ繝ｫ縺ｮ邨ゅｏ繧?繧医ｊ蠕梧婿縺ｫ縺ゅｋ
852             *
853             * @param row
854             * @param offset
855             *
856             * @return 迴ｾ蝨ｨ縺ｮ繧ｪ繝輔そ繝?ヨ縺後そ繝ｫ縺九←縺?°(false縺ｮ蝣ｴ蜷医?繧ｪ繝悶ず繧ｧ繧ｯ繝?
857             */
858            private boolean isCell( final String row, final int offset ) {
859                    int drawStartOffset = row.lastIndexOf( DRAW_START_KEY, offset );
860                    if( drawStartOffset < 0 ) {
861                            return true;
862                    }
863                    else {
864                            int cellStartOffset = row.lastIndexOf( TABLE_CELL_START_TAG, offset );
865                            if( drawStartOffset < cellStartOffset ) {
866                                    return true;
867                            }
868                            else {
869                                    int drawEndOffset = row.indexOf( DRAW_END_KEY, offset );
870                                    if( drawEndOffset < 0 ) {
871                                            return true;
872                                    }
873                                    else {
874                                            int cellEndOffset = row.indexOf( TABLE_CELL_END_TAG, offset );
875                                            // 5.1.8.0 (2010/07/01) Avoid unnecessary if..then..else statements when returning a boolean
876                                            return cellEndOffset >= 0 && cellEndOffset < drawEndOffset ;
877                                    }
878                            }
879                    }
880            }
881    
882            /**
883             * QR繧ｳ繝ｼ繝峨ｒ菴懈?縺励∪縺吶?
884             * 縺薙?蜃ｦ逅?〒縺ｯ縲｛ffset繧帝?繧√ｋ縺溘ａ縲∵綾繧雁?縺ｨ縺励※蜃ｦ逅?ｾ後?offset繧定ｿ斐＠縺ｾ縺吶?
885             *
886             * @og.rev 4.3.1.1 (2008/08/23) mkdirs 縺ｮ謌ｻ繧雁?蛻､螳?
887             * @og.rev 4.3.3.5 (2008/11/08) 竊代?蛻､螳壹?蟄伜惠繝√ぉ繝?け繧定｡後▲縺ｦ縺九ｉ蜃ｦ逅?☆繧九?繝輔ぃ繧､繝ｫ蜷阪↓蜃ｦ逅?｡後ｒ莉伜刈
888             * @og.rev 5.3.1.0 (2011/01/01) OpenOffice3.2蟇ｾ蠢?霑ｽ蜉?＠縺溽判蜒上ｒmanifest.xml縺ｫ逋ｻ骭ｲ縺吶ｋ
889             *
890             * @param row
891             * @param curOffset
892             * @param key
893             * @param sb
894             *
895             * @return 蜃ｦ逅?ｾ後?繧ｪ繝輔そ繝?ヨ
896             */
897            private int makeQRImage( final String row, final int curOffset, final String key, final StringBuilder sb ) {
898                    int offset = curOffset;
899    
900                    // {@QRCODE.XXXX}縺九ｉ螳滄圀縺ｫ逕ｻ蜒上?繝代せ縺梧嶌縺九ｌ縺ｦ縺?ｋ驛ｨ蛻?∪縺ｧ繧呈嶌縺崎ｾｼ繧?
901                    offset = row.indexOf( DRAW_IMG_START_TAG, offset ) + DRAW_IMG_START_TAG.length();
902                    sb.append( row.substring( curOffset, offset ) );
903                    // 逕ｻ蜒上?繝代せ縺ｮ邨ゆｺ?う繝ｳ繝?ャ繧ｯ繧ｹ繧呈ｱゅａ繧?
904                    offset = row.indexOf( DRAW_IMG_HREF_END, offset ) + DRAW_IMG_HREF_END.length();
905    
906                    // QRCODE縺ｮ逕ｻ蜒上ヵ繧｡繧､繝ｫ蜷阪ｒ豎ゅａ譖ｸ縺崎ｾｼ繧?
907                    // 4.3.3.5 (2008/11/08) 繝輔ぃ繧､繝ｫ蜷阪↓蜃ｦ逅?｡後ｒ莉伜刈
908                    String fileName = IMG_DIR + '/' + key + "_" + currentBaseRow + QRCODE_FILETYPE;
909                    sb.append( fileName ).append( DRAW_IMG_HREF_END );
910    
911                    // QRCODE縺ｫ譖ｸ縺崎ｾｼ繧??繧呈ｱゅａ繧?
912                    String value = getValue( key );
913    
914                    // QRCODE縺ｮ菴懈?
915                    // 4.3.3.5 (2008/11/08) 繝輔ぃ繧､繝ｫ蜷阪↓蜃ｦ逅?｡後ｒ莉伜刈
916                    String fileNameAbs =
917                            new File( path ).getAbsolutePath() + File.separator + IMG_DIR + File.separator + key + "_" + currentBaseRow + QRCODE_FILETYPE;
918    
919                    // 逕ｻ蜒上Μ繝ｳ繧ｯ縺檎┌蜉ｹ縺ｨ縺ｪ縺｣縺ｦ縺?ｋ蝣ｴ蜷医?縲￣ictures縺ｮ繝輔か繝ｫ繝?′菴懈?縺輔ｌ縺ｦ縺?↑縺?庄閭ｽ諤ｧ縺後≠繧?
920                    // 4.3.1.1 (2008/08/23) mkdirs 縺ｮ謌ｻ繧雁?蛻､螳?
921                    // 4.3.3.5 (2008/11/08) 蟄伜惠繝√ぉ繝?け霑ｽ蜉?
922                    if( !new File( fileNameAbs ).getParentFile().exists() ) {
923                            if( new File( fileNameAbs ).getParentFile().mkdirs() ) {
924                                    System.err.println( fileNameAbs + " 縺ｮ 繝?ぅ繝ｬ繧ｯ繝医Μ菴懈?縺ｫ螟ｱ謨励＠縺ｾ縺励◆縲? );
925                            }
926                    }
927    
928                    QrcodeImage qrImage = new QrcodeImage();
929                    qrImage.init( value, fileNameAbs );
930                    qrImage.saveImage();
931    
932                    // 5.3.1.0 (2011/01/01) OpenOffice3.2蟇ｾ蠢?霑ｽ蜉?＠縺溽判蜒上ｒmanifest.xml縺ｫ逋ｻ骭ｲ縺吶ｋ
933                    addObjs.put( fileName, QRCODE_FILETYPE.substring( 1 ) );
934    
935                    // 隱ｭ縺ｿ霎ｼ縺ｿOffset繧定ｿ斐＠縺ｾ縺?
936                    return offset;
937            }
938    
939            /**
940             * DBTableModel縺ｫ險ｭ螳壹＆繧後◆繝代せ縺九ｉ逕ｻ蜒上ョ繝ｼ繧ｿ繧貞叙蠕励＠縲∝?驛ｨ縺ｫ蜿悶ｊ霎ｼ縺ｿ縺ｾ縺?
941             * 縺薙?蜃ｦ逅?〒縺ｯ縲｛ffset繧帝?繧√ｋ縺溘ａ縲∵綾繧雁?縺ｨ縺励※蜃ｦ逅?ｾ後?offset繧定ｿ斐＠縺ｾ縺吶?
942             *
943             * @og.rev 4.3.3.5 (2008/11/08) 譁ｰ隕剰ｿｽ蜉?
944             * @og.rev 4.3.3.6 (2008/11/15) 逕ｻ蜒上ヱ繧ｹ縺悟ｭ伜惠縺励↑縺??蜷医?縲√Μ繝ｳ繧ｯ繧ｿ繧ｰ(draw:image)閾ｪ菴薙ｒ蜑企勁
945             * @og.rev 5.3.1.0 (2011/01/01) OpenOffice3.2蟇ｾ蠢?霑ｽ蜉?＠縺溽判蜒上ｒmanifest.xml縺ｫ逋ｻ骭ｲ縺吶ｋ
946             *
947             * @param row
948             * @param curOffset
949             * @param key
950             * @param sb
951             *
952             * @return 蜃ｦ逅?ｾ後?繧ｪ繝輔そ繝?ヨ
953             */
954            private int changeImage( final String row, final int curOffset, final String key, final StringBuilder sb ) {
955                    int offset = curOffset;
956                    File imgFile = null;
957    
958                    // 逕ｻ蜒上ヵ繧｡繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?ヱ繧ｹ繧呈ｱゅａ繧?
959                    String value = getValue( key );
960    
961                    if( value != null && value.length() > 0 ) {
962                            imgFile = new File( HybsSystem.url2dir( value ) );
963                    }
964    
965                    // 逕ｻ蜒上ヵ繧｡繧､繝ｫ縺ｮ繝代せ縺悟?縺｣縺ｦ縺?※縲∝ｮ滄圀縺ｫ逕ｻ蜒上′蟄伜惠縺吶ｋ蝣ｴ蜷?
966                    if( imgFile != null && imgFile.exists() ) {
967                            // {@IMG.XXXX}縺九ｉ螳滄圀縺ｫ逕ｻ蜒上?繝代せ縺梧嶌縺九ｌ縺ｦ縺?ｋ驛ｨ蛻?∪縺ｧ繧呈嶌縺崎ｾｼ繧?
968                            offset = row.indexOf( DRAW_IMG_START_TAG, offset ) + DRAW_IMG_START_TAG.length();
969                            sb.append( row.substring( curOffset, offset ) );
970    
971                            // 逕ｻ蜒上?繝代せ縺ｮ邨ゆｺ?う繝ｳ繝?ャ繧ｯ繧ｹ繧呈ｱゅａ繧?
972                            offset = row.indexOf( DRAW_IMG_HREF_END, offset ) + DRAW_IMG_HREF_END.length();
973    
974                            String fileNameOut = IMG_DIR + '/' + imgFile.getName();
975                            sb.append( fileNameOut ).append( DRAW_IMG_HREF_END );
976    
977                            String fileNameOutAbs =
978                                    new File( path ).getAbsolutePath() + File.separator + IMG_DIR + File.separator + imgFile.getName();
979                            if( !new File( fileNameOutAbs ).getParentFile().exists() ) {
980                                    if( new File( fileNameOutAbs ).getParentFile().mkdirs() ) {
981                                            System.err.println( fileNameOutAbs + " 縺ｮ 繝?ぅ繝ｬ繧ｯ繝医Μ菴懈?縺ｫ螟ｱ謨励＠縺ｾ縺励◆縲? );
982                                    }
983                            }
984                            FileUtil.copy( imgFile, new File( fileNameOutAbs ) );
985    
986                            // 5.3.1.0 (2011/01/01) OpenOffice3.2蟇ｾ蠢?霑ｽ蜉?＠縺溽判蜒上ｒmanifest.xml縺ｫ逋ｻ骭ｲ縺吶ｋ
987                            addObjs.put( fileNameOut, getSuffix( imgFile.getName() ) );
988                    }
989                    // 逕ｻ蜒上ヱ繧ｹ縺瑚ｨｭ螳壹＆繧後※縺?↑縺??蜿医?逕ｻ蜒上′蟄伜惠縺励↑縺??蜷?
990                    else {
991                            // {@IMG.XXXX}縺九ｉ隕九※縲?draw:image> ... </draw:image>縺ｾ縺ｧ繧偵せ繧ｭ繝??縺吶ｋ
992                            offset = row.indexOf( DRAW_IMG_START_TAG, offset );
993                            sb.append( row.substring( curOffset, offset ) );
994    
995                            offset = row.indexOf( DRAW_IMG_END_TAG, offset ) + DRAW_IMG_END_TAG.length();
996                    }
997    
998                    // 隱ｭ縺ｿ霎ｼ縺ｿOffset繧定ｿ斐＠縺ｾ縺?
999                    return offset;
1000            }
1001    
1002            /**
1003             * 螟画鋤蠕後?陦後ョ繝ｼ繧ｿ縺ｧ螳夂ｾｩ縺輔ｌ縺ｦ縺?ｋ髢｢謨ｰ縺ｫISERROR髢｢謨ｰ繧貞沂繧∬ｾｼ縺ｿ縺ｾ縺吶?
1004             *
1005             * 縺薙ｌ縺ｯ縲＾Oo縺ｮ髢｢謨ｰ縺ｮ蜍穂ｽ懊→縺励※縲∽ｸ肴ｭ｣縺ｪ蠑墓焚遲峨′蜈･蜉帙＆繧後◆蝣ｴ蜷?null蛟､縺ｪ縺ｩ)縺ｫ縲?
1006             * 繧ｨ繝ｩ繝ｼ:xxx縺ｨ陦ｨ遉ｺ縺輔ｌ縺ｦ縺励∪縺?◆繧√?縺薙ｌ繧帝亟縺舌◆繧√↓髢｢謨ｰ繧ｨ繝ｩ繝ｼ縺ｮ繝上Φ繝峨Μ繝ｳ繧ｰ繧定｡後＞縲?
1007             * 繧ｨ繝ｩ繝ｼ縺ｮ蝣ｴ蜷医?縲∫ｩｺ逋ｽ譁?ｭ励ｒ霑斐☆繧医≧縺ｫ縺励∪縺吶?
1008             *
1009             * @og.rev 4.3.7.2 (2009/06/15) 髢句ｧ区枚蟄励′螟画峩縺ｫ縺ｪ縺｣縺溘◆繧∝ｯｾ蠢?
1010             * @og.rev 5.0.2.0 (2009/11/01) 髢｢謨ｰ蜀??"(quot)縺ｯ縲√Γ繧ｿ譁?ｭ励↓螟画鋤縺吶ｋ
1011             * @og.rev 5.1.7.0 (2010/06/01) 髢｢謨ｰ縺ｮ邨ゅｏ繧翫′)蜃ｺ縺ｪ縺??蜷医↓繧ｨ繝ｩ繝ｼ縺ｨ縺ｪ繧九ヰ繧ｰ繧剃ｿｮ豁｣
1012             * @og.rev 5.1.8.0 (2010/07/01) 繝代?繧ｹ譁ｹ豕輔?蜀?Κ螳溯｣?､画峩
1013             *
1014             * @param row
1015             *
1016             * @return 螟画鋤蠕後?陦後ョ繝ｼ繧ｿ
1017             */
1018            private String replaceOoocError( final String row ) {
1019                    // 4.3.7.2 (2009/06/15) OOOC_FUNCTION_START3縺ｮ譚｡莉ｶ蛻､螳夊ｿｽ蜉??縺ｩ縺｡繧峨°蛻?°繧峨↑縺??縺ｧ螟画焚縺ｧ蜿励￠繧九?
1020                    final String functionStart;
1021                    if( row.indexOf( OOOC_FUNCTION_START_3 ) >= 0 )              { functionStart = OOOC_FUNCTION_START_3; }
1022                    else if( row.indexOf( OOOC_FUNCTION_START ) >= 0 )   { functionStart = OOOC_FUNCTION_START; }
1023                    else { return row; }
1024    
1025                    String rowStr = new TagParser() {
1026                            @Override
1027                            protected boolean checkIgnore( final int strOffset, final int endOffset ) {
1028                                    // 5.1.7.0 (2010/06/01) 髢｢謨ｰ縺ｮ邨ゅｏ繧翫′)蜃ｺ縺ｪ縺??蜷医↓繧ｨ繝ｩ繝ｼ縺ｨ縺ｪ繧九ヰ繧ｰ繧剃ｿｮ豁｣
1029                                    // 蜊倥↑繧玖｡悟盾辣ｧ縺ｧ繧ゅ?of:=縺ｧ蟋九∪繧九′縺薙?蝣ｴ蜷医?縲?未謨ｰ縺ｧ縺ｪ縺?◆繧∫ｵゅｏ繧翫′)縺ｧ縺ｪ縺?
1030                                    // 縺薙?縺溘ａ縲?縺瑚ｦ九▽縺九ｉ縺ｪ縺?∪縺溘?縲√ち繧ｰ縺ｮ邨ゅｏ繧?>)縺悟?縺ｫ隕九▽縺九▲縺溷?蜷医?縲√お繝ｩ繝ｼ髢｢謨ｰ繧?
1031                                    // 蝓九ａ霎ｼ縺ｾ縺ｪ縺?ｈ縺?↓縺吶ｋ縲?
1032                                    int tmpOffset = row.indexOf( ">", strOffset + 1 );
1033                                    return endOffset >= 0 && endOffset < tmpOffset ;
1034                            }
1035    
1036                            @Override
1037                            protected void exec( final String str, final StringBuilder buf, final int offset ) {
1038                                    String key = str.substring( functionStart.length(), str.length() - OOOC_FUNCTION_END.length() ) + ")";
1039                                    key = key.replace( "\"", "&quot;&quot;" ).replace( OOO_CR, "" );
1040                                    buf.append( functionStart + "IF(ISERROR(" + key + ");&quot;&quot;;" + key + OOOC_FUNCTION_END );
1041                            }
1042                    }.doParse( row, functionStart, OOOC_FUNCTION_END );
1043    
1044                    return rowStr;
1045            }
1046    
1047            /**
1048             * 繧ｰ繝ｩ繝戊｡ｨ遉ｺ繝??繧ｿ驛ｨ蛻?ｒ譖ｴ譁ｰ縺励∪縺吶?
1049             *
1050             * @og.rev 5.1.8.0 (2010/07/01) 譁ｰ隕丈ｽ懈?
1051             * @og.rev 5.3.1.0 (2011/01/01) OpenOffice3.2蟇ｾ蠢?霑ｽ蜉?＠縺溽判蜒上ｒmanifest.xml縺ｫ逋ｻ骭ｲ縺吶ｋ
1052             *
1053             * @param row
1054             * @param sheetOrig
1055             * @param sheetNew
1056             *
1057             * @return 螟画鋤蠕後?陦後ョ繝ｼ繧ｿ
1058             */
1059            private String replaceGraphInfo( final String row, final String sheetOrig, final String sheetNew  ) {
1060                    if( row.indexOf( GRAPH_START_TAG ) < 0 || row.indexOf( GRAPH_UPDATE_RANGE_START ) < 0 ) { return row; }
1061    
1062                    String rowStr = new TagParser() {
1063                            @Override
1064                            protected void exec( final String str, final StringBuilder buf, final int offset ) {
1065                                    // <draw:object ... /> 縺ｮ驛ｨ蛻?
1066                                    String graphTag = str;
1067    
1068                                    if( graphTag.indexOf( GRAPH_UPDATE_RANGE_START ) >= 0 ) {
1069                                            String nameOrig = TagParser.getValueFromTag( graphTag, GRAPH_HREF_START, GRAPH_HREF_END );
1070                                            if( new File( path + nameOrig ).exists() ) {
1071                                                    String nameNew = nameOrig + "_" + pages;
1072    
1073                                                    // 繧ｰ繝ｩ繝輔が繝悶ず繧ｧ繧ｯ繝医?螳夂ｾｩ繝輔ぃ繧､繝ｫ繧偵さ繝斐?(./Object X/* 竍?./Object X_n/*)
1074                                                    FileUtil.copyDirectry( path + nameOrig, path + nameNew );
1075                                                    graphTag = graphTag.replace( GRAPH_HREF_START + nameOrig, GRAPH_HREF_START + nameNew );
1076    
1077                                                    // 繧ｰ繝ｩ繝輔が繝悶ず繧ｧ繧ｯ繝医?逕ｻ蜒上う繝｡繝ｼ繧ｸ繧偵さ繝斐?(./ObjectReplacements/Object X 竍?./ObjectReplacements/Object X_n)
1078                                                    // 窶ｻ螳滉ｽ薙?繧ｳ繝斐?縺励↑縺?繝ｪ繝ｳ繧ｯ縺ｮ蜿ら?繧堤┌蜉ｹ縺ｫ縺励※縺翫￥縺薙→縺ｧ縲∵ｬ｡蝗櫁ｵｷ蜍墓凾縺ｫ繧ｰ繝ｩ繝輔?蜀肴緒逕ｻ縺瑚｡後ｏ繧後ｋ)
1079                                                    graphTag = graphTag.replace( GRAPH_HREF_START + GRAPH_OBJREPL + "/" + nameOrig, GRAPH_HREF_START + GRAPH_OBJREPL + "/" + nameNew );
1080    
1081                                                    // OpenOffice3.2蟇ｾ蠢?霑ｽ蜉?＠縺溽判蜒上ｒmanifest.xml縺ｫ逋ｻ骭ｲ縺吶ｋ
1082                                                    addObjs.put( nameNew, "graph" );
1083    
1084                                                    // 繧ｰ繝ｩ繝輔が繝悶ず繧ｧ繧ｯ繝医?螳夂ｾｩ繝輔ぃ繧､繝ｫ縺ｫ險倩ｿｰ縺輔ｌ縺ｦ縺?ｋ螳夂ｾｩ繝輔ぃ繧､繝ｫ繧偵ヱ繝ｼ繧ｹ縺励?繧ｷ繝ｼ繝亥錐縺ｨ{@XXXX}繧堤ｽｮ縺肴鋤縺?
1085                                                    parseGraphContent( path + nameNew + File.separator + "content.xml", sheetOrig, sheetNew );
1086    
1087                                                    // 繧ｰ繝ｩ繝輔?蜿ら?遽?峇縺ｮ繧ｷ繝ｼ繝亥錐繧堤ｽｮ縺肴鋤縺?
1088                                                    String range = TagParser.getValueFromTag( str, GRAPH_UPDATE_RANGE_START, GRAPH_UPDATE_RANGE_END );
1089                                                    graphTag = graphTag.replace( GRAPH_UPDATE_RANGE_START + range, GRAPH_UPDATE_RANGE_START + range.replace( sheetOrig, sheetNew ) );
1090                                            }
1091                                    }
1092    
1093                                    buf.append( graphTag );
1094                            }
1095                    }.doParse( row, GRAPH_START_TAG, GRAPH_END_TAG );
1096    
1097                    return rowStr;
1098            }
1099    
1100            /**
1101             * 繧ｰ繝ｩ繝輔ョ繝ｼ繧ｿ縺ｮcontent.xml繧偵ヱ繝ｼ繧ｹ縺励∪縺吶?
1102             *
1103             * @og.rev 5.1.8.0 (2010/07/01) 譁ｰ隕丈ｽ懈?
1104             *
1105             * @param fileName
1106             * @param sheetOrig
1107             * @param sheetNew
1108             */
1109            private void parseGraphContent( final String fileName, final String sheetOrig, final String sheetNew  ) {
1110                    String graphContent = readOOoXml( fileName );
1111    
1112                    // 繧ｷ繝ｼ繝亥錐縺ｮ鄂ｮ縺肴鋤縺?
1113                    if( graphContent.indexOf( GRAPH_CONTENT_START ) >= 0 ) {
1114                            graphContent = new TagParser() {
1115                                    @Override
1116                                    protected void exec( final String str, final StringBuilder buf, final int offset ) {
1117                                            buf.append( str.replace( sheetOrig, sheetNew ) );
1118                                    }
1119                            }.doParse( graphContent, GRAPH_CONTENT_START, GRAPH_CONTENT_END );
1120                    }
1121    
1122                    // {@XXXX}縺ｮ鄂ｮ縺肴鋤縺?
1123                    if( graphContent.indexOf( VAR_START ) >= 0 ) {
1124                            graphContent = new TagParser() {
1125                                    @Override
1126                                    public void exec( final String str, final StringBuilder buf, final int offset ) {
1127                                            buf.append( getHeaderFooterValue( str ) );
1128                                    }
1129                            }.doParse( graphContent, VAR_START, VAR_END, false );
1130                    }
1131    
1132                    writeOOoXml( fileName, graphContent );
1133            }
1134    
1135            /**
1136             * 謖?ｮ壹＆繧後◆繧ｭ繝ｼ縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
1137             *
1138             * @og.rev 4.3.0.0 (2008/07/18) 繧｢繝ｳ繝??繧ｹ繧ｳ繧｢縺ｮ蜃ｦ逅?､画峩
1139             * @og.rev 4.3.5.0 (2008/02/01) 繧ｫ繝ｩ繝?錐縺ｨ陦檎分蜿ｷ譁?ｭ励?菴咲ｽｮ縺ｯ譛?ｾ後°繧画､懃ｴ｢縺吶ｋ 4.3.3.4 (2008/11/01) 菫ｮ豁｣蛻?
1140             *
1141             * @param key
1142             *
1143             * @return 蛟､
1144             */
1145            private String getValue( final String key ) {
1146                    int conOffset = key.lastIndexOf( VAR_CON );
1147    
1148                    String value = null;
1149    
1150                    if( conOffset < 0 ) {
1151                            value = getHeaderFooterValue( key );
1152                    }
1153                    else {
1154                            String name = key.substring( 0, conOffset );
1155                            int rownum = -1;
1156                            try {
1157                                    rownum = Integer.valueOf( key.substring( conOffset + VAR_CON.length(), key.length() ) ) + currentBaseRow;
1158                            }
1159                            catch ( NumberFormatException ex ) {
1160                                    // 4.3.0.0 (2008/07/18) 繧ｨ繝ｩ繝ｼ縺瑚ｵｷ縺阪※繧ゅ↑縺ｫ繧ゅ＠縺ｪ縺??
1161                                    // queue.addMsg( "[ERROR]髮帛ｽ｢縺ｮ螟画焚螳夂ｾｩ縺瑚ｪ､縺｣縺ｦ縺?∪縺吶?繧ｫ繝ｩ繝?錐=" + name + HybsSystem.CR );
1162                                    // throw new Exception( ex );
1163                            }
1164    
1165                            // 4.3.0.0 (2008/07/18) 繧｢繝ｳ繝??繧ｹ繧ｳ繧｢蠕後′謨ｰ蟄励↓螟画鋤縺ｧ縺阪↑縺??蜷医?繝倥ャ繝?ヵ繝?ち縺ｨ縺励※隱崎ｭ?
1166                            if( rownum < 0 ){
1167                                    value = getHeaderFooterValue( key );
1168                            }
1169                            else{
1170                                    value = getBodyValue( name, rownum );
1171                            }
1172                    }
1173    
1174                    return checkValue( value );
1175            }
1176    
1177            /**
1178             * 謖?ｮ壹＆繧後◆繧ｭ繝ｼ縺ｮ繝倥ャ繝??縲√ヵ繝?ち繝ｼ蛟､繧定ｿ斐＠縺ｾ縺吶?
1179             *
1180             * @og.rev 4.3.6.0 (2009/04/01) 繝ｬ繝ｳ繝?Λ繝ｼ驕ｩ逕ｨ縺輔ｌ縺ｦ縺?↑縺?ヰ繧ｰ繧剃ｿｮ豁｣
1181             * @og.rev 5.0.2.0 (2009/11/01) 繝ｭ繝ｼ繧ｫ繝ｫ繝ｪ繧ｽ繝ｼ繧ｹ繝輔Λ繧ｰ繧剃ｽｿ逕ｨ縺励↑縺??蜷医?縲√Μ繧ｽ繝ｼ繧ｹ螟画鋤繧定｡後ｏ縺ｪ縺??
1182             * @og.rev 5.1.6.0 (2010/05/01) 繝壹?繧ｸNO蜃ｺ蜉帛ｯｾ蠢?
1183             *
1184             * @param key
1185             *
1186             * @return 蛟､
1187             */
1188            private String getHeaderFooterValue( final String key ) {
1189                    String value = "";
1190    
1191                    // 5.1.6.0 (2010/05/01) 繝壹?繧ｸNO蜃ｺ蜉帛ｯｾ蠢?
1192                    if( PAGE_NO.equals( key ) ) {
1193                            value = String.valueOf( pages + 1 );
1194                    }
1195                    // 譛?ｾ後?陦後°繧ｪ繝ｼ繝舌?繝輔Ο繝ｼ譎ゅ?繝輔ャ繧ｿ繝ｼ
1196                    else if( status >= LASTROW ) {
1197                            if( queue.getFooter() != null ) {
1198                                    int clmno = queue.getFooter().getColumnNo( key, false );
1199                                    if( clmno >= 0 ) {
1200                                            value = queue.getFooter().getValue( 0, clmno );
1201                                            // 5.0.2.0 (2009/11/01) 繝ｭ繝ｼ繧ｫ繝ｫ繝ｪ繧ｽ繝ｼ繧ｹ繝輔Λ繧ｰ繧剃ｽｿ逕ｨ縺励↑縺??蜷医?縲√Μ繧ｽ繝ｼ繧ｹ螟画鋤繧定｡後ｏ縺ｪ縺??
1202                                            if( queue.isFglocal() ) {
1203                                                    // 4.3.6.0 (2009/04/01)
1204                                                    value = queue.getFooter().getDBColumn( clmno ).getRendererValue( value );
1205                                            }
1206                                    }
1207                            }
1208                    }
1209                    // 譛?ｾ後?陦後↓縺阪※縺?↑縺??蜷医?繝倥ャ繝??
1210                    else {
1211                            if( queue.getHeader() != null ) {
1212                                    int clmno = queue.getHeader().getColumnNo( key, false );
1213                                    if( clmno >= 0 ) {
1214                                            value = queue.getHeader().getValue( 0, clmno );
1215                                            // 5.0.2.0 (2009/11/01) 繝ｭ繝ｼ繧ｫ繝ｫ繝ｪ繧ｽ繝ｼ繧ｹ繝輔Λ繧ｰ繧剃ｽｿ逕ｨ縺励↑縺??蜷医?縲√Μ繧ｽ繝ｼ繧ｹ螟画鋤繧定｡後ｏ縺ｪ縺??
1216                                            if( queue.isFglocal() ) {
1217                                                    // 4.3.6.0 (2009/04/01)
1218                                                    value = queue.getHeader().getDBColumn( clmno ).getRendererValue( value );
1219                                            }
1220                                    }
1221                            }
1222                    }
1223    
1224                    return value;
1225            }
1226    
1227            /**
1228             * 謖?ｮ壹＆繧後◆陦檎分蜿ｷ縲√く繝ｼ縺ｮ繝懊ョ繧｣繝ｼ蛟､繧定ｿ斐＠縺ｾ縺吶?
1229             *
1230             * @og.rev 4.3.6.0 (2009/04/01) 繝ｬ繝ｳ繝?Λ繝ｼ驕ｩ逕ｨ縺輔ｌ縺ｦ縺?↑縺?ヰ繧ｰ繧剃ｿｮ豁｣
1231             * @og.rev 4.3.6.2 (2009/04/15) 陦檎分蜿ｷ縺ｮ繧医ｊ蟆上＆縺?き繝ｩ繝?ｮ夂ｾｩ繧定ｪｭ繧薙□髫帙↓縲∝?驛ｨ繧ｫ繧ｦ繝ｳ繧ｿ縺後け繝ｪ繧｢縺輔ｌ縺ｦ縺励∪縺?ヰ繧ｰ繧剃ｿｮ豁｣
1232             * @og.rev 4.3.6.2 (2009/04/15) 荳?ｺｦ繧ｪ繝ｼ繝舌?繝輔Ο繝ｼ縺励◆蝣ｴ蜷医↓遘ｻ陦後′蜈ｨ縺ｦ遨ｺ譁?ｭ励〒霑斐▲縺ｦ縺励∪縺?ヰ繧ｰ繧剃ｿｮ豁｣
1233             * @og.rev 5.0.2.0 (2009/11/01) 繝ｭ繝ｼ繧ｫ繝ｫ繝ｪ繧ｽ繝ｼ繧ｹ繝輔Λ繧ｰ繧剃ｽｿ逕ｨ縺励↑縺??蜷医?縲√Μ繧ｽ繝ｼ繧ｹ螟画鋤繧定｡後ｏ縺ｪ縺??
1234             * @og.rev 5.1.6.0 (2010/05/01) 陦檎分蜿ｷ蜃ｺ蜉帛ｯｾ蠢?
1235             * @og.rev 5.1.7.0 (2010/06/01) 隍?焚繧ｷ繝ｼ繝亥ｯｾ蠢?
1236             * @og.rev 5.1.9.0 (2010/08/01) 譛?ｵり｡後〒豁｣縺励￥繧ｷ繝ｼ繝医ヶ繝ｬ繧､繧ｯ縺輔ｌ縺ｪ縺?ヰ繧ｰ繧剃ｿｮ豁｣
1237             *
1238             * @param key
1239             * @param rownum
1240             *
1241             * @return 蛟､
1242             */
1243            private String getBodyValue( final String key, final int rownum ) {
1244                    // if( status == OVERFLOW || isPageBreak ) { return ""; }
1245                    if( isPageBreak ) { return ""; } // 4.3.6.2 (2009/04/15) OVERFLOW譎ゅヰ繧ｰ菫ｮ豁｣
1246    
1247                    int clmno = queue.getBody().getColumnNo( key, false );
1248                    if( clmno < 0 && !ROW_NO.equals( key ) ) { return ""; }
1249    
1250                    // 繝壹?繧ｸ繝悶Ξ繧､繧ｯ蛻､螳壹?蜈郁ｪｭ縺ｿ縺励※蛻､譁ｭ
1251                    if( PAGE_BREAK.equals( key ) ) {
1252                            if( rownum < queue.getBody().getRowCount() - 1 ) {
1253                                    if( !( queue.getBody().getValue( rownum, clmno ).equals( queue.getBody().getValue( rownum + 1, clmno ) ) ) ) {
1254                                            isPageBreak = true;
1255                                    }
1256                            }
1257                            return "";
1258                    }
1259    
1260                    // 5.1.7.0 (2010/06/01) 隍?焚繧ｷ繝ｼ繝亥ｯｾ蠢?
1261                    // 繧ｷ繝ｼ繝医ヶ繝ｬ繧､繧ｯ縺ｯ蠕瑚ｪｭ縺ｿ縺励※蛻､譁ｭ(蜑阪?陦後→逡ｰ縺ｪ縺｣縺ｦ縺?◆蝣ｴ蜷医↓繝悶Ξ繧､繧ｯ)
1262                    if( sheetBreakClm >= 0 ) {
1263                            // 5.1.9.0 (2010/08/01) 譛?ｵり｡後〒豁｣縺励￥繧ｷ繝ｼ繝医ヶ繝ｬ繧､繧ｯ縺輔ｌ縺ｪ縺?ヰ繧ｰ繧剃ｿｮ豁｣
1264                            if( rownum < queue.getBody().getRowCount() && currentBaseRow != rownum ) {
1265                                    if( !( queue.getBody().getValue( currentBaseRow, sheetBreakClm ).equals( queue.getBody().getValue( rownum, sheetBreakClm ) ) ) ) {
1266                                            isPageBreak = true;
1267                                            return "";
1268                                    }
1269                            }
1270                    }
1271    
1272                    if( rownum >= queue.getBody().getRowCount() ) {
1273                            status = OVERFLOW;
1274                            return "";
1275                    }
1276    
1277                    if( rownum == queue.getBody().getRowCount() - 1 ) {
1278                            // status = LASTROW;
1279                            status = Math.max( LASTROW, status ); // 4.3.6.2 (2009/04/15) 閾ｪ霄ｫ縺ｮ繧ｹ繝??繧ｿ繧ｹ縺ｨ豈斐∋縺ｦ螟ｧ縺阪＞譁ｹ繧定ｿ斐☆
1280                    }
1281    
1282                    String value = null;
1283                    // 5.1.6.0 (2010/05/01) 繝壹?繧ｸNO蜃ｺ蜉帛ｯｾ蠢?
1284                    if( ROW_NO.equals( key ) ) {
1285                            value = String.valueOf( rownum + 1 );
1286                    }
1287                    else {
1288                            value = queue.getBody().getValue( rownum, clmno );
1289                            // 5.0.2.0 (2009/11/01) 繝ｭ繝ｼ繧ｫ繝ｫ繝ｪ繧ｽ繝ｼ繧ｹ繝輔Λ繧ｰ繧剃ｽｿ逕ｨ縺励↑縺??蜷医?縲√Μ繧ｽ繝ｼ繧ｹ螟画鋤繧定｡後ｏ縺ｪ縺??
1290                            if( queue.isFglocal() ) {
1291                                    // 4.3.6.0 (2009/04/01)
1292                                    value = queue.getBody().getDBColumn( clmno ).getRendererValue( value );
1293                            }
1294                    }
1295    
1296                    // 4.3.6.2 (2009/04/15)
1297                    if( currentMaxRow < rownum + 1 ) {
1298                            currentMaxRow = rownum + 1;
1299                    }
1300    
1301                    return value;
1302            }
1303    
1304            /**
1305             * 蛟､縺ｫ'<'繧?>','&'縺悟性縺ｾ繧後※縺?◆蝣ｴ蜷医↓繝｡繧ｿ譁?ｭ励↓螟画鋤縺励∪縺吶?
1306             *
1307             * @og.rev 5.0.2.0 (2009/11/01) 謾ｹ陦靴縺ｮ螟画鋤繝ｭ繧ｸ繝?け繧定ｿｽ蜉?
1308             * @og.rev 5.0.2.0 (2009/11/01) 繝ｪ繧ｽ繝ｼ繧ｹ螟画鋤譎ゅ?span繧ｿ繧ｰ繧帝勁蜴ｻ
1309             *
1310             * @param value
1311             *
1312             * @return 螟画鋤蠕後?蛟､
1313             */
1314            private String checkValue( final String value ) {
1315                    String rtn = value;
1316    
1317                    // 5.0.2.0 (2009/11/01)
1318                    if( queue.isFglocal() ) {
1319                            int idx = -1;
1320                            if( ( idx = rtn.indexOf( "<span" ) ) >= 0 ) {
1321                                    String spanStart = rtn.substring( idx, rtn.indexOf( '>', idx ) + 1 );
1322                                    rtn = rtn.replace( spanStart, "" ).replace( "</span>", "" );
1323                            }
1324                    }
1325    
1326                    if( rtn.indexOf( '&' ) >= 0 ) {
1327                            rtn = rtn.replace( "&", "&amp;" );
1328                    }
1329                    if( rtn.indexOf( '<' ) >= 0 ) {
1330                            rtn = rtn.replace( "<", "&lt;" );
1331                    }
1332                    if( rtn.indexOf( '>' ) >= 0 ) {
1333                            rtn = rtn.replace( ">", "&gt;" );
1334                    }
1335                    if( rtn.indexOf( '\n' ) >= 0 ) {
1336                            rtn = rtn.replace( "\r\n", "\n" ).replace( "\n", OOO_CR );
1337                    }
1338    
1339                    return rtn;
1340            }
1341    
1342            /**
1343             * 蠑墓焚縺ｮ譁?ｭ怜?繧呈欠螳壹＆繧後◆髢句ｧ九ち繧ｰ縲∫ｵゆｺ?ち繧ｰ縺ｧ隗｣譫舌＠驟榊?縺ｨ縺励※霑斐＠縺ｾ縺吶?
1344             * 髢句ｧ九ち繧ｰ繧医ｊ蜑阪?譁?ｭ怜?縺ｯ0逡ｪ逶ｮ縺ｫ縲∫ｵゆｺ?ち繧ｰ繧医ｊ蠕後?譁?ｭ怜?縺ｯ1逡ｪ逶ｮ縺ｫ譬ｼ邏阪＆繧後∪縺吶?
1345             * 2逡ｪ逶ｮ莉･髯阪↓縲?幕蟋九ち繧ｰ縲∫ｵゆｺ?ち繧ｰ縺ｮ驛ｨ蛻?′譬ｼ邏阪＆繧後∪縺吶?
1346             *
1347             * @param str
1348             * @param startTag
1349             * @param endTag
1350             *
1351             * @return 隗｣譫千ｵ先棡縺ｮ驟榊?
1352             */
1353            private static String[] tag2Array( final String str, final String startTag, final String endTag ) {
1354                    String header = null;
1355                    String footer = null;
1356                    List<String> body = new ArrayList<String>();
1357    
1358                    int preOffset = -1;
1359                    int curOffset = 0;
1360    
1361                    while( true ) {
1362                            curOffset = str.indexOf( startTag, preOffset + 1 );
1363                            if( curOffset < 0 ) {
1364                                    curOffset = str.lastIndexOf( endTag ) + endTag.length();
1365                                    body.add( str.substring( preOffset, curOffset ) );
1366    
1367                                    footer = str.substring( curOffset );
1368                                    break;
1369                            }
1370                            else if( preOffset == -1 ) {
1371                                    header = str.substring( 0, curOffset );
1372                            }
1373                            else {
1374                                    body.add( str.substring( preOffset, curOffset ) );
1375                            }
1376                            preOffset = curOffset;
1377                    }
1378    
1379                    String[] arr = new String[body.size()+2];
1380                    arr[0] = header;
1381                    arr[1] = footer;
1382                    for( int i=0; i<body.size(); i++ ) {
1383                            arr[i+2] = body.get(i);
1384                    }
1385    
1386                    return arr;
1387            }
1388    
1389            /**
1390             * 蟶ｳ逾ｨ蜃ｦ逅?く繝･繝ｼ繧貞?縺ｫ縲《tyle.xml(繝倥ャ繝??縲√ヵ繝?ち繝ｼ)繧呈嶌縺肴鋤縺医∪縺吶?
1391             *
1392             * @og.rev 5.1.8.0 (2010/07/01) 繝代?繧ｹ譁ｹ豕輔?蜀?Κ螳溯｣?､画峩
1393             */
1394            private void execStyles() {
1395                    String fileName = path + "styles.xml";
1396                    String content = readOOoXml( fileName );
1397    
1398                    if( content.indexOf( VAR_START ) < 0 ) { return; }
1399                    content = new TagParser() {
1400                            @Override
1401                            public void exec( final String str, final StringBuilder buf, final int offset ) {
1402                                    buf.append( getHeaderFooterValue( str ) );
1403                            }
1404                    }.doParse( readOOoXml( fileName ), VAR_START, VAR_END, false );
1405    
1406                    writeOOoXml( fileName, content );
1407            }
1408    
1409            /**
1410             * 蟶ｳ逾ｨ蜃ｦ逅?く繝･繝ｼ繧貞?縺ｫ縲［eta.xml繧呈嶌縺肴鋤縺医∪縺吶?
1411             *
1412             * @og.rev 5.1.6.0 (2010/05/01) 逕ｻ髱｢蟶ｳ逾ｨ菴懈?讖溯?蟇ｾ蠢?API邨檎罰縺ｧ縺ｯ蜃ｺ蜉帙＆繧後↑縺?％縺ｨ縺後≠繧?
1413             */
1414            private void execMeta() {
1415                    String fileName = path + "meta.xml";
1416    
1417                    String meta = readOOoXml( fileName );
1418    
1419                    // 繧ｷ繝ｼ繝域焚譖ｸ縺肴鋤縺?
1420                    // 5.1.6.0 (2010/05/01)
1421                    if( meta.indexOf( TABLE_COUNT_START_TAG ) >=0 ){
1422                            String tableCount = TagParser.getValueFromTag( meta, TABLE_COUNT_START_TAG, TABLE_COUNT_END_TAG );
1423                            meta = meta.replace( TABLE_COUNT_START_TAG + tableCount, TABLE_COUNT_START_TAG + pages );
1424                    }
1425    
1426                    // 繧ｻ繝ｫ謨ｰ譖ｸ縺肴鋤縺?
1427                    // 5.1.6.0 (2010/05/01)
1428                    if( meta.indexOf( CELL_COUNT_START_TAG ) >=0 ){
1429                            String cellCount = TagParser.getValueFromTag( meta, CELL_COUNT_START_TAG, CELL_COUNT_END_TAG );
1430                            meta = meta.replace( CELL_COUNT_START_TAG + cellCount, CELL_COUNT_START_TAG + ( Integer.parseInt( cellCount ) * pages ) );
1431                    }
1432    
1433                    // 繧ｪ繝悶ず繧ｧ繧ｯ繝域焚譖ｸ縺肴鋤縺?
1434                    // 5.1.6.0 (2010/05/01)
1435                    if( meta.indexOf( OBJECT_COUNT_START_TAG ) >= 0 ){
1436                            String objectCount = TagParser.getValueFromTag( meta, OBJECT_COUNT_START_TAG, OBJECT_COUNT_END_TAG );
1437                            //4.2.4.0 (2008/06/02) 蟄伜惠縺励↑縺??蜷医?null縺ｧ蟶ｰ縺｣縺ｦ縺上ｋ縺ｮ縺ｧ辟｡隕悶☆繧?
1438                            if( objectCount != null){
1439                                    meta = meta.replace( OBJECT_COUNT_START_TAG + objectCount, OBJECT_COUNT_START_TAG + ( Integer.parseInt( objectCount ) * pages ) );
1440                            }
1441                    }
1442    
1443                    writeOOoXml( fileName, meta );
1444            }
1445    
1446            /**
1447             * 譖ｸ縺肴鋤縺亥ｯｾ雎｡縺ｮ繧ｹ繧ｿ繧､繝ｫ繝ｪ繧ｹ繝医ｒ蜿門ｾ励＠縺ｾ縺吶?
1448             *
1449             * @og.rev 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
1450             *
1451             * @param header content.xml縺ｮ繝倥ャ繝??
1452             */
1453            private void getRepStyleList( final String header ) {
1454                    String[] tags = tag2Array( header, STYLE_START_TAG, STYLE_END_TAG );
1455                    Set<String> origNameSet = pageNameMap.keySet();
1456                    for( int i=2; i<tags.length; i++ ) {
1457                            for( String origName : origNameSet ) {
1458                                    if( tags[i].indexOf( "=\"" + origName + "." ) >= 0 ) {
1459                                            String styleName = TagParser.getValueFromTag( tags[i], STYLE_NAME_START_TAG, STYLE_NAME_END_TAG );
1460                                            repStyleList.add( styleName );
1461                                            break;
1462                                    }
1463                            }
1464                    }
1465            }
1466    
1467            /**
1468             * 蟶ｳ逾ｨ蜃ｦ逅?く繝･繝ｼ繧貞?縺ｫ縲…ontent.xml繧呈嶌縺肴鋤縺医∪縺吶?
1469             * 縺ｾ縺壹?XML繧剃ｸ?率繝｡繝｢繝ｪ荳翫↓螻暮幕縺励◆蠕後?繧ｷ繝ｼ繝亥腰菴阪↓蛻?ｧ｣縺励?繝??繧ｿ縺ｮ蝓九ａ霎ｼ縺ｿ繧定｡後＞縺ｾ縺吶?
1470             *
1471             * @og.rev 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
1472             */
1473            private void execContentHeader() {
1474                    String fileName = path + "content.xml";
1475                    String content = readOOoXml( fileName );
1476    
1477                    // 繝輔ぃ繧､繝ｫ縺ｮ隗｣譫舌＠縲√す繝ｼ繝?陦悟腰菴阪↓蛻?ｧ｣
1478                    String[] tags = tag2Array( content, STYLE_START_TAG, STYLE_END_TAG );
1479                    String header = tags[0];
1480                    String footer = tags[1];
1481    
1482                    BufferedWriter bw = null;
1483                    try {
1484                            bw = getWriter( fileName );
1485                            bw.write( xmlHeader );
1486                            bw.write( '\n' );
1487                            bw.write( header );
1488    
1489                            // 繧ｹ繧ｿ繧､繝ｫ諠??縺ｫ繧ｷ繝ｼ繝井ｾ晏ｭ倥?諠??縺後≠繧句?蜷医?縲√?繝ｼ繧ｸ蛻?□縺代さ繝斐?縺吶ｋ縲?
1490                            Set<String> origNameSet = pageNameMap.keySet();
1491                            for( int i=2; i<tags.length; i++ ) {
1492                                    boolean isReplace = false;
1493                                    for( String origName : origNameSet ) {
1494                                            if( tags[i].indexOf( "=\"" + origName + "." ) >= 0 ) {
1495                                                    List<String> newNames = pageNameMap.get( origName );
1496                                                    for( String newName : newNames ) {
1497                                                            String styleStr = tags[i].replace( "=\"" + origName + "." , "=\"" + newName + "." );
1498                                                            // 繧ｷ繝ｼ繝亥錐縺ｮ譖ｸ縺肴鋤縺?
1499                                                            String styleName = TagParser.getValueFromTag( styleStr, STYLE_NAME_START_TAG, STYLE_NAME_END_TAG );
1500                                                            styleStr = styleStr.replace( STYLE_NAME_START_TAG + styleName, STYLE_NAME_START_TAG + styleName + "_" + newName );
1501                                                            bw.write( styleStr );
1502                                                            isReplace = true;
1503                                                    }
1504                                                    break;
1505                                            }
1506                                    }
1507    
1508                                    if( !isReplace ) {
1509                                            bw.write( tags[i] );
1510                                    }
1511                            }
1512    
1513                            bw.write( footer );
1514                            bw.flush();
1515                    }
1516                    catch ( IOException ex ) {
1517                            queue.addMsg( "[ERROR]PARSE:error occurer while write ReParsed Sheet " + fileName + HybsSystem.CR );
1518                            throw new HybsSystemException( ex );
1519                    }
1520                    finally {
1521                            Closer.ioClose( bw );
1522                    }
1523            }
1524    
1525            /**
1526             * content.xml縺ｮ繝倥ャ繝??驛ｨ蛻?ｒ蜃ｺ蜉帙＠縺歡ontent.xml縺ｫ縲√?繝?ム繝ｼ驛ｨ蛻?ｻ･髯阪ｒ蜃ｺ蜉帙＠縺?
1527             * content.xml.bak繧偵?繝ｼ繧ｸ縺励∪縺吶?
1528             *
1529             * @og.rev 5.2.2.0 (2010/11/01) 譚｡莉ｶ莉俶嶌蠑丞ｯｾ蠢?
1530             */
1531            private void execMergeContent() {
1532                    FileChannel srcChannel = null;
1533                    FileChannel destChannel = null;
1534                    try {
1535                            srcChannel = new FileInputStream( path + "content.xml.tmp" ).getChannel();
1536                            destChannel = new FileOutputStream( path + "content.xml", true ).getChannel();
1537                            srcChannel.transferTo(0, srcChannel.size(), destChannel);
1538                    }
1539                    catch ( IOException ex ) {
1540                            queue.addMsg( "[ERROR]PARSE:error occurer while merge content.xml" + HybsSystem.CR );
1541                            throw new HybsSystemException( ex );
1542                    }
1543                    finally {
1544                            Closer.ioClose( srcChannel );
1545                            Closer.ioClose( destChannel );
1546                    }
1547                    FileUtil.deleteFiles( new File( path + "content.xml.tmp" ) );
1548            }
1549    
1550            /**
1551             * META-INF/manifest.xml縺ｫ縲∬ｿｽ蜉?＠縺溘が繝悶ず繧ｧ繧ｯ繝?繧ｰ繝ｩ繝輔?逕ｻ蜒?繧堤匳骭ｲ縺励∪縺吶?
1552             *
1553             * @og.rev 5.3.1.0 (2011/12/01) 譁ｰ隕丈ｽ懈?
1554             */
1555            private void execManifest() {
1556                    String fileName = path + "META-INF" + File.separator + "manifest.xml";
1557                    String[] conArr = TagParser.tag2Array( readOOoXml( fileName ), MANIFEST_START_TAG, MANIFEST_END_TAG );
1558    
1559                    StringBuilder buf = new StringBuilder();
1560                    buf.append( conArr[0] );
1561                    for( int i=2; i<conArr.length; i++ ) {
1562                            buf.append( conArr[i] );
1563                    }
1564                    for( Map.Entry<String,String> entry : addObjs.entrySet() ) {
1565                            if( "graph".equals( entry.getValue() ) ) {
1566                                    buf.append( "<manifest:file-entry manifest:media-type=\"text/xml\" manifest:full-path=\"" + entry.getKey() + "/content.xml\"/>" );
1567                                    buf.append( "<manifest:file-entry manifest:media-type=\"text/xml\" manifest:full-path=\"" + entry.getKey() + "/styles.xml\"/>" );
1568                                    buf.append( "<manifest:file-entry manifest:media-type=\"text/xml\" manifest:full-path=\"" + entry.getKey() + "/meta.xml\"/>" );
1569                                    buf.append( "<manifest:file-entry manifest:media-type=\"application/vnd.oasis.opendocument.chart\" manifest:full-path=\"" + entry.getKey() + "/\"/>" );
1570                            }
1571                            else {
1572                                    buf.append( "<manifest:file-entry manifest:media-type=\"image/" + entry.getValue() + "\" manifest:full-path=\"" + entry.getKey() + "\"/>" );
1573                            }
1574                    }
1575                    buf.append( conArr[1] );
1576    
1577                    writeOOoXml( fileName, buf.toString() );
1578            }
1579    
1580            /**
1581             * XML繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ蜿悶ｊ縲∫ｵ先棡繧定ｿ斐＠縺ｾ縺吶?
1582             * OOo縺ｮXML繝輔ぃ繧､繝ｫ縺ｯ蜈ｨ縺ｦ1陦後ａ縺警ml螳｣險?〒縲?陦檎岼縺悟?螳ｹ蜈ｨ菴薙→縺?≧蠖｢蠑上〒縺ゅｋ縺溘ａ縲?
1583             * 縺薙％縺ｧ縺ｯ縲?陦檎岼縺ｮ蜀?ｮｹ驛ｨ蛻?ｒ霑斐＠縺ｾ縺吶?
1584             *
1585             * @og.rev 4.3.6.0 (2009/04/01) meta.xml縺ｧ繧ｳ繝ｳ繝?Φ繝??驛ｨ蛻?′謾ｹ陦後＆繧後※縺?ｋ蝣ｴ蜷医′縺ゅｋ縺溘ａ縲√Ν繝ｼ繝励ｒ蝗槭＠縺ｦ隱ｭ霎ｼ縺ｿ
1586             *
1587             * @param fileName
1588             *
1589             * @return 隱ｭ縺ｿ蜿悶▲縺滓枚蟄怜?
1590             */
1591            private String readOOoXml( final String fileName ) {
1592                    File file = new File ( fileName );
1593    
1594                    BufferedReader br = null;
1595                    String tmp = null;
1596                    StringBuilder buf = new StringBuilder();
1597                    try {
1598                            br = new BufferedReader( new InputStreamReader( new FileInputStream( file ), "UTF-8" ) );
1599                            xmlHeader = br.readLine();
1600                            while( ( tmp = br.readLine() ) != null ) { // 4.3.6.0 (2009/04/01)
1601                                    buf.append( tmp );
1602                            }
1603                    }
1604                    catch( IOException ex ) {
1605                            queue.addMsg( "[ERROR]PARSE:Failed to read " + fileName + HybsSystem.CR );
1606                            throw new HybsSystemException( ex );
1607                    }
1608                    finally {
1609                            Closer.ioClose( br );
1610                    }
1611    
1612                    String str = buf.toString();
1613                    if( xmlHeader == null || xmlHeader.length() == 0 || str == null || str.length() == 0 ) {
1614                            queue.addMsg( "[ERROR]PARSE:Maybe " + fileName + " is Broken!" + HybsSystem.CR );
1615                            throw new HybsSystemException();
1616                    }
1617    
1618                    return str;
1619            }
1620    
1621            /**
1622             * XML繝輔ぃ繧､繝ｫ繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
1623             * OOo縺ｮXML繝輔ぃ繧､繝ｫ縺ｯ蜈ｨ縺ｦ1陦後ａ縺警ml螳｣險?〒縲?陦檎岼縺悟?螳ｹ蜈ｨ菴薙→縺?≧蠖｢蠑上〒縺ゅｋ縺溘ａ縲?
1624             * 縺薙％縺ｧ縺ｯ縲?陦檎岼縺ｮ蜀?ｮｹ驛ｨ蛻?ｒ貂｡縺吶％縺ｨ縺ｧ縲々ML繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺励∪縺吶?
1625             *
1626             * @param fileName 譖ｸ縺崎ｾｼ繧?ML繝輔ぃ繧､繝ｫ蜷?
1627             * @param str 譖ｸ縺崎ｾｼ繧?枚蟄怜?
1628             */
1629            private void writeOOoXml( final String fileName, final String str ) {
1630                    BufferedWriter bw = null;
1631                    try {
1632                            bw = getWriter( fileName );
1633                            bw.write( xmlHeader );
1634                            bw.write( '\n' );
1635                            bw.write( str );
1636                            bw.flush();
1637                    }
1638                    catch( IOException ex  ) {
1639                            queue.addMsg( "[ERROR]PARSE:Failed to write " + fileName + HybsSystem.CR );
1640                            throw new HybsSystemException( ex );
1641                    }
1642                    finally {
1643                            Closer.ioClose( bw );
1644                    }
1645            }
1646    
1647            /**
1648             * XML繝輔ぃ繧､繝ｫ譖ｸ縺崎ｾｼ縺ｿ逕ｨ縺ｮ繝ｩ繧､繧ｿ繝ｼ繧定ｿ斐＠縺ｾ縺吶?
1649             *
1650             * @param fileName 繝輔ぃ繧､繝ｫ蜷?
1651             *
1652             * @return 繝ｩ繧､繧ｿ繝ｼ
1653             */
1654            private BufferedWriter getWriter( final String fileName ) {
1655                    return getWriter( fileName, false );
1656            }
1657    
1658            /**
1659             * XML繝輔ぃ繧､繝ｫ譖ｸ縺崎ｾｼ縺ｿ逕ｨ縺ｮ繝ｩ繧､繧ｿ繝ｼ繧定ｿ斐＠縺ｾ縺吶?
1660             *
1661             * @param fileName 繝輔ぃ繧､繝ｫ蜷?
1662             * @param append 繧｢繝吶Φ繝峨☆繧九°
1663             *
1664             * @return 繝ｩ繧､繧ｿ繝ｼ
1665             */
1666            private BufferedWriter getWriter( final String fileName, final boolean append ) {
1667                    File file = new File ( fileName );
1668                    BufferedWriter bw;
1669                    try {
1670                            bw = new BufferedWriter( new OutputStreamWriter( new FileOutputStream( file, append ), "UTF-8" ) );
1671                    }
1672                    catch ( UnsupportedEncodingException ex ) {
1673                            queue.addMsg( "[ERROR] Input File is written by Unsupported Encoding" );
1674                            throw new HybsSystemException( ex );
1675                    }
1676                    catch ( FileNotFoundException ex ) {
1677                            queue.addMsg( "[ERROR] File not Found" );
1678                            throw new HybsSystemException( ex );
1679                    }
1680                    return bw;
1681            }
1682    
1683            /**
1684             * 繝輔ぃ繧､繝ｫ蜷阪°繧画僑蠑ｵ蟄?蟆乗枚蟄?繧呈ｱゅａ縺ｾ縺吶?
1685             *
1686             * @param fileName 諡｡蠑ｵ蟄舌ｒ蜿門ｾ励☆繧狗ぜ縺ｮ繝輔ぃ繧､繝ｫ蜷?
1687             *
1688             * @return 諡｡蠑ｵ蟄?蟆乗枚蟄?
1689             */
1690            public static String getSuffix( final String fileName ) {
1691                    String suffix = null;
1692                    if( fileName != null ) {
1693                            int sufIdx = fileName.lastIndexOf( '.' );
1694                            if( sufIdx >= 0 ) {
1695                                    suffix = fileName.substring( sufIdx + 1 ).toLowerCase( Locale.JAPAN );
1696                            }
1697                    }
1698                    return suffix;
1699            }
1700    }
1701