From 5d1f44e314d2ecbe4b2a72d90a2396da1b704c74 Mon Sep 17 00:00:00 2001
From: Nick Burch <nick@apache.org>
Date: Tue, 6 Jan 2009 20:49:02 +0000
Subject: [PATCH] Support for reading HSSF column styles

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@732112 13f79535-47bb-0310-9956-ffa450edef68
---
 src/documentation/content/xdocs/changes.xml   |   1 +
 src/documentation/content/xdocs/status.xml    |   1 +
 .../apache/poi/hssf/usermodel/HSSFSheet.java  |  18 ++++++++
 .../org/apache/poi/ss/usermodel/Sheet.java    |  13 ++++++
 .../apache/poi/xssf/usermodel/XSSFSheet.java  |  11 +++++
 .../apache/poi/hssf/data/ColumnStyle1dp.xls   | Bin 0 -> 18432 bytes
 .../poi/hssf/data/ColumnStyle1dpColoured.xls  | Bin 0 -> 18432 bytes
 .../apache/poi/hssf/data/ColumnStyleNone.xls  | Bin 0 -> 17408 bytes
 .../poi/hssf/usermodel/TestHSSFSheet.java     |  39 ++++++++++++++++++
 9 files changed, 83 insertions(+)
 create mode 100755 src/testcases/org/apache/poi/hssf/data/ColumnStyle1dp.xls
 create mode 100755 src/testcases/org/apache/poi/hssf/data/ColumnStyle1dpColoured.xls
 create mode 100755 src/testcases/org/apache/poi/hssf/data/ColumnStyleNone.xls

diff --git a/src/documentation/content/xdocs/changes.xml b/src/documentation/content/xdocs/changes.xml
index 410abba48a..139b48f9a0 100644
--- a/src/documentation/content/xdocs/changes.xml
+++ b/src/documentation/content/xdocs/changes.xml
@@ -37,6 +37,7 @@
 
 		<!-- Don't forget to update status.xml too! -->
         <release version="3.5-beta5" date="2008-??-??">
+           <action dev="POI-DEVELOPERS" type="add">Support for reading HSSF column styles</action>
            <action dev="POI-DEVELOPERS" type="fix">Hook up POIXMLTextExtractor.getMetadataTextExtractor() to the already written POIXMLPropertiesTextExtractor</action>
            <action dev="POI-DEVELOPERS" type="fix">46472 - Avoid NPE in HPSFPropertiesExtractor when no properties exist</action>
            <action dev="POI-DEVELOPERS" type="fix">46479 - fixed bugs related to cached formula values and HSSFFormulaEvaluator.evaluateInCell()</action>
diff --git a/src/documentation/content/xdocs/status.xml b/src/documentation/content/xdocs/status.xml
index e9e6761cb2..1af660ed72 100644
--- a/src/documentation/content/xdocs/status.xml
+++ b/src/documentation/content/xdocs/status.xml
@@ -34,6 +34,7 @@
 	<!-- Don't forget to update changes.xml too! -->
     <changes>
         <release version="3.5-beta5" date="2008-??-??">
+           <action dev="POI-DEVELOPERS" type="add">Support for reading HSSF column styles</action>
            <action dev="POI-DEVELOPERS" type="fix">Hook up POIXMLTextExtractor.getMetadataTextExtractor() to the already written POIXMLPropertiesTextExtractor</action>
            <action dev="POI-DEVELOPERS" type="fix">46472 - Avoid NPE in HPSFPropertiesExtractor when no properties exist</action>
            <action dev="POI-DEVELOPERS" type="fix">46479 - fixed bugs related to cached formula values and HSSFFormulaEvaluator.evaluateInCell()</action>
diff --git a/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java b/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java
index 9ed29e00f5..30556bd554 100644
--- a/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java
+++ b/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java
@@ -36,6 +36,7 @@ import org.apache.poi.hssf.model.Workbook;
 import org.apache.poi.hssf.record.CellValueRecordInterface;
 import org.apache.poi.hssf.record.DVRecord;
 import org.apache.poi.hssf.record.EscherAggregate;
+import org.apache.poi.hssf.record.ExtendedFormatRecord;
 import org.apache.poi.hssf.record.Record;
 import org.apache.poi.hssf.record.RowRecord;
 import org.apache.poi.hssf.record.SCLRecord;
@@ -502,6 +503,23 @@ public final class HSSFSheet implements org.apache.poi.ss.usermodel.Sheet {
     {
         sheet.setDefaultRowHeight((short) (height * 20));
     }
+    
+    /**
+     * Returns the HSSFCellStyle that applies to the given
+     *  (0 based) column, or null if no style has been
+     *  set for that column
+     */
+    public HSSFCellStyle getColumnStyle(int column) {
+    	short styleIndex = sheet.getXFIndexForColAt((short)column);
+    	
+    	if(styleIndex == 0xf) {
+    		// None set
+    		return null;
+    	}
+    	
+        ExtendedFormatRecord xf = book.getExFormatAt(styleIndex);
+        return new HSSFCellStyle(styleIndex, xf, book);
+    }
 
     /**
      * get whether gridlines are printed.
diff --git a/src/ooxml/interfaces-jdk15/org/apache/poi/ss/usermodel/Sheet.java b/src/ooxml/interfaces-jdk15/org/apache/poi/ss/usermodel/Sheet.java
index 9650db2009..a6a1662c53 100644
--- a/src/ooxml/interfaces-jdk15/org/apache/poi/ss/usermodel/Sheet.java
+++ b/src/ooxml/interfaces-jdk15/org/apache/poi/ss/usermodel/Sheet.java
@@ -177,6 +177,19 @@ public interface Sheet extends Iterable<Row> {
      * @param height default row height
      */
     void setDefaultRowHeightInPoints(float height);
+    
+    /**
+     * Returns the CellStyle that applies to the given
+     *  (0 based) column, or null if no style has been
+     *  set for that column
+     */
+    public CellStyle getColumnStyle(int column);
+
+    /**
+     * Sets the CellStyle that applies to the given
+     *  (0 based) column.
+     */
+//    public CellStyle setColumnStyle(int column, CellStyle style);
 
     /**
      * Adds a merged region of cells (hence those cells form one)
diff --git a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java b/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
index c8de77972d..10391170a1 100644
--- a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
+++ b/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
@@ -500,6 +500,17 @@ public class XSSFSheet extends POIXMLDocumentPart implements Sheet {
                worksheet.getSheetFormatPr() :
                worksheet.addNewSheetFormatPr();
     }
+    
+    /**
+     * Returns the CellStyle that applies to the given
+     *  (0 based) column, or null if no style has been
+     *  set for that column
+     */
+    public CellStyle getColumnStyle(int column) {
+    	// TODO
+    	return null;
+    }
+
 
     /**
      * Get whether to display the guts or not,
diff --git a/src/testcases/org/apache/poi/hssf/data/ColumnStyle1dp.xls b/src/testcases/org/apache/poi/hssf/data/ColumnStyle1dp.xls
new file mode 100755
index 0000000000000000000000000000000000000000..1318b0fa5dbe1253f324ecc578e653144120d1fc
GIT binary patch
literal 18432
zcmeHOeQ;FQbw6)+C9MD>351NX5sUZ+Nfuf`AQ&XRO|n9aBnD+dh6w2iZ4p{^wQ`_i
zYPn6Oo!ZSfkeI}#O<c#*G*0t@oexi(1oB6ibmX*?#&w+99VcTlY0_!OH2p}%_V)L?
zci--NZ{K^`t(}?J;qKh`-aYT$-#Pc(bI<*FcmLt<>t1@~OG|z%uCPPG@_M#fDs6NF
z&x|V6iY&te)30Z<Sxpqd<BjkZ(!gtwwF!+EMvNd<AhOM?5Tl6Ih;tC<BF;m+32{DR
z4I)fH>JS$oE<~(HT!h$wcr)T+#9I)TAl{028{$&LMnu{S<8s^cTS#qh8&P{Dg<nQu
zvRB4&Ps<s!Na>*g7Go(RgkrHMuOgS#Rrcvy?t0;wwvLJK8Zjg<>uhoa+|zPWjw?A%
z<}#LkTOc8Wc5BH{N=dSA*{X9^NS{o}Df|Xi-48$uBT6PxGLppecmU{H@TU)C|Dg;4
zSskx_m`hd29&i{^GMK6b%9Cdc_*-=^l|S_rrO*h~QS{=<3i<4^XR5Bin^)rHk0m5u
zj9kH0<R^$nWr9B7U~=eWY}ZtJXf*bl54)5Mg9c@|3|Y4um5?q3JzvDN7Jh|q(E7M8
zRM#)4yicp^cIA_5<k-G%FWZ6~9H$0CT`J$7t80_G&d1e|uc|UXQk0GGPA?#TR34y)
zLUO6f*bPe<gC!h?g(T&-DaR;mZ;L!lCFCVNm6LN&N!sj@!&#TetT|qQj@(?F7}QwZ
ztQxDIHOC#Z=GZYy4nsO!`fy8XNXINW1UZ6R-@v%&)ViAsN6lc25XQ*h90sg#HZIk^
z7>$v|@XZ*Pn;vai(Y#_s+qR=E)?;I2DMopW&lX|Zdwb2{_t`TvVhVu4+se?|W-pIa
zV`K%y!%%L|;X+Z_HpzNv6FEla>tjliV=Y>iLNfQZsig_;j<s|hYiW!$%Q{)Zf`x2H
zZO^1T@^6=Bn5lyi1aR@vlmffX&H}>@*&w&u7+R%s{H>yjt-ah5`84M}s%oum$6}~l
z?)hl!B{eG&`LApYeZ&fv6`c-7(SKPQo!#6kzaO2bUish7bVFjSo(>_cXU=Jr9-hq6
zBcD|IFQ)&k5B;+~^w0ayANHYt!H51iANpVT(C_o1`^n>n|AfNfoZYFPzx1JNd5ZIE
zd5Y<u_QCm*5B*6W`Zs;(f96Af%7<RAJYQBgT>CinqwR!iAVvRZUEPJb7v@UjL6x6t
zB26C|`PQ;;EtAMs6}<xfMbZBk8C0<BbDa;p*@wQ~lg>4m!gu)-uHO_rZ~xk!t1S8t
z<PaXQoY(Sj-KX+vI;yYfTnpytF+8IBF1m{^*NQ5CUO(FYxo*tiydRHP9%>w}FBLs6
z=i@oO<>(jd>Kf)YK+g{;I@h5VzSgtWe+5QoMR)0$>sm#3$ysmFe}IXe?8xhZ>sqh;
z0)Mak3@6eI@H2Nu>*a1LE+0CjYr~wwXQM50)<I{65Z2N4YR$kgK#f2cRpw*74iy(*
zma+=y>0lWgxOgdx11nxu0lM0<3b3upDnMf{s{k9NtO7LuvI?-@l~sU_rmO<&F=Z8C
zmn^FQ`&d~8=oHH;u%X-n&E*zoDYrmtxdq-?Zh>u%0_=ZwCt#e7?sR#LjmQ$tdkuGi
zP&DUG*fBYKjv*9-w3h;s?F<HqmjcorcY?T`U<W`7R#H@*V$rdJ$km_T4SqUnS6C>5
z`t!wi{^NUD|N5_WfLxSHZ;<TOAdq)BK};V>vcI@!ljI|==G+93D%G5ny0h~xA4z6D
zkq4>DRq>vC?#Z%w8QAOuu+yq-G`vz_jtA{*)GZXZ#Oy+KdJA>^`t>5AIy*aygtF5t
zp-9Wggaxt|-cBnPYMn!<U!V0+x0g_Mt-LW!xqIVg2&H=?wO=HZ#Vk8*<TX`Xv-SC!
z(f%1cP5QCN9?OGRHegq+#mr7CUES`ExgBEYj>(##t(-PcTnntYb4J5j6isKWj+xEQ
z6xHI=rAtLdW2afQAPv|mSVm)~6;GM4inrB*cHmI$+2~<cf4l<)B6;^(R14~z)w4S_
z>fNI0-st6Wn^3CYw~;7rWDCUKZ*jt004b7=Iu46DVwbMigYv7)tRORqU=V)7DS#m1
zRUNnUclVwZrGV&9QT{sNBC8;YuTD7e^atTrs#!s162Tz+q*VYx!doZ7AS+7&(Vyo0
ztHT9LK@wk`aBl4nvbYqGnM5!MKk*eLLBd-n!62(j0nwi-{j0-8aX}JaopAZ!4}y)*
z*+FI!!5~;y+CY%-)=4nP>QX@Tr(6H(aKT%GPPjty2jN%USwUtJ!5}dQ2ol~p2?kkH
z3W)xc?Oz>kUd>t^bA*dPe-M7<o)u&!5e%~20fL0LPMjd_aeN1g6(-n4W`91k03Xq?
z8f<S{6>Ev@92zpmGaJuEyX72poeM^!F?*A=WBY!U#H0mrCq7jUiT+Tjmm~&`1yn`M
zk$=ASO16T}<b`R&DsE<wO`V%fdoi1)05*EjqS#cJBiCPi!JEwjH=B4do7Dkq^s+{=
zsWeA^{>qEqY!<rNbQH5$AHaqSpD?CLP*jyUa_yym^JY`;X0xf7O=|!ft}k+IqG+3c
z|4(l=i`;BB7qe*(V58^3sy5Z;$ZP-lyf>Q$vgru6v}It^QG%t-B)&HDvNxNX-E2H8
zZAAbZyQR$}e)`ncyxA;vv+=OBH34kwmNt`k?&YVw+1%o0<6&tV0@&CsZ6+~u`A6Pt
zmblq?SlaCYZ0wdcllaPuKl5gDtDB97rNsl-*ez`)@#?crdb7EWY&Hj5S`2J9mtbk_
z@sB<6oMuCZhLHDZOWkZdENx`~8@r{o$DhCOF>f}FZZ;m4wl;u`-O}3Q-~OkEyxA;s
zv+=OB<^VQ!OKXo`dgQ7%o0yx8ho!Xzu(4ZOd;I(}IS=h_o8@jc9+uV-z{YNA?eSk<
ze!#0X^P~x@UdfM}J6+@E(rlIQSSiwT?>D?bR}?^DQEt%XE>OD_;Ty`KZg0?)1yI<J
z8+4Tm)NV5(4}bkV-k_@rps*G<=sFju-9kjBhyThObaep~w&4bCae><HLFC<^`;Is0
zngS>+!41061!`}7k^gycpBHFU)?##(U4z5tqFbFUZ`_&<%P#Cs4(CVU3hts{OOdl9
zK6BqO=SgaD!~vWBy9dXHrp5*{$<+9{=)F$BP(yaE=o3ghB{l}=!l|?>HIpDH_rEL#
z+>cTWDsfbkFS!9?Kn?a()RC%oq|S$GaA*UcFLsZbIP<mJ92+|qy~icj&DlASYZQ~g
zA)Mcf;n{?AW2kmPD(+pWNuj-yT2gVtsxmK?PFYgvlqHo;oyRWkhUswjTr}nsr6LR_
zyK#(8AL9crVczEHO5|PZ%3Fy;&4s)%c`rtS_pyj7(=r`Fnboc`k!%!Yrf~c#t>(T%
zxkHlV(mGv*60NQhRoQt(C7iq#$?ZHqyZ7|O*x>kJCY3%D>o-ql&PDe-p+cLowK$u3
z8fWm>_T#Gkd1mqqblwkfPQxBJ*SA`qjh!>EYSaz;Ir~#780t1BuCXK=k^N9w%4MqD
zLbtHM%)*+F<78NJ+-VLDC&y33uvTyh8m@(A?}R|K{UiiE0Ri<IL74zL%(4S#H5^T`
z3X*9@cs?{Aiwqk$e4iV<&I4TgKOgXH=Vvbe3o1hJxE&lm&<(!816=z-A8<W22r2Lm
zJ2-ry%OQjpdVtd(>K3cAtL1!Xj%-3h%7O8TDVV~Pv&lmBs1FaQPQVt~=!K4!#fJi`
z(fBpt4R-%pOpxH063OwC=5Vh6zuP6uV)&(mYUq<_^kIhw2<NRa?~5$&!#(jzC~ls-
z1M<s3b1IV_gnMy0X5%(E=7RucP1CR`Iu^a6QT`NPSFHM8#3z`X!Na7c1>G_3l+_Th
zJP1oqt8>1D%4y%gV_~scjq_uGIGD<q=c31*7@;}nFT}_|C~i)2)uTkg&bH;!xGP<7
zv^r(EG@Y_snogY$&6TZ!U9g_1jB4=@xR@>ibdS<Oahuy+K0TzP%}FRoqEnV6I%P?s
zQ*>qToUVZGRyswfs6ay;LY>q3g+EnBQ{6^W?N4ULpskJ0QsEjjPd}_9gNCENimlxs
z#2pGEm7xW=_8!8wC<rQCw|+z!m1BQ_dbj+DuC0}#iPgz=w2>ScOpnuLY4_Uc6f`s!
zp85zlq|vV|ujS=dIfyF_e>gfIAGU3hJb>EO;nxq4<EplO5c!OH>PFq^40*zQE3}xD
zyOaeLa<B)Tz$lu5tK2N_S0|A_gj!wUH)vQ!->7M3Hj=WOQxl8QPRd{NQ=~<SKNMXo
z5833>rma88Jc?7^kJ{d`-2E_h14kyW7*Rz0GvgPAyowQl*%)D!eaTZ3V<tRQ<^w4t
zhf-rxr^eAiG8m|M8%<8)HklkY(UZrgP8~PXlQ4-?X4Fh)F@K245>x|CAVbjxL_Fj|
zL+&1u2O-*nwl}-38S*e_58G(0%Kf0-Z=(@_2Q2gf_FBgQ_PL>YzE*+TWOeYjk7K%c
z6U>m^HiSm0QO|X_@{cT0dG&8z`F{8DL!HMIeZ8V@P}e_Flxd|DjkyY)MWord7jLda
z$ZHYeAFJFSRM*wWJ)*)-JJ;Br*XB`v*1691+%1~{*$rbDf+eP85^)4Z5t9L!O&{*=
zzX`-(wLFeaca+v*3H}LD`GO3D!!T9@zn{-ZMTc>(!Qpq-oL6{tl*l;B<%<8mZfqL{
z-igk;*B=q~95{HmNotKmc%J;-_y5}x8M%uC+e`-w-AdoM|E_4j-tx6b^mX^Yi*?7G
z*?1%UL`|)BCC6o7Pj7c$&*9$Pd!=`8-=0K54v#0(<|LmEjAzXBm^pYC#trG&w@(h7
z8a!e4pP4Y_U5EDW?>2{}C!NHWxmvTyp`PCU-kk^fWp`=}%Q#aN=`|<eFS(|Zo(bMI
z%AvstGu@Z`15*-v`}_CyGJh)Fof<Z!z2o@AM5%2{kJ>%3=ZFElJc6AF1OANtoqv!S
z2n~edD*R)obvNW9)-)Gg-qX(Q4o-JfI1G%aoQ0Pp-pXozNI<|WnnCwW_VZ{6ErAe%
zA5;%UjiNE(rZK;phEb)6Mz8A5hw-F{hOwxKh7qWU#tPf<UQ;86{_~>9A7cJNf5jTE
z?czJiUZbvj$NKYKi+aa8aLmx<I1}9=#-2yiJIY<d9RVQ<C9dH-Ql%(sjiQC2L;i_r
zhiv$hhUdSx|2?WK<*wmit8!D~8qSM_xuYug%k@jYd+q8#*K_z|Wf~%W3V)=$4a2|w
z#c<z&&n#adgmm$OaP6wdeHbzCbF}$St}X>S<YYw|vsuG95xrSX*s@`up#Ki<2^wE@
z+mjPR921e>-m#TEgrl|YArZ8pk+ph;b;qtunLWhn5lR8-qFO;cbrpyntq{VWV70X%
z8(V?lO=yLua1`f8EBq!~K{wUg>Pq{gQ={|Z|FP-3=t<~;=oCn!o8<jQc>8JKbu1Ms
z)T$GWYzwrDmp=5#>%Zz5t$q9>QQ5HOiRaru`wSv&gYUZ#In3RONLx9IxB!v!7*0|C
z6cL}}<fDiS5kG}UTYDLW8gXZy!k>!$X&h|2lSAp$WNIW6+k1M*98<ifM-MNE<NxGc
zct8E|l=^Qu?YNu}RR7Sk&pdmv_14<+7f}D^UwxkS{~;nLL9G8FL>_k^K;%iXVMHF`
zA48<f8AR6mZbUA4KZr<u+>gk*e;LuP59*RZ*I}N*Vw#u??t3GcFfZFf?-LXr+Y66z
znTL#IM5PntNGg4Dk{b(?s(iUR142F+@C;!%2=)y3fB#n_SE1c{Mn;lDrf$Aids|yP
zmKQ^LoL$M0ku8|aa8Dd9+^TBSx<!7u_0sR>+1+?}lQm%EK88$SoAJ2(UfJmU2fp1a
bmIA>36S)2_1;m!8T>iGAZ_49ang9O*6so;d

literal 0
HcmV?d00001

diff --git a/src/testcases/org/apache/poi/hssf/data/ColumnStyle1dpColoured.xls b/src/testcases/org/apache/poi/hssf/data/ColumnStyle1dpColoured.xls
new file mode 100755
index 0000000000000000000000000000000000000000..25dd8de6ded50181b457842d62a2e573a11901ae
GIT binary patch
literal 18432
zcmeHOeQ;b?bw6)+B|X`WCE2p#II+Buzimm8CE3{V$NJlGkSvcRj|G@<Wa-ITENj)(
zD%hQ<QCb+7CS`&R$uw3=(vTSnln*C-4WT&vfhQe>b|4`MO*#SM422GzxD*PLWc&Nw
zw{Q2oyKkR&i<wEN@6LT6=iU1|=bm%!xgY!9zx;E}E0276(T_z-+axS+r7NY}MK^HG
ztWvee5?t{9t#mqV6Gd=&Exm&@@Frw!fbqh}5#%yt+PnhUM6N`hg*+R14)S%#bCIi%
z;Q~^FJP&z3axL-#<T~W*kryK0fV>F#M&z527bDjr(`T4(c3r=N)b>XsYPTftOG#Ar
z$SBT9ISq>xpX%T-jxs{17BzVkxuA}+mnXAf{I>S7r;X~nBAa74M?t$_7n8%_o|F@E
zOv!NqPfAPkBxKNU9T|$LP1f(-WS1<H9+{An`1Px{?}rwKluV?gB#!IR0MJ$7&lt%5
zLm2{!dLF%yxhs?1;4q+Mu#^Q#lV>CNJ8dtPKlNo&XrxLLy|}zgKD*?Zil-6H%kl8X
z5|S@Pp2AV&C&))+j4|LqeBeZM=R|T~IQoZAJCzLm24%PaS+^SHkS+v0PvcmPxWXr}
zK92L%@r$bLlj^ut#iS}Zy7xOvHlhT_slL#5Rqn6Uu|XZ@;%La%RGl9w$~r`+mr&l6
z`>COj++Jbqf+vi?6OO?{;_`MXF$~|^C{I!eSxHZ3<m^|HHu{wCwk2}K5-&kVIu|bn
zHCA&)jn!VU#Fi_T*mi{yhQu^|=#m=JeuWZ(62aCtFfMwvu5;n28H^Fa7#Uo`fEQkg
zOJxAYB6%2=o0Y{VGj=EsrZ?9|79w(E)NXjRVQJ&ir7fF}G&z^`k;Rw;VDxqfo8Q-M
z4Zh!9pdJ$h4DC*V<`#E-+|@^xLU;`H?h+b`Dz;wMNQ=l(GG7x_k{oTaWy#%Uo;EZ!
z;Mvip?MIvHBaO0JR<dHQ*b&z?>7Mdir4df-VFUp*UN$AiE*8r%Y?rlii;JOCJHy|p
zs@S^gEs{@jR-~HN+;TLE#$~RLL|;*JCXxS6N6~|vbV1QM6I1kGU87$OJy45=L>*-!
zVrqJRBJ(KnDX;#s^nWNo|7-#J7YfkN6`+5y0R8g?=zmjyes2MKA$bbnKdx{%qgVRR
z>fvt-&~170%iHqg(?4AR=gS4?PZXg4V*&bK7NCEl0KHUszM^orGV<!j_7kp<6#Wx5
zH4n~yaJEDqQ02K|vgt!Z-(K?VB@+3XqL(4QDEj}PfJ%;kt}Z}tEI?o5OXmtr;cM}P
zt2;%{+Sm5y3Wxrz9K<CS`?fq>6{_+!9nH7tTq$PgQCy<=8eQYdm82@4)sOA}TvcXp
z?!YA$k2VfhpNgK9^K%)!W$4p2HFdM=py!7aovTy_-`2CO|1yl-imvIIt6oLd<g9h*
z&te)V+p>D#s@Jc49pb%;GaV?vRDNCbF0)qdqT;eCCTngvw|vrUl1UGp1wvS5*Qyl-
zr=V&C!l*JA<8>&%f;~$up@KbGETICIHYJI~^+ib)IMkI?fwn5C0-d>}3N%Vd73lsY
zRbam>sR9E{Nfp>*N~*vvSyBb|v63n<C<a#8q4ftwgK**g5K$e)8luZ_UKmB1G<6V$
z+#*2ehJ``c--`gDYZeA!5H13Q?phdx5vd3ex^Q6-4#!1+(5(xDaHsEzATu4o*5OuR
z5g@_V!D^)#kYMX@v$6<Df~~{d&LTj9t;6loB0z$z!~NDA2yVP%iQRWv+k&mb4cj6>
zf~~_H-y%SQt%H%b7?5D=M2iCnw$9DPfdpHpp%@T*Q@(HqTv{ARuyvLd2NG<Z<;8&n
zTW3XaAi>sISsX~Pbyj6TIA5BU^0a3j#=gS`>5Jb>=dAN_ZSY!+5*2FjV%gtKia*HZ
z%a^kt6&c{W@4h?D!HmiDp;fwQz*cFN4{g%ag<6BMwoshdG5NOavBw_E6Dk&q<q74c
zIYN<ULvtI<)|8u;KZ{+9;(_x5eV*J{YK5j!D>Ro{0h>daHqhEMphvO!(-Q1^Wda&2
zV0GcG;P}{g|I_Vb`rKw+7KG+x_Hd=|kQf}~TZ;in$AUrHiUHAw8{Mw$0LeK*UUTx@
zc|9uR`dBP>r@s=@Gk=}u&R4IG=|<U*RfTWIcRF->%E$_p?;h{+fJ|Ej+#~&qX%~pz
z+p*>8>g{>!Nyo?1>6t8u6N1j4KcCmz-884SlLjs-IlbLY%eNW-dvn_?=5I5<xabZy
zjvC!GM<{o=afEWy@<Y(A5Gv<+d78?vu-Q{VcU5E3JfsZ=TTmfVcr8P{>s{5|eeJ=3
z>l?k(Y|TnScY`s!`kXYkXp(HpRv<&p4xFHoa|qyM`uo|?JpAK^#bIm9@@P|Z$H0I!
znp$_p?36Pci8INF)TghLR_x|4m#8!$@4)|>17iQHX@@BT?+{c(tf7Cs^m@9C*Hkma
zUCzA?vZ>M8wC1yE2w-CeGR3CM8oK=QOa5%;>1^8a*{ld)V~0A$rra9(`RgzHvzf26
zY0qb~CV&ltVHlf9P*jCAbm^7<@Mlx2vss_dra6EOLuiJL3ETYgzx>%O(AjLrXVV(M
z#tw?AHI>%ToB#fzKbtzTX%F_aC1BHDgs07Pe0}Cse>T_aY<xUzX#g9yr_FS{_KmOm
zvstLK@$s~k0c_l!Hq-I^t55o~xj|>+<7sOH*tk7yreo&9kNnvz(%JZU+ARTW+@3bm
z@zs}q=FjFvosEyDwFR(od)iFL8_zxA&*mnw*%0h$QLx!igr~K(ee&_=Z8i*ONZFXS
zSZCwoY0CoGxIL}4?ZpQ_>CdKKXXE2(s{+`#J*~CvJ3oBLpUo1TjgO}_2C#8^T5H?+
zM=tuaiRx^8Jgp^wjoZ^&+s;0diO{-jZr0iOcv^b^8@H#mw*BtH{eG>PBMq4DNOs)Z
zp^cl1(-j5BN|CO6zU2?PGzSWg(m`+5K;2%1zf=x(`hzaZfx>@u(B&Ga+h;`1ee*s3
zpv!Zh@D?3(wFc_;5Rs|Dzw-xOkpqQq=%7s+sM{Yz-u?OS`h%{_fx;7X&~+N9+xjBE
zd0?*}s41&Bt=ri@c*fl1wY+g-IxIV}@EgpIz-64hVN-##BVKdoArnce@x}xG1K8C+
zGB7dHpNc0&&zSdk0Yi1^*<!!0#8=8j0G)e<twPNt2+E1I!+^UIia|Nv>*PbOiVUd1
zeP?>^Dm`~+LsfW(1OI018ny;bM0Z&uBWKLJHMy=&&w^aTm<$f!Wxpt{El4+lX6K~h
zj)R&Mx;v>O73c2dS*h$hM=JZyk;=Y18;Z!<sc`y?8TE=%76y}Dc<0W3=MTJuWgDl;
zQFfJ9wj6Ij=gLOqeHaPe&nl`;(^Ld?R%mr1X%lrO@TN^t&3y+lZ&Z>?^Hc?DG;1{~
z(sS}^czG?5Tllu^o>OBZ{iFS<MDldB*E*FtWA5`ph1RF5@gnCbys$^xk1G4~1<TXW
zc`w8{1%Kc&$FV+*opG;9v<(yfeTf7db+Z@OSd@;)J}51rxhnT294s(%u;$|3GwiS3
zX7vxoM~_FbR?q|uS3|S6K_L2m9D*K)fc6?exd1xMlKqo599^*jlG%aqY-lbP87^?d
zJ{`Qq2i%T-1;Ep>&s_L7G=$)7Zg9jv9ekb-xE%)zfZJ1pkOFUagCiDd0U<o!2b}TH
zwpfK*EoVcsWIfkz`$xwn;0hC7lZ9&09=^>w24AGna~+L)A&$|wVe)%+|7uK-5SKdQ
zqbIDvO#gqkCd@*_r4D826EOOqCjx}C-k6O=PW0ghNjVfZN8Sbb<$yJjO7<hXXo1<d
z34!?lfZ5U{e2Rg^UeTy{iX9TCz0=r6$v8Y*YD&-@+q|+G0+t8h=}GlcFrhNqH*lF-
ztXAT6GC&+iq^vXMF)v1F7WxY@QV@y@Y_58gDA;FlLK^o-a)H*qb3&SZ=Y%x-?rdnb
zY!d9kcTJ>}#XqPqT>$7VrGtE%yF)%Bq{rqY<Rr2097*guM-uyvq3qVFGU#rZSA?=M
z7~&w>oXjr#sWQ6iX1Z!`JT(Gst@G9jSHV2J@QxG=M}6gcyFrL83L=rB2WWc_;TseL
z6>eKUqMXXJzd*e^al~$|b4M4ek*%<i9PUq!GGy7|HRcsGG#ionFgPU9ubimm7gjll
zD-D0l?30hVHc9SB>uT`p1;{bg+8&5}T3vOb?F@!|9eoqD7?(Sh2jxnz2OY;KnnI}D
zAa|(OmOqSE{gQjt@Qj{e%Sx>y<p8H94yBcpXSto|P}&|c7s^8}xop?AKj(QAuY^D9
zdd7P9!PO1CLHU$nBI7fTUl{TRMg$gPhFA8)PmYaPh)}5yCU85D7@0UZiVl*(K*iH=
zd>p6o_@ITJJUVgmn3WudOC(amRx*wGgDLya446O$%sOOTWKvz`9Fhkh+5@g9J1-e>
z4zzPF8k=$-X!p5j1mOD?_S^2&p10j+hids)B@8RF4e|B`Oc$?%8?xJmV3aC#U4tXP
zdNJjVzkmJvoyQKwjw<>ZMPI9qf37G~N+~wxa&#7vM&lklc`8C)3y}XpmHv=Au0ZJ_
zm0pXjbX~8?qWmnj+I8J28vxk}XBdDdCS)9W2u=}|KDbQ}&iXe6QFtxiU1vB-+F}Vl
zn<#%t`odv2tAXFoXC=%*oU8DrJX_8qqB?4%JoPfw|4%2{hKXmQ^X&K4!tVVC4mC)%
z(Gi{_|MdM|J0hcWexl9n<e)qE*UtZ6G~l*;HEw!3dv9mkF=sY@pMIjIRy*UPvbU?d
zv#0A&_pUwCy{Bh)M~565jVG;fUhN-ES;-Nr|4xh>(zSQ5>_6Fm-0D3&X36ab_w4Jm
z2Bj+*$CkNTv&q4(?%wVl`+H?qVg$=LOI7K%#t|>MrjxEQp4Q31{xK`r6aQ07I`;JT
z?&)UvM6xq6Xi01Pv9YmYZOe$-*|+<!0lhqeod^T*jQyQo)AWV<LTxJjAm*G6nZ}xC
zT8o};Zd*9rRp}5gOqoQKB;K-0{;z<9Su~T~GuhA05G;WdLL5{VMwO!RMyIj7PQ$2@
zM`Kjg%V9jpqhTz{qhSQfqp`tmyf@W|VSni;@@JTTFkZ2RtG4qQWv^04K4bg&tVum%
z8#rdz^*9sVCdTeZ)HBLm#T@}53MH=MJW}0J)+$8{Lx=q0X`8J5NZpIy+xH$-mvUEe
zuvMigaTVvq!qTQH{c7#vr!QUX+x|Sh!c0QMhw;_rO&I>|UliwU_?zXcgpln#AYHmB
zaxX^Adp$P)$;HJ$hn#FEb2?@i$Ia{IxT_cj3dZm7?x6A2wmms9-GPb7+jneb58-HS
z_mBu|Xr!H<;heE6Q(_NsdW2GdIw&istL-_Wj}=1rV%GK+6r&ZGu7VX_!ym)ftni1l
zf^Dj|`;jiiIK_Cx@39$=7#tW?*w0C0<m35T`s35UTbTWqsf8qr>`L^DS3dly%fIa!
zuKwJ|O<BA0@fTY_`wTLDgU`1kbL6@WnZ9xac^)#SCY*JA6dC`p$tRHKBR`BxUwajm
z>Tzb7+(*TQX&gT~;{(aWcw#6O-E(Td8d1Ebh7Zka!}sLd@qFs&PjBV7<@DoHQc(Lt
z&pq?pbn}hXXCFlS8-M!+w*LiW&TH8IgUEcLy$_i$F%Kg1CH)a(%A7)GyYE8g8umlT
z)W?0uZ2MP`-TI&|nd~;qQCPeuCX;@y2NRa1J?y1_?y@y^*(P&Pkc_Bwf*ejHPmFV~
zU|iKNRcAoRCIgWni~zx&p?~|o0;O_x>lzx04_LPOqOC10ZPBb4D&p*n4-IX^{Dj-w
zuyC_#QS(Om)u!`*l4W=8;wo#v$o#)ChMmJ>@_~}k`31f^Di#C4{u8*QF9yU_rd0l}
Ms#oRmoy`A#0nWa^xc~qF

literal 0
HcmV?d00001

diff --git a/src/testcases/org/apache/poi/hssf/data/ColumnStyleNone.xls b/src/testcases/org/apache/poi/hssf/data/ColumnStyleNone.xls
new file mode 100755
index 0000000000000000000000000000000000000000..3f0128aad41fbde6c5a344741a3916ef7ad407fe
GIT binary patch
literal 17408
zcmeHOYiwM_6+U-&ZLgCM+lgZWB=(Y!w;d9%6O!iPJa`J{Arb@>Q0mybu^Y#BH)|TC
zq%pKrtCChUDM1ZsA*D#PrLRC=Ds4l55LH@e)k1j`DyT@+ms*k12ME}H-^||Kd*?p9
zTR<%+W6kxQbI*L|%$YOi&di<t#m^gFIQH#xUlb#)mZ-d$ua#;C-NHSyO7$Ysal`VP
z`FvgzMR0p2y^AdH26RoJ^P<Qx<SJzLc@1(LxfXdG@_6J4$Y&u>M6N@I3rGX<B;?7+
zjmT4wn~={&o{D@9^0~<8Ax}f5uQ0bb?%ze`de5nPl?>r8D+#$o2Jt^5H=}3DPfhR`
z+b9uKOT>8<Iiap{ss5+0n<pM==@|Z*)r{f^%_i4CdPa82cBRKoCwp1<lO$r%Z*3jQ
zsYKCxJ2YpNY>^S!g}-jq_A6k8w9<)`tn}l4Fa&fi<TD0x{7{DwR@bAa3#BT#7!rDv
z4k^_GmFcq#^6j>lE1&j?7Xo>09HY3pO1|3iSj{7d=GA!kqD16du}5$f`5p2NGRzpT
zvA<_$V%<olr!Vo&r*%q)Zi_mcfUc{oYG@aMosZ&LkGR4o=zUx#tLrxv@5Ac4O2wo)
z*>>qqTb6-?@2P7eYZTw7)pdrtPQ=xc@2NV^D#~JMmgm49m)mKfh#ar6*25D9;0fE|
zA^r0I#L)-eTP6?F2t`eI74+;@nzs6IxZ4sNljAwq$duy7pv4--v{>Vq94p7<SUm=Z
zC7p&nOieB67=uH=5#IY2-ivOln^O4J49AGz9U0DH!3)QdQX7cT9Gi;RjQ8@4duPmS
zojG&SiW}PO+veDGyyfwJwh1e)zbe&xqm!W-QvkfYZH9%5ob^#^j?IL62<1)=14Xed
zk@>PnWE+LgPbf{cwP{^S#lq7WZ8Pv}Ticp#ZOyS(nJ05tvBY+R<DPUE|0-#Po4N!+
z0YjFil*Dy*mIQXl0=dv3(5_vOZ&y`fOZ8q*^B$3ZsCg6yf=VY6q%(vl`YQ#pgwr{Y
z{rH3EMD^o;FVihauz5N~v^_a%Rd#r&K#$$6?C+(2J%Ikz0Qxrq=ywIszZpP(Ab|db
z0QzkK^dNnL@E=q-oRz!n^ThzV*2l}Q_3_fb9Dwuf0Qy4#^dAS%KNUd#K>)o{eZHe`
zxVmxMNBap^Ig0+dhK4)G-#K1lhZR3pJ(`|Q|D@$7EfV{lqE{h;DEhy_ppxyM^8)Ct
z0rdI4bgr@#z7bEjLR0jj|7(A)vFT69X53=YrS;*;PVs9xny=|x?G@+=+@kpg-H^-G
zpyDsuNBcilh6S7t;1&x&jl&hBq8Ii2TET7w`q74lrtwX%^ASboO4G*IcGmW<!uwaz
z4Lft?s_2HEjW+!WOyy*C(GFa>n*4j?jk1>pDyG%4<H~1q`{He~&qXIg1S{f3HT!3*
zSML(MA130>8}U{kOGOp*#I6DfT!vI6fop+^Dlnv0RDpd`Q3X0}MHSd76;+^{S5$%H
ztD*`FC>2%U$f&3Shh9Y$IF>4^z~EO=g$0#XXsxtDTcs5iR$AeGl~!2cs=)E*3<B1^
z_*x@sECx%o7&Xiak$54TaA0yCoIvt|w3h>t?+gb?mIKnBbc2{dumd0^FYz?Tt2)*K
zh4wSLAs*+Q28+bdem;2gZ;$7L+dtO@a#X7QLGmZVKrV8FqyjX_|M{pxlg}F6xdb3J
zsynH5XXi};n&duT1gR-BasU4Pd3G-oyPW_|TCIbIM=Fi;q3w&CN-YPkQ>jjWrB0td
z?NO?;v(uxLlV&SLT0ti)b+z(NnpdfLE~Q@E7hrBbrJPoIYnC!c<5DQ4M<cE8QOXvU
zAGL~>^0sV#v1RmsCSRAn@4owrAhr)UO=}Bt(#kitIWSj24LvZ~GW3<(2fVGo+PUB~
zY=vh!V-L)HKIdu0@#DumPUEE6tso89D%nosq<N=ISdTkeK|gSrc3=EzV?3@zg;+7X
zdRjrdvw6;-M!VZIJsSN&?hMo_#cdS4oos^y$1P5bOCTQYXyd4)(oXHX5tQFo#stZA
zg@f>8ObG-9zvh_1-yA(N%K_0Jm4a=;#Z*a?K$~#l84SYjO=E)Oy23&DL9+ycg1=3|
zK`tl<M1N!pZVneFB~1ct!nt)Y$kcK`a$Vsd{8&@c1O<PagoDf~2Sk5#3~mk=za>oq
zZNlY4FbKa#jtP?M3J1aZ(E);jzfHnHW|sq^Kf(q#hYQ;=o0Cd&g%k|J@3Uiq<hsH^
z5-t!F{B05rGN&96{ZTr&IozZgvpK0W7lFYb{9ZjKNUkd!<a`$h3jQ{6f*guW!q+V<
z?%Eg4O0*@`_VlC%vx^VLH^@Pnu8^!)bN(!8$G-Y3Nk|*=T6{z75&Z>GuP`ipudj)v
z(!V+Na=wc995I*$%;Mez#Wa{=+Pz|Cgox2=5GAH6l|KFabN*r`nPQS&F|$L&=v9gm
zQ=Llx>E-AB#Y{HEba=(g4-vz4Ocb*o7^)_fKJ~(1{KYhyVwQNtEDRCD<w8MB9DVcG
zzx#`sVv1Sn71JIfMo(*1Yid*JH~#pHznCV9=?M3<7KrI6!_#tI-_O0|FXn7hjE|?y
z3=!k>v|QKkfAD>OF;h)3KAtuwM2yqZa$Qfo^sv8}b4)Qlp0*%FjMLL{UAYs_`inW&
z6yxJ*7lw#&dRngQyU+i@U(9)?7#~kdhKO-`TCVH$Cm-?`GmT=FhI?89VwRTSY3<27
z9(+oRVL(GF#<c0C7#~l&AViGQ)7q2I+<Aw;m}XOqkEhKI5##i<_T*20eZ*f(iz&v(
z(^^BsI6bXBdHmQ(e=!MDjE|=+3K8S<wD#no#|jbJ?3?pVF+QHw5hBLvY3<3^PTcO-
znh7!ki&!bXH`f~P&FT4?z;~s{rdxjG4?4313Xd{D&o@AwUW88{n>YA_UQhys|Cpe&
z3{a=fh}`wV>-<4yl|bPwCg?l^)afB2qrG492c2C4g>RUkZ3d{*A4INv;8B0jIVDhd
zf(g3V0Co1h$iEI>>IWK^xp=$Ey6)bC@#XHGx6aE)WgWH~dy8-2DsGBkhmf-)-g6tV
z5J~EB_5geM>$?YfMh3dG{X>HX<F~j0BTf17qK^jg_|^cROUK1()J%e)+|IHEaC=D!
zsKyyeKIDFe1v5BHaaXC<RXP-@!)Xe9jac88!eOlSseyrm@%@HgXXnR3uRcr$dvLHW
zf%_D+8$h#5T5&5%O$wcZ)YgjoPt`@Objj9Amu#(c=@2$;7mP;p2jdC1DpgSkS&#E=
z`g|Q^33*#btHC?h;H}1K;}UN|uE(3;MpjXE+D2ojGux;W%g0e?1n06cYVO-pIK4<I
z3rA~EW1&%_CO^Sb!!2uyT*#BHm+ToH=pO9O4rOjmY)$RS9*ke+hKel7*W=LS9vqHi
z-w&$(=V8X1Ve_p}XAk^=n^$)4v$G5CRg1P^d*-sCAvo#^H?DPVJ|>sJXhVjpa!1_8
zf-oCvBF=eX1#x+*ySIOEM*?dFL(ynGEPFW=qVM-Z(H&4wuMw0BV8FCou}{O%6>FfG
z4uppy6S2r}fFt&q;0-?DI{pQK=R5B|@mn;6;7KPqVxS2=$p>7=!2obQHHawi4ktKb
zp%D<GlYPJ$4|R{#IL&e>GESDDBjt+0;SspPh`Y-ojc5-~jt;{Y+3BT$mdC!o-D&(d
z@D_)EJtjzqOI`hgJ5#-d@qeYE%v8jsF4fUH(doUe2oNoLV=)%l(T7{y)iB%yxd{5p
z#?(kQ(~a<A1ZHa*0`o=yv!xmM6a$N1(WrQek0o|{kK&6;!QtUjqk`d>bn9vfL~ewq
zXVd{)LKUoU;kL9`t;NAEKx`b!rVhrpyD=i;FkXm}g;LyW<f=!hf{kiBq;ZqE6litH
z4r#h%hcsO}6d5ne1)Ex%MzX5MKWqq{0_aW32Hrk*hI~dySD%wm(nObRO?1iDM3)%K
z-ZxqW+g;#Rp{fcUu^Da76c_$98C`V+U3F`Jb^z8|?5-89L-%ZjcVy9Vw3pZ0EkdkR
z5JOpdfU)-wJx4*%;JWu?%BfuY3$(i(M|5lL5?!o8R-upNn(oXXLzWJ&oo+=V;}NN^
zfrJdkl^wPG!YW_l%EF(CUn`$+Y?9oL)-~X7D?qlZ)^35yH><l1Xgh-;kA5$Q75n8T
z<v}G5j-VZQi)Iljm&ym!5#f)cRqy8~Wq8JxzEmo^n3Q40Qk&9F%0C$ZZA$V;e5xFA
z=%rm-e_^>7$FJ{oJY&5BaCHl386UCY$oQGfpDlSEZv?V2!z;J+?;0LRAwp$8JcMG;
z(7?#9K@5;AUR3<o*S{P8cK7$DFp>vHc5P2(cEcrxvVEyc9`lE|Jcv)}=mP19HzDJu
zkeUkrBXSt39d<lfcgm8xK)cI9V^a=*cECX+0MAS4ljZfUljY+hjeM*UcfE%3dFM5J
z5IzfT$YC2nr_`zY23+|IleoP8m6w0HVf*IJZHhi$(HE%et%@?LjG{4TVX%m_TDRcI
zBQeUFg8Wg%{V{c&4eqo`zweymxSv}@`9tSC$Ne#^Cx~c4KMNg0D<oC=Rj2(wCPy(d
zIcnGd)rx5)Us@_%4K2WkcOMgNz#)i^jquYD?_0HhSapiVf=MI4NrNwVXtagN2QTo@
z;6WZ5{Ki9L1D$wpsD9SJ1rqrPq6VFs$42I^;WO%9r>=ZP`|(+udd4=er*%EPKfrnM
zG4+gk*Kr;%M4`rYjQ*-bUF#Gr3LEk_0d=zA6HU)Ne%W=ZF7>YC5K-LJxQ=f#A$MGH
zztlMWXQxhHyXGnUPALNw@4@eqreV<PzXblT#^&gE2_b8EK{|C(<Tm*EZLU84-O1@d
zkJbW~4X?$YW$lQcEjt`+aBS{SL@y2-6}s=0C|qtu_;~k>2sY3j3HE=irT)tiVcP(w
z^w<lkxTZw(>4gY>hp4>;Z0rf9x1kr}m<yiig?F+SbXT3Z{x2=S0mCTFXv^PaGTJiq
zF=jG~k;b^r|7X&B&jN2^`dp<Zx9DU?qF=o5@w-pIx~Z@JYoCqFf;kU9gNd5lk4)d-
z^EJqPFJF#KU%3H!67n!I=a!#D#;(774tX;2J;?O6mr#kv3dmFXQDHERZ^sS&J(;21
zL+Nbdl07}C0VR91@9IfO{GN0Tp38yR>bIrz<4RIk`y)?2_T<rp=hYv&6YXz(^&4#e
z)5x5)vHhEoIitB2ndeV>k$LcU0GT>xk=gFO$edSy44L*gfXudk2ia*4+LB4PVS>V9
znV3xG|7HjwFZ)9;M@qNtrQ4)T03!v_=mfcDD6?}n*Dt$O{Yq^HgkrJ~8KMXf92w?s
ze`kZM)Nh;8>HeOS?!H9(qD9F>Q4JMw*7c{;%P{-m)*E_wp=!~>W%A1M;~y%DJ9G0k
rTfi#pxejADW4nB?Vs!oj*BKSd0pR$_l*3piPo?t9ge{xx-7Nn<0Sa6$

literal 0
HcmV?d00001

diff --git a/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFSheet.java b/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFSheet.java
index 4757223354..c119daa283 100644
--- a/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFSheet.java
+++ b/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFSheet.java
@@ -911,4 +911,43 @@ public final class TestHSSFSheet extends TestCase {
         }
         wb.createSheet(SAME_PREFIX + "Exxxx"); // OK - differs in the 31st char
     }
+    
+    /**
+     * Tests that we can read existing column styles
+     */
+    public void testReadColumnStyles() {
+        HSSFWorkbook wbNone = HSSFTestDataSamples.openSampleWorkbook("ColumnStyleNone.xls");
+        HSSFWorkbook wbSimple = HSSFTestDataSamples.openSampleWorkbook("ColumnStyle1dp.xls");
+        HSSFWorkbook wbComplex = HSSFTestDataSamples.openSampleWorkbook("ColumnStyle1dpColoured.xls");
+    	
+        // Presence / absence checks
+        assertNull(wbNone.getSheetAt(0).getColumnStyle(0));
+        assertNull(wbNone.getSheetAt(0).getColumnStyle(1));
+        
+        assertNull(wbSimple.getSheetAt(0).getColumnStyle(0));
+        assertNotNull(wbSimple.getSheetAt(0).getColumnStyle(1));
+        
+        assertNull(wbComplex.getSheetAt(0).getColumnStyle(0));
+        assertNotNull(wbComplex.getSheetAt(0).getColumnStyle(1));
+        
+        // Details checks
+        HSSFCellStyle bs = wbSimple.getSheetAt(0).getColumnStyle(1);
+        assertEquals(62, bs.getIndex());
+        assertEquals("#,##0.0_ ;\\-#,##0.0\\ ", bs.getDataFormatString());
+        assertEquals("Calibri", bs.getFont(wbSimple).getFontName());
+        assertEquals(11*20, bs.getFont(wbSimple).getFontHeight());
+        assertEquals(8, bs.getFont(wbSimple).getColor());
+        assertFalse(bs.getFont(wbSimple).getItalic());
+        assertEquals(HSSFFont.BOLDWEIGHT_NORMAL, bs.getFont(wbSimple).getBoldweight());
+        
+        
+        HSSFCellStyle cs = wbComplex.getSheetAt(0).getColumnStyle(1);
+        assertEquals(62, cs.getIndex());
+        assertEquals("#,##0.0_ ;\\-#,##0.0\\ ", cs.getDataFormatString());
+        assertEquals("Arial", cs.getFont(wbComplex).getFontName());
+        assertEquals(8*20, cs.getFont(wbComplex).getFontHeight());
+        assertEquals(10, cs.getFont(wbComplex).getColor());
+        assertFalse(cs.getFont(wbComplex).getItalic());
+        assertEquals(HSSFFont.BOLDWEIGHT_BOLD, cs.getFont(wbComplex).getBoldweight());
+    }
 }
-- 
2.39.5