[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-dev
Subject:    svn commit: r437526 - in /jakarta/poi/trunk/src/java/org/apache/poi/hssf:
From:       jheight () apache ! org
Date:       2006-08-28 4:44:35
Message-ID: 20060828044436.6B1441A981A () eris ! apache ! org
[Download RAW message or body]

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/


[prev in list] [next in list] [prev in thread] [next in thread]