You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by jh...@apache.org on 2006/08/28 06:44:35 UTC
svn commit: r437526 - in /jakarta/poi/trunk/src/java/org/apache/poi/hssf:
model/Sheet.java usermodel/HSSFSheet.java
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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/