From 117e95f06340652c3152025f15ea105ee0cb7336 Mon Sep 17 00:00:00 2001
From: Nick Burch <nick@apache.org>
Date: Mon, 31 Mar 2008 22:30:56 +0000
Subject: [PATCH] XSSF named range support

git-svn-id: https://svn.apache.org/repos/asf/poi/branches/ooxml@643189 13f79535-47bb-0310-9956-ffa450edef68
---
 .../apache/poi/xssf/usermodel/XSSFName.java   |  73 ++++++++++++++
 .../poi/xssf/usermodel/XSSFWorkbook.java      |  57 +++++++----
 .../poi/xssf/usermodel/TestXSSFWorkbook.java  |  90 +++++++++++++++++-
 .../apache/poi/hssf/data/WithVariousData.xlsx | Bin 0 -> 10603 bytes
 4 files changed, 203 insertions(+), 17 deletions(-)
 create mode 100644 src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFName.java
 create mode 100644 src/testcases/org/apache/poi/hssf/data/WithVariousData.xlsx

diff --git a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFName.java b/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFName.java
new file mode 100644
index 0000000000..5392bfce8d
--- /dev/null
+++ b/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFName.java
@@ -0,0 +1,73 @@
+/* ====================================================================
+   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.xssf.usermodel;
+
+import org.apache.poi.ss.usermodel.Name;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDefinedName;
+
+/**
+ * XSSF Implementation of a Named Range
+ */
+public class XSSFName implements Name {
+	private XSSFWorkbook workbook;
+	private CTDefinedName ctName;
+	
+	protected XSSFName(XSSFWorkbook workbook) {
+		this.workbook = workbook;
+		this.ctName = CTDefinedName.Factory.newInstance();
+	}
+	protected XSSFName(CTDefinedName name, XSSFWorkbook workbook) {
+		this.workbook = workbook;
+		this.ctName = name;
+	}
+
+	/**
+	 * Returns the underlying named range object
+	 */
+	protected CTDefinedName getCTName() {
+		return ctName;
+	}
+	
+	public String getNameName() {
+		return ctName.getName();
+	}
+	public void setNameName(String nameName) {
+		ctName.setName(nameName);
+	}
+
+	public String getReference() {
+		return ctName.getStringValue();
+	}
+	public void setReference(String ref) {
+		ctName.setStringValue(ref);
+	}
+	
+	public String getSheetName() {
+		long sheetId = ctName.getLocalSheetId();
+		if(sheetId >= 0) {
+			return workbook.getSheetName((int)sheetId);
+		}
+		return null;
+	}
+
+	public String getComment() {
+		return ctName.getComment();
+	}
+	public void setComment(String comment) {
+		ctName.setComment(comment);
+	}
+}
diff --git a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFWorkbook.java b/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFWorkbook.java
index 59e4e26b99..05479d9b74 100644
--- a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFWorkbook.java
+++ b/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFWorkbook.java
@@ -58,6 +58,8 @@ import org.openxml4j.opc.PackagingURIHelper;
 import org.openxml4j.opc.TargetMode;
 import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBookView;
 import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBookViews;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDefinedName;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDefinedNames;
 import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet;
 import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;
 import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook;
@@ -188,6 +190,7 @@ public class XSSFWorkbook extends POIXMLDocument implements Workbook {
     private CTWorkbook workbook;
     
     private List<XSSFSheet> sheets = new LinkedList<XSSFSheet>();
+    private List<XSSFName> namedRanges = new LinkedList<XSSFName>();
     
     private SharedStringSource sharedStringSource;
     private StylesSource stylesSource;
@@ -247,6 +250,13 @@ public class XSSFWorkbook extends POIXMLDocument implements Workbook {
         } catch (InvalidFormatException e) {
             throw new IOException(e.toString());
         }
+        
+        // Process the named ranges
+        if(workbook.getDefinedNames() != null) {
+        	for(CTDefinedName ctName : workbook.getDefinedNames().getDefinedNameArray()) {
+        		namedRanges.add(new XSSFName(ctName, this));
+        	}
+        }
     }
 
     protected CTWorkbook getWorkbook() {
@@ -324,9 +334,10 @@ public class XSSFWorkbook extends POIXMLDocument implements Workbook {
         return null;
     }
 
-    public Name createName() {
-        // TODO Auto-generated method stub
-        return null;
+    public XSSFName createName() {
+    	XSSFName name = new XSSFName(this);
+    	namedRanges.add(name);
+    	return name;
     }
 
     public Sheet createSheet() {
@@ -430,19 +441,19 @@ public class XSSFWorkbook extends POIXMLDocument implements Workbook {
         return null;
     }
 
-    public Name getNameAt(int index) {
-        // TODO Auto-generated method stub
-        return null;
-    }
-
-    public int getNameIndex(String name) {
-        // TODO Auto-generated method stub
-        return 0;
+    public XSSFName getNameAt(int index) {
+    	return namedRanges.get(index);
     }
-
     public String getNameName(int index) {
-        // TODO Auto-generated method stub
-        return null;
+        return getNameAt(index).getNameName();
+    }
+    public int getNameIndex(String name) {
+    	for(int i=0; i<namedRanges.size(); i++) {
+    		if(namedRanges.get(i).getNameName().equals(name)) {
+    			return i;
+    		}
+    	}
+    	return -1;
     }
 
     public short getNumCellStyles() {
@@ -456,8 +467,7 @@ public class XSSFWorkbook extends POIXMLDocument implements Workbook {
     }
 
     public int getNumberOfNames() {
-        // TODO Auto-generated method stub
-        return 0;
+        return namedRanges.size();
     }
 
     public int getNumberOfSheets() {
@@ -657,6 +667,21 @@ public class XSSFWorkbook extends POIXMLDocument implements Workbook {
 	             StylesTable st = (StylesTable)stylesSource;
 	             STYLES.save(st, corePart);
             }
+            
+            // Named ranges
+            if(namedRanges.size() > 0) {
+            	CTDefinedNames names = CTDefinedNames.Factory.newInstance();
+            	CTDefinedName[] nr = new CTDefinedName[namedRanges.size()];
+            	for(int i=0; i<namedRanges.size(); i++) {
+            		nr[i] = namedRanges.get(i).getCTName();
+            	}
+            	names.setDefinedNameArray(nr);
+            	workbook.setDefinedNames(names);
+            } else {
+            	if(workbook.isSetDefinedNames()) {
+            		workbook.setDefinedNames(null);
+            	}
+            }
 
             // Now we can write out the main Workbook, with
             //  the correct references to the other parts
diff --git a/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java b/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
index 8f52d618d0..94b279cc8f 100644
--- a/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
+++ b/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
@@ -17,15 +17,19 @@
 
 package org.apache.poi.xssf.usermodel;
 
+import java.io.ByteArrayInputStream;
+import java.io.ByteArrayOutputStream;
 import java.io.File;
 import java.io.FileOutputStream;
 import java.io.OutputStream;
 
 import junit.framework.TestCase;
 
+import org.apache.poi.ss.usermodel.Name;
 import org.apache.poi.ss.usermodel.RichTextString;
 import org.apache.poi.ss.usermodel.Sheet;
 import org.apache.poi.ss.usermodel.StylesSource;
+import org.apache.poi.ss.usermodel.Workbook;
 import org.apache.poi.xssf.model.StylesTable;
 import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;
 import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook;
@@ -299,7 +303,91 @@ public class TestXSSFWorkbook extends TestCase {
 				st.putNumberFormat("testFORMAT2"));
 		assertEquals(10, st._getNumberFormatSize());
 		
+		
 		// Save, load back in again, and check
-		// TODO
+        ByteArrayOutputStream baos = new ByteArrayOutputStream();
+        workbook.write(baos);
+        ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
+        workbook = new XSSFWorkbook(Package.open(bais));
+        
+        ss = workbook.getStylesSource();
+		assertNotNull(ss);
+		assertTrue(ss instanceof StylesTable);
+		st = (StylesTable)ss;
+		
+		assertEquals(10, st._getNumberFormatSize());
+		assertEquals(2, st._getFontsSize());
+		assertEquals(2, st._getFillsSize());
+		assertEquals(1, st._getBordersSize());
+    }
+    
+    public void testNamedRanges() throws Exception {
+    	// First up, a new file
+        XSSFWorkbook workbook = new XSSFWorkbook();
+        assertEquals(0, workbook.getNumberOfNames());
+        
+        Name nameA = workbook.createName();
+        nameA.setReference("A2");
+        nameA.setNameName("ForA2");
+        
+        XSSFName nameB = workbook.createName();
+        nameB.setReference("B3");
+        nameB.setNameName("ForB3");
+        nameB.setComment("B3 Comment");
+        
+        // Save and re-load
+        ByteArrayOutputStream baos = new ByteArrayOutputStream();
+        workbook.write(baos);
+        ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
+        workbook = new XSSFWorkbook(Package.open(bais));
+        
+        assertEquals(2, workbook.getNumberOfNames());
+        assertEquals("A2", workbook.getNameAt(0).getReference());
+        assertEquals("ForA2", workbook.getNameAt(0).getNameName());
+        assertNull(workbook.getNameAt(0).getComment());
+        
+        assertEquals("B3", workbook.getNameAt(1).getReference());
+        assertEquals("ForB3", workbook.getNameAt(1).getNameName());
+        assertEquals("B3 Comment", workbook.getNameAt(1).getComment());
+        
+        assertEquals("ForA2", workbook.getNameName(0));
+        assertEquals(1, workbook.getNameIndex("ForB3"));
+        assertEquals(-1, workbook.getNameIndex("ForB3!!"));
+    	
+        
+        // Now, an existing file with named ranges
+		File xml = new File(
+				System.getProperty("HSSF.testdata.path") +
+				File.separator + "WithVariousData.xlsx"
+		);
+		assertTrue(xml.exists());
+    	
+		workbook = new XSSFWorkbook(xml.toString());
+		
+        assertEquals(2, workbook.getNumberOfNames());
+        assertEquals("Sheet1!$A$2:$A$7", workbook.getNameAt(0).getReference());
+        assertEquals("AllANumbers", workbook.getNameAt(0).getNameName());
+        assertEquals("All the numbers in A", workbook.getNameAt(0).getComment());
+        
+        assertEquals("Sheet1!$B$2:$B$7", workbook.getNameAt(1).getReference());
+        assertEquals("AllBStrings", workbook.getNameAt(1).getNameName());
+        assertEquals("All the strings in B", workbook.getNameAt(1).getComment());
+        
+        // Tweak, save, and re-check
+        workbook.getNameAt(1).setNameName("BStringsFun");
+        
+        baos = new ByteArrayOutputStream();
+        workbook.write(baos);
+        bais = new ByteArrayInputStream(baos.toByteArray());
+        workbook = new XSSFWorkbook(Package.open(bais));
+		
+        assertEquals(2, workbook.getNumberOfNames());
+        assertEquals("Sheet1!$A$2:$A$7", workbook.getNameAt(0).getReference());
+        assertEquals("AllANumbers", workbook.getNameAt(0).getNameName());
+        assertEquals("All the numbers in A", workbook.getNameAt(0).getComment());
+        
+        assertEquals("Sheet1!$B$2:$B$7", workbook.getNameAt(1).getReference());
+        assertEquals("BStringsFun", workbook.getNameAt(1).getNameName());
+        assertEquals("All the strings in B", workbook.getNameAt(1).getComment());
     }
 }
diff --git a/src/testcases/org/apache/poi/hssf/data/WithVariousData.xlsx b/src/testcases/org/apache/poi/hssf/data/WithVariousData.xlsx
new file mode 100644
index 0000000000000000000000000000000000000000..5459734b23b1b57362ce5eeab3c57b7da1255f22
GIT binary patch
literal 10603
zcmeHNbyU=Aw;sABq@+QHQc6<kh8czuk?!t>LApypx{+?_5Cj>z1!<7(4gnDm?&vw+
z^&F1(uJ7-Azu#IjznL|&pP9AaXTST|d%sFxBxFJWDgYe-0MG&!LVL6#5C8yQQ~=;E
zU<N@;!p_#&#MW6)6>4wdq{HTJV@;Difxz?zfC&Hof3E*i9vFDmuh7nc_x}D7?(1?U
z2QB(QrBNy-iY$UPq{wEQQii%U7d@Yk475aVqKiSe+GNj0h6aZA6}m>fUdw157M96P
zbKI*ykE{WuKI@w&`FJE0!GWG5X^WG)3+Ty@-6=U*UIg4P=1r=4i2SwnaUV9OUzm&j
z=HRCbapa4g=btg&5kFYWfi1oQTOlUlg%AWly2|NWtx!g^&kyM^mzOTn(8L2S+>-F9
zBB*xSVgyXu-f4sJWgjn)oksA~_2(tLDg8{?5wEJx2gJOI#cQWU+l2%T1t=vU1kx#5
z4hKU~!IixdCpC;{mZL(e?z&cbrVOeYwNc5gQ?TJZoq9%rok{A6x9oeMEd>>H8?reY
zu;^&&i=F7v(id31pBzzGT#+$^&G|hhx*%BUXSy%(p{Jy$6NgSbug-O-YBn3bGd{V{
zTf-31d}}hxg;waj-uddd>^^!fYu|7ym~Uz^BZ<$nEx-dSLseJsRg00^7XN%k4b_ld
z14B;Vc0$C;_*bK23;^Kf1__|_x2UXr#&Q1?PBnRW&|v|F5cC{Ptex1|emv7;_x&dt
z|Ib8WWXwl+1Y&m`$iA0Yz1+5yMbFA>l9z3wRi$dB->0s9nL{u7^(+v{A7nH;a<=hN
zL~DM3-9nX`!jN5|y^%?*lFRVLq@{aVrW)=WLpn1H!fvux6b8@d=B@SIbK_DCCoc=D
zA|l8d<F4)-a#Jc2Vjb-|=Dp@n?lUkSiM>~7@;PozDEI@F606`i%n}{#1zNH2h2XcU
zdTxlFJNvqqVWL8$XvSTEe%Cb#Q>>zovxO<*{c-_BU(!bLdoSsXkTMu%v=vWo>i8Y#
zz+uC(i(dp6!kt8ScKp~f&5O>PhXj`k0+%4h=LWD&Tva{zvi+0m^BCWm5aAhU3<&@r
z1E3?gTeJT`cQ-pnD?>Xws~<V&PwFH8pg#P&|G%&Iu^%mek|v-zV8qKI#?~b6NpqxF
zxz<+zgYxol2XDd|qn${sM5AagTNX(G{gs!<aKZPbf`bkcRLk^d(LiSOn!FOtS*COT
zW?{hqnu)qk>D7h$qW%&NKJ`BB3Qkv&`KR>R;Xst&>4V(dPx|G|4pcU2V{9iWM)%0J
zT%Z#;eS(nsM_1#%hWX5|;{EMQd1({^qK0m)ni_4vo(^kfQ3>VhJ$58R#(0mzw})vS
zBx%xj_cDZa(3H2Y@&)%M>Q|As8-qD!c?^0sea8htlEfQJEhlvSp_)X&A#B0knAk5*
zW4^DXoKYxZu<si&ce~Amq|F%~Vf~IlPzKJEYB(!o;0(frQv=SRzj7xs7NWSqffs!6
zV9)1JQ#&!2jai9D?4|37qnNB`Iz-Uo;T8V$9p)SFZVa2JFh8)+3iQ%_y|%h>#!_m&
z6>0%dFe_jN>a#q^onAdTTDtg(0u;8t-%y3>cyT8~mq^5?)MH0iuha{O&LLa?LEn2M
z=Q-}Xemz#FU!kH^0Bs$!Ay{~_*v1DCD+$coq8rgBdqR+~FMzEzS>-QMx6PfzAx^<W
zRpGVJGcjuT42+_<A{kh}$2vLnRZTg&0oNx8o5s;2xM*+5yxqlST8^khBV{Ca3KzN&
z>YL)mBDm--@Z_R%h*V3`q-I%8`~cS{oOxOpeBU~A^c!NC*MbS>R!CnpVV2mZNFCFr
zW*-_pNRLH=PA-0i{APfUdtU_s7q%O<Q2LTo=PBxC_Y^A-bzgdbZYeeeGDdnZz6(C}
z%<gh8&%m9-vA4!xjX{;<zT&?$cPbmZs2gQ>=ZjNS>wYl6ydN_R;4})7m6)g@mAP=K
z5;g!|J=O!>y%<qObB9t>w9J+-dY4MNLwytRb-n!+quRt+-m-WC9PYh0nSM;JD^qoe
z8h!&`y?^cyTlv5Sf4Dw<O8!Hm{#;*Ya}ygA_Mgw3KlX=R4Mn?IUcwK!Q*JcQb~cQ4
z<Y+G8Q<bS@5b_S&5Gsr01ofxcqMziv$Y)l35!xFK5)qpAIIJHGBQ`l_GH8XAAzcui
z$%3j#`@x@3$tT7`B<XxSZx&YWyPVDhgl0+5(XTnomgv0o2<;H29_2TG;THTIOimSp
z*=;o7E<ZD$CVMb5ae1KAnaV<sFIFL(klL^p1OleUho2ab_V)|Yat=TmLM!~A<EwTd
zQX|ZTKAR{WHwCtFpD9J&r+M+>QI@cn1mx3fU+7oT_g$cEgv>BM21ptaszAmBxA>4r
zB8GFQ#w?PskvBIzZd?dy0w%+Z?)cUFzKL<nd3h4fT0<KHorSAUE?fRb&Vz@9FeWq2
zok^|du8tR|tz(bgPVTt8s7=d2&|g4<ls%M6IlY!Hiye9BySwse&$d>%tmz!_`zbJ4
zD_x;r1Y}YviPIxIk$6ZxZtC@75Jn!|$(L|=I^<eE>wJi6d^8C3yaAPHxE-MqJ|a_0
z9G=Pg?hO(Ok>{Uf4YC7x=A^WdFogySHgZQ`M2#1#M;v;wT>yqfgNa_gPGL0m_X=HR
zdnN5}I0&#K&`zq9XwfG7^gj9o1)@58$pMST$MPu8@VVLk_Vi@?TkJ~6$5+(X&R3fw
zNA1+CtY%AWuL73a5*NJBHYTZaL^8a;93PRaxodRXT(mQOxVnNq#(QK=I}*X3d3Cni
z8&NL&{d-e4@X*FjM(R9TS~6Q}6`k@B-I*)c0myjYp@pa&@2MHe9Y0r$tqe@c#j?ky
zCJlESUb;OOJz_%A&75;HrVKR9H^<l@H&_LH<u{{b1L4?9d|^>{=Z^?*TsKtfpw#zN
z?`n!L>aK0pKzzo91?oPVi{>}n=c0H(5uL=8yKx>DO|ZAGyglU-b>R;dR^FtNqLc?i
z9_8L=j3$n7wLtbxPTazN>uO!?M&iQ%VALaoqES{BeE<|lO|YJH^dy6sBK|eSawrjw
z_uY~T`5u_|xs<jd%b~L<sZ2BH>niI(8-xquG;bt{W)_!As#F;^6{aVwIncXKx{~{c
z7JMDbD#4V){0|L9qMxEGN1nZ72{>@zlQ<DLN9cYq=aop%Jy$^DFTiatsfiq#k&Lki
zW*SrY{?h!)tuslvu!|RUo@k}69!Kk`252{f307i%18ZvvFgp_VQ`eh!pC6xdbD4ax
zv$J2UEo@b*L#STZ+z74ks@#gniH95qKH^n!lC}knGJ>Zbc6pJG?F=BiUJc2o5A3dK
z5NHt9uSUgqE1b<j5y<aH)wFIw=O-_RMgY`qn;ybW{50XdIT|l?kM|@QHh~m2PDMSt
z<RX+tiR1Xlv>#*O8<$bdTa2{$>5KR{ro!(}1}rrTxtvPwjmQ@{HLS4&;3hr`fPGFG
z4x-uAY3+mXXIo9!^THw{Yv=Y*)82KuFVX4HO9(O)Mb*sr3m4yGG^sRXL!xm7dFFnE
z7O0oCmgV)fAk<g$7xlbt@z+^z<~vd$hGDU9y%&1@>LD8gW5kH^tQF4$8P&1Fr!xlo
z(x7f8gmUoQxdCzOTy%LL&gIkCY2$Bgsb%t<d>EGYPYw23ax0#q5zvm`Nyx&%;ffCi
zMDQ>^xY0x!@KDB_lJ&u1p5UV)z2;$Vef8F=*I3;1nX{{b<m^yOeqP*1Li_-G&p>Hw
zhC3V$dLb;ET=@jHjPg>$?Dp~bWj6Vrm(v(@ju877clk}_LPs4-o^tmaWAQ=L`t|2A
zm;G$>s>s)d%ERTpVX5SicHMA2JMl)GMA<RgL!h>GM3H`?H%mprvZ@pm6Mf-@@G_u?
z5|7oM5^EGs)jreu8q2ZpW;U&wTVAuhNRe_FfPs1W8WV-~QYk_HBwf5TVP7YK9*mJ3
z$`bnE?t`;X3Ig6So{FNcuDC&X+xaQECasGKU742|ro&9b5CzVKG_sh3W?r=Gt)XrP
zE~d2!gVAB*vyV~_r=RV4R140&hzQ>dlS+N|u?jJXsLo$4<*b~!?Qy-PR%HUWu9b0{
zA4wulFzh`oXz>%;mPo~o@)FmjgScIxgg2m;2v&~@!EQs%zKF3AjAn~=wMTv#OIZWU
zmD3o_FN>|ytkcl5FG&3&WMIuYt#Re0V6-uq+&|RY8NuypY0y34YMoaEt7d#k7|bv&
z*2UlDInLtkzMONpxJlWtoXH7<aKOxfep#m!NrJws^%R4j%0B!yW%*QkZ(qYd(S{dr
z_y0&)KO~8hxrvFh)1UhG=bN9|>!-RcjTr<XaS{f7^*_MdpEu6;59J<(JaAr;-bM;s
z9in$WmLRaYJk#A#q%3UMVtW^ocIlw79??uaeaFdxQ`Q`cgdOmzD@d%ZfBk5kO1+4M
zl&8y=;EuZfh>qT1rh{rc71550!74#GvX+$xUbcCJE)msTRF#XQ=3?i;09lY7T+B^y
zyV2d8`Pwe`PDqRErfTV@N@Ne-yy$LmBTH2N;DLQQfSHwZ6O9Qi7SxY#{r0h9tpjse
zuxmGlR6vBS+9M~Dk!IaVtwYZ4ar%v+C3~+i^QvHDg%GV5Fe7^<+@spv`cTU!JXlj>
z@4@<;SCNLtjE!!;bzcJr%z78D=<4AQ(to(`r{f;|Nc)jWFi-~vUNhFUL{byvxkh~6
z9^JzTDrEfA3>!w9Df+uH8qaU$YfMOB5%o~0o$h+G<@dGH^Nu9!Z)C($7>Hir^dm2v
z1H0Lh7kFXu2XVkC9#12G7bmDPCG-BMZx5ZoxoUeWg_=sft7w6W7=o86w^RXt`&2(6
zU9qjEqnd8wTA6d7dlIGEkqA|8t%ZZc9xQ8Pnm+qk+JRyK21ZITS28(LSZHH#2ue?W
zO3QZ+cli&docUAudos&KC0P`C$5E~VdG2A^5@mN1^tR4J^Qrlt*9kV+5th8CQjPk^
za@NIYplk-w`0N*2?VXa`cG8GkdEeBLk$csjgG8B_kA@pRv(<g#-SIlw@1)be;YhCk
zIP%|cWZZQL)i6Am>)|@|e_-U#P>y^Cv76<<ZpNMR!E>Inxwed{)7Z^+P^xL=C4|&B
zS&mjJ%^uSOH7<5!dS4ovQE||q(;poP#Sm<D4jwep2}FlSFyv>EC?P@^9OtbKFIK+o
ze<1>bsu|4U&1v${luj7Fof}k=96yT(q|iv@7;0M14SDIA0LSE^*+HnRLD4*;4e{i9
zwFK(6>Dzr#{`%{ak$g2qN&PoVcv3Jf^)PEKi5vj}45Cre4=m6U^QxZ5GxFk+;`pPp
z_8Gwlr?Elt*S!Yi9#+}Y{bVdX+^gycAXoHIi+<k2c*+j7r^gJE%|q%a3lLtSY{b&o
zqSgq!^58=R9i%w5gdW*y`7e~YO0<GFuhqU+jU@2|FE^=Q>=<dg)mcWxtSVL5<YjhT
zQ=R9JF$uXOmnNC^iiZoqKHUpSNRB|?AR(1Ay<>Mo=q0c0Dpzsn#+1-Jo8YCzUz6uG
z8(;mca1A*}8P)@mdhNFK-kKg9*d&{s#kx29Hr?ipD`&AO!5na;BlStS0?v}c9$~Mq
z!=pa_EmE`jwR`v5C|8Wl!8q~F2qEZ-om8O;GExO<&IBH2lNFK;If7u$z1g<d6;WGW
z7QUU;><_DW`>UpG-3TjdOe<@zj~?~_;Q$&^qb;n0LScTNPm{F63tsVDb)On`M{x(<
zLl#;Xm2xfCdG6}<j7l?_$WFJCd9E>)X}xVNZG$r&7dkm~$IqPWNekz@rI&O>grt^>
z231v7`b`trwFT~B?BZ6+)NVip+14Q(LC>}zyo&}{vVr^Ln|fA@dtG(wcKp$t)U=O>
z#03x?Y%z*}D=9Gq9~Y3xil6nf;%&TN=kI=XDPKczxHhvi#k`==YfO85H6I+~Y3OnZ
z^kREQcRmV?z9VPfGfgXfc$B`_^(DQ-V}9nQKqfMMYAr{K+T|+C8ihQ8QY~ih2+6tF
z!B{5$a+TiaxBD`oV6T)TJPPpOn+?1e`%!5dI~urI*qS-9yV_Vw{_&cV4gPxfnX=U^
z2c9?et_b=mExX*^7vQ>L*Eh~5Hssa;Ld2aahP72g>Lim}<qLAIF{aizN?p39vh+JG
z0&`#I(1sfO9$h?UpGmVLXY^Fw23^RRgrf?UI;e;OXZnsO%TejCFfev%nQJx^jTF8{
zQp^#}90TWK{SNa=YvTo`=&XYFIW{!!MK0m-6~~;)1u};{+Q7){A{dP&>o45{FTb4_
zC`?;$<?^uQOwUUr0=zt4SKbhW5LZw0Upq<jST;V^FJx5%KXlT4X+v%2QM#9?fIBz>
znQCn|b<<DlPR}cj7n?gt=d=V88m3CK<WNc%+h;mqlMpYav2mOve+hPdA*_f_F(qiS
z9INqUqf}8)AZwD3vlvFsy%?wst<V}v^iu_<zI3=-GRYM4?Mg6x()}?7-I!rUMo27L
zP6Z(e)=a{THHa_}$FDog0pvy(Hm<oc*ry&KpiGumLta^1SqH#^41Jt9*`z<Dx8PQL
z6Pov#j-m$3JOvFldSCbzH@b`_v%CIcwx+~*e0-<Sxb`>0S@V>=H`8KUnW`>}Cl182
z>zZQSsIOUY@0$1@=8j2f5@t0k9}*fRKiZ=rJ!Z1yRY2a8?zaYwg!bo`k@lS(q&L(V
zj8XSw?|#{SRqPXibdAhE6>O4zj$U?cTk(Ek;v&O|{~FYF)p->E0AzmAHI>Q<USDY#
z=!$e*+M7#i9?Va756|^@F1Z<OtUE8e<AS`a=#h|qj)>czM8<pBZuJPVmSE9CdPYmA
zhkJtf<S^>(b(u1W53KMY(_-x8gYr$Ya)3mXbhG<wWfGVlJI{8Ua6muxZ>cKFR<BJ8
zmk&Q$=!Abz)ydqz(Zu+vv*QoG{>XaPF^XU$PQ1<o{{@2{jZ`%yN!R)*aj`@7BZ|6F
z2JYTcfl;4@d1bBmxghQJW<ArGM8Z*{@QUsPq_t1-(nd&0R+>TYnFnVb9WKp%JJ;eP
z;wrfrjk(I+mSdVC%%#5L*3E@hC0IrE9)*$(Y?l^66l$#b5>koh!iBPP%@4X(&{DN~
zP%URnM&5lzb$#r)Yk&Pf6(yuNdK;>uUW9r1>^oC+MitGr*xNl22*!a?E#^T=rN7a9
zm(@#ucumxfY6XM41!s(O1&6}ly)4LYg2tT?{hq&b)Fs(5ao{3_orJ+ESplt&%uJqM
zYm?CS`xKS7&pWPXYoa9nO|0`rpW1h<4A?)2_(14yyh=V~T_FEXLmbJmkE+7G*oOiD
z;QZ-HXQ;KwPZyS|&RTxv!1H21p$?oUFHhvPj@TO}P9UDa>mj~inXO{Yj(EM=Ia_`Z
zxvJ$6ass^fa$_KkD{;_P8rYkx#TYqc;Zd6txYIW#UjO*J<C7MCrDefUo>=KGX}S$L
ze4Ss+lE0Aj9taEx`4P^n)qH93iKTzL-C(%iccR^%*rnbnC}@+~Fz=`)fXtk{>(;a*
z$(d#Gnn(JD3=5Ze=4fJUPS0mPM^gg#JZ|QyK3Su%kP}gQckZWx((lbw;?(rj+vB1W
zH|KNibEGWC4R>X8!D1@yU*nLThG+^%UTIazKsVCRI%F=yCp}kP6mUhD_$!B)h!F)$
zDNlGnH(}QAXfHDf&_3O1q|Mdts_5qQ&FS%27plKN$9*(i0LGOVuDJVJFZ2@ZY&8v>
z`!EBDQL5+x8Cgxipa?336gpB2&=s)?BAbw#=B*_=i}!q(k(w0~<_s`-(+*?bv~Vyq
z>cvH^hGR}~C9Q{&%$i6Wh5m{Ik?Gw)dD8(B>gXG{H-v{DQ1K_e9y<yY#>^V=2Pm<+
zS0?W4=nQ{oSpbb#b{>)X>H<D%tU%Y=llMiDc3)t_c22X~xct`joi2fKvQLE;tAbDz
zx=?3oY(Ul{u}u<P>&!Oc=9@-%jU&QMbu;bb$oQf!xRzy*bh!xxXVScVZE96E(Vi#=
z4Xn}Rl8}XUKS)V5Y5Tm~v5M`>X$`1M2NNwSN9}|Mm1o2sUWWG9a|BTE*iF%VxA>Mc
zI(|K1#aTEB9!uvZr&d{Yt`%7V=1wk!Pf#x{3;Z^ar=;a%xZr`z3-9jY{Xst?I~yDL
zjN0j^;#yUK{0L%r4G_YSVN>U?nJ`HFkPsOk_Y|#Tw+6#D1{j;LUG7%bq$OECA4ogU
z-T!`RP_;kDt`p(zJ5s^{GZb`e241#Z!uPfllUR6hF6PeUNG#`~{w7{f<>XDFV0nLX
zWEFj<eGqf6`bmmuWqWJ9jl8beolymqL?u3B{A#;3i1KH-avk5sPnXt4*}X-X=};2f
zOJi$bh^EkEY_jA`iZv%10$ZX|TQThOZfP-CIv3TwxGCLpXsnA==JFdY6s*P84qk>O
z@c@}s>Ii72{0`|cV8)!hS(vs=A<*aoIkq6-+iZmiFj@Z0`u>t$?5Sbmm_>W4J`cty
zf?s`Q<tyY=;vD`Bxz#tm6kkM8nr;gG%Yt`^o;wMzSy+9jNl_(Nun8}`hDY%~+pDS%
z0-Yt{4mN>*iVq*a7~2^sIojDfu^ZVrn*7)%X|n$_cYzZR5E=7hTuvzYRrX3^)oVF-
zNx76h9&<aKjy_y;_u*w-Etx>VUd-8n0~JnDpMTy#WR%(4w81-7*ex)1<su58awMWs
z>9V+u<4KEV;8Q|%8KMG{JQ^993Uf7WJrnu6YWLiE;!#(Sr&?p<fbtvWJ82B0T6HLL
zHmj6<5j%ad+gBsj75UaOe7=kho*_W~zM`B4gkTSvY^vUA-?0}@>i|O>aWrC&BVw6g
zA9T^AXGGX*`g)jy1S}Vdq6AExCc*+P^*i-Tcb*iF@&<p*T>QB9MN5l^uy~pXN!2(F
z-_*CUkC5Ge&;Q$eg-x)`ifItA)^@ADnYeYMn`<L)JJ}}a4z}Q7mhAJTT+iGn#S#=2
z&$kw&1qLal3>fdAG_fZo(5qeVyH(^p!fhYI>c7&zlIghnrsuG;o5}mPv5keAey<r$
zz3rc|{TJ#P*xUbyc|SP!$CdUJX8T7~DMH%9=U8P+il`x#V7qCs<NtVXs93&R+@v>}
z^#1f@R9#BPmOnzO0wML$`MKm#s*X|29nayR^)2U^JPh?UkPRR7qT<@|loNso(gLkK
zT-~A)_qadbvh?6U^RSSXUeZ7!V<L1ft@4efxp5MnHAYdI9sQ?qyQC79vc-ua8zkcC
zhyB7FQ?yeAeI;kINzz@=kQ=b(lkpv_s2wk`KZ;&W*$9XZ!rWr9rejaUkm-hrZDtf5
z+lV+eVf8s8vic~V1VpAzP+6FZ(K^ixI}km~FUvg>JG`?&$>c1IaX~Wen$Dp3NR*vX
zQDCdKMz-pr%Ke_<DC)^_!IzI&sI9H{h&opBURiZlwh$i#BVt}_lD^wFK{7d(n8CRM
zM@+8~H+S(rI2Cp?C>s$y*DcHK#>#(Bo%%>NB0(}<$`0nd`OOeE5{VG*$R<7#IXT>x
z)cL&*nr-r-2XtP5C?vFe&zpClBrM^rMc&-#V)tfA-N&UYohGd?`>EJ3^z4>fS-Im+
z77LI+<PaU@GipqH$BGY05%Kdbp<bCJ8l9%k;d=OmwtIRjHhclTc7N=)2#Bn34f^{d
zSN~e#f8Bp`080t{cYwd24*8eik9z_<j{b61<hJ48N9}(#{4rkpp9k-^ac&P>e<5|i
zPnF#ozuq>!J<a=NoQwI}+1_n{+r8Ca0MGIN``7=sPU~&J+fA}xfC&V*0e|%#|9zAN
z_|WoCr~LW1e%^jI-fpAZ?lb-RFHA(gMfs_LZlm0;(|@6`!JAkAOVxfG=ynzL3uv0`
zC(u7?s@n*+tA}3*_bL8B`0rZcw&`u<_scY!>Zj@7bl`34zss6mwg3PU4FK>Dk#pPp
j@2Tmp=H7IFG5<4BDS=Vo5%lBu0WM$_9)u3SAMgGPi9<?A

literal 0
HcmV?d00001

-- 
2.39.5