[patch] Altered ColumnHelper, that uses the CTCol and CTCols proxies

ColumnHelper.java (text/plain), 12.45 KB, created by val235 on 2012-10-08 18:46:49 UTC

(hide)

Description: Altered ColumnHelper, that uses the CTCol and CTCols proxies

Filename:

MIME Type:

Creator: val235

Created: 2012-10-08 18:46:49 UTC

Size: 12.45 KB

patch

obsolete

>/* ==================================================================== > Licensed to the Apache Software Foundation (ASF) under one or more > contributor license agreements. See the NOTICE file distributed with > this work for additional information regarding copyright ownership. > The ASF licenses this file to You under the Apache License, Version 2.0 > (the "License"); you may not use this file except in compliance with > the License. You may obtain a copy of the License at > > http://www.apache.org/licenses/LICENSE-2.0 > > Unless required by applicable law or agreed to in writing, software > distributed under the License is distributed on an "AS IS" BASIS, > WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. > See the License for the specific language governing permissions and > limitations under the License. >==================================================================== */ > >package org.apache.poi.xssf.usermodel.helpers; > >import java.lang.reflect.Proxy; >import java.util.Arrays; > >import org.apache.poi.ss.usermodel.CellStyle; >import org.apache.poi.xssf.util.CTColComparator; >import org.apache.poi.xssf.util.NumericRanges; >import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol; >import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols; >import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet; > >/** > * Helper class for dealing with the Column settings on > * a CTWorksheet (the data part of a sheet). > * Note - within POI, we use 0 based column indexes, but > * the column definitions in the XML are 1 based! > */ >public class ColumnHelper { > > private CTWorksheet worksheet; > private CTCols newCols; > > public ColumnHelper(CTWorksheet worksheet) { > super(); > this.worksheet = worksheet; > cleanColumns(); > } > > @SuppressWarnings("deprecation") //YK: getXYZArray() array accessors are deprecated in xmlbeans with JDK 1.5 support > public void cleanColumns() { > > CTCols newCTCols =CTCols.Factory.newInstance(); > > this.newCols =(CTCols) Proxy.newProxyInstance( > CTColsProxy.class.getClassLoader(), > new Class[] { CTCols.class }, > new CTColsProxy(newCTCols)); > > CTCols[] colsArray = worksheet.getColsArray(); > int i = 0; > for (i = 0; i < colsArray.length; i++) { > CTCols cols = colsArray[i]; > CTCol[] colArray = cols.getColArray(); > for (int y = 0; y < colArray.length; y++) { > CTCol col = colArray[y]; > newCols = addCleanColIntoCols(newCols, col); > } > sortColumns(newCols); > } > for (int y = i - 1; y >= 0; y--) { > worksheet.removeCols(y); > } > worksheet.addNewCols(); > > if(newCols instanceof Proxy && Proxy.getInvocationHandler(newCols) instanceof CTColsProxy){ > worksheet.setColsArray(0, ((CTColsProxy)Proxy.getInvocationHandler(newCols)).getProxied()); > }else{ > worksheet.setColsArray(0, newCols); > } > > > } > > @SuppressWarnings("deprecation") //YK: getXYZArray() array accessors are deprecated in xmlbeans with JDK 1.5 support > public static void sortColumns(CTCols newCols) { > CTCol[] colArray = newCols.getColArray(); > Arrays.sort(colArray, new CTColComparator()); > newCols.setColArray(colArray); > } > > public CTCol cloneCol(CTCols cols, CTCol col) { > CTCol newCol = cols.addNewCol(); > newCol.setMin(col.getMin()); > newCol.setMax(col.getMax()); > setColumnAttributes(col, newCol); > return newCol; > } > > /** > * Returns the Column at the given 0 based index > */ > public CTCol getColumn(long index, boolean splitColumns) { > return getColumn1Based(index+1, splitColumns); > } > /** > * Returns the Column at the given 1 based index. > * POI default is 0 based, but the file stores > * as 1 based. > */ > public CTCol getColumn1Based(long index1, boolean splitColumns) { > CTCols colsArray = worksheet.getColsArray(0); > for (int i = 0; i < colsArray.sizeOfColArray(); i++) { > CTCol colArray = colsArray.getColArray(i); > if (colArray.getMin() <= index1 && colArray.getMax() >= index1) { > if (splitColumns) { > if (colArray.getMin() < index1) { > insertCol(colsArray, colArray.getMin(), (index1 - 1), new CTCol[]{colArray}); > } > if (colArray.getMax() > index1) { > insertCol(colsArray, (index1 + 1), colArray.getMax(), new CTCol[]{colArray}); > } > colArray.setMin(index1); > colArray.setMax(index1); > } > return colArray; > } > } > return null; > } > > public CTCols addCleanColIntoCols(CTCols cols, CTCol col) { > boolean colOverlaps = false; > boolean skipLoop=false; > > long[] range2 = { col.getMin(), col.getMax() }; > > if(cols instanceof Proxy && Proxy.getInvocationHandler(cols) instanceof CTColsProxy){ > CTColsProxy colsProxy= (CTColsProxy) Proxy.getInvocationHandler(cols); > if(colsProxy.getMax()!=null && colsProxy.getMin()!=null){ > long[] colsRange = { colsProxy.getMin(), colsProxy.getMax() }; > int colsOverlappingType = NumericRanges.getOverlappingType(colsRange, range2); > if(colsOverlappingType == NumericRanges.NO_OVERLAPS)skipLoop=true; > } > } > > for (int i = 0; !skipLoop && i < cols.sizeOfColArray(); i++) { > CTCol ithCol = cols.getColArray(i); > long[] range1 = { ithCol.getMin(), ithCol.getMax() }; > long[] overlappingRange = NumericRanges.getOverlappingRange(range1, range2); > int overlappingType = NumericRanges.getOverlappingType(range1, range2); > // different behavior required for each of the 4 different > // overlapping types > if (overlappingType == NumericRanges.OVERLAPS_1_MINOR) { > ithCol.setMax(overlappingRange[0] - 1); > CTCol rangeCol = insertCol(cols, overlappingRange[0], > overlappingRange[1], new CTCol[] { ithCol, col }); > i++; > CTCol newCol = insertCol(cols, (overlappingRange[1] + 1), col > .getMax(), new CTCol[] { col }); > i++; > } else if (overlappingType == NumericRanges.OVERLAPS_2_MINOR) { > ithCol.setMin(overlappingRange[1] + 1); > CTCol rangeCol = insertCol(cols, overlappingRange[0], > overlappingRange[1], new CTCol[] { ithCol, col }); > i++; > CTCol newCol = insertCol(cols, col.getMin(), > (overlappingRange[0] - 1), new CTCol[] { col }); > i++; > } else if (overlappingType == NumericRanges.OVERLAPS_2_WRAPS) { > setColumnAttributes(col, ithCol); > if (col.getMin() != ithCol.getMin()) { > CTCol newColBefore = insertCol(cols, col.getMin(), (ithCol > .getMin() - 1), new CTCol[] { col }); > i++; > } > if (col.getMax() != ithCol.getMax()) { > CTCol newColAfter = insertCol(cols, (ithCol.getMax() + 1), > col.getMax(), new CTCol[] { col }); > i++; > } > } else if (overlappingType == NumericRanges.OVERLAPS_1_WRAPS) { > if (col.getMin() != ithCol.getMin()) { > CTCol newColBefore = insertCol(cols, ithCol.getMin(), (col > .getMin() - 1), new CTCol[] { ithCol }); > i++; > } > if (col.getMax() != ithCol.getMax()) { > CTCol newColAfter = insertCol(cols, (col.getMax() + 1), > ithCol.getMax(), new CTCol[] { ithCol }); > i++; > } > ithCol.setMin(overlappingRange[0]); > ithCol.setMax(overlappingRange[1]); > setColumnAttributes(col, ithCol); > } > if (overlappingType != NumericRanges.NO_OVERLAPS) { > colOverlaps = true; > } > } > > if (!colOverlaps) { > CTCol newCol = cloneCol(cols, col); > } > //sortColumns(cols); > return cols; > } > > /* > * Insert a new CTCol at position 0 into cols, setting min=min, max=max and > * copying all the colsWithAttributes array cols attributes into newCol > */ > private CTCol insertCol(CTCols cols, long min, long max, > CTCol[] colsWithAttributes) { > if(!columnExists(cols,min,max)){ > CTCol newCol = cols.insertNewCol(0); > newCol.setMin(min); > newCol.setMax(max); > for (CTCol col : colsWithAttributes) { > setColumnAttributes(col, newCol); > } > return newCol; > } > return null; > } > > /** > * Does the column at the given 0 based index exist > * in the supplied list of column definitions? > */ > public boolean columnExists(CTCols cols, long index) { > return columnExists1Based(cols, index+1); > } > private boolean columnExists1Based(CTCols cols, long index1) { > for (int i = 0; i < cols.sizeOfColArray(); i++) { > if (cols.getColArray(i).getMin() == index1) { > return true; > } > } > return false; > } > > public void setColumnAttributes(CTCol fromCol, CTCol toCol) { > if(fromCol.isSetBestFit()) toCol.setBestFit(fromCol.getBestFit()); > if(fromCol.isSetCustomWidth()) toCol.setCustomWidth(fromCol.getCustomWidth()); > if(fromCol.isSetHidden()) toCol.setHidden(fromCol.getHidden()); > if(fromCol.isSetStyle()) toCol.setStyle(fromCol.getStyle()); > if(fromCol.isSetWidth()) toCol.setWidth(fromCol.getWidth()); > if(fromCol.isSetCollapsed()) toCol.setCollapsed(fromCol.getCollapsed()); > if(fromCol.isSetPhonetic()) toCol.setPhonetic(fromCol.getPhonetic()); > if(fromCol.isSetOutlineLevel()) toCol.setOutlineLevel(fromCol.getOutlineLevel()); > toCol.setCollapsed(fromCol.isSetCollapsed()); > } > > public void setColBestFit(long index, boolean bestFit) { > CTCol col = getOrCreateColumn1Based(index+1, false); > col.setBestFit(bestFit); > } > public void setCustomWidth(long index, boolean bestFit) { > CTCol col = getOrCreateColumn1Based(index+1, true); > col.setCustomWidth(bestFit); > } > > public void setColWidth(long index, double width) { > CTCol col = getOrCreateColumn1Based(index+1, true); > col.setWidth(width); > } > > public void setColHidden(long index, boolean hidden) { > CTCol col = getOrCreateColumn1Based(index+1, true); > col.setHidden(hidden); > } > > /** > * Return the CTCol at the given (0 based) column index, > * creating it if required. > */ > protected CTCol getOrCreateColumn1Based(long index1, boolean splitColumns) { > CTCol col = getColumn1Based(index1, splitColumns); > if (col == null) { > col = worksheet.getColsArray(0).addNewCol(); > col.setMin(index1); > col.setMax(index1); > } > return col; > } > > public void setColDefaultStyle(long index, CellStyle style) { > setColDefaultStyle(index, style.getIndex()); > } > > public void setColDefaultStyle(long index, int styleId) { > CTCol col = getOrCreateColumn1Based(index+1, true); > col.setStyle(styleId); > } > > // Returns -1 if no column is found for the given index > public int getColDefaultStyle(long index) { > if (getColumn(index, false) != null) { > return (int) getColumn(index, false).getStyle(); > } > return -1; > } > > private boolean columnExists(CTCols cols, long min, long max) { > for (int i = 0; i < cols.sizeOfColArray(); i++) { > if (cols.getColArray(i).getMin() == min && cols.getColArray(i).getMax() == max) { > return true; > } > } > return false; > } > > public int getIndexOfColumn(CTCols cols, CTCol col) { > for (int i = 0; i < cols.sizeOfColArray(); i++) { > if (cols.getColArray(i).getMin() == col.getMin() && cols.getColArray(i).getMax() == col.getMax()) { > return i; > } > } > return -1; > } >} View Attachment As Diff View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]