From abc3d37adc41cb4250f7c2950aaccf51c6977e3d Mon Sep 17 00:00:00 2001 From: Dominik Stadler Date: Fri, 10 Mar 2017 20:14:00 +0000 Subject: [PATCH] Add tests from bug 45353 to show that this now works fine git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1786432 13f79535-47bb-0310-9956-ffa450edef68 --- .../org/apache/poi/hssf/usermodel/TestBugs.java | 14 ++++++++++++++ .../spreadsheet/named-cell-in-formula-test.xls | Bin 0 -> 96768 bytes test-data/spreadsheet/named-cell-test.xls | Bin 0 -> 96256 bytes 3 files changed, 14 insertions(+) create mode 100644 test-data/spreadsheet/named-cell-in-formula-test.xls create mode 100644 test-data/spreadsheet/named-cell-test.xls diff --git a/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java b/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java index 2718688647..b84c953cf6 100644 --- a/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java +++ b/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java @@ -3080,4 +3080,18 @@ public final class TestBugs extends BaseTestBugzillaIssues { //fos.close(); wb.close(); } + + @Test + public void test45353a() throws IOException { + final Workbook wb = HSSFTestDataSamples.openSampleWorkbook("named-cell-in-formula-test.xls"); + wb.getCreationHelper().createFormulaEvaluator().evaluateAll(); + wb.close(); + } + + @Test + public void test45353b() throws IOException { + final Workbook wb = HSSFTestDataSamples.openSampleWorkbook("named-cell-test.xls"); + wb.getCreationHelper().createFormulaEvaluator().evaluateAll(); + wb.close(); + } } diff --git a/test-data/spreadsheet/named-cell-in-formula-test.xls b/test-data/spreadsheet/named-cell-in-formula-test.xls new file mode 100644 index 0000000000000000000000000000000000000000..3d70bab4617b086cafb7649640168367e74914c3 GIT binary patch literal 96768 zcmeI5eQ*_58OG1vByakbMAe? zEzdH~?%uQKyzidhd3N{Qg@ix+zE9K6*9O05E?Xv=9CM*H-*ihWk6{1Tsn3PR$Y&3_ z(AwIXDz3*4K5_{Of%9$WDPx$6vCD&G%)3KT=vPn=s3+75x(VtH6+p0n=>zqJ`a%7n zo1p>FEzm${5HuLN75Wf#8#Dy^FcgDshlWBQfj$b|0Tn^RpyAL6Xe2ZWDuzZwW1u^s zvCueZJTw9N81!-I6VP4I-OxSIC!vYZz0f4+K4>x&ho(SNp%UnRXc{yfngPv(Wn zS^_PFmO+)!OryZ-Z0 z{{M3Q%X!Q7FI$mZ|FY%cP9Q&8h#P*MIds$Sy!X#U+AL)O%CBqrr@qPF~B!OErQoz?d%m#Cf9|KOH4 zf@w^;*S4fMk4kcAzPx;dPkFIV`ADDg{7%aaoN)R1Y>wb+tT(N)Ev(P6+dlQ(?6z-x zuHE*l?{2sK>+@R6;Bn7vg5&=tw|HFR^Oq$Ob>pODaNAXHOU6q{OEj&{gr{-kd-$`@ z%fp?FS~fp&Iha%_lX(bTz9WwwQ-lY7|^WJc&e-MI_FYZK`a7>DeqZ&fnrpqGp|kCsg!^7sonohP;ovnaok62o}X0H2NP* zQ|0-Uyw4T3yU+DP?8k5(LZ^?-Q;3NFedYZ>&aRj@`B7V5kCN1Khj2GTymdJ8R_;jK zVw7F4w{`nt275cEuO&r87gSa!R>kHdo`{v!RF|(PE=??5T~%H?v}oM;qA53HR*O0A zRqD+vUz&&&&D&rTY_#hloXiBfoS8f^~- zy<#ubKDG5QWsP8Z|CF8H8}Ip^7#LY1GR;q-Pr{Ez1g`84k@3Kx0&}?S23ue!=>>Kw z?7?6%jgQzb15)w6xD29vX(*AFCGsg}5TgA9b7=5yo{0jmZx+@zHb57coaV9kTwrpO z{xJE?$rC_f+7dB6Y&$Ve9?I{F^fd>&Nrkwq+LqfSUUENq@|a@7AWJWeF3#7J=cs%Q zpku6KB2JD;A#XptvGm~u^)3%D+FTr7n<9?&z4l9!e68g0cKL>o&EXxJKD@a3c6oTw zCY!^1$%I$l^Y9HK2ba5C`GwKsZR$v}$#i*VF}recZOy8hC3UfBYZfP}V)xuNdO>+b zqN*xkr^-_+mn=z6EU%o#_b6^g$)vtDu6*D^tK2a=hLDoTJICK?7;|gk<`<%7RB_8b z+}KRsWo3Tt&*G&J0RJYm~kkz#8W%i%6|R+1KTGzy)Do8i^~k`&BS@g zn92QnI3({sUW7dR)(P$2#fQrlsn11$z<`NSg{TZE1jts;2V_gOdIa<$)3;=+M?fz! zeM`1_1oR@)w`8kFKrb?VOSXCh^di%@WUEI&FEV{gwt58gBGb2It4BaDGJQ+7dIa<$ z)3;=+M?fz!eM`1_1oR@)w`8kFKrb?VOSXCh^di%@WUEI&FEV{gwt58gBGb2It4BaD zGJQ+7dIa<$)3;=+M?fz!eM`1_1oR@)w`8kFKrb?VOSXCh^di%@WUEI&FEV{gwt58g zBGb2It4BaDGJQ+7dIa<$)3;=+M?fz!eM`1_1oR@)w`8kFKrb?VOSXCh^di%@WUEI& zFEV{gwt58gBGb2It4BaDGJQ+7dIa<$)3;=+M?fz!eM`1_1oR@)w`8kFKrb?VOSXCh z^di%@WUEI&FEV{gwt58gBGb2It4BaDGJQ+7dIa<$)3;=+M?fz!eM`1_1oR@)w`8kF zKrb?VOSXCh^di%@WUEI&FEV{gwt58gBGb2It4BaDGJQ+7dIa<$)3;=+M?fz!eM`1_ z1oR@)w`8kFKrb?VOSXCh^di%@WUEI&FEV{gwt58gBGb2It4BaDGJQ+7dIa<$)3;=+ zM?fz!eM`1_1oR@)w`8kFKrb?VOSXCh^di%@WUEI&FEV{gwt58gBGb2It4BaDGJQ+7 zdIa<$)3;=+M?fz!eM`1_1oR@)w`8kFKrb?VOSXCh^di%@WUEI&FEV{gwt58gBGb2I zt4BaDGJQ+7dIa<$)3;=+M?fz!eM`1_1oR@)w`8kFKrb?V8y2>E_UzfZb?dHOyH1}z zot1OmzI{6aHZ?V6H|&WMCmI_Y7cN|w#Z&Fr-|YGpYj>~zfKP}0)UvSY`N zQ>RX4H|*K7XAd7foJb_Hc&Z(HmqoV6jvd>(ckh-hTefZ61{xi6Ig}habO=rYz=oRRv(5uj1=x5MA zXg_oSdJXzH^g8ql=nd!~^d|I6=mPpDI@Gq0T`uhj@LIb@*BY>sH5t$Y^Z-3T56}bj z06jnt&;#@UJwOl81M~nrKo8IZ^Z-3T56}bj06jnt&;#@UJwOl81M~nrKo8IZ^Z-3T z56}bj06jnt&;#@UJwOl81N6Xk@c@3b#tb@zpV#^8-29nutUV~(SoD#6DOX;i%JDl3 zAC{c*qg9zKF8!>@Bq7?moHGQ8mv3MwOsny-8WjW11>p(MfR`dl9ShpKhN|d zE^O1=yX=Q0XT3}3(%OWjpJ}J;w99@vVGGnKENl~jdgEUyEdBKFL9iq2XE07KwOrV) zbV-!f#wBN3bEjSAbix*>QCQfH3Dg_^N@3}ze-DBk2}?h3l8m-yg$$MBQ9*y z+q>+CB`3d^1smP4jAyXk_}5}T{n^NW`;y5L7Pi;py=Ep{rEOT)vY){Sgk?OJ1?!G) zt+4ddw*vtWu%7`zIaG6DyTTz)dJ~tN>Fr(inbU<@ur^^~TM?`~zO};APu~uN?Z6_O z@Ic6GQz5ny=*)TlavbLJ0U=OoYVfDd#LP6a0^3^iWS4q2z~ssA9I%Ucs4yz-G3JO} zo9W3-`*jXJ#(O2p9zyn7v)okJ^H|=#Vt`M5;a16*3&}|YXkx3J?2)YLnG$5KHY?3s zoWtWmn_sLa`K3Qe0>SbZqyDV62p;lQ8TZ#bJ&-?@J81vqAG7vv%b#cFo7L!lwJEn_ zKMO8cV#h>E>P#i}uQVAM-j+WP@q*@;zbwgpSlnXZp8Jtuu|0=`bzs-d=Wd7o--*0+ VHhXqfUF9$TA8mFrC!=JN|9^E-J&FJT literal 0 HcmV?d00001 diff --git a/test-data/spreadsheet/named-cell-test.xls b/test-data/spreadsheet/named-cell-test.xls new file mode 100644 index 0000000000000000000000000000000000000000..72890ae28665aca736733b62d623ec5f724ea98d GIT binary patch literal 96256 zcmeI5dvFzJ8OFaoxo`p$!ljh9HlAV|ZUMQdZEYz53Ir_|16nVXlF$RBBm_gSRBZ`2 zwYAk&ss%yIts)j_Yb|)2k^bWpFQcP&rj=oaI^!Rm`bX;MIAw(Ryx-=)CbHqnx90_q zKFd63cfb9<=iUA7b9VQf_Q3CcJLuG&7p{53benE9MdoZrnJJC5r?C9v+zT>%Y%211B{83YZ6hCoB1 zE1_Y~RnTzgYUmp1TIgNSbx;NLZYTp?4~>A{1Kj}K2vtHOp;6FiXbdzKs)EKr2cVmvo1t5v4??#>w?R{&+o7pYH8c&H4$Xk>fM!CopxICjGza<+ z^kL{uXf8Alnh!02J_6N33!z2ON1=~FcR?SAJ^_6a`V_Pnx*J*o-2*L!>Y#dP8FVj{ zg_c7rpp{SqbRV<|YJ{4g)lf6E2KqGA0@z_p!=cq&;!tCq0d2|haQ9;f;K=K zp;|aKV`K(Lz8douI|3UVr(sA;H0mzHqSp(T{uk@R`sWE;jFoJU@(-|{f{LIEz5mP5 z{@?KamwlG^zsyDQ{+BtYWCY66xQdsSn4ezpYq{jxYyTTa#Ph{3+g$t^ZHsZGK{jU8 zH7?6ss%g62hq^$rIVC8?b4Cgo-G$cyxTi?#VEa16zCLIB{mi~r+m^@d>lAx$Lg#9e zk-LFBulxb`8yPRC)@ObCjq9mAxD`Eq#(v7&&blHl2`Py1h z+~4e%JMQe6^JdmgyHnPmiL9Tpch>#p9~~J~%}vKL(k?q{+yCy?E=PW${&DT%dZGUR zyY2hIG$V)CIpsKy4LP)TZyz1gUKP_mCZ@gYg6#%L=)OPOQg}DEnGTtkw-wp>pte#w zAKX@K=R?~1*!j@5l8&Xwcwn|7@xPKwJl^9AS7x)V6Q$)XdDzRfOp=ygrXwwrAH_RA zz@NiGG2VYc@l|*#l+4LA+&ByS-oj(cKx5kL?OJL3D9nTY;Y~(v zHX<<+N%&-*YnyEPwaY{0&rvLGHU_u}rH=*Gc&#=SZ{va`kD+OprSX`V{wJP9Q-0PW>>6htZNxjIdM|uv@7x8ipSWC^jlE3 zBAcmPu-O*aVqYtg}(f6zX`o8ZZQI59G%WOj&za4vmp1W%}B2 za?g>EBe$mpn|v(|bOIU6ulT3Mj(6 zTi)p9>F`=~EbK8$zH^w{u&kwdZS(Th%*^%6vW=NrZW_0!u0Gq?n6;0((;JpA4<8J> zxVo?4+7lLaAJV1g*$%lt{-=esq+b2atGmWuTfXh7v>99V&S6}~Oi8yk`A%UtB-cQZ zTu^1~n`h$NvH9E-S6{qNZGHN0@62CW{_GQ|Kk~)b<>LLv#ew~9NVZo)^7*g^k_)VS z{~_NKEroFQ?e`V9QQPk!8p=)8xdqH+xovl*cHXI1g9lJ$ySemo-=bxwt58g zoS9p))gz$i%-oW#9sxaP=9X;r2GnOm~eBcSKZ+>)&x0X=8tmTdJ1=s7dDWUEI&&zZR;TRj4L&de>@>JiX$ zW^Tz=kAR*tb4#{*1oWJlTe8(7py$lolC2&AJ!j^YZ1o7}IWxCpt4Bc3nYkrfJpy{p z%q`jK5zupHZpl`UfSxmROSXCh^qiSnvehG?=gi!atsVhAXXch{^$6%WGq+@`M?lY+ zxg}dY0(#EOE!pZ3&~s*P$ySemo-=bxwt58goS9p))gz$i%-oW#9sxaP=9X;r2GnOm~eBcSKZ+>)&x0X=8t zmTdJ1=s7dDWUEI&&zZR;TRj4L&de>@>JiX$W^Tz=kAR*tb4#{*1oWJlTe8(7py$lo zlC2&AJ!j^YZ1o7}IWxCpt4Bc3nYkrfJpy{p%q`jK5zupHZpl`UfSxmROSXCh^qiSn zvehG?=gi!atsVhAXXch{^$6%WGq+@`M?lY+xg}dY0(#EOE!pZ3&~s*P$ySemo-=bx zwt58goS9p))gz$i%-oW#9sxaP=9X;r2GnOm~eBcSKZ+>)&x0X=8twoup}IB;OcjvagV?mc<(WWM$pp0LWh zZN7G|2cP`r7995N+jsi(=@3W{b=^0GR(ZE|-vRHQd1QP1`0+!B4sGAQedo@dCr+I3 z-lgck&=W2BwT+h0Th1d}y`3yj=a8+z-cw}23@`)C05iZ0Fayj0Gr$Zm1Iz$3zzi@0 z%m6dM3|yiNoWU1zn~X7=p)Jr>=nK#np)WxXLytgTh8~3;gT4ZN6?z$pC&{W3E1d-|PHkep$^+8;;04lU`CL?aI@osL}lp z3Zon(-yLI!sOM-hpo?;=*}e_AN6uw_Nm$6Y97q0H&Zp0q=q~t-m%qv}$>dX0{#wW+lTXdHNeW`D zPtAlS3#R7!ga_)wR{o07B$H3gB=uyhPfcEL-KhJpb#spI#hUSKF2{dIir*WzEj*uY zoP2r}3R~vZ?d%rH`AoW>KI6B#A&l+iQ#01gaRX~Qg7WC*!#3klCpyHZW^}yIvQNz> zpF)u_J~erbj{xjp(T8mhc21iLr6xa@Ih{_g&%AEV@x2NqL-9x8wxv*xQ~uePBvYXr zr~O{@ApU_I`HfA@;U)IBHZpfS__Slce0F2aeA4XdMYdgeMAueES3H)<)&rX35VDO2 zwK{&2(-yLI!sOM7Y~!)j$8U1l^8dot3C5-9RBM{?r`2T4OtTvE7V|)_$__In@|$xz z1sGYLPTBFtLYGz9~? zW*v^d$<*0%KL;sTZqJFdw3-Gi_jEHF)mgs;ey;W9gG%w;k`{yX+<^+q>^@{|0(-YV dH+vkv{Lh@Nwt9YEddpw_P15{S4qcMe|2H>