From bed3ab6871d3424245d986fad3e237224a9134dd Mon Sep 17 00:00:00 2001
From: Nick Burch <nick@apache.org>
Date: Thu, 10 Jul 2008 18:41:25 +0000
Subject: [PATCH] Fix bug #45365 - Handle more excel number formatting rules in
 FormatTrackingHSSFListener / XLS2CSVmra

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@675671 13f79535-47bb-0310-9956-ffa450edef68
---
 src/documentation/content/xdocs/changes.xml   |   1 +
 src/documentation/content/xdocs/status.xml    |   1 +
 .../eventusermodel/examples/XLS2CSVmra.java   |  48 +-------------
 .../FormatTrackingHSSFListener.java           |  62 ++++++++++++++++++
 .../org/apache/poi/hssf/data/45365.xls        | Bin 0 -> 51712 bytes
 .../TestFormatTrackingHSSFListener.java       |  43 ++++++++++--
 6 files changed, 105 insertions(+), 50 deletions(-)
 create mode 100644 src/testcases/org/apache/poi/hssf/data/45365.xls

diff --git a/src/documentation/content/xdocs/changes.xml b/src/documentation/content/xdocs/changes.xml
index 16a82aa3ae..808bea2a9c 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.1.1-alpha1" date="2008-??-??">
+           <action dev="POI-DEVELOPERS" type="fix">45365 - Handle more excel number formatting rules in FormatTrackingHSSFListener / XLS2CSVmra</action>
            <action dev="POI-DEVELOPERS" type="fix">45373 - Improve the performance of HSSFSheet.shiftRows</action>
            <action dev="POI-DEVELOPERS" type="fix">45367 - Fixed bug when last row removed from sheet is row zero</action>
            <action dev="POI-DEVELOPERS" type="fix">45348 - Tweaks to RVA formula logic</action>
diff --git a/src/documentation/content/xdocs/status.xml b/src/documentation/content/xdocs/status.xml
index 7143b98d78..21d279ada1 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.1.1-alpha1" date="2008-??-??">
+           <action dev="POI-DEVELOPERS" type="fix">45365 - Handle more excel number formatting rules in FormatTrackingHSSFListener / XLS2CSVmra</action>
            <action dev="POI-DEVELOPERS" type="fix">45373 - Improve the performance of HSSFSheet.shiftRows</action>
            <action dev="POI-DEVELOPERS" type="fix">45367 - Fixed bug when last row removed from sheet is row zero</action>
            <action dev="POI-DEVELOPERS" type="fix">45348 - Tweaks to RVA formula logic</action>
diff --git a/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java b/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java
index 1c9b220356..632eacf5cc 100644
--- a/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java
+++ b/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java
@@ -20,10 +20,6 @@ import java.io.FileInputStream;
 import java.io.FileNotFoundException;
 import java.io.IOException;
 import java.io.PrintStream;
-import java.text.DateFormat;
-import java.text.DecimalFormat;
-import java.text.SimpleDateFormat;
-import java.util.Date;
 
 import org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener;
 import org.apache.poi.hssf.eventusermodel.HSSFEventFactory;
@@ -37,7 +33,6 @@ import org.apache.poi.hssf.model.FormulaParser;
 import org.apache.poi.hssf.record.BOFRecord;
 import org.apache.poi.hssf.record.BlankRecord;
 import org.apache.poi.hssf.record.BoolErrRecord;
-import org.apache.poi.hssf.record.CellValueRecordInterface;
 import org.apache.poi.hssf.record.FormulaRecord;
 import org.apache.poi.hssf.record.LabelRecord;
 import org.apache.poi.hssf.record.LabelSSTRecord;
@@ -47,7 +42,6 @@ import org.apache.poi.hssf.record.RKRecord;
 import org.apache.poi.hssf.record.Record;
 import org.apache.poi.hssf.record.SSTRecord;
 import org.apache.poi.hssf.record.StringRecord;
-import org.apache.poi.hssf.usermodel.HSSFDateUtil;
 import org.apache.poi.hssf.usermodel.HSSFWorkbook;
 import org.apache.poi.poifs.filesystem.POIFSFileSystem;
 
@@ -180,7 +174,7 @@ public class XLS2CSVmra implements HSSFListener {
     	        	nextRow = frec.getRow();
     	        	nextColumn = frec.getColumn();
         		} else {
-        			thisStr = formatNumberDateCell(frec, frec.getValue());
+        			thisStr = formatListener.formatNumberDateCell(frec);
         		}
         	} else {
         		thisStr = '"' + 
@@ -231,7 +225,7 @@ public class XLS2CSVmra implements HSSFListener {
             thisColumn = numrec.getColumn();
             
             // Format
-            thisStr = formatNumberDateCell(numrec, numrec.getValue());
+            thisStr = formatListener.formatNumberDateCell(numrec);
             break;
         case RKRecord.sid:
         	RKRecord rkrec = (RKRecord) record;
@@ -290,44 +284,6 @@ public class XLS2CSVmra implements HSSFListener {
 		}
 	}
 	
-	/**
-	 * Formats a number or date cell, be that a real number, or the 
-	 *  answer to a formula
-	 */
-	private String formatNumberDateCell(CellValueRecordInterface cell, double value) {
-        // Get the built in format, if there is one
-		int formatIndex = formatListener.getFormatIndex(cell);
-		String formatString = formatListener.getFormatString(cell);
-		
-		if(formatString == null) {
-            return Double.toString(value);
-        } else {
-        	// Is it a date?
-        	if(HSSFDateUtil.isADateFormat(formatIndex,formatString) &&
-        			HSSFDateUtil.isValidExcelDate(value)) {
-        		// Java wants M not m for month
-        		formatString = formatString.replace('m','M');
-        		// Change \- into -, if it's there
-        		formatString = formatString.replaceAll("\\\\-","-");
-        		
-        		// Format as a date
-        		Date d = HSSFDateUtil.getJavaDate(value, false);
-        		DateFormat df = new SimpleDateFormat(formatString);
-	            return df.format(d);
-        	} else {
-        		if(formatString == "General") {
-        			// Some sort of wierd default
-        			return Double.toString(value);
-        		}
-        		
-        		// Format as a number
-	            DecimalFormat df = new DecimalFormat(formatString);
-	            return df.format(value);
-        	}
-        }
-	}
-
-	
 	public static void main(String[] args) throws Exception {
 		if(args.length < 1) {
 			System.err.println("Use:");
diff --git a/src/java/org/apache/poi/hssf/eventusermodel/FormatTrackingHSSFListener.java b/src/java/org/apache/poi/hssf/eventusermodel/FormatTrackingHSSFListener.java
index b88143713d..5a84f45646 100644
--- a/src/java/org/apache/poi/hssf/eventusermodel/FormatTrackingHSSFListener.java
+++ b/src/java/org/apache/poi/hssf/eventusermodel/FormatTrackingHSSFListener.java
@@ -16,7 +16,11 @@
 ==================================================================== */
 package org.apache.poi.hssf.eventusermodel;
 
+import java.text.DateFormat;
+import java.text.DecimalFormat;
+import java.text.SimpleDateFormat;
 import java.util.ArrayList;
+import java.util.Date;
 import java.util.Hashtable;
 import java.util.List;
 import java.util.Map;
@@ -24,8 +28,11 @@ import java.util.Map;
 import org.apache.poi.hssf.record.CellValueRecordInterface;
 import org.apache.poi.hssf.record.ExtendedFormatRecord;
 import org.apache.poi.hssf.record.FormatRecord;
+import org.apache.poi.hssf.record.FormulaRecord;
+import org.apache.poi.hssf.record.NumberRecord;
 import org.apache.poi.hssf.record.Record;
 import org.apache.poi.hssf.usermodel.HSSFDataFormat;
+import org.apache.poi.hssf.usermodel.HSSFDateUtil;
 
 /**
  * A proxy HSSFListener that keeps track of the document
@@ -69,6 +76,61 @@ public class FormatTrackingHSSFListener implements HSSFListener {
 		}
 	}
 	
+	/**
+	 * Formats the given numeric of date Cell's contents
+	 *  as a String, in as close as we can to the way 
+	 *  that Excel would do so.
+	 * Uses the various format records to manage this.
+	 * 
+	 * TODO - move this to a central class in such a
+	 *  way that hssf.usermodel can make use of it too
+	 */
+	public String formatNumberDateCell(CellValueRecordInterface cell) {
+		double value;
+		if(cell instanceof NumberRecord) {
+			value = ((NumberRecord)cell).getValue();
+		} else if(cell instanceof FormulaRecord) {
+			value = ((FormulaRecord)cell).getValue();
+		} else {
+			throw new IllegalArgumentException("Unsupported CellValue Record passed in " + cell);
+		}
+		
+        // Get the built in format, if there is one
+		int formatIndex = getFormatIndex(cell);
+		String formatString = getFormatString(cell);
+		
+		if(formatString == null) {
+            return Double.toString(value);
+        } else {
+        	// Is it a date?
+        	if(HSSFDateUtil.isADateFormat(formatIndex,formatString) &&
+        			HSSFDateUtil.isValidExcelDate(value)) {
+        		// Java wants M not m for month
+        		formatString = formatString.replace('m','M');
+        		// Change \- into -, if it's there
+        		formatString = formatString.replaceAll("\\\\-","-");
+        		
+        		// Format as a date
+        		Date d = HSSFDateUtil.getJavaDate(value, false);
+        		DateFormat df = new SimpleDateFormat(formatString);
+	            return df.format(d);
+        	} else {
+        		if(formatString == "General") {
+        			// Some sort of wierd default
+        			return Double.toString(value);
+        		}
+        		if(formatString == "0.00E+00") {
+        			// This seems to mean output as a normal double
+        			return Double.toString(value);
+        		}
+        		
+        		// Format as a number
+	            DecimalFormat df = new DecimalFormat(formatString);
+	            return df.format(value);
+        	}
+        }
+	}
+	
 	/**
 	 * Returns the format string, eg $##.##, for the
 	 *  given number format index.
diff --git a/src/testcases/org/apache/poi/hssf/data/45365.xls b/src/testcases/org/apache/poi/hssf/data/45365.xls
new file mode 100644
index 0000000000000000000000000000000000000000..fbf1d97c589d0c82c232b0578b4ced79d75c6b71
GIT binary patch
literal 51712
zcmeHw2YggT*Zyo0lBEZT5D;+*Eg&WI^lTcTgd#-*f+U1cLqZ8nMHdS;M5HN2jR+!$
z2uN391x3`T*s!4n6hTBqv7oP#|9Q^2H<|3-4e;vweSH7lyZOz@+~>}ndFGUvxpVI(
zhu*GL{P^YuN0rAXUiqu@C6!g6hTABQ#GhcLMo<RF=SxaT1XPN$|NZ<Q(!gKDbtD<j
zpHcv&N|a#pAWC*hl_^!BRFzUSO4TXVpj49*xqzxgsWzoLltL(7L8&gKdXz#b)u+^e
z(v_4NQo4##BT83Oa!_haDU4DRN=+#>qtu*I3rgXXT2g97=^9F{DYc>0mQp)P5tQ0f
z>OiR@rB0MOQ|dygE2T(EQIw)7#ZZc+6h|qZQUWC>r9?_el#(f>P)eoLjZzw=?v#2^
z>Pe{=rF2TYDfOY$mr_4U*HY?FX#k~xlm=0{j?!RC*HaooX(**(lrks{r*s1)#0*jv
z<+HWp|7q9hukz`qfNYVf^62*zHH+9>{HHE?jLF%LE_2u+m2$IWRjQNsf4g|@rw48B
zS3Wtnf_`VxITxIbK7*<CDQbcm$vh?qcnPw$^0T2Tlf%Va3Wlk>q+}(s+%z?jezLgl
zJxB|qnG=u#HIDLm6;v8d?c3-);s+cmC|d5+A>*hLd0jqv0665Z1ul(GB(-n${bJjP
zz7C0*RAoCwabP92?&>##UZc@GkWL;|eri*|OC*&#Mkzy0!Z`2vpZp{-hb$X7xT*0t
z%H^otwwf4)296y!b#VTa2_y6KC#<A`!8FXEAUOlcIxL^%OJ86aM`tFS53h7A=8IYw
z6fkXF@8{%l_p=ORS%aia?ci%ZVWd3`UI(ds$*l`uW%^XIC6c3zBj?Da!RJ4BHk8`6
z(J=Y~x<sD<TX#}Gu9{A*w&HVD<s6-_ZtG2M?4XoIE;N;MIm~jjQQD8x#yz;G(g8G-
zqcjvzaoxi53QLw@>J0TDxb$4*(jMe+U}Y0q4-Ha#-uewNxPy(=*`}pj%b#te#!_fT
znp&C?WJ{(NC(=+O_G?cQQEQ75xnx}_gAxH3EOCT->Dfy8I*yS2YMJ^sczBl(os--7
zED?LbI^r)-!bTGxdz8;sY&4BlTmloV;Y&W4+GyEup*pHmP)E6_BBq{pJwi&VSHbm-
z6l`L@Acx8qr~^wNUp;LU5K2=YEqlVA2y4>1Nt1|}j5cPrQNUHShzixt4eOsXYPepY
z5v{Q5mlbFmp<ho&jRKlb<FryT>qH5UTDVwe8VzV6Gy;vcaxjw-ZG=nNp>Z~>O&FaU
z(Z)HVO{0L;w6>yE)`&J`#WJ)!@N(tjX#GWlr``||@MuervgQ&J${OrMi#S@gl{RQz
zZM1J*%FXK6HB_syoD6F!dLGd-CL`QD$Y|Lpps`wmrKJhcdC^n3LSgDjtUb*_XiTq%
zj!{($wN{0Bmh!00DB4v$g@xw`v|?(oWsGr{5zdClC<UNN95_c%D{a*}tZPSv>({k%
z=og9ZORq>!>#>T}8<QTCZ;z>&9H>dsVrdm!)YCNDmNjZ#U)rvDv8n&kE32ywxD^m5
zk0H+tR?pymfC0KH23V-th+vr5ZdAKjvoaiGqbE+xa3uC_*ROY@fa>a5R4|cF;%uXU
zK(&eDQ;lsDP*rWl?M4Ju1D~&=w%`tg4;uy8)pJ-^(NUv-YHBO)Nu(ehS6ACmr*TX`
z4YeIND<(ilO|=8JE~N-T!D=U%mqCP8R=aTLLs+v$0iD!t_EFO`ZQ&*`lwq8<<R*OV
zq1_1eJZ@1gXj0uGG;87(Dr`v3)UX&s_Q?-x6wpAui2JCpfm5dC&>7=bx2)W$IdnEe
z?ZMqwSl>K4Ct~zy!iTH96rr|ZbQ`t7(T03;I4#^9bYs<;QWF{@+ER+3oA#D;Gc=5D
zT5{AVE)z~i6<?D<*A(;Zol?J)IItWsK5hqavZdfZUmQ*oxn+4@IBMl~J?j7e8Ml$`
z%08lJ+%&Tuwi;&w9%KD`<IniO*ZaUX`oLHCz@PPjZ}5RX;sd|W2kwiHulk?kdT6@z
z(9fejaN*-!Uif(9t9{h7*$2MW2foJ#ey<OFmk<0>`E28QXn^+6kN62TYuK+A*Q)hU
z)rYF8fTdiX7AOWjdi36__g<|6b}(LvW`ti#Xrlaz3h>7q2cDMl=REOsKJfKE@TV+s
zn&k!e7zeN^^)qh0J#cJHm5&$ke;Pgof1meoD13xJjmA1oGlk&T<l=hX=b)s^J#de9
z18G8G{S?!M{E_lOK5)Aa92;&{{lX?&d3#Ab(u&jMnMqmNcawHQOnfV4@CkUD?MNMz
z@(e;qd2H5k{VQwLs#~=#`NMK9kBvREUGWF;6Rh_c_pp0q_7jJfU9f@3<vsL<%|XWB
zryDgDUuu^swBRV`Z-#$T2QBMCzmEDlNSYt%S5;b09Q7x^g+lma;#H+Qc18^RW_yUb
znN}EOpPp)6^o&EZ?QPWTayYgQ{b*w}gg1e(5oAuZHE1zon{7|@xS%7I@b`IvpWUbl
zWXze_yOK^9Q%Ole#g$;U^ny$}bSz(qXaBL?>bw7b-qf*QE3IO}CsUW`3iHG615O<H
z;jI$i{SPl!$x0PyT}jES6;*=W;4&sFb9^u<`F5qo<UtQ}Vrw~w%?Z{C3DbQrDOy%q
zNs!USTW`I!#9W-g?5F^k!}wIzFgnGbDi+vmyC*3pmDNclSd;qcr=Pq?B_t$xkpkvP
z3YbvBBLX3>W8S2&nO{cgkJ&!dZAI#z)0Ag4#uBMAAMhe&nx({LE7g>D&+v#sddBe&
zwHS+Si~*%Cy=Kjt(n?Gp_~+E^8JKvEA%O|MB3qUBf!X$%9-f>)#VXNUB(^LmDJs3d
zB)etHmJ((3!qg07MlVc<Eyc)bOy4NQs1@%~l=d(*vM_f!4bHX?@*tZ+7X*}!qPPVq
zcL5l~7RK1cWFbt9!j8#$4^LrqRoS43ddpP|^_Z2=@Wd5+SAwNPStVZVq>`M`Iy>)5
zFyCIVlA`pAE5V|vtP(n~>Q3nx@1r|SE~XMV4^LS>D#0?UjEPU3R9p$xsu!%JD81rJ
zu+S*0gbu8AQgJ0sFQyWCn(Et6utY6m;!`KIM}oD055;2Lcfm@E(kre6H$7#Q(1Ep1
zDz2p2#Z-c!vZC(bHl>V-Pn}d;3GQ7kSV>WO#g)(sRI7vztaVaxCCx9U5_#J0+r(J0
zUa&hkqp>jcT?y997p$Zxz2Zt7<tm{AYn@bFNsEiAMBYB|-5uNpU9dYjqiI*L0-fMq
z=Yo|KrB_@@<8qbIfwfNbN*4LmrrkffbL|k(%+bb?n4O)ISI~Z;y|-Ej)fpdKK%<iC
zw3in_FGe`%<p&47u#inZ@~D{hbBVi+o{t3u<c$9G_>U!(kmra|CC#w%Kr^*Go9W=)
zOjrfY$a<ZdsgyJNr_YX9H&ffQnU3DgG_Rl;xh>*m0&_;6`tdXCX6kr0)5*J;RuwcO
zH%{D4P|oP%#iy;C3Gr;Evv)IXD`-Y;t+*LG+2;GR*3Deu*-RJjW;#^R3~s&*7pR;w
z`mb+3wr-{_n(0)rr(I3Wbh-#nD@xy4^p$lp^*o!g@U$isG^2Z3QTo@rc3L+R>e-Bi
zr?se{8Qs&0(m(v_1?y(&dp2X?Y1dTHjP7Yg=|%2Otea`z*^Gs!wX2{R-P4NFw|{oh
zx|u6Io3Ze;jukYcds<QYpC4?sZl)oc=~A($IjET~7vX6gIxczcLurQG9Iv;Oj%inU
zHe=ywO)F?d_p}ZjKYnP5bu*1To3Ze;@CusIJ*`8>eTSD@H*>XTGZvoKx`JkOPwUWe
z%j2(FH{<YZ#=_GgDriRcv<@8?y=jclp0;W1*^Gs!b*i8l-P1aB{KLJ#syEf>K`pJj
zO6Sc)k9qT|k|3XRCB42k=SAyEo0L^b9_3kSV~<L8FQU!Ue!Z<LZCX|-`HyF%%{(gA
zeMYGj&kwP#v{_lD<Sm|+w)Ch}_YkFAqgGj0+Pth%@(s^Q+jvx}`vbiqx#56yr7g-T
zB~S3Iw7o~Ay7iU%ZD}{FO6~M=DBXl7WsO>Bk1B6@+m$8$^h#$IJ>4{?#!A@xpp8JR
zj*!Q0p)ryK)1yt=E>6zM&7PK<RWL3;Z=roo`3n8&mQ<zpL-E2F-qXvaT-kepLA?Az
zrP#GH8^A6SHxNiK%i<*VGi;;={m5SKsB*cZMSeBuy$*VMojf)tdx9f5CpUMY{Z<cN
z^-8J`ud%ck%%(Re9hAolV!71qGFI5D;YFbyq$VqD+60!ek|UFq9GR@-2#d*U5ZuZ6
zxzi@*InuL6=HyOYMB7`fUH&Bt?T+#UEBRB?$@F@oyk1ER6w0=71yb2?kFtUEvUyoq
z2d&s6_+?qSrmZW0u4(RZO+bmAu9-&fb4}qDaklaDDq3mh3Zg68dR!4yQqAj%@@-u~
z?b7B=>dZ;GS$SCn`BP>&2IkBxSZGfxUzK0yl3;pgb|$?W36IEQufV&kv&a$yiOx*&
z5^QOiJ^>dnoGw7McU2~K(H>P+E~!m#%;vKZ^VJNhWE54_ovNHf`6+~tqlP9xk)+AW
zbYDPQKWX{-6a+EltFkpH37~hF@osPVFu<m|$%rVMjB3ye)O2^!Jtu3_xV$kAx)1T_
zu75Du2X7!EuE1gpF_Zfbb}tIXt9#6r>fq)<#7qX+MSeACS*cY{<Em%nwJa)^vDHWA
zB?(WtKc|kM^3HnYG`@OPUfZH_8Do7^F3S!-uDpw0IgPU(gN=V3i^?(9irs^BwJh=r
zrq|MGu<1T-%-CE?1&$8DBFkePfkl<aI>Do(U3Txd@v}1lYY(YHZ+g%kR*$?%)5w9R
zm3I-p5YiuBcb-HM1XnE^G)m}Eh3O=Cp7A$_vS51ip1PerE^k84C}S+^<v}Kt#@KYj
zy~XXzMl=7?7%ClC&5;zl@_}TiYV=}1tp@t!Oe>g@MMI^>Bx7qxlT07-Ui5Sd`7j1a
zxozUPfu8S}{ar~9fl9+vxfH29tUOnnq9*%LWKE%gO{zjTR;TY3(4Bjq{3#Q&avkL4
z<wq+;uW8%MUFN|1WAs5JCm@ph<QL>Dw2v&`nqL))WVBX5^s&Q=TS_KP+w<l?j;-~w
z=|zsrfn1Kvfn1Ij`Bha;MO%4&rxmbo%<yRR3aYv<Ys=d^^ob7hLOJgMP{u@#OeS(<
zGLa)VcA~2iX}M{63Y996$@=lIXKr_hvTD=hPE%0-oJsjp3LFE+73Aj76oi?OT%8XW
z+S`|}%fBX>cOZFJ0T~`z^o~v&sz~7~@(bWW9{Vu<^|=a|K};UNPFZfR1=cXfJ<)-A
z1Q)GIvjt7)1N#n4OdsIrpFd-fUo9H#=^6jvtSNaIb!DDOD9_!mDot5~snIDEs^-9J
zHNRku!={*Tzh2GP_K+4(hilQ#K&oUUD_{WiVixCmlR7Y-<Ld`er0#L_emVMBRsume
zh87tGG}?DjnKnF1x|3dA4aF!&wf4-)ZbNCp)cm|Qy$2+ZXusSZs+Mcb+fa@^xbO-3
zw!stHIpFii^=<T$+D7^whfUc6>Zwq_A%x4f8U8E(s{zpfd?gewS(4Y$Y(l=mAM(8s
zhX0LV|BJbv@JA?xs+VkbN=l9S+NS=bRUIxtqJd&+!L-q%ODG`i>K7V@@up3-y)Grn
z7@xYv?<duC`?HkrD935EN~hq@G`*Mm;0YHcub40kRia8x+^uMYWD-oKZEN!^J;q6i
z&hWapZT8gZQpDDTepB))(%1`GN|Cly>rB#dn_5BG3Jn8`d4$c=Ff>G?l<~cw;Bwy!
zs_NGir}^_J$#}Z|OYg1JNAv}$ujeVX@d>3)?Z9^g@im%iBuCMks>s)3Z3UCE|6KRu
zyS+#DOBlg;E5@&3c^e}x%%R4o8O;qe4yZYF<|TUXRlZ$#JD0wLW%JU~Clgv|`S8;G
znS_>F{&CtgK#erc&`*GZR^(HhQ1*KzP2DTYXc#5Reu0&I1`!Lpn$7NGQ`<YFF)JMV
z!8fX;VUFeV0mxM@I}XCv1GMw>xXRX)&hy6)FGwi`9m_W;?X)D6JdN`B(D$H#fqi{E
z*~iDg;Fq2laq+^?3(s;C7+x59;8~8AT3#3w=2;F8JUlUYmnVjJ_QVj9o*2#hUKn)c
zSq?Awd1BC@Cx&?S#A;h$bu2LWqvy3(SYQ}NJj>xBwkL*%xSkjuVtQhDi06snA(khG
z=l-4;o_l*@c<$?oUG0JW#bbheD^}6l=}YOnjlUx+*qH?OTqmTRWiZPSmZ2;gvUIQv
zW7(8tbC%&OTd{1-vMtL9mhD+~VA+vnCzhRAc467o8A{Ana!h~+I2Afe=-i<Pek18v
z{1eIIm@_0@wZ0}<c<x)0nLqtXa?%99#56VbNC3&u06R(N?^Q`=X4XJ{dQFm>Zh|~L
zDwt%*leI|}&8<W7{Wg#Xoj_v4k>C0vWTayJ23%FRGcZy3AwIiPQq-#R^ijz4cS)+n
zdmy_#4Y}o6$huo0Tf9%w{Vg-T^(5sTgT5!ZspVOcXU6{w<Vna)?S3J7$PF2>;CGS>
zUj7&GPLL7b{Xw$O{wGQ2<L619=>=I_8zmi0elYZhv4UD<JDynq{W;yx--4~sU+`e)
z&zS%=j=`r%P8x@^=iY+;oWm-SJoq^D_wd?kBwY^lzEczE?BPa`^NJuN8bCL({vjkA
zu1EgNX6SF`3gkDm2Yx6E`IA4OhI6%o4E<r;0zdIE@g(sr@iUPj#EIVXWGQFG+kE+%
zc$+Vu6VKDVP)FpdR)+pChL*P7un-JV7DAqz1L>X$sq#2K9WvrR$WF^37e59WunO{{
z)sP3DWMm!W>uVW*3UWUCN$ZWsH`@f6!TD92k?;N-WP`1c&oXj;t-%lDIiZU6lsOG0
zGABd2b0HmLA&W;rs&SA`#y4@9NnHNWOyI#cLT28?WmukJ>1OGe4P3E|ko?U+7O+&e
zARl}yWFaG&Gl<_UbQ2b2@N4Mwr+E;Y5^3s-ydE_^`d~wXAby0*8=dp71v_pw5Pw2$
z`ZeRp<}Xb!kN`s355N0^tFvYrNF_qL4xD$k>*M_lB#@9jdlPT^<;O_|5=4l5WAna4
zde1NrJ0WKuT>Nvy)_V=4G9i=R?G(N|=qUrKLdfWdZcVGS*=rzG3CXmj*N-ebWFXZD
zx#_o8Z~EZ%j|`+bAs@Vc$B0uWJ~NOSgj9RuvHYq_KQxe<gbZDA;Mbx3ju}WWAsK^<
z?D-FTX&|)-*|z$LhDA>vHIUkbth;M$LD1$C22zKRwFR5bzn%55frJp!_xRSeUmf|?
zK&~L<!OZo`whdH<=IavD(iu|p@G3t8sYl4kHjO@?T71s9DwL4>YjoeY=c;1~7=5t{
zAe$-~=VP46cV?+aj6`8u?QA^f6CqtmEK?Zi#xku;x+LF|k#v^5SPCL}mM%tIT!Smo
z@P4dFz$uKc(fPG!L}V+@d+~EQf$RLFcBS!C-T7KCey$#Tt<KVlA67@;*OY6~`9(1D
zALFNVW|~Gl^oNxi_%-+9cM<m0^`}y~1~2<otUu+$zRI*OR*m2%9;WN>68X8<|1Q<O
z7vzT(EcmtJ-v0;qNqmU!D=j|6|9tT)jSsA*!LRjyir>Fy-%@^9*@K_Nrr1<;DIO_t
zBQw5?L2_2sh|%0DZLCqrjIeY`UdA1XXo+RcyEK0_VnUE4t|7)4UvQTJeiE%6`P`-Q
zi{q<!Ed0m$;f@FVWE{B+_{nIhO#R{R3;e{g|EPVHSoZJP7k7f-Cz|_5`TZmQhr3en
z>*OqBc{%wX?vTMu)&&2k|NVRR_3%I3t%IM87k|UPG-9D1ZDjdd_Kh~i7wjCM-mYBx
zKdQgK#m|gi>|%glB=h?l`lA`WRDYtyf6u-uiR&@>VMhh^M*WlgM00;jf2Mu0y90hQ
zQ(Xr3^@tDbG=ZP2TrNNRV%H1&V%ffzf&M)F4?A$+Cv&{)n_V7KcBil#2!66gx(xK^
z;eXhf1iu8fugr3?mXQ^qNLl^MyeEkCL}ncs+hqimaY{x5T}u3kmrLH4l&iYX`23+t
zQBTqUo$L3MD%5`V*z}_d=drWzpgwx;$~LyZ!Yr^R7FbgYteFMY+yZN1frVROEiJHC
z78su4dG-wt!91}x7Fb&gtepiGVS%-`!0-x&XS;Yg$P>fUZchxaKYC(aEU>N?Sfm9O
zWr0OoVEDqZXS?_ot0xv`fyG;32_6{saU6sp&UnYeSnc|XGr3okvl5Y)8fSWJNj&L@
z<RwxOXW)leAbzr=P;Q4w?z}__GZ_JV@soOejRP_Q$ZR4~M`RS&aq}qz;u89kRgBz~
z%Kd0V9=W`woRyLy<&IV#%Vb2;rSwqmr;g}(^DaR2hcN>B6Mmu_(V0Gu>etIznej!+
zm?{?6?Jm~$_5m4jW%Sj@V8Nw)N5j4tub{sq)>atHiuETNm6E=+D7w_8u1m>#>st_W
ze?jzzu@m|ee$oTcf#^oprLH;Yx9)A?-Qq*K6yK70SftE(dY+@xhylUPbtJ}d=uh@E
zL?5CXUs}}t&s#&fC+K<ITO==Mec|DTeOnm%6Mo*B6P@XGiH}~)Jg!HyXjfuZpUw3s
z7OhK3b9}-42K}Y5=T)pZ@jP9B;wzULzq($%^X20gb1nQ&_(>1Mw?sp_7wRLQjIMg`
zz5K}-^Vzp#{E|_^7%O<hF!D*zj>Le0#2NO*ybt}!9+~))c%d)<6CHc&OxJ|BR|z8C
z;vI9|xcQV0YY=c3exg5#VqJftInkwzPvRwdY_gt=7?jaelZI|sPev^2d2Pqh7)cTg
z{b4->{dIFfdh5?yi(y(x@s)}-C%Tay>at?o)F0Mn(4X*=h%-lUFczJ8>rZqn<@MMU
z3y2i$ij*-=d{Lx^h}I3=3vS-$W1R>dvX6VI<Dc$@qI>UoqGIiOd#aQ-$3LuDp+Dg#
zn$Twv-3#?G&pUo~UlbkaQgo(!BqO@N8j&j{V-5eq`WgD`?t~P5gmK=X$%a~9&gz=G
z7%%*H;}>gr=ui0RBcJ%MXj^9>z9>E_n$}mEy65S6@6pi<Dd&GthW>D00nPDKKVvsX
zX1R*_c{7u-TDP*E_lgGP!@dSf)4sUJf&PS_Xhk%nYfiVOSW5b!uikt`v9}gQbKbc0
zLGVaJf4JX*{(3qgMJo~qdSvPL6}?JNyw_LyjOWcjd|zb6_BGd6xc7tpbbg{6(W0=?
zy<0{^U+X__e!@~`BYM&iZ{ET$lwQ>q{q=J8P&W4f)*{|n#Tyh|=-tFL^=W9#(PokF
z@N@hwDu9sme|>%a)Z>l#S$`K*iI9@m>Y+`)t8E~Gg!KI;^RLIU8yH9sAuqob68-Ga
zrUqgsB;&fQj_z#{22z=jyx*og*06d91F1qtz`Br_2Kzf12;P^-SpRO_51;C4Ak_#N
zwpC4h`pqZ<!TS<xGmZ{#`$@Ec)F5P|D=BXF1{1;i63_g0<##);iZ#jv6LNTM!$q(B
zo?sxg2pO{W_21@2q!>tTLMrF2&V8^;vVqhgr0x0bExLD4GLR5LUR?j&(99p&8ORlc
zI14+D8!$P}K<X0G{^peQdxFiY>Jidw$lS=oAIBSILJ2wd<Tuaxuj=Z=+b-A}fFJeZ
z^IiFEm$N56y=_f&TLbZ<^QSwGnf>~Z76t<AZR;Es8Z@SffxvnPj%>T*=BFAP2&`A@
zi+hH&>sH@DV7-Zr?t1CZW)1^^_5S?VysAO9&6;7o5#RQ2^79I@URV0|Q<`dga_pd9
zhdUZq!Fqvr9Nzzst&4%cdYh()oOtThNCScOYMlEsA}Kb;Kw!Pcdqw_S_aU)NSNg6*
zn%ewXob$K(CIai#?ep%R?Q=w<UFnr=dOxjovp0H-bQ<-*dYvnOzM$I=CIai7jhgZN
z4ZBSQ*8A|u%`et%C^qj(f3Yb|HCs^o`R%D@8CdVWm-cVXpJXDi-mHMG{kLClUIpuQ
zMDv5hzq%?|@70~hjy?5qN9T)lgk2nrPw5s>7Rgce=G2ruz1F?YQ5MNjR{!eJ?LOTo
zQ5MNj_G!QNZ+-EzL|G)gC!D4VmRI`Zs*w%2&yn;FRGOkVoIUioL|G)gWs|1b)ql17
zuTP1cBH2z~1y7#ZilPjD6-jSwrl~oxg+?8)QM)eBg!nxo5f(}BD5t4KgHMDm_)H=!
zlHS`+Q^}KGUGb+8VUcX3hE=QF-r*6^KqS4-ou=kDIectDHL+SG+bA+5ept{6(OV?F
z?M?3=<z7Evh!J6t^zRqw{lT7_pO_pg5k_xD5^`0;)4i+3NUTJ%jV520();HhCBh=<
zZy=|s9m)GgzCTO+A(H;H4E18~d!r82F|UG+GGbpi;XWV{7RfdmR9N@+yY80=!>$@4
zES)tG#SvEfcK7R#SCR;eqERtTeRWsQCZoS^Zj?cURUdd@@7oVcghjFCjy-cW|Dii2
z!lKx6^#{$J+;yx(SQJ~Xa{YtPy;09$)C0@S>mD-na5IUpD7M@$cP==4{vokk6kG1W
zAH$cN*(nhg#g<E0pS8C|bBQo~88A)t=)QX5pPMDZqS$)f*L?I&WG9KRD7M~#Yj@o<
zbfj1&immri>O1~dcQp}M@77Q2G~GT}G#bU$D|zsnL*Go3IEZ5FEw1xjtJSAW1lA+_
z2HmvAL}0y6dzbqM3>KS5vGsNh3icm<tyu=v8}Z)lxAmWEBCy_^DrpOP4l%D{>tVL2
zF8&q8)_Z;R+%D=<L|7yK-#v)1-sK_;h@$wyY!=P7nR)X~9~S;_73)2kZ8OU8cH1xh
zkf@4g+l;7oJmvZE5>?S0RZZF~+0o>PL{&7~=C<SZ`Um%lZKByWZEjra_x%+zcSW;p
z9`nnLz5OkjyQ0}Pch1;#_YZ{<S<!5pL02@mJLheQtZ25)l51XgBeh8S8O^r&W5*k}
zeD;!wz&1BMaoxjv>WH<X**4Fe?vXk5YtdIU+vb;$sFWkEW$udR$a--3^!9H?N@PWI
zWDQtUTz#A|cSW;pKKb&_f|=(evZ6V%s(<zI@nK`c5287;Qu>nSYfEHB)1TZ=Q|nv4
z7TxfuL{>E0=KWCzKJ9s*L>Bg;5m~)i>oFWzoBOI)4i1&bis8t*fBCZuANWNgD~89!
zU7c<@x}-oND~7EXb!Pmoj*BF+@Rd~>n<w^v=lT^ASut$AeV@>RrIN#F3z7BCv(G$s
z-d`dshOOrs6<u)Se6d~(Tkp9Yi_gBYULq@ot=BT?)bw8)OJv2c^%ft=s<Z54iL4m5
zUi1FT-~2LCA}fZiw`u(ix2$a=mWg5O{jxhXb3+pof%Sfy+4!nPH;6`K*m{L)ZMUx;
zC;lJ9)_W<cNza?!G!aDBm#^##j(XZe5LxT1&RmuiBsPy>>n(f1HhNEKJ&3GmysA0F
zyb6)EKRe;RH3QA7V7+JdHd7@{#lK?MdI<%Iv)_0@<}N%jKpgcc7g>HBQ?YEPN#Qqd
zuTi6j=dM_`(_JseEsZabxht0KH1MyUC-$F}D2rt~&1=7D{+EL#%3?Xn{67Bnv#Z~h
zD2rt~9op8eu-+cAQ!LwQ+`1R8I@(a8ESBvQdHdcGMMjk2`@=NvZ_9nA9j%)X^|5TH
z*a<s^k9}97ESBw*e(wW)4<3^~$FiMff4!k^)IJk|o%W=MG@f>~ST2_B^iI$lA07Hj
zbQjBZTGRW3xGha2%3?XnuDR3Mc5<{tSu97{*?@h0Hpff6#Il`Ud7%A_Hs45;#d4Gt
zM!IhKB42zWmZL1;{JX2-jrl8<qio$LdAH@iB~cd3cB(zs)@$QJi84IJL6r63e#dc?
z&8ZZTQ*4(gi{mJJ`mOPE;%Z1N#If}%Pr9+*55@{Hj;;4*!XM3h-!4%WCs9@svnpwj
zL|GhLuf)FJ)hxkbw1p_!H+Sve*ISu2W94yn@WG7wFN^i!*m}dV{<tC8Em0Q7)|=Sn
zx{;4wAyF2`)(hEkwo8}aB+BC0dJAgxJ8G{YQ5MJ6Qv(8PjO{FziDT;pyiu#ef_f$b
z>)p`fr;IOpiALktdi_)84tim-#6lcf?~mojx4d)KL=a`6Gry0^c*{f(WyRT>jt%T9
zHjiWL-FR?u&BQFT45I9}P4%jLbgzjZ${HVU@j?7J^D0Ey`G*fbxj9b!D~_!<W#1j|
zY$)o;>o7cTLzMMpjmER}9K&;mw){xEHlD4w?3R0Ge*3<7e>_`n!u!dcc0Vl^j%VxD
z{rq^?o+l*s;@NspBiqE&zo0Q{#=5a_lfr$q21@M3bL>q&8gycS5qtQ4dYa1VJiKqg
zi(<Waw%%R$9eM8qV}^@o>xEx4_i2B(%y98+y^}oy*57K}oyD{DZcg2C!+UR-y};V>
z&Kv)*|9M<A5zp2Oyr$2#y04oEtatK?zH#q{h&|)kdYyypU!VL@G#by=tGu>SyFZK>
zE?#19&6peSNtD=&=hzFle_6_l-6Zzn*?I?_7`U&FL!u;}WAC=enk^!Fry2U;)yI<L
z`*N$ASHXH~9SK+N`dnf!o~_sB(Dw^QJ}j|^C!>fxv0egOZ{wqjKJS_*mPugi<t}}r
z+lkXM!zHlwZalDO)R*_j42Q4w(>H}iG@hC>Nn$U7t;hG584`O59DC0{GW&R9n1lHy
zu=OTw>yt6RtHfRcTW{*w`%gZ)My!{>*1K=@XD74wN$e%C^%}>15;@W)v6sNsYnnRh
z`d8kQ*h^sRt#8#S_>IrSG6@`eFV7fx_`W$}nFN{PYMtBv_F0L~1YY^KST$l;LZZZ8
z0$cB^4te7Xjd>`6t;g$%nu$g)5PPGFhW9$SOQI-&tw*DmYiT#Jc>-IH@7gDtWe|H0
zOsqd?={ysG^@h#7p;ecm=2fuXsjxe@oM~_N0(WPQ_fxCnyw=f)cQI1vA#tu>q4p-m
zh4N3?_SjZaT1g4{JvO|H;Uq8ce72rwfhAdB$rf0O1(s@ob+f=QmUwc(x5+%Q9u`<n
z3#^v~mTrOdw!r#WV0|sHeiqoZ7Fd4^Y=8we&;lD|fn8^T4Yt6px4?#2U_&jiVHQ}1
z1vcCQyTJk*;ep{^-bonj-j8F-$)nKOuO~h8Ymtn;P9BB&o_gcmKA*`P;^a{%VBx0x
z7IS2za`Gtj`;p4Oj<`$a5GRj9Yft}t`|gvne#2h`p?#9mpY}+(zJbveRsf%_Dhgco
zm8{>KG74d9X@`tLP9BBwUx?{&T|KjP>^<zQa^|zIUz0h+$)nJW!+FmiS}p50Cyzqk
z?L0c;J!AjD$)nJik-LMR-Y*gD<WXqjtsjngYrBbH4*9HU;G88@Wu$WQD8zTdr)6Yt
z@+frRkHF?#jr|8F&mp(3nx*cGkU7N3qtFlQR{pxUr_2UU9)*s#s=K#kQ<+1YJckTg
z(`Mt3!(<L|^7@VUF{+tYVHE06X~N3hAIco!<T<49?$l~Acgq}tk%Fw}6ze6j^$x!G
zlmFn#Vwps?-n99)kH2jrBYh%UZz8rwZk9PDk*!xeH}u(AgJcd#Wb4%oUoqv*wK9h!
z%K9z-%YAdgWe!Q?IpoB@@RfVBW~=~sPr$gxO=Rn>efGqJrE6slN#r@?*3Sp7-q%#-
zkVLi~@8Lcpb4VgvZ~DGolTKYN^FtzAZ&zfiuGfwc%OtY(_MIDdWJOIAf%P8z?&gHf
z#$8gPtlye<-fGK~kv>sY09QVGLra^?A&G3gYFl!C-|aTbVEwjc{PUIfWQola*?M%J
zKI?qCSq5{+?k7r)553t$Fo#_EQLC4Zg_~EwddIiVe&CN=#lI5SdSUY(JMiK=vVOyu
zPS$gY^^(|nyplEU?eTv~)6{ztp4(jeTk-xRw%)9G|5I<e#KK8zy%8f@zt_&#T~A``
z)%&H#_nRuq`YnmAmtJq=FKOK+_LA6oL!bXHY3g?pdr2I7`*QuNz45ffUJ_gHU`o&D
zX4%cw5qmlFj}QOl1&O^Rw%(|P4?eePt;AjuTkq}OD<(I1OGXg<MIGA7&pcmc+1sLt
zB(~npMR%WRx5Y$Yz3=U`IIAo6Ok(RrejNC{(<VAjV(S&Xw`<knaJhF%V(T?L^Ly4E
z#@=5N$KH|JyNavDN)#or^@z=?DlH`Tk~sF>S=3?O<HIHPk~sDTbvk_hEn{~*iSL~z
zPoJ=?+FFUdB(~lgk1WfKG<GO3`;ztCV!dRxUiZ+z*1KAXWs=!?HQH=><cBngkYu)A
zwIQFKidrVIm(12%IlfI%(te3O{G}mUjch+$uku8Ry=1oD%bWH;{Bt`8kDSSDy`EcY
zqz(R2R))!Jy*?>>x8Jf#te4EzoAOfqKmR%)v6sxThaoV**!xRn>+#;lcM^NaY`tC^
zNB+1XUScnqtrt4XKBeC(u}m^sZ}OGZi`z6c5m;~XYm?U&WXSq0nXTt;x}@dTxnjL!
zw%*W3gJz8Rmx*Bgmejm{RMl5Z1hF@$<Aj!umn4dk*?OPHj8DJY*r7;f>!p45{Nmk(
z=2eKjuTRW<^7O;zRfxS7<HzOQdA;~oGFxxzk2~TLw@d6{orHPsTGnU^TQBXwZFBpd
z5U)*P>wUL;!QoKj-YJEx_sqn5Urk*j7EWR7wVKx^AZn+~d-x+yY3jr)_dGk@*mF-|
z>%IM9>xb^YL1Hh3t@rI;-D2_%N$jPt^|DXj@lf$rv0e&W@6+@<XEv=Ov6sTuQ~rsr
zYTG3CQrLPoez`j0hh-9bDQvwH13RdJub90+>`irL&TsUgXd;EJXB$8M<Dsvb2&{Mb
z%5D38t|azMVe36Mb;q}Bei4nPu=NhoH;nISEU}luvDfsLR~oeKAoE@d$KIm(QzBLv
z`xYr|y>5ZK?u%$9v6sTutGE2yPVe@Y*h}Hqd;Qq?Chr;h7AYKix!=uRU*%1Sy%e_I
zPp2CCZ+SrGJ*;Rk?}_zN*?L>!ZrndRLoAcZ)?2cz_m4XxCH7L;dI1LyZNB|piM>>|
z-l<dbU+J<;VlS1g*JST4cUNC3v6sr$d+N&YGkpRb>?x^iy-7bb_<2o<#9k^}@56rM
z+pT&~te48xd#U8QE!jIH_VCxa($wdUq1Sv8Ec0F}TW`)nzp9zXB=%C-dSCoG_nyGc
z5__o}dj}IMcbvFLER)LCD?0O7UZLGYU_IX9GGZ^4t;aJ$wnRuOTW{ygnQzbe(L@k?
z)h8uxZ~dH!Aoe!4T=4M_<H=SkTkq*NTH4z8GRt7z<0q%HOa!sF=(Tl^Wc3tJNoDIL
zL{$l{lrR33%GTTcd$)qOmtuEtrNX@j=Dlm3h(LLc9nSftEW=oavUISNv+X(GiKRU2
z_I_hUd;acna!Gza#mMthZprIN={pqi{v}vZa)V#L;Ikw*o%xBRdlTe>+aU|1Ao~qt
zd@W@0Z;;MwP`=+l$Vt;7-HRd5Y=kV_3AyP2Wbs+ZL+2nf)z2hdzaZ~C#b;lKT(AW)
zVm9Qa)U!_EhkG(`>`$oqZQoXxn3p#({#hySZ`D?~KO|;O;pcGL=&kB|3B{8y^KWa|
znXl4hFz4m15b*<HC;kz^XFISIKajk5gML=>UAd(GE|~aAdqan~UnMp!;i&VFysz)g
zc$d`6d!P00r(Q<R>QWi}aPLg~+`>=Th}CuJjqAMimVDv9*z4tuR#>BF62u2_9}jB|
zU{q}9t3CaCy{~eWFB!r$U#bi?^oKnK;^!28;xXb|GOkFy(zfIqa(m${#pmQIksTTD
zq{+^l*ZoZ1v(d*Sd7H|~CFR{3^BrL9Z@~X_{fTaLZRu7J?dsa{){XQ{m(nYd4(8#F
z2re?j&>!|%;D5qTY7~CL!&}N(@3!^Y^?Vq!(MNpAixgXlHFW7P_+j4%{x^_o5v>RV
zUsBhcp7++GH=_4SKP$M7nEr=7DEQw%<|qCnW3==}dN2Br9?MzrwoZJNcvvLo<xRL)
zEic|CUgc!m`yDPp#0$kQ&F?^9KMejS{G<oER&<R@Udrg2(7j5xte%&CRxI`M4GsHZ
zZw~%<G5o~h-Yj)b_r>*6n8Dvd4Sv`s#PJ~3{Kf0fmliALs<YI!CAf~5{IF+9{G7s1
zO6azeytmGzq}1yjj}n!7Y<jOd#J|0zToq>M5BsOY&n5h%C23pNgsv?)>)p2ZDj|Yx
zB2rcfx|9eLL`HSVo9j@S->{cU{M^D%agG0;6z}|}q`5x8zB2spI$_3nLH@U;=ns3`
z@IT=vHWF)k&uOApeclsoiFfKgDm8d}g&y7Fd16z2?359-li`2ZZ-@U0KZypzzM3w}
zab>(5;)De%_6l#i3wvR#N0=D{&|fJ1ivs577Je<MC0p?Vr=P<63B!0LJ(@pqFFQ;H
z5WD5e@CoB*!^8Mq*4FPHzH1$(0_nV5(U|VRBB&1RzS}|<pyrPjK{}T}x|Twoe2DRf
zA^R<JRyW$Mp^R4Q%bo5pesU-EMi}h|QyE+Fa--c^<`v7@Q@gdP-P(jGm$|m8W7Hf%
zsMOQmxDxl8(j#06jnpl@(l&FMlUlJaHLQuJBCy3^Lfv~lCg}=zo21(3hCK5;<gsm#
z2|G!;9ymbK+3N$y-%;M(@CfohehxXj7|5QZBpq)d?_7zzJNXz%b?QsVMaLn7zam+<
z82QXzCy=lH4M}GV^2Jd{4Ssk+L#3VIS3C-Jxw6r=tMWm}-(P{8xDWEPmq@w`-+`?2
z8RSQhstK-AdCcGlq;nqHR<*&#@dISx6X4;P_BHbNpCp<2FXWwD!N%b@h5Q5G0^iIs
z`?$dmPm8E77x+09Gduh$<<<NbAd|L2{`4$l<`$B!?O^GA^$?KU_er{su`VZmgtNu0
z(eFOR*(*K)(hJ&Et-pX=4UJ~DM<0qEtlc}fZ+n0^a?mSBE%e9T?h}I_o?OwDZtzog
zq88UX(2&{>&8gS+LONkt^@tntnj(_!E*~Pl1Du@iGLL@Hr7IIw&b$(ByY5E5FdX^f
z$zb4m9n$?Wc(@NCpLrZ?oNJ+7XCQRx-p+arfPL{a_`p?o8jNSU=1(C%8D4!6&xhOE
zq%58WXHq{spSEUMU?VNCYzu6Z1(suhjkdtXSYTr<uyGdHcnfTT1(s`pO|-!BEU<hF
zY?1{w*#etlflal*3M{Z`7T9zPY=#9k(*m1if!%0<-DH8?Y=O<Tz;3a?ZuP*hGnYvi
zMU1+hd|bV`33BK<$lTSCr!hCE;=3UG-3R&p!;r5RLel%-BuB1+Z2CClyr&?~uuS36
zV>8#edK>UTETdWegi%GU+zxqe7vz{7kl)MMXN++Gu|TMk`BmM662rLMKE8f8%g{%F
z?|A~U=LX2+&5-k1?&3C<@Q7AzC-9ZrMs1!W;vro%FuJ*3b3+C}s^8I;D~0g^F9WH<
z`SAV7ci3g{LtN6ai}}rC2J%;0H!MRr(OEic@qI>Omjl0k7368w+`Fu;W32T<Yk?o&
zd?BB0#AiD^1AH#`?HAVQ!l!|3<dRj^BYz8@ZNMep-(c{=7(wUU%y0K|C|8TM62tOl
z=5dBC^(SB1lxxXmy*|#Gdzp1Mo^5oPb$>78tyrV8`0VW6sCfx%G=azFEG}7#&*t;B
zu`IK>%(&eKKa5v&r5b|k9o*NI%;{m4DGvc3h1H6Bcm?F?#~^n;2|1GcJ&I*N?!!FJ
z&)<l%4{{$SFpu_Z@z<I6LeAgI?3b`czGWnwkxh(@-)Qi|*hzIcnV)#>R@Q$4%RjlL
z!)*6lwnZrGFOzFI!u7t%_4ef6f5rK}lE+Nz+6}K#``FvMbACSiUp;8i70ezP%XnYb
ztBdtF?0JJ9#&Npd1%A%8AL5!pZ<18Ax%2|={ZGv1US_jmAIeO7m!$id!z7)fah3Z1
zBjB&{ocSux-A#EFQtu1GGnW;UEQ~!$(rNz^at-I*$h$gYo-AyJd9rvi@~+G;41QyT
zpBwz#lTeE*=L3>z?kmXe+>iW&FCzZ|_q*oX$anY{GVoK#mSE$W2R6>z!NwVaw%s2x
zr@N6ad;mNgD<M@VX6nr5n9W_^flcw_VCHgv1NqfSl7;?X8T>H6(KTu)q3Rj-;yc)r
zW<CMrJj)|XkS}-`axBMPBI|V!+u}ynbOMh}#mKvs?uRUdrj?WP_o27yW$ts<Ysd#4
zfPC;($Q(vC6d`{V=lAb1_+hRk)CqpB46fxij;Z79-M!heoj4kP=IA*CX0AeR^%{&@
zu9|4cRh8uuZuQH9gs44e$>sMt<heH>>o9{Mhme1ck?^;W-^ex@{to3;5TxtW0fQgr
zeL`KVzkxhX4rA~BnzeYEnWe14mEW(1{Fuj`P}tfv2rShezN$9!8wh>4?q_Dntcjt_
z;{*2T5a!{}JPN@~ZDg+JfVlg<2jmR%oAH{#4{H!Y-OSIGh!V!%cWKV~rYsw>bg+zI
z83!rl<u9?hQW;NU*@Mq=UcNJIeDgJ(@!niU@_mq}w{;+|WxOxTG=m@3L*O)wQOW;%
zQom0%?yR|Hsm=SWjs$b-U0H^*G<W^6HUsy+&rk1F#r!UYF@?Fp`UUGm;^z{6cIK`$
zsrS-omCs5^>9@!b#(hcA%Ed^j!Q2(bnw9vug`eJUJ@2g>owwc}UwP?|F7=Y$dNFsE
zuzrUBWpM9(ajKY~aTV8~xB7STrvG6r5C8MU&zrHXIX(Y(*mz%S^22=v{7?8vIlWb#
zpN@OiD2Q&szmqrZi+ddSpUzKjTjykOWjlJet;dRY-dEgs<8rOt82@m;1^*k)txEp#
zkTSmD-VgqFx$?t(DE#ko<%fG>_@D4=#a5O%H;nT#qKcPD-obb{ODW%$^ARj1FS0!&
z9eqeSE3$)DM)Kxgp27V&{O<-XA(5fSgq+o-epZhdJ*xhG-W*@BR{;Mr_%T<V&ELs;
z_rw<>t>|aX`4{^Z@IU7F39m_aZ-Oo(`ED|O9r6V%V|nGgf$@8}OdyxPp4YGiEWeWc
zR$R53<w=&!`OfVrzJnRcaxTm9EFWcQXL*BMyTuq^u!ll*xtSmRR}jiO3Lstikn-P1
z+@q0qPhfl!<6K6~WaK8uVwRb+k$2q82+Pb{8F4|nCC{>$OFB89DQ89Af|B%qPGo$+
zehwY05kQT<lP_K`5fH|BLzWJfg2?K%H6yyG>;5izi5u~Hk)8M|i5nf!ar3Pi>@5*9
zr|?sJrAXZyD$eUyT})o)9=)VDV$N^a=OTVCgCFvOT$HSsx18nr`Tsx3e}TF<X~qZk
z+=!E#`E6u>e~NuSb0c(la6M!&%K(m##T*}Xxy+-RarRNZssTqvzpX$vu$0JXz+V3@
zOBc(g94qHJzn$e<EcdW{l&_`TH`&K_)xFejHObz!F0qg8qJDbrW6!a`ZnMB{x4`bO
z!0xob=2~EPSzvctVE0&H_gY~0Szz-lu=_2r`4-p%7T5v{>_H1`p#`?c0$Xf>EwR9s
zT3`=ZU=Leh%Pg?v7T5|4Y^4SEhzExII~QT(@hTI3@8a>;U4Xor0_n`-yf$(dP6i@n
z+_R9E{|KdSMc(1!@|rAWd=ev@Sh`pivNX!i;d)pq#@#m?<2QU9^=5Lt-B`*lLk#Dm
zSVpppW|_b;nI-Qj7=QJyJ0r5Q&=YytQ}Etdpzm(eS^B0uNquL**k9<!*Y-5{A>L3<
z_{nH5vxdI^5ymwNBD0S^YsgH|nagxxDLVyvUiv9Ll%9)><?`{GjN`odm$?x8#4l6$
z2?Gb02w@qlNkL>Tlr^Nxk;1qwmlWRm%qMy2x!#jbTweMh_7N$FIsaiCB7QENpD@t*
z$^0Z-L%Ck*gRqod>0HGEy42YVSK%#;b*_?cYuFcKBJnE}e!^Yqm9~Y4zJ3sGNiAYW
zv6R@w3HHXmm!41JUWvboOyQE<Sn4}rj3}qU592e{=oWs`GtopC*C@<HXOb6fi9U24
z=>Dfil~_$YFP7_+o=Beipd=!>55`;IrvKd~{ECI2*imsUx-?b-8ZIS$N$~{ztnSCY
z^14Tv`$w3!NPjAe+tzFJ<|izrjI<#&iWD8|nihSFba4IN()+9+=3AqfLy4b5_?hRx
zSns7bCuynT_z+JOZ;oJoy3`{^a6!VkWSHT9n9qrgvtoXtOJOY9()kHXsaNNu=XGW}
z8y&aehqVRq%M^aXK-lO~U#EKO^6%I;%+MArCVe(-DEB8==g>J<#rpGRAa#k<$3HzU
z`t#PS=uFP)<6kUum9wUOvF0Lvg~E^Xg8Z*b(I3`-#Ls=X^21t`_!VD{{P1mctc!`C
z8p-dPVMR<wj*;|!*h+=9FdaEZI#EK(T^>?wk99dQ%e-9q;U0nbxh_|JxL+ZDg_kQo
z+&d9J_vOkD_i@Cp_;TfkdrIP`vYn8UzdWSGFYa%Nnd5ThhkI?}=e%6`;l7{vWnQlQ
zum?f>T$d|9?1vD)!po80hsvpbu0#LP!mm(O{8NLz!E9Y3-mkXW9*7+jCnbESx9UE7
zFeN@TM3TCS-a7Yxln-s{QTm~Gb!-k*IV_l7F2|=9z4(`v-G<VHsrh+rdJjk*(O#(|
z^ablcJ}<)0-dy<^Rr@m(?Bhy*dqd?<CFN=x{?>K5PbEA3$yPdl;%=qrtg1u_zuUGp
zi-nSIqBFcmwauP7eT==H8e`BvaX)1%p^twGy<=!z{(ti~Q~*sux#y`%PzzKTL<t?P
zObK1AN~s#9>Xd3ws!0ju$&CCP>iF;H|DFcUmry9!JYt1x3co16^Rb_P?>jd5=?CrV
znikJ}96?wiCHMx;J1GTF>P`v1l0gZ<J(d!D#YGAJf;&<gcobF-Xz44us1f}}nNcJ2
z^Yd~dI#HG})aNkr!SuWLxa=wUQ}ag`I8tY3=j3vmu9iz@1)bezbJBTrZr`~TpB}Wy
z-~iy#KEC=7o_-&^`N7JzR|YS7i2C39_l+rpRr0_xND-lw5GT+{KT3#=>nYWv1YIC@
zCQ(9vW>SJKT$JcRj=Gx?bhLmH^zjiTT}ROCfJsxv<<V;w(#L9CAHhC<H=>462W;Ur
zoT=u7w(x>mG$v>SC5*-+WHhcu^}rsm75XqZf69cZV{>u}rZN?D7pFkKPu9eoQI7su
zd1G?QP8LuJ@W-b+C0uZh61d?2{jt+;w9$}$W9)I#Z;U^g^c#LQ);PvBA(TcWj_RJD
z-9KmgxSScuv$At@df;!q$e1)Dbz;`I+yT=@j?c+1;95a#MB=o9vH4T@95)f_0j7+b
zIw?167P`PqH^ljVQ>cmjX;Uql1FiZfBP_<{jTxAqpF4HH*!&rJee<$&O6><;!B;%d
z-SqW7se>IUi9OPX5Dp9tjmn!gcFMSj_Rgtn<f)U0`jlxC+h*ra<T4=J2SxJ6w05Lq
z<vG$F!}<*DHJo7Xw^=`Q`0spdDp}>LiR7Ps)krn|lB=jqz12s(i>Ux{Fy&$jUSyd|
zZT}*xz35{9m)p0|?CnnzJo@0Ub7U&F^t>BJin8&y@95FvvU6k@c65k{=;$aN4>)X+
j#*H40{}@33^9v(&+W{CU+D59Mqqa<z3jZrFKMnjp(qAD$

literal 0
HcmV?d00001

diff --git a/src/testcases/org/apache/poi/hssf/eventusermodel/TestFormatTrackingHSSFListener.java b/src/testcases/org/apache/poi/hssf/eventusermodel/TestFormatTrackingHSSFListener.java
index e52a3bc961..60f5d2ca72 100644
--- a/src/testcases/org/apache/poi/hssf/eventusermodel/TestFormatTrackingHSSFListener.java
+++ b/src/testcases/org/apache/poi/hssf/eventusermodel/TestFormatTrackingHSSFListener.java
@@ -24,6 +24,9 @@ import java.util.List;
 import junit.framework.TestCase;
 
 import org.apache.poi.hssf.HSSFTestDataSamples;
+import org.apache.poi.hssf.record.CellValueRecordInterface;
+import org.apache.poi.hssf.record.FormulaRecord;
+import org.apache.poi.hssf.record.NumberRecord;
 import org.apache.poi.hssf.record.Record;
 import org.apache.poi.poifs.filesystem.POIFSFileSystem;
 /**
@@ -31,16 +34,17 @@ import org.apache.poi.poifs.filesystem.POIFSFileSystem;
  */
 public final class TestFormatTrackingHSSFListener extends TestCase {
 	private FormatTrackingHSSFListener listener;
-	
-	public void setUp() {
+	private MockHSSFListener mockListen;
+
+	private void processFile(String filename) throws Exception {
 		HSSFRequest req = new HSSFRequest();
-		MockHSSFListener mockListen = new MockHSSFListener();
+		mockListen = new MockHSSFListener();
 		listener = new FormatTrackingHSSFListener(mockListen);
 		req.addListenerForAllRecords(listener);
 		
 		HSSFEventFactory factory = new HSSFEventFactory();
 		try {
-			InputStream is = HSSFTestDataSamples.openSampleFileStream("MissingBits.xls");
+			InputStream is = HSSFTestDataSamples.openSampleFileStream(filename);
 			POIFSFileSystem fs = new POIFSFileSystem(is);
 			factory.processWorkbookEvents(req, fs);
 		} catch (IOException e) {
@@ -49,11 +53,42 @@ public final class TestFormatTrackingHSSFListener extends TestCase {
 	} 
 	
 	public void testFormats() throws Exception {
+		processFile("MissingBits.xls");
+		
 		assertEquals("_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)", listener.getFormatString(41));
 		assertEquals("_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)", listener.getFormatString(42));
 		assertEquals("_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)", listener.getFormatString(43));
 	}
 	
+	/**
+	 * Ensure that all number and formula records can be
+	 *  turned into strings without problems
+	 */
+	public void testTurnToString() throws Exception {
+		processFile("45365.xls");
+		
+		for(int i=0; i<mockListen._records.size(); i++) {
+			Record r = (Record)mockListen._records.get(i);
+			CellValueRecordInterface cvr = null;
+			
+			if(r instanceof NumberRecord) {
+				cvr = (CellValueRecordInterface)r;
+			}
+			if(r instanceof FormulaRecord) {
+				cvr = (CellValueRecordInterface)r;
+			}
+			
+			if(cvr != null) {
+				// Should always give us a string 
+				String s = listener.formatNumberDateCell(cvr);
+				assertNotNull(s);
+				assertTrue(s.length() > 0);
+			}
+		}
+		
+		// TODO - test some specific format strings
+	}
+	
 	private static final class MockHSSFListener implements HSSFListener {
 		public MockHSSFListener() {}
 		private final List _records = new ArrayList();
-- 
2.39.5