Author: ilgrosso
Date: Tue Oct 11 07:25:31 2016
New Revision: 1764205
URL: http://svn.apache.org/viewvc?rev=1764205&view=rev
Log:
[COCOON-2354] Applying provided patch - had to rebuild poi from source tag as the JAR from Maven is built for JDK 1.6
Added:
cocoon/branches/BRANCH_2_1_X/lib/optional/commons-codec-1.5.jar (with props)
cocoon/branches/BRANCH_2_1_X/lib/optional/poi-3.10-FINAL.jar (with props)
Removed:
cocoon/branches/BRANCH_2_1_X/lib/optional/commons-codec-1.3.jar
cocoon/branches/BRANCH_2_1_X/lib/optional/poi-3.0.2-FINAL-20080204.jar
Modified:
cocoon/branches/BRANCH_2_1_X/lib/jars.xml
cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Cell.java
cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/EPMerge.java
cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Sheet.java
cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Workbook.java
cocoon/branches/BRANCH_2_1_X/src/blocks/poi/samples/content/simple-date-test.xml
Modified: cocoon/branches/BRANCH_2_1_X/lib/jars.xml
URL: http://svn.apache.org/viewvc/cocoon/branches/BRANCH_2_1_X/lib/jars.xml?rev=1764205&r1=1764204&r2=1764205&view=diff
==============================================================================
--- cocoon/branches/BRANCH_2_1_X/lib/jars.xml (original)
+++ cocoon/branches/BRANCH_2_1_X/lib/jars.xml Tue Oct 11 07:25:31 2016
@@ -496,7 +496,7 @@
document objects.
</description>
<used-by>MS Excel serializer (poi block)</used-by>
- <lib>optional/poi-3.0.2-FINAL-20080204.jar</lib>
+ <lib>optional/poi-3.10-FINAL.jar</lib>
<homepage>http://jakarta.apache.org/poi/</homepage>
</file>
@@ -829,7 +829,7 @@
<title>Jakarta Commons Codec</title>
<description>Implementations of common encoders and decoders</description>
<used-by>WebDAV block</used-by>
- <lib>optional/commons-codec-1.3.jar</lib>
+ <lib>optional/commons-codec-1.5.jar</lib>
<homepage>http://commons.apache.org/codec/</homepage>
</file>
Added: cocoon/branches/BRANCH_2_1_X/lib/optional/commons-codec-1.5.jar
URL: http://svn.apache.org/viewvc/cocoon/branches/BRANCH_2_1_X/lib/optional/commons-codec-1.5.jar?rev=1764205&view=auto
==============================================================================
Binary file - no diff available.
Propchange: cocoon/branches/BRANCH_2_1_X/lib/optional/commons-codec-1.5.jar
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: cocoon/branches/BRANCH_2_1_X/lib/optional/poi-3.10-FINAL.jar
URL: http://svn.apache.org/viewvc/cocoon/branches/BRANCH_2_1_X/lib/optional/poi-3.10-FINAL.jar?rev=1764205&view=auto
==============================================================================
Binary file - no diff available.
Propchange: cocoon/branches/BRANCH_2_1_X/lib/optional/poi-3.10-FINAL.jar
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Modified: cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Cell.java
URL: http://svn.apache.org/viewvc/cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Cell.java?rev=1764205&r1=1764204&r2=1764205&view=diff
==============================================================================
--- cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Cell.java (original)
+++ cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Cell.java Tue Oct 11 07:25:31 2016
@@ -44,16 +44,12 @@ class Cell {
/**
* Constructor Cell.
- * Only a hack as long as the POI stuff is not maintained in the POI CVS:
- * Setting the encoding to UTF-16 for internationalization
- * (<a href="http://jakarta.apache.org/poi/javadocs/org/apache/poi/hssf/usermodel/HSSFCell.html#getEncoding()">POI API</a>).
*
* @param cell
*/
Cell(final HSSFCell cell, final int cellType) {
_cell = cell;
_celltype = cellType;
- _cell.setEncoding(HSSFCell.ENCODING_UTF_16);
}
/**
Modified: cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/EPMerge.java
URL: http://svn.apache.org/viewvc/cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/EPMerge.java?rev=1764205&r1=1764204&r2=1764205&view=diff
==============================================================================
--- cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/EPMerge.java (original)
+++ cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/EPMerge.java Tue Oct 11 07:25:31 2016
@@ -17,8 +17,7 @@
package org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements;
-import org.apache.poi.hssf.util.RangeAddress;
-import org.apache.poi.hssf.util.Region;
+import org.apache.poi.ss.util.CellRangeAddress;
import java.io.IOException;
@@ -54,25 +53,9 @@ public class EPMerge extends BaseElement
* @exception IOException
*/
public void endProcessing() throws IOException {
- RangeAddress rangeAddress = new RangeAddress(getCellRange());
Sheet sheet = this.getSheet();
-
- //subtracting one since rangeaddress starts at 1,1 where rows/cols
- // start at 0,0
- short fromCol =
- (short) (rangeAddress.getXPosition(rangeAddress.getFromCell()) - 1);
- int fromRow = rangeAddress.getYPosition(rangeAddress.getFromCell()) - 1;
- short toCol =
- (short) (rangeAddress.getXPosition(rangeAddress.getToCell()) - 1);
- int toRow = rangeAddress.getYPosition(rangeAddress.getToCell()) - 1;
-
- if (getLogger().isDebugEnabled()) {
- getLogger().debug("Merging Range: Row (" + fromRow + ") Col ("
- + fromCol + ")" + " to Row (" + toRow + ") Col (" + toCol
- + ")");
- }
- Region region = new Region(fromRow, fromCol, toRow, toCol);
- sheet.addMergedRegion(region);
+ CellRangeAddress range = CellRangeAddress.valueOf(getCellRange());
+ sheet.addMergedRegion(range);
}
} // end public class EPMerge
Modified: cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Sheet.java
URL: http://svn.apache.org/viewvc/cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Sheet.java?rev=1764205&r1=1764204&r2=1764205&view=diff
==============================================================================
--- cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Sheet.java (original)
+++ cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Sheet.java Tue Oct 11 07:25:31 2016
@@ -33,6 +33,7 @@ import org.apache.poi.hssf.usermodel.HSS
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.hssf.util.Region;
+import org.apache.poi.ss.util.CellRangeAddress;
/**
* internal representation of a Sheet
@@ -128,7 +129,8 @@ class Sheet extends AbstractLogEnabled {
* @return default column width (in 1/256ths of a character width)
*/
short getDefaultColumnWidth() {
- return _sheet.getDefaultColumnWidth();
+ Integer objColWidth = new Integer(_sheet.getDefaultColumnWidth());
+ return objColWidth.shortValue();
}
/**
@@ -237,6 +239,14 @@ class Sheet extends AbstractLogEnabled {
}
/**
+ * Flag a certain region of cells to be merged
+ * @param range the cell range to create as merged
+ */
+ void addMergedRegion(CellRangeAddress range) {
+ this._sheet.addMergedRegion(range);
+ }
+
+ /**
* assigns blank cells to regions where no cell is currently allocated.
* Meaning if there is a sheet with a cell defined at 1,1 and a style
* region from 0,0-1,1 then cells 0,0;0,1;1,0 will be defined as blank
Modified: cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Workbook.java
URL: http://svn.apache.org/viewvc/cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Workbook.java?rev=1764205&r1=1764204&r2=1764205&view=diff
==============================================================================
--- cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Workbook.java (original)
+++ cocoon/branches/BRANCH_2_1_X/src/blocks/poi/java/org/apache/cocoon/components/elementprocessor/impl/poi/hssf/elements/Workbook.java Tue Oct 11 07:25:31 2016
@@ -104,7 +104,7 @@ class Workbook {
* @param name the new name for the sheet
*/
void renameSheet(final int index, final String name) {
- _workbook.setSheetName(index, name, HSSFWorkbook.ENCODING_UTF_16);
+ _workbook.setSheetName(index, name);
}
/**
Modified: cocoon/branches/BRANCH_2_1_X/src/blocks/poi/samples/content/simple-date-test.xml
URL: http://svn.apache.org/viewvc/cocoon/branches/BRANCH_2_1_X/src/blocks/poi/samples/content/simple-date-test.xml?rev=1764205&r1=1764204&r2=1764205&view=diff
==============================================================================
--- cocoon/branches/BRANCH_2_1_X/src/blocks/poi/samples/content/simple-date-test.xml (original)
+++ cocoon/branches/BRANCH_2_1_X/src/blocks/poi/samples/content/simple-date-test.xml Tue Oct 11 07:25:31 2016
@@ -118,7 +118,11 @@
<gmr:Cell Col="1" Row="17">=date(year(now()), month(now()) + 3, day(now()))</gmr:Cell>
<gmr:Cell Col="0" Row="18" ValueType="60">today minus 2 years:</gmr:Cell>
<gmr:Cell Col="1" Row="18">=date(year(now()) - 2, month(now()), day(now()))</gmr:Cell>
+ <gmr:Cell Col="0" Row="19" ValueType="60">Tets Merge cell range</gmr:Cell>
</gmr:Cells>
+ <gmr:MergedRegions>
+ </gmr:MergedRegions>
+ <Merge>A20:B20</Merge>
</gmr:Sheet>
</gmr:Sheets>
</gmr:Workbook>
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.