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