Author: jheight Date: Sun Aug 27 21:44:32 2006 New Revision: 437526 URL: http://svn.apache.org/viewvc?rev=437526&view=rev Log: Bug 33736: Applied patch for Column Hiding. Thanks
Modified: jakarta/poi/trunk/src/java/org/apache/poi/hssf/model/Sheet.java jakarta/poi/trunk/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java Modified: jakarta/poi/trunk/src/java/org/apache/poi/hssf/model/Sheet.java URL: http://svn.apache.org/viewvc/jakarta/poi/trunk/src/java/org/apache/poi/hssf/model/Sheet.java?rev=437526&r1=437525&r2=437526&view=diff ============================================================================== --- jakarta/poi/trunk/src/java/org/apache/poi/hssf/model/Sheet.java (original) +++ jakarta/poi/trunk/src/java/org/apache/poi/hssf/model/Sheet.java Sun Aug 27 21:44:32 2006 @@ -47,6 +47,7 @@ * @author Shawn Laubach (slaubach at apache dot org) Gridlines, Headers, Footers, PrintSetup, and Setting Default Column Styles * @author Jason Height (jheight at chariot dot net dot au) Clone support. DBCell & Index Record writing support * @author Brian Sanders (kestrel at burdell dot org) Active Cell support + * @author Jean-Pierre Paris (jean-pierre.paris at m4x dot org) (Just a little) * * @see org.apache.poi.hssf.model.Workbook * @see org.apache.poi.hssf.usermodel.HSSFSheet @@ -1841,6 +1842,50 @@ public void setColumnWidth(short column, short width) { setColumn( column, new Short(width), null, null, null); + } + + /** + * Get the hidden property for a given column. + * @param column index + * @see org.apache.poi.hssf.record.DefaultColWidthRecord + * @see org.apache.poi.hssf.record.ColumnInfoRecord + * @see #setColumnHidden(short,boolean) + * @return whether the column is hidden or not. + */ + + public boolean isColumnHidden(short column) + { + boolean retval = false; + ColumnInfoRecord ci = null; + + if (columns != null) + { + for ( Iterator iterator = columns.getIterator(); iterator.hasNext(); ) + { + ci = ( ColumnInfoRecord ) iterator.next(); + if ((ci.getFirstColumn() <= column) + && (column <= ci.getLastColumn())) + { + break; + } + ci = null; + } + } + if (ci != null) + { + retval = ci.getHidden(); + } + return retval; + } + + /** + * Get the hidden property for a given column. + * @param column - the column number + * @param hidden - whether the column is hidden or not + */ + public void setColumnHidden(short column, boolean hidden) + { + setColumn( column, null, null, new Boolean(hidden), null); } public void setColumn(short column, Short width, Integer level, Boolean hidden, Boolean collapsed) Modified: jakarta/poi/trunk/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java URL: http://svn.apache.org/viewvc/jakarta/poi/trunk/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java?rev=437526&r1=437525&r2=437526&view=diff ============================================================================== --- jakarta/poi/trunk/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java (original) +++ jakarta/poi/trunk/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java Sun Aug 27 21:44:32 2006 @@ -41,6 +41,7 @@ * @author Glen Stampoultzis (glens at apache.org) * @author Libin Roman (romal at vistaportal.com) * @author Shawn Laubach (slaubach at apache dot org) (Just a little) + * @author Jean-Pierre Paris (jean-pierre.paris at m4x dot org) (Just a little, too) */ public class HSSFSheet @@ -337,6 +338,28 @@ public int getLastRowNum() { return lastrow; + } + + /** + * Get the visibility state for a given column. + * @param column - the column to get (0-based) + * @param width - the visiblity state of the column + */ + + public void setColumnHidden(short column, boolean hidden) + { + sheet.setColumnHidden(column, hidden); + } + + /** + * Get the hidden state for a given column. + * @param column - the column to set (0-based) + * @return hidden - the visiblity state of the column + */ + + public boolean isColumnHidden(short column) + { + return sheet.isColumnHidden(column); } /** --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/