From 2644df3773441532477a94e324fae394bf36a963 Mon Sep 17 00:00:00 2001
From: Nick Burch <nick@apache.org>
Date: Wed, 5 Dec 2007 10:51:20 +0000
Subject: [PATCH] Stub out sheet hiding tests, so we have a framework for when
 sheet hiding is supported (bug #43937)

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@601288 13f79535-47bb-0310-9956-ffa450edef68
---
 .../poi/hssf/data/1900DateWindowing.xls       | Bin 6144 -> 6144 bytes
 .../poi/hssf/data/1904DateWindowing.xls       | Bin 6144 -> 6144 bytes
 .../poi/hssf/data/TwoSheetsNoneHidden.xls     | Bin 0 -> 13824 bytes
 .../poi/hssf/data/TwoSheetsOneHidden.xls      | Bin 0 -> 13824 bytes
 .../poi/hssf/usermodel/TestSheetHiding.java   | 105 ++++++++++++++++++
 5 files changed, 105 insertions(+)
 create mode 100644 src/testcases/org/apache/poi/hssf/data/TwoSheetsNoneHidden.xls
 create mode 100644 src/testcases/org/apache/poi/hssf/data/TwoSheetsOneHidden.xls
 create mode 100644 src/testcases/org/apache/poi/hssf/usermodel/TestSheetHiding.java

diff --git a/src/testcases/org/apache/poi/hssf/data/1900DateWindowing.xls b/src/testcases/org/apache/poi/hssf/data/1900DateWindowing.xls
index 33a57732ea1f2f3a02aae2eba8c5d23aa6522157..94fe5c1becedcfb8db91d9f8afcb81bec9588255 100644
GIT binary patch
delta 27
jcmZoLXfW82!!+4|iDU8s7M9HwOdFUPb2n?UT^9rZeZmO8

delta 28
kcmZoLXfW82!^F|BsB>`++X=?aB}`kG8M!xWvRxMh0G5*p#sB~S

diff --git a/src/testcases/org/apache/poi/hssf/data/1904DateWindowing.xls b/src/testcases/org/apache/poi/hssf/data/1904DateWindowing.xls
index 7eda89e73157f0d422d68c188c16a4317af6fb6c..8c0dba1d7ac2415cc48f5678d0cd4450f0d9cded 100644
GIT binary patch
delta 27
jcmZoLXfW82%QV@5iGA_`7M9HwOdFUPb2n?UT^9rZea8sD

delta 27
jcmZoLXfW82%f!AUeP#~Z3C7JOOk0>4xi@RFT^9rZhb9Re

diff --git a/src/testcases/org/apache/poi/hssf/data/TwoSheetsNoneHidden.xls b/src/testcases/org/apache/poi/hssf/data/TwoSheetsNoneHidden.xls
new file mode 100644
index 0000000000000000000000000000000000000000..969f01408eab582cf1fb27aee2e47b8927a9a90a
GIT binary patch
literal 13824
zcmeHOZ)jUp6#u<6Y16f9lXja^Y4%8wxis0@vbn+Rnif|Ttd7;Oft9RlGc&R+BaJdY
z8UGCYpitchQ3^T)nFw<t=ogU|{ID-W84l4;nfP7&i-WE4cg}myq_x>Hhv@X)aPB?t
z+;i_a_xJ97@16TzzW6*`I`zRFm#`%5Km!)a&1kHWTjX!|jzeI5xh#iXxt2UdCfz~^
zGzWPi8w0qo?tIhy9N7lo5_~x8pJxtyOB%;9v;q(3(ueKQiF`IQam4<+)3Ew5VTliO
zoOlD49~Nb^q&Ch%k#}g`srmb=`HAKOtjSpS;?d!!Hf^IG*m9pQsd_JK9@V^!xrL9l
z%{MCPLqE<@zx>RMOm?6YwnmW0lPKU2o<N$sjm_A?{2`TOSaWN%dW*xkv2jKGYY{*v
z5Pdt^9q;b$-9Dc1*oeQ2*9NY5Pq6*5-RY^vs}&+>lFNmsu(7wgJ&z*(ZUhlotg)mQ
zRoj9XdV!P}kJ;);D&hE2Idp5Ii74w*iDW7f@yD?N>!o2uZM=#X`6B%R#K8$uZHNvm
zvE@iA<^~5V1~;Pzo2m?YtzG+GQ#D&@SHdcpYxt#XYw2Wjw#a1~s{CiK>e_Ny7t86_
zl1s14>HnAI7FTa2d3g3XIQ-_-c=8Q3<nbEvSPgmepX4WfeuRn*WhukOMlCyvel0tT
zO<JM|Emsu-<^6i4I>GDTR=q7ZVl0zR7y3kUv`PGSCH*f!u9k7kTR{?6*ryh*aH+{G
z5DLO=I@IT}{X>0atYFQr0m#)Jlfl&_GHzP!mhY?}<J>kvi*6e&K4%(>o=n@H=wyO!
zt<=kGEAuI|D<4)TLNs>e-5)ND9@sUQQh7|}J(@qKlA^fkrn?9e&}BW#nt8w25|^G=
z?H4pZg{W#+v~LlDN-7OHyp(&W%U*qLDiTi}e}g{W3YG72h3&XXNF=pu{uKch3&0Lv
z2R_o1kkn%*>!MzR*P*xoe9tBUY$aDOY%%&aMf%5Ja|WOzx_Q{7vn8-;&q>Xl?7Fa3
z=^EA`U=T0}7z7Lg27#MLV1YY00e!Aq+?U+9ODEp^@$w^?(0i{0(X;-;uNi~kEJ+?U
zr9MfLhpY!kd|<(TQU~ccNuD5QNGnORBu0@qO_Hb2@7Rc8ALMbXdQ*Xi*OiYRn#|{>
za|a9d&f}Bm!|DTGEsVT=&p9h89V}$=26=8{m}C$z2p9wm0tNwtfI+|@U=T0}7z7Lg
z1_6VBi@>$wf8WLP7iTx#89MnI<Nx^OGZO!QNopoZ{J)DNFGlu}ZX;z#Eu>>4iS1<{
zK;r%)X$|Q`lI#b}kYs=045@lQK=u&!43F7E_k&-b0H3XE(f-KREF&}|eaN1K^ERx)
z_M_FUmE8vMY;P`~otAfI(`rB(nq&|#2p9wm0tNwtfI+|@U=T0}7z7Lg27&(p0uskd
z7%cI&yvygupZsFciKpd%9TMxymx~fTOUy3uyL>n)alh1uS;{+qiSxZrG9}iR{Q#-I
zN|Mr~e<uRFk>jrb8#{57WgbuS%+;UP@aqw8WHOKJptGqm=X5c$Tu(9|Jo#Q)&m)Ti
z>POZS*In{IAb;2wKk9BM8&pgIjPc(cNBEo2u|G%@4ysQgk$-*UD5;(9rhQpMvVQ8d
gFZ*1&LB=A0`)FZOeMsvWxG{gW{e|)C(B1L>4w(oyD*ylh

literal 0
HcmV?d00001

diff --git a/src/testcases/org/apache/poi/hssf/data/TwoSheetsOneHidden.xls b/src/testcases/org/apache/poi/hssf/data/TwoSheetsOneHidden.xls
new file mode 100644
index 0000000000000000000000000000000000000000..940ffc058296fe3ad0839855c1b9e9ed6f50c889
GIT binary patch
literal 13824
zcmeHOZ)jUp6#u<6Y16f9lXja^Y4%8wxis0@vbn<Snif|Ttd7;Oft9RlGc&p^BaJdY
z8UGCYpitch85DE~q6l*$=ogU|{ID-W84l4;nTTJ-zc|<yf9JgSOj4UIbBIpw4d>qT
z&OP^@bAP$_y?5?=@AJ>X#Z&L!aS=<>b~NB>sTqwGa*O=!-f;-5FO}rbE7y{z$fR2c
zf#x9p$i@K9uRGVYxInf6xCkH4_!pT2-;gG76s^F++4LcMY%({KnLKR&-DyO9n6$))
z1x~y{%MXjPc~To^p~yQl@6`M~)%;lVLDpofd-3SVQ=10ZN`8BNN!5E<^Qh)+%q@JR
zZN64XANp~YJ(r%DlgSPg!`3KrcoKOW#1lx9x3L*pm_MYF3~O$UR&Q`PH#V+_e=P#&
z1fp+7yW`#6z1t=d9vks@@!Y@_?+La&wktjTc%?!FO>(;M6gKu&w&zjA-;E$5)f!8B
zQME0Ip%+Mr@tCciq!NxV<wLhNnuxM4l}M%%5q}&TuwELL)g~%<kyq&tB94J-Lv&z?
zEk{x|H#Af>xEVdzRAJC-?b`R6s@Zb8B38*<!!IRUOD9{fMK04&<v)8>*Otq=SWdr|
zTzXwj|GzA^xO&UU!?VZ1;Ww|wlW(XYkJpgLYRH@aBtPNvBUET8Nf|CQYS~fnYuQ<7
z(h>z|xvCH-?b9>Wai0IS^0I7k{f%eR>3p9^jx>qiuB87Z$k{TEMJq_+3j4&uWiB<D
z1wui%O^5qDwtu*<gcYp$H2^u=V=B0sM8-|4-SVv!WSq-JsOqxO;&Z04=*hJGiB2Zy
z)=E9iwlbeayYgXmB1B`C-}&ME*#4bEDV4`m-lO?*Dk+GoZn}#w0bSO!tXcGnEph32
z)qX+qQ;4dDbIKQOFBOLzPRiZXWv{+A6^W;gzd;`_h01ri!ggFCB$C=S|B?WU1z@|c
z10O1v)ZEFssMp|iC{6(1vq=D3$<+&6jJ{2i{xR5`0qBTs9yaN032b^xnbiKB?7Fa3
z=o;1_U=T0}7z7Lg27#ML;3{`;0(xIr-IrXqi^pI8@zNui(7Ue$(X;-8uNZ^j3`uS^
zr9MfLo2&;&ykWsUQU~c6N$w!$NGnP6Bu0^Vn<RIi-?9<IKFIA><)#7;uPYxrIF-xJ
zW)I};9ml59htvnWnjbxR&si%e9TdMiDLl6^Ofm=<1PlTO0fT@+z#w1{FbEg~3<3rL
zgMdN6Mc`WTzwg4i3-cTA44rt5@qhf%X^H>8AT^UD{@+QG2P1n)w~;cW7Sd6Y#P+fe
zAaQ?zw1)H|N%jNgNU}e0npC+TAbSYAN5<{p`@y$QfKS)8Xn$mDmJu3~K4eeAc^Xz`
z`_byw%5H;rwkMmLnU!Z|vuZ#Znq&|#2p9wm0tNwtfI+|@U=T0}7z7Lg27&(p0uskd
z7%cI&Jj>_HpL}D{iKpee4vF>U%|(fxC1#iSU0$4&xL@kSEajQM#QEMUnG);Eet^_p
zAxUY{zY~F7$nuwmjU70`GKZ)6&()vS@a++AWHOKJptGs6;B+y%Tu(9|Joz44&tV4p
z)sGoZTzAQDK>n~Ve$?GiHmH~a80Xg=hxwb-u|G%@4yaEek*_|ol+;dl)4r@BSwHpK
gmwhhXAY&20eY7y8KBV;@xG{eQ{=)cm=<fJ`2hxo=BLDyZ

literal 0
HcmV?d00001

diff --git a/src/testcases/org/apache/poi/hssf/usermodel/TestSheetHiding.java b/src/testcases/org/apache/poi/hssf/usermodel/TestSheetHiding.java
new file mode 100644
index 0000000000..9628ab23e4
--- /dev/null
+++ b/src/testcases/org/apache/poi/hssf/usermodel/TestSheetHiding.java
@@ -0,0 +1,105 @@
+/*
+* 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.hssf.usermodel;
+
+import java.io.ByteArrayInputStream;
+import java.io.ByteArrayOutputStream;
+import java.io.FileInputStream;
+import java.io.FileNotFoundException;
+
+import org.apache.poi.poifs.filesystem.POIFSFileSystem;
+
+import junit.framework.TestCase;
+
+/**
+ * Tests for how HSSFWorkbook behaves with XLS files
+ *  with a WORKBOOK directory entry (instead of the more
+ *  usual, Workbook)
+ */
+public class TestSheetHiding extends TestCase {
+	private String dirPath;
+	private String xlsHidden = "TwoSheetsOneHidden.xls";
+	private String xlsShown  = "TwoSheetsNoneHidden.xls";
+
+	protected void setUp() throws Exception {
+		super.setUp();
+		
+        dirPath = System.getProperty("HSSF.testdata.path");
+	}
+
+	/**
+	 * Test that we get the right number of sheets,
+	 *  with the right text on them, no matter what
+	 *  the hidden flags are
+	 */
+	public void testTextSheets() throws Exception {
+		FileInputStream isH = new FileInputStream(dirPath + "/" + xlsHidden);
+		POIFSFileSystem fsH = new POIFSFileSystem(isH);
+		
+		FileInputStream isU = new FileInputStream(dirPath + "/" + xlsShown);
+		POIFSFileSystem fsU = new POIFSFileSystem(isU);
+
+		HSSFWorkbook wbH = new HSSFWorkbook(fsH);
+		HSSFWorkbook wbU = new HSSFWorkbook(fsU);
+		
+		// Both should have two sheets
+		assertEquals(2, wbH.sheets.size());
+		assertEquals(2, wbU.sheets.size());
+		
+		// All sheets should have one row
+		assertEquals(0, wbH.getSheetAt(0).getLastRowNum());
+		assertEquals(0, wbH.getSheetAt(1).getLastRowNum());
+		assertEquals(0, wbU.getSheetAt(0).getLastRowNum());
+		assertEquals(0, wbU.getSheetAt(1).getLastRowNum());
+		
+		// All rows should have one column
+		assertEquals(1, wbH.getSheetAt(0).getRow(0).getLastCellNum());
+		assertEquals(1, wbH.getSheetAt(1).getRow(0).getLastCellNum());
+		assertEquals(1, wbU.getSheetAt(0).getRow(0).getLastCellNum());
+		assertEquals(1, wbU.getSheetAt(1).getRow(0).getLastCellNum());
+		
+		// Text should be sheet based
+		assertEquals("Sheet1A1", wbH.getSheetAt(0).getRow(0).getCell((short)0).getStringCellValue());
+		assertEquals("Sheet2A1", wbH.getSheetAt(1).getRow(0).getCell((short)0).getStringCellValue());
+		assertEquals("Sheet1A1", wbU.getSheetAt(0).getRow(0).getCell((short)0).getStringCellValue());
+		assertEquals("Sheet2A1", wbU.getSheetAt(1).getRow(0).getCell((short)0).getStringCellValue());
+	}
+
+	/**
+	 * Check that we can get and set the hidden flags
+	 *  as expected
+	 */
+	public void testHideUnHideFlags() throws Exception {
+		// TODO
+	}
+
+	/**
+	 * Turn the sheet with none hidden into the one with
+	 *  one hidden
+	 */
+	public void testHide() throws Exception {
+		// TODO
+	}
+
+	/**
+	 * Turn the sheet with one hidden into the one with
+	 *  none hidden
+	 */
+	public void testUnHide() throws Exception {
+		// TODO
+	}
+}
-- 
2.39.5