正在查看： 远离手机 v4.9.11 应用的 I1111111IllI.java JAVA 源代码文件
本页面展示 JAVA 反编译生成的源代码文件，支持语法高亮显示。 仅供安全研究与技术分析使用，严禁用于任何非法用途。请遵守相关法律法规。
页面标题
页面副标题
远离手机 v4.9.11 - I1111111IllI.java 源代码
package com.lijianqiang12.silent;
import com.lijianqiang12.silent.IIlI1lll1II;
import com.lijianqiang12.silent.IllI1I1IlIl;
import com.lijianqiang12.silent.ll11Ill1llII1;
import com.yalantis.ucrop.view.CropImageView;
import java.io.File;
import java.io.IOException;
import java.net.MalformedURLException;
import java.net.URL;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.Locale;
import java.util.TimeZone;
public class I1111111IllI {
private String IIllIl1llII;
private IIlIIIIl1I1I IlllIll1I1I;
public I1111111IllI(String str) {
this.IIllIl1llII = str;
}
private void Il11lI1III1(l1lI1IlIllI l1li1ililli) throws I1II111111II {
IIIll1lllI1I iIIll1lllI1I = new IIIll1lllI1I(IIlIIIIl1I1I.IIllIl1llII);
iIIll1lllI1I.IIlIIlI1I1I(true);
l1li1ililli.lI1111IllIl1(0, 20);
l1li1ililli.lI1111IllIl1(2, 20);
l1li1ililli.lI1111IllIl1(3, 20);
l1li1ililli.lI1111IllIl1(4, 20);
l1li1ililli.IIIII11lIlIl().IIlIlIlI111ll(2);
l1li1ililli.IIIII11lIlIl().Il1I1l111l1l(2);
Calendar calendar = Calendar.getInstance(TimeZone.getTimeZone("GMT"));
calendar.set(1975, 4, 31, 15, 21, 45);
calendar.set(14, 660);
Date time = calendar.getTime();
calendar.set(1900, 0, 1, 0, 0, 0);
calendar.set(14, 0);
Date time2 = calendar.getTime();
calendar.set(1970, 0, 1, 0, 0, 0);
Date time3 = calendar.getTime();
calendar.set(1918, 10, 11, 11, 0, 0);
Date time4 = calendar.getTime();
calendar.set(1900, 0, 2, 0, 0, 0);
Date time5 = calendar.getTime();
calendar.set(1901, 0, 1, 0, 0, 0);
Date time6 = calendar.getTime();
calendar.set(1900, 4, 31, 0, 0, 0);
Date time7 = calendar.getTime();
calendar.set(1900, 1, 1, 0, 0, 0);
Date time8 = calendar.getTime();
calendar.set(1900, 0, 31, 0, 0, 0);
Date time9 = calendar.getTime();
calendar.set(1900, 2, 1, 0, 0, 0);
Date time10 = calendar.getTime();
calendar.set(1900, 1, 27, 0, 0, 0);
Date time11 = calendar.getTime();
calendar.set(1900, 1, 28, 0, 0, 0);
Date time12 = calendar.getTime();
calendar.set(1980, 5, 31, 12, 0, 0);
Date time13 = calendar.getTime();
calendar.set(1066, 9, 14, 0, 0, 0);
Date time14 = calendar.getTime();
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("dd MMM yyyy HH:mm:ss.SSS");
simpleDateFormat.setTimeZone(TimeZone.getTimeZone("GMT"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 0, "All dates are " + simpleDateFormat.format(time), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 1, "Built in formats", iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 1, "Custom formats"));
IIIll1lllI1I iIIll1lllI1I2 = new IIIll1lllI1I(l1l1lIl1II1II.IIllIl1llII);
ll11Ill1llII1.IIllIl1llII iIllIl1llII = l11lIlIlIl.IIllll1Il1lIl;
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 2, time, iIIll1lllI1I2, iIllIl1llII));
I111llIl i111llIl = l1l1lIl1II1II.Il11lI1III1;
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 3, time, new IIIll1lllI1I(i111llIl), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 4, time, new IIIll1lllI1I(l1l1lIl1II1II.lIIl1I1I)));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 5, time, new IIIll1lllI1I(l1l1lIl1II1II.Il1IlII1)));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 6, time, new IIIll1lllI1I(l1l1lIl1II1II.lI11111lI1)));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 7, time, new IIIll1lllI1I(l1l1lIl1II1II.lII1lI1Illl)));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 8, time, new IIIll1lllI1I(l1l1lIl1II1II.lI111l1I1llIl), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 9, time, new IIIll1lllI1I(l1l1lIl1II1II.Ill1llIIlIlll), iIllIl1llII));
I111llIl i111llIl2 = l1l1lIl1II1II.IIll11IllI1l;
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 10, time, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 11, time, new IIIll1lllI1I(l1l1lIl1II1II.I1Il11llllIl), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 12, time, new IIIll1lllI1I(l1l1lIl1II1II.ll11llIII1111), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 13, time, new IIIll1lllI1I(l1l1lIl1II1II.IllIlI1l1I), iIllIl1llII));
IIIll1lllI1I iIIll1lllI1I3 = new IIIll1lllI1I(new III11II1lI("dd MM yyyy"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 2, "dd MM yyyy"));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 2, time, iIIll1lllI1I3, iIllIl1llII));
IIIll1lllI1I iIIll1lllI1I4 = new IIIll1lllI1I(new III11II1lI("dd MMM yyyy"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 3, "dd MMM yyyy"));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 3, time, iIIll1lllI1I4, iIllIl1llII));
IIIll1lllI1I iIIll1lllI1I5 = new IIIll1lllI1I(new III11II1lI("hh:mm"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 4, "hh:mm"));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 4, time, iIIll1lllI1I5, iIllIl1llII));
IIIll1lllI1I iIIll1lllI1I6 = new IIIll1lllI1I(new III11II1lI("hh:mm:ss"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 5, "hh:mm:ss"));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 5, time, iIIll1lllI1I6, iIllIl1llII));
IIIll1lllI1I iIIll1lllI1I7 = new IIIll1lllI1I(new III11II1lI("H:mm:ss a"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 5, "H:mm:ss a"));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 5, time, iIIll1lllI1I7, iIllIl1llII));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(4, 5, time13, iIIll1lllI1I7, iIllIl1llII));
IIIll1lllI1I iIIll1lllI1I8 = new IIIll1lllI1I(new III11II1lI("mm:ss.SSS"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 6, "mm:ss.SSS"));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 6, time, iIIll1lllI1I8, iIllIl1llII));
IIIll1lllI1I iIIll1lllI1I9 = new IIIll1lllI1I(new III11II1lI("hh:mm:ss a"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 7, "hh:mm:ss a"));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(4, 7, time13, iIIll1lllI1I9, iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 16, "Zero date " + simpleDateFormat.format(time2), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 17, time2, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 16, "Zero date + 1 " + simpleDateFormat.format(time5), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 17, time5, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 19, simpleDateFormat.format(time6), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 20, time6, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 22, simpleDateFormat.format(time7), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 23, time7, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 25, simpleDateFormat.format(time8), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 26, time8, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 28, simpleDateFormat.format(time9), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 29, time9, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 28, simpleDateFormat.format(time9), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 29, time9, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 31, simpleDateFormat.format(time10), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 32, time10, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 34, simpleDateFormat.format(time11), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 35, time11, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 37, simpleDateFormat.format(time12), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(3, 38, time12, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 19, "Zero UTC date " + simpleDateFormat.format(time3), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 20, time3, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 22, "Armistice date " + simpleDateFormat.format(time4), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 23, time4, new IIIll1lllI1I(i111llIl2), iIllIl1llII));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 25, "Battle of Hastings " + simpleDateFormat.format(time14), iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new l11lIlIlIl(0, 26, time14, new IIIll1lllI1I(i111llIl), iIllIl1llII));
}
private void Il1IlII1(l1lI1IlIllI l1li1ililli) throws I1II111111II {
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 0, "Weald & Downland Open Air Museum, Sussex"));
l1li1ililli.l1I11II1llI1I(new IlI1llllI11l(0.0d, 3.0d, 5.0d, 7.0d, new File("resources/wealdanddownland.png")));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 12, "Merchant Adventurers Hall, York"));
l1li1ililli.l1I11II1llI1I(new IlI1llllI11l(5.0d, 12.0d, 4.0d, 10.0d, new File("resources/merchantadventurers.png")));
}
private void IlllIll1I1I(l1lI1IlIllI l1li1ililli) throws I1II111111II {
l1li1ililli.IIIII11lIlIl().IlIIlIlll11I1(true);
l1li1ililli.lI1111IllIl1(1, 15);
l1li1ililli.lI1111IllIl1(2, 15);
l1li1ililli.lI1111IllIl1(4, 15);
IIIll1lllI1I iIIll1lllI1I = new IIIll1lllI1I();
lI11lI1I1I1 li11li1i1i1 = lI11lI1I1I1.lI11111lI1;
Il1111I1III il1111I1III = Il1111I1III.Ill1llIIlIlll;
iIIll1lllI1I.III11l1IlI(li11li1i1i1, il1111I1III);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(1, 0, "Thick left", iIIll1lllI1I));
IIIll1lllI1I iIIll1lllI1I2 = new IIIll1lllI1I();
iIIll1lllI1I2.III11l1IlI(lI11lI1I1I1.lII1lI1Illl, Il1111I1III.lII1lI1Illl);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 0, "Dashed right", iIIll1lllI1I2));
IIIll1lllI1I iIIll1lllI1I3 = new IIIll1lllI1I();
lI11lI1I1I1 li11li1i1i12 = lI11lI1I1I1.lIIl1I1I;
iIIll1lllI1I3.III11l1IlI(li11li1i1i12, Il1111I1III.IIll11IllI1l);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(1, 2, "Double top", iIIll1lllI1I3));
IIIll1lllI1I iIIll1lllI1I4 = new IIIll1lllI1I();
lI11lI1I1I1 li11li1i1i13 = lI11lI1I1I1.Il1IlII1;
iIIll1lllI1I4.III11l1IlI(li11li1i1i13, Il1111I1III.I1Il11llllIl);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 2, "Hair bottom", iIIll1lllI1I4));
IIIll1lllI1I iIIll1lllI1I5 = new IIIll1lllI1I();
lI11lI1I1I1 li11li1i1i14 = lI11lI1I1I1.Il11lI1III1;
Il1111I1III il1111I1III2 = Il1111I1III.Il1IlII1;
iIIll1lllI1I5.III11l1IlI(li11li1i1i14, il1111I1III2);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 2, "All thin", iIIll1lllI1I5));
IIIll1lllI1I iIIll1lllI1I6 = new IIIll1lllI1I();
iIIll1lllI1I6.III11l1IlI(li11li1i1i12, il1111I1III);
iIIll1lllI1I6.III11l1IlI(li11li1i1i1, il1111I1III);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(6, 2, "Two borders", iIIll1lllI1I6));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(20, 20, "Dislocated cell - after a page break"));
l1li1ililli.IIIII11lIlIl().Ill1I1IlI1III(Il11l1IIlll1I.ll11llIII1111);
l1li1ililli.IIIII11lIlIl().llIIlIIllI111(IIIIIII1I1l1.IlllIll1I1I);
l1li1ililli.IIIII11lIlIl().I11I1l1I1l11l(lIIIl1lllII1.IIllIl1llII);
l1li1ililli.IIIII11lIlIl().IlIl1llIlIl1(2.0d);
l1li1ililli.IIIII11lIlIl().l1IlI1IIII1I(2.0d);
l1li1ililli.IIIII11lIlIl().Ill1I1lIIll(3.0d);
l1li1ililli.IIIII11lIlIl().Ill11IIlII1(3.0d);
I1IlIIl1IlI1 i1IlIIl1IlI1 = new I1IlIIl1IlI1();
i1IlIIl1IlI1.lI111l1I1llIl().IIllIl1llII("Page Header");
l1li1ililli.IIIII11lIlIl().IlI11I1l11II1(i1IlIIl1IlI1);
I1IlIIl1IlI1 i1IlIIl1IlI12 = new I1IlIIl1IlI1();
i1IlIIl1IlI12.IIll11IllI1l().IIllIl1llII("page ");
i1IlIIl1IlI12.IIll11IllI1l().Il1IlII1();
l1li1ililli.IIIII11lIlIl().IlII1l1l1IIlI(i1IlIIl1IlI12);
l1li1ililli.l1I111lllI1l1(18);
l1li1ililli.IlIl1llIlIl1(17);
l1li1ililli.IlIl1llIlIl1(17);
l1li1ililli.l1IlI1IIII1I(17);
l1li1ililli.l1I111lllI1l1(30);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(10, 1, "Hidden column"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 8, "Hidden row"));
l1li1ililli.lI11lI1llIl11(8, true);
IIIll1lllI1I iIIll1lllI1I7 = new IIIll1lllI1I();
iIIll1lllI1I7.IIIl1l1lIlI11(li11li1i1i14, il1111I1III, l1llIII11I11l.I1Il11llllIl);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(1, 5, "All thick red", iIIll1lllI1I7));
IIIll1lllI1I iIIll1lllI1I8 = new IIIll1lllI1I();
l1llIII11I11l l1lliii11i11l = l1llIII11I11l.IllIlI1l1I;
iIIll1lllI1I8.IIIl1l1lIlI11(li11li1i1i12, il1111I1III2, l1lliii11i11l);
iIIll1lllI1I8.IIIl1l1lIlI11(li11li1i1i13, il1111I1III2, l1lliii11i11l);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 5, "Top and bottom blue", iIIll1lllI1I8));
}
private void lI11111lI1(l1lI1IlIllI l1li1ililli) throws I1II111111II {
l1li1ililli.lI1111IllIl1(0, 60);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 0, "Arial Fonts"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(1, 0, "10pt"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 0, "Normal"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 0, "12pt"));
IllI1I1IlIl.IlllIll1I1I illlIll1I1I = IllI1I1IlIl.llIIlllll111;
IIIll1lllI1I iIIll1lllI1I = new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 12));
iIIll1lllI1I.IIlIIlI1I1I(true);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 0, "Normal", iIIll1lllI1I));
IllI1I1IlIl.IIllIl1llII iIllIl1llII = IllI1I1IlIl.lIl11II1lII;
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 2, "BOLD", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 2, "BOLD", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 12, iIllIl1llII))));
IllI1I1IlIl.IIllIl1llII iIllIl1llII2 = IllI1I1IlIl.lllIlIl11ll;
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 4, "Italic", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII2, true))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 4, "Italic", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 12, iIllIl1llII2, true))));
IllI1I1IlIl.IlllIll1I1I illlIll1I1I2 = IllI1I1IlIl.llI1l1l1Il1I;
IIIll1lllI1I iIIll1lllI1I2 = new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I2, 10));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 7, "Times Fonts", iIIll1lllI1I2));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(1, 7, "10pt", iIIll1lllI1I2));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 7, "Normal", iIIll1lllI1I2));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 7, "12pt", iIIll1lllI1I2));
IllI1I1IlIl illI1I1IlIl = new IllI1I1IlIl(illlIll1I1I2, 12);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 7, "Normal", new IIIll1lllI1I(illI1I1IlIl)));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 9, "BOLD", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I2, 10, iIllIl1llII))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 9, "BOLD", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I2, 12, iIllIl1llII))));
l1li1ililli.lI1111IllIl1(6, 22);
l1li1ililli.lI1111IllIl1(7, 22);
l1li1ililli.lI1111IllIl1(8, 22);
l1li1ililli.lI1111IllIl1(9, 22);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 11, "Underlining"));
ll1Il1l111l ll1il1l111l = ll1Il1l111l.Il1IlII1;
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(6, 11, "Underline", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII2, false, ll1il1l111l))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(7, 11, "Double Underline", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII2, false, ll1Il1l111l.lI11111lI1))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(8, 11, "Single Accounting Underline", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII2, false, ll1Il1l111l.lII1lI1Illl))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(9, 11, "Double Accounting Underline", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII2, false, ll1Il1l111l.lI111l1I1llIl))));
IIIll1lllI1I iIIll1lllI1I3 = new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I2, 14, iIllIl1llII, false, ll1il1l111l));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(6, 12, "Times 14 Bold Underline", iIIll1lllI1I3));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(6, 13, "Arial 18 Bold Italic Underline", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 18, iIllIl1llII, true, ll1il1l111l))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 15, "Script styles"));
ll1Il1l111l ll1il1l111l2 = ll1Il1l111l.lIIl1I1I;
l1llIII11I11l l1lliii11i11l = l1llIII11I11l.lI11111lI1;
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(1, 15, "superscript", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII2, false, ll1il1l111l2, l1lliii11i11l, I1IIlI111I1.Il1IlII1))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 15, "subscript", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII2, false, ll1il1l111l2, l1lliii11i11l, I1IIlI111I1.lI11111lI1))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 17, "Colours"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 17, "Red", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII2, false, ll1il1l111l2, l1llIII11I11l.I1Il11llllIl))));
l1llIII11I11l l1lliii11i11l2 = l1llIII11I11l.IllIlI1l1I;
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 18, "Blue", new IIIll1lllI1I(new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII2, false, ll1il1l111l2, l1lliii11i11l2))));
IllI1I1IlIl illI1I1IlIl2 = new IllI1I1IlIl(illlIll1I1I);
illI1I1IlIl2.l1llI1111I1lI(l1llIII11I11l.lIlI1IIllI1);
IIIll1lllI1I iIIll1lllI1I4 = new IIIll1lllI1I(illI1I1IlIl2);
iIIll1lllI1I4.IIlIIlI1I1I(true);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 18, "Modified palette - was lime, now red", iIIll1lllI1I4));
IIIll1lllI1I iIIll1lllI1I5 = new IIIll1lllI1I();
iIIll1lllI1I5.IIlIIlI1I1I(true);
iIIll1lllI1I5.I1Il1II11Ill(l1llIII11I11l.I111I1IlIl1ll);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 19, "Grey background", iIIll1lllI1I5));
IllI1I1IlIl illI1I1IlIl3 = new IllI1I1IlIl(illlIll1I1I, 10, iIllIl1llII2, false, ll1il1l111l2, l1llIII11I11l.l1llllI11l111);
IIIll1lllI1I iIIll1lllI1I6 = new IIIll1lllI1I(illI1I1IlIl3);
iIIll1lllI1I6.IIlIIlI1I1I(true);
iIIll1lllI1I6.I1Il1II11Ill(l1lliii11i11l2);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 20, "Blue background, yellow foreground", iIIll1lllI1I6));
IIIll1lllI1I iIIll1lllI1I7 = new IIIll1lllI1I(illI1I1IlIl3);
iIIll1lllI1I7.IIlIIlI1I1I(true);
iIIll1lllI1I7.I1Il1II11Ill(l1llIII11I11l.IIll11IllI1l);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 20, "Black background, yellow foreground", iIIll1lllI1I7));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 22, "Null label"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 22, (String) null));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 24, "A very long label, more than 255 characters\nRejoice O shores\nSing O bells\nBut I with mournful tread\nWalk the deck my captain lies\nFallen cold and dead\nSummer surprised, coming over the Starnbergersee\nWith a shower of rain. We stopped in the Colonnade\nA very long label, more than 255 characters\nRejoice O shores\nSing O bells\nBut I with mournful tread\nWalk the deck my captain lies\nFallen cold and dead\nSummer surprised, coming over the Starnbergersee\nWith a shower of rain. We stopped in the Colonnade\nA very long label, more than 255 characters\nRejoice O shores\nSing O bells\nBut I with mournful tread\nWalk the deck my captain lies\nFallen cold and dead\nSummer surprised, coming over the Starnbergersee\nWith a shower of rain. We stopped in the Colonnade\nA very long label, more than 255 characters\nRejoice O shores\nSing O bells\nBut I with mournful tread\nWalk the deck my captain lies\nFallen cold and dead\nSummer surprised, coming over the Starnbergersee\nWith a shower of rain. We stopped in the Colonnade\nAnd sat and drank coffee an talked for an hour\n", iIIll1lllI1I));
IIIll1lllI1I iIIll1lllI1I8 = new IIIll1lllI1I();
iIIll1lllI1I8.IlI1I11llII(I1lI1lll1lIIl.Il1IlII1);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 26, "Vertical orientation", iIIll1lllI1I8));
IIIll1lllI1I iIIll1lllI1I9 = new IIIll1lllI1I();
iIIll1lllI1I9.IlI1I11llII(I1lI1lll1lIIl.lI11111lI1);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(1, 26, "Plus 90", iIIll1lllI1I9));
IIIll1lllI1I iIIll1lllI1I10 = new IIIll1lllI1I();
iIIll1lllI1I10.IlI1I11llII(I1lI1lll1lIIl.lII1lI1Illl);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(2, 26, "Minus 90", iIIll1lllI1I10));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 28, "Modified row height"));
l1li1ililli.Ill1l11ll11l(28, 480);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 29, "Collapsed row"));
l1li1ililli.lI11lI1llIl11(29, true);
try {
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 30, "Hyperlink to home page"));
URL url = new URL("http://www.andykhan.com/jexcelapi");
l1li1ililli.lI1l11l11ll(new IIl1111lI1III(0, 30, 8, 31, url));
l1li1ililli.lI1l11l11ll(new IIl1111lI1III(7, 30, 9, 31, url));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 2, "File hyperlink to documentation"));
l1li1ililli.lI1l11l11ll(new IIl1111lI1III(0, 32, 8, 32, new File("../jexcelapi/docs/index.html"), "JExcelApi Documentation"));
l1li1ililli.lI1l11l11ll(new IIl1111lI1III(0, 34, 8, 34, "Link to another cell", l1li1ililli, 0, 180, 1, 181));
l1li1ililli.lI1l11l11ll(new IIl1111lI1III(0, 36, 8, 36, new File("\\\\localhost\\file.txt")));
l1li1ililli.lI1l11l11ll(new IIl1111lI1III(0, 38, 0, 38, new URL("http://www.amazon.co.uk/exec/obidos/ASIN/0571058086/qid=1099836249/sr=1-3/ref=sr_1_11_3/202-6017285-1620664")));
} catch (MalformedURLException e) {
System.err.println(e.toString());
}
l1l11IIIl1 lili1iiil111 = new lIlI1IIIl111(5, 35, "Merged cells", iIIll1lllI1I3);
l1li1ililli.l1Illll1lI(5, 35, 8, 37);
l1li1ililli.I1Il11llllIl(lili1iiil111);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(5, 38, "More merged cells"));
lllllIllI1l l1Illll1lI = l1li1ililli.l1Illll1lI(5, 38, 8, 41);
l1li1ililli.IlIl1llIlIl1(40);
l1li1ililli.l1IlI1IIII1I(39);
l1li1ililli.ll11lIII1lll(l1Illll1lI);
IIIll1lllI1I iIIll1lllI1I11 = new IIIll1lllI1I();
iIIll1lllI1I11.llIl11III1lI1(lIlIll1IlIII.lI11111lI1);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(5, 42, "Centred across merged cells", iIIll1lllI1I11));
l1li1ililli.l1Illll1lI(5, 42, 10, 42);
IIIll1lllI1I iIIll1lllI1I12 = new IIIll1lllI1I();
iIIll1lllI1I12.III11l1IlI(lI11lI1I1I1.Il11lI1III1, Il1111I1III.Il1IlII1);
iIIll1lllI1I12.I1Il1II11Ill(l1llIII11I11l.I11I1l1I1l11l);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 44, "Merged with border", iIIll1lllI1I12));
l1li1ililli.l1Illll1lI(3, 44, 4, 46);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 49, "Courier fonts", new IIIll1lllI1I(new IllI1I1IlIl(IllI1I1IlIl.IIllll1Il1lIl, 10))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 50, "Tahoma fonts", new IIIll1lllI1I(new IllI1I1IlIl(IllI1I1IlIl.lI1l11l11ll, 12))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 51, "Bespoke Windgdings 2", new IIIll1lllI1I(new IllI1I1IlIl(IllI1I1IlIl.llllII1llIlI("Wingdings 2"), 10))));
IIIll1lllI1I iIIll1lllI1I13 = new IIIll1lllI1I(illI1I1IlIl);
iIIll1lllI1I13.I1IIl1IlIlI(true);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 53, "Shrunk to fit", iIIll1lllI1I13));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 55, "Some long wrapped text in a merged cell", iIIll1lllI1I));
l1li1ililli.l1Illll1lI(3, 55, 4, 55);
l1l11IIIl1 lili1iiil1112 = new lIlI1IIIl111(0, 57, "A cell with a comment");
Il1I1IIII1l il1I1IIII1l = new Il1I1IIII1l();
il1I1IIII1l.III11IIll1lI1("the cell comment");
lili1iiil1112.l11l1l11I1(il1I1IIII1l);
l1li1ililli.I1Il11llllIl(lili1iiil1112);
l1l11IIIl1 lili1iiil1113 = new lIlI1IIIl111(0, 59, "A cell with a long comment");
Il1I1IIII1l il1I1IIII1l2 = new Il1I1IIII1l();
il1I1IIII1l2.IIl1I11I1lI1l("a very long cell comment indeed that won't fit inside a standard comment box, so a larger comment box is used instead", 5.0d, 6.0d);
lili1iiil1113.l11l1l11I1(il1I1IIII1l2);
l1li1ililli.I1Il11llllIl(lili1iiil1113);
IIIll1lllI1I iIIll1lllI1I14 = new IIIll1lllI1I(illI1I1IlIl);
iIIll1lllI1I14.I1lll111IlllI(4);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 61, "Some indented text", iIIll1lllI1I14));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 63, "Data validation: list"));
l1l11IIIl1 llill1iil1ill = new llIll1IIl1Ill(1, 63);
Il1I1IIII1l il1I1IIII1l3 = new Il1I1IIII1l();
ArrayList arrayList = new ArrayList();
arrayList.add("bagpuss");
arrayList.add("clangers");
arrayList.add("ivor the engine");
arrayList.add("noggin the nog");
il1I1IIII1l3.Il11lI1l(arrayList);
llill1iil1ill.l11l1l11I1(il1I1IIII1l3);
l1li1ililli.I1Il11llllIl(llill1iil1ill);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 64, "Data validation: number > 4.5"));
l1l11IIIl1 llill1iil1ill2 = new llIll1IIl1Ill(1, 64);
Il1I1IIII1l il1I1IIII1l4 = new Il1I1IIII1l();
il1I1IIII1l4.IIllll1Il1lIl(4.5d, Il1I1IIII1l.llll1IlllIl1);
llill1iil1ill2.l11l1l11I1(il1I1IIII1l4);
l1li1ililli.I1Il11llllIl(llill1iil1ill2);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 65, "Data validation: named range"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 65, "tiger"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(5, 65, "sword"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(6, 65, "honour"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(7, 65, "company"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(8, 65, "victory"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(9, 65, "fortress"));
l1l11IIIl1 llill1iil1ill3 = new llIll1IIl1Ill(1, 65);
Il1I1IIII1l il1I1IIII1l5 = new Il1I1IIII1l();
il1I1IIII1l5.llIIlllll111("validation_range");
llill1iil1ill3.l11l1l11I1(il1I1IIII1l5);
l1li1ililli.I1Il11llllIl(llill1iil1ill3);
l1li1ililli.l1llllI11l111(39, 45, false);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 66, "Block of cells B67-F71 with data validation"));
ArrayList arrayList2 = new ArrayList();
arrayList2.add("Achilles");
arrayList2.add("Agamemnon");
arrayList2.add("Hector");
arrayList2.add("Odysseus");
arrayList2.add("Patroclus");
arrayList2.add("Nestor");
l1l11IIIl1 llill1iil1ill4 = new llIll1IIl1Ill(1, 66);
Il1I1IIII1l il1I1IIII1l6 = new Il1I1IIII1l();
il1I1IIII1l6.Il11lI1l(arrayList2);
llill1iil1ill4.l11l1l11I1(il1I1IIII1l6);
l1li1ililli.I1Il11llllIl(llill1iil1ill4);
l1li1ililli.llIIlllll111(llill1iil1ill4, 4, 4);
Il1I1IIII1l il1I1IIII1l7 = new Il1I1IIII1l();
il1I1IIII1l7.llIIlllll111("");
l1l11IIIl1 lili1iiil1114 = new lIlI1IIIl111(0, 71, "Read only cell using empty data validation");
lili1iiil1114.l11l1l11I1(il1I1IIII1l7);
l1li1ililli.I1Il11llllIl(lili1iiil1114);
l1li1ililli.l1llllI11l111(39, 45, false);
}
private void lI111l1I1llIl(l1lI1IlIllI l1li1ililli) throws I1II111111II {
IIIll1lllI1I iIIll1lllI1I = new IIIll1lllI1I(IIlIIIIl1I1I.IIllIl1llII);
iIIll1lllI1I.IIlIIlI1I1I(true);
l1li1ililli.lI1111IllIl1(0, 20);
l1li1ililli.lI1111IllIl1(4, 20);
l1li1ililli.lI1111IllIl1(5, 20);
l1li1ililli.lI1111IllIl1(6, 20);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 0, "+/- Pi - default format", iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(1, 0, 3.1415926535d));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(2, 0, -3.1415926535d));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 1, "+/- Pi - integer format", iIIll1lllI1I));
IIIll1lllI1I iIIll1lllI1I2 = new IIIll1lllI1I(lll1IIIIll1II.IlllIll1I1I);
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(1, 1, 3.1415926535d, iIIll1lllI1I2));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(2, 1, -3.1415926535d, iIIll1lllI1I2));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 2, "+/- Pi - float 2dps", iIIll1lllI1I));
I111llIl i111llIl = lll1IIIIll1II.Il11lI1III1;
IIIll1lllI1I iIIll1lllI1I3 = new IIIll1lllI1I(i111llIl);
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(1, 2, 3.1415926535d, iIIll1lllI1I3));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(2, 2, -3.1415926535d, iIIll1lllI1I3));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 3, "+/- Pi - custom 3dps", iIIll1lllI1I));
IIIll1lllI1I iIIll1lllI1I4 = new IIIll1lllI1I(new Illl1lI11l("#.###"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(1, 3, 3.1415926535d, iIIll1lllI1I4));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(2, 3, -3.1415926535d, iIIll1lllI1I4));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 4, "+/- Pi - custom &3.14", iIIll1lllI1I));
IIIll1lllI1I iIIll1lllI1I5 = new IIIll1lllI1I(new Illl1lI11l("&#.00"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(1, 4, 3.1415926535d, iIIll1lllI1I5));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(2, 4, -3.1415926535d, iIIll1lllI1I5));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 5, "+/- Pi - custom Text #.### Text", iIIll1lllI1I));
IIIll1lllI1I iIIll1lllI1I6 = new IIIll1lllI1I(new Illl1lI11l("Text#.####Text"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(1, 5, 3.1415926535d, iIIll1lllI1I6));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(2, 5, -3.1415926535d, iIIll1lllI1I6));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 0, "+/- Bilko default format"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 0, 1.5042699E7d));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(6, 0, -1.5042699E7d));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 1, "+/- Bilko float format"));
IIIll1lllI1I iIIll1lllI1I7 = new IIIll1lllI1I(i111llIl);
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 1, 1.5042699E7d, iIIll1lllI1I7));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(6, 1, -1.5042699E7d, iIIll1lllI1I7));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 2, "+/- Thousands separator"));
IIIll1lllI1I iIIll1lllI1I8 = new IIIll1lllI1I(lll1IIIIll1II.lIIl1I1I);
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 2, 1.5042699E7d, iIIll1lllI1I8));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(6, 2, -1.5042699E7d, iIIll1lllI1I8));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 3, "+/- Accounting red - added 0.01"));
IIIll1lllI1I iIIll1lllI1I9 = new IIIll1lllI1I(lll1IIIIll1II.Ill1llIIlIlll);
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 3, 1.504269901E7d, iIIll1lllI1I9));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(6, 3, -1.504269901E7d, iIIll1lllI1I9));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 4, "+/- Percent"));
IIIll1lllI1I iIIll1lllI1I10 = new IIIll1lllI1I(lll1IIIIll1II.IIll11IllI1l);
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 4, 1.5042699E7d, iIIll1lllI1I10));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(6, 4, -1.5042699E7d, iIIll1lllI1I10));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 5, "+/- Exponential - 2dps"));
IIIll1lllI1I iIIll1lllI1I11 = new IIIll1lllI1I(lll1IIIIll1II.ll11llIII1111);
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 5, 1.5042699E7d, iIIll1lllI1I11));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(6, 5, -1.5042699E7d, iIIll1lllI1I11));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 6, "+/- Custom exponentional - 3dps", iIIll1lllI1I));
IIIll1lllI1I iIIll1lllI1I12 = new IIIll1lllI1I(new Illl1lI11l("0.000E0"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 6, 1.5042699E7d, iIIll1lllI1I12));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(6, 6, -1.5042699E7d, iIIll1lllI1I12));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 7, "Custom neg brackets", iIIll1lllI1I));
IIIll1lllI1I iIIll1lllI1I13 = new IIIll1lllI1I(new Illl1lI11l("#,##0;(#,##0)"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 7, 1.5042699E7d, iIIll1lllI1I13));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(6, 7, -1.5042699E7d, iIIll1lllI1I13));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 8, "Custom neg brackets 2", iIIll1lllI1I));
IIIll1lllI1I iIIll1lllI1I14 = new IIIll1lllI1I(new Illl1lI11l("#,##0;(#,##0)a"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 8, 1.5042699E7d, iIIll1lllI1I14));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(6, 8, -1.5042699E7d, iIIll1lllI1I14));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 9, "Custom percent", iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 9, 3.14159265d, new IIIll1lllI1I(new Illl1lI11l("0.0%"))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 10, "Boolean - TRUE"));
l1li1ililli.I1Il11llllIl(new I11Il1I1Il11I(1, 10, true));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 11, "Boolean - FALSE"));
l1li1ililli.I1Il11llllIl(new I11Il1I1Il11I(1, 11, false));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 12, "A hidden cell->"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(1, 12, 17.0d, IIlIIIIl1I1I.Il1IlII1));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 19, "Currency formats"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 21, "UK Pound"));
IIlI1lll1II.IIllIl1llII iIllIl1llII = Illl1lI11l.I11ll1l1lI11l;
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 21, 12345.0d, new IIIll1lllI1I(new Illl1lI11l("� #,###.00", iIllIl1llII))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 22, "Euro 1"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 22, 12345.0d, new IIIll1lllI1I(new Illl1lI11l("[$�-2] #,###.00", iIllIl1llII))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 23, "Euro 2"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 23, 12345.0d, new IIIll1lllI1I(new Illl1lI11l("#,###.00[$�-1]", iIllIl1llII))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 24, "Dollar"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 24, 12345.0d, new IIIll1lllI1I(new Illl1lI11l("[$$-409] #,###.00", iIllIl1llII))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 25, "Japanese Yen"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 25, 12345.0d, new IIIll1lllI1I(new Illl1lI11l("[$�-411] #,###.00", iIllIl1llII))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 30, "Fraction formats"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 32, "One digit fraction format", iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 32, 3.18279d, new IIIll1lllI1I(lll1IIIIll1II.IllIlI1l1I)));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 33, "Two digit fraction format", iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 33, 3.18279d, new IIIll1lllI1I(lll1IIIIll1II.l1llllI11l111)));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 34, "Three digit fraction format (improper)", iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 34, 3.18927d, new IIIll1lllI1I(new Illl1lI11l(Illl1lI11l.lI1l11l11ll, iIllIl1llII))));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(4, 35, "Three digit fraction format (proper)", iIIll1lllI1I));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(5, 35, 3.18927d, new IIIll1lllI1I(new Illl1lI11l("# ???/???", iIllIl1llII))));
for (int i = 0; i < 100; i++) {
for (int i2 = 8; i2 < 108; i2++) {
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(i2, i, i2 + i));
}
}
for (int i3 = 101; i3 < 3000; i3++) {
for (int i4 = 0; i4 < 25; i4++) {
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(i4, i3, i4 + i3));
}
}
}
private void lII1lI1Illl(l1lI1IlIllI l1li1ililli) throws I1II111111II {
l1li1ililli.IIIII11lIlIl().IlIIlIlll11I1(true);
l1li1ililli.IIIII11lIlIl().l1ll1IllII11("jxl");
l1li1ililli.IIIII11lIlIl().Il11IIIlII1l(5);
l1li1ililli.IIIII11lIlIl().I1Il1l11II1lI(CropImageView.DEFAULT_IMAGE_TO_CROP_BOUNDS_ANIM_DURATION);
IllI1I1IlIl illI1I1IlIl = new IllI1I1IlIl(IllI1I1IlIl.llIIlllll111, 12);
illI1I1IlIl.l1ll1IllII11(true);
IIIll1lllI1I iIIll1lllI1I = new IIIll1lllI1I(illI1I1IlIl);
l1IIl1l1ll11 l1iil1l1ll11 = new l1IIl1l1ll11();
l1iil1l1ll11.I1Il11llllIl(6400);
l1iil1l1ll11.Ill1llIIlIlll(iIIll1lllI1I);
l1li1ililli.III11IIll1lI1(0, l1iil1l1ll11);
l1li1ililli.lI1111IllIl1(1, 15);
for (int i = 0; i < 61; i++) {
lIlI1IIIl111 lili1iiil111 = new lIlI1IIIl111(0, i, "Common Label");
lIlI1IIIl111 lili1iiil1112 = new lIlI1IIIl111(1, i, "Distinct label number " + i);
l1li1ililli.I1Il11llllIl(lili1iiil111);
l1li1ililli.I1Il11llllIl(lili1iiil1112);
}
lIlI1IIIl111 lili1iiil1113 = new lIlI1IIIl111(0, 61, "Common Label", iIIll1lllI1I);
lIlI1IIIl111 lili1iiil1114 = new lIlI1IIIl111(1, 61, "1-1234567890", iIIll1lllI1I);
lIlI1IIIl111 lili1iiil1115 = new lIlI1IIIl111(2, 61, "2-1234567890", iIIll1lllI1I);
l1li1ililli.I1Il11llllIl(lili1iiil1113);
l1li1ililli.I1Il11llllIl(lili1iiil1114);
l1li1ililli.I1Il11llllIl(lili1iiil1115);
for (int i2 = 62; i2 < 200; i2++) {
lIlI1IIIl111 lili1iiil1116 = new lIlI1IIIl111(0, i2, "Common Label");
lIlI1IIIl111 lili1iiil1117 = new lIlI1IIIl111(1, i2, "Distinct label number " + i2);
l1li1ililli.I1Il11llllIl(lili1iiil1116);
l1li1ililli.I1Il11llllIl(lili1iiil1117);
}
IllI1I1IlIl illI1I1IlIl2 = new IllI1I1IlIl(IllI1I1IlIl.llI1l1l1Il1I, 10, IllI1I1IlIl.lIl11II1lII);
illI1I1IlIl2.l1llI1111I1lI(l1llIII11I11l.I1Il11llllIl);
IIIll1lllI1I iIIll1lllI1I2 = new IIIll1lllI1I(illI1I1IlIl2);
iIIll1lllI1I2.IIlIIlI1I1I(true);
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(0, 205, "Different format", iIIll1lllI1I2));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(5, 2, "A column for autosizing", iIIll1lllI1I2));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(5, 4, "Another label, longer this time and in a different font"));
l1IIl1l1ll11 l1iil1l1ll112 = new l1IIl1l1ll11();
l1iil1l1ll112.lII1lI1Illl(true);
l1li1ililli.III11IIll1lI1(5, l1iil1l1ll112);
}
private void lIIl1I1I(l1lI1IlIllI l1li1ililli) throws I1II111111II {
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(0, 0, 15.0d));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(0, 1, 16.0d));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(0, 2, 10.0d));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(0, 3, 12.0d));
l1li1ililli.lI1111IllIl1(2, 20);
IIIll1lllI1I iIIll1lllI1I = new IIIll1lllI1I();
iIIll1lllI1I.llIl11III1lI1(lIlIll1IlIII.lII1lI1Illl);
iIIll1lllI1I.IIlIIlI1I1I(true);
l1IIl1l1ll11 l1iil1l1ll11 = new l1IIl1l1ll11();
l1iil1l1ll11.I1Il11llllIl(6400);
l1iil1l1ll11.Ill1llIIlIlll(iIIll1lllI1I);
l1li1ililli.III11IIll1lI1(3, l1iil1l1ll11);
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 0, "A1+A2"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 0, "a1+a2"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 1, "A2 * 3"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 1, "A2 * 3"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 2, "A2+A1/2.5"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 2, "A2+A1/2.5"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 3, "3+(a1+a2)/2.5"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 3, "3+(a1+a2)/2.5"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 4, "(a1+a2)/2.5"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 4, "(a1+a2)/2.5"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 5, "15+((a1+a2)/2.5)*17"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 5, "15+((a1+a2)/2.5)*17"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 6, "SUM(a1:a4)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 6, "SUM(a1:a4)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 7, "SUM(a1:a4)/4"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 7, "SUM(a1:a4)/4"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 8, "AVERAGE(A1:A4)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 8, "AVERAGE(a1:a4)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 9, "MIN(5,4,1,2,3)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 9, "MIN(5,4,1,2,3)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 10, "ROUND(3.14159265, 3)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 10, "ROUND(3.14159265, 3)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 11, "MAX(SUM(A1:A2), A1*A2, POWER(A1, 2))"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 11, "MAX(SUM(A1:A2), A1*A2, POWER(A1, 2))"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 12, "IF(A2>A1, \"A2 bigger\", \"A1 bigger\")"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 12, "IF(A2>A1, \"A2 bigger\", \"A1 bigger\")"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 13, "IF(A2<=A1, \"A2 smaller\", \"A1 smaller\")"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 13, "IF(A2<=A1, \"A2 smaller\", \"A1 smaller\")"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 14, "IF(A3<=10, \"<= 10\")"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 14, "IF(A3<=10, \"<= 10\")"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 15, "SUM(1,2,3,4,5)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 15, "SUM(1,2,3,4,5)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 16, "HYPERLINK(\"http://www.andykhan.com/jexcelapi\", \"JExcelApi Home Page\")"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 16, "HYPERLINK(\"http://www.andykhan.com/jexcelapi\", \"JExcelApi Home Page\")"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 17, "3*4+5"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 17, "3*4+5"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 18, "\"Plain text formula\""));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 18, "Plain text formula"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 19, "SUM(a1,a2,-a3,a4)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 19, "SUM(a1,a2,-a3,a4)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 20, "2*-(a1+a2)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 20, "2*-(a1+a2)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 21, "'Number Formats'!B1/2"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 21, "'Number Formats'!B1/2"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 22, "IF(F22=0, 0, F21/F22)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 22, "IF(F22=0, 0, F21/F22)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 23, "RAND()"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 23, "RAND()"));
StringBuffer stringBuffer = new StringBuffer();
stringBuffer.append("'");
stringBuffer.append(this.IlllIll1I1I.llIIlllll111(0).getName());
stringBuffer.append("'!");
stringBuffer.append(II1I1llll1II.IIllIl1llII(9, 18));
stringBuffer.append("*25");
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 24, stringBuffer.toString()));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 24, stringBuffer.toString()));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 25, "NOW()", new IIIll1lllI1I(l1l1lIl1II1II.IlllIll1I1I)));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 25, "NOW()"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 26, "$A$2+A3"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 26, "$A$2+A3"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 27, "IF(COUNT(A1:A9,B1:B9)=0,\"\",COUNT(A1:A9,B1:B9))"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 27, "IF(COUNT(A1:A9,B1:B9)=0,\"\",COUNT(A1:A9,B1:B9))"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 28, "SUM(A1,A2,A3,A4)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 28, "SUM(A1,A2,A3,A4)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(1, 29, "a1"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 29, "SUM(INDIRECT(ADDRESS(2,29)):A4)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 29, "SUM(INDIRECT(ADDRESS(2,29):A4)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 30, "COUNTIF(A1:A4, \">=12\")"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 30, "COUNTIF(A1:A4, \">=12\")"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 31, "MAX($A$1:$A$4)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 31, "MAX($A$1:$A$4)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 32, "OR(A1,TRUE)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 32, "OR(A1,TRUE)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 33, "ROWS(A1:C14)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 33, "ROWS(A1:C14)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 34, "COUNTBLANK(A1:C14)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 34, "COUNTBLANK(A1:C14)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 35, "IF(((F1=\"Not Found\")*(F2=\"Not Found\")*(F3=\"\")*(F4=\"\")*(F5=\"\")),1,0)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 35, "IF(((F1=\"Not Found\")*(F2=\"Not Found\")*(F3=\"\")*(F4=\"\")*(F5=\"\")),1,0)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 36, "HYPERLINK(\"http://www.amazon.co.uk/exec/obidos/ASIN/0571058086qid=1099836249/sr=1-3/ref=sr_1_11_3/202-6017285-1620664\", \"Long hyperlink\")"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 37, "1234567+2699"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 37, "1234567+2699"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 38, "IF(ISERROR(G25/G29),0,-1)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 38, "IF(ISERROR(G25/G29),0,-1)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 39, "SEARCH(\"C\",D40)"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 39, "SEARCH(\"C\",D40)"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 40, "#REF!"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 40, "#REF!"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(1, 41, 79.0d));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 41, "--B42"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 41, "--B42"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 42, "CHOOSE(3,A1,A2,A3,A4"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 42, "CHOOSE(3,A1,A2,A3,A4"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 43, "A4-A3-A2"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 43, "A4-A3-A2"));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 44, "F29+F34+F41+F48+F55+F62+F69+F76+F83+F90+F97+F104+F111+F118+F125+F132+F139+F146+F153+F160+F167+F174+F181+F188+F195+F202+F209+F216+F223+F230+F237+F244+F251+F258+F265+F272+F279+F286+F293+F300+F305+F308"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 44, "F29+F34+F41+F48+F55+F62+F69+F76+F83+F90+F97+F104+F111+F118+F125+F132+F139+F146+F153+F160+F167+F174+F181+F188+F195+F202+F209+F216+F223+F230+F237+F244+F251+F258+F265+F272+F279+F286+F293+F300+F305+F308"));
l1li1ililli.I1Il11llllIl(new lI1I1I1ll11l1(1, 45, 17.0d));
l1li1ililli.I1Il11llllIl(new l1lI1IIIl111(2, 45, "formulavalue+5"));
l1li1ililli.I1Il11llllIl(new lIlI1IIIl111(3, 45, "formulavalue+5"));
}
public void IIllIl1llII() throws IOException, I1II111111II {
I1II1Il1111II i1II1Il1111II = new I1II1Il1111II();
i1II1Il1111II.lllIl1ll1l1I(new Locale("en", "EN"));
IIlIIIIl1I1I l1llllI11l111 = I1I1II1Il1lI1.l1llllI11l111(new File(this.IIllIl1llII), i1II1Il1111II);
this.IlllIll1I1I = l1llllI11l111;
l1lI1IlIllI III11IIll1lI1 = l1llllI11l111.III11IIll1lI1("Number Formats", 0);
l1lI1IlIllI III11IIll1lI12 = this.IlllIll1I1I.III11IIll1lI1("Date Formats", 1);
l1lI1IlIllI III11IIll1lI13 = this.IlllIll1I1I.III11IIll1lI1("Label Formats", 2);
l1lI1IlIllI III11IIll1lI14 = this.IlllIll1I1I.III11IIll1lI1("Borders", 3);
l1lI1IlIllI III11IIll1lI15 = this.IlllIll1I1I.III11IIll1lI1("Labels", 4);
l1lI1IlIllI III11IIll1lI16 = this.IlllIll1I1I.III11IIll1lI1("Formulas", 5);
l1lI1IlIllI III11IIll1lI17 = this.IlllIll1I1I.III11IIll1lI1("Images", 6);
this.IlllIll1I1I.Il11lIlllll1(l1llIII11I11l.lIlI1IIllI1, 255, 0, 0);
this.IlllIll1I1I.IIll11IllI1l("namedrange", III11IIll1lI14, 1, 11, 5, 14);
this.IlllIll1I1I.IIll11IllI1l("validation_range", III11IIll1lI13, 4, 65, 9, 65);
this.IlllIll1I1I.IIll11IllI1l("formulavalue", III11IIll1lI16, 1, 45, 1, 45);
III11IIll1lI15.IIIII11lIlIl().I11lII1l1lIII(4, 4, 15, 35);
lI11111lI1(III11IIll1lI13);
lI111l1I1llIl(III11IIll1lI1);
Il11lI1III1(III11IIll1lI12);
IlllIll1I1I(III11IIll1lI14);
lII1lI1Illl(III11IIll1lI15);
lIIl1I1I(III11IIll1lI16);
Il1IlII1(III11IIll1lI17);
this.IlllIll1I1I.lI11lI1llIl11();
this.IlllIll1I1I.I1Il11llllIl();
}
}