From b4d27a47bdb48ed659c05b51a784b06c7317322d Mon Sep 17 00:00:00 2001 From: Dominik Stadler Date: Mon, 28 Jul 2014 19:10:54 +0000 Subject: [PATCH] Add simple unit test to verify that Bug 42016 was fixed already by some other fixes git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1614135 13f79535-47bb-0310-9956-ffa450edef68 --- .../org/apache/poi/hssf/usermodel/TestBugs.java | 9 +++++++++ test-data/spreadsheet/42016.xls | Bin 0 -> 13824 bytes 2 files changed, 9 insertions(+) create mode 100644 test-data/spreadsheet/42016.xls diff --git a/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java b/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java index de12602e40..543ec99ebc 100644 --- a/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java +++ b/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java @@ -2722,4 +2722,13 @@ public final class TestBugs extends BaseTestBugzillaIssues { FormulaEvaluator eval = wb.getCreationHelper().createFormulaEvaluator(); assertEquals("4.0", eval.evaluate(intF).formatAsString()); } + + @Test + public void bug42016() { + Workbook wb = openSample("42016.xls"); + Sheet s = wb.getSheetAt(0); + for(int row = 0;row < 7;row++) { + assertEquals("A$1+B$1", s.getRow(row).getCell(2).getCellFormula()); + } + } } diff --git a/test-data/spreadsheet/42016.xls b/test-data/spreadsheet/42016.xls new file mode 100644 index 0000000000000000000000000000000000000000..4cbdab7d264d7f6ee9af1ccb5bb36a01c30b339b GIT binary patch literal 13824 zcmeHOZD<@t7=Cu|BNvkR`cJHe%>*mkCzxEQAgzX4mAzz8G54V`V(>;!Y<@vlEy6GLv6Efj{ z#6V?)7cv~eFO72*U(7HY04~ACd%;=8!1t6P9L84{ZB@mDGCE8pk!RVQk?e zZS##HJy?s+SwDaDqzrdpAY|Q#EDj=tLs;3;GgMbvZ*y=xLbx4>-yLu1Y-#BpZr?i8 z<{k{SHwQQHPF-JAzIPzK|LNjNaa5qmtJKw9d>$UlsWu{l_|jTS&Q_?p1qt*5!(vJz z=2})b9BNZwsC{bzh;NG1?%}rNFtv1{oj*49w@bwQjS{h<7X9eNy~WC$9u(_S(|juX z`#q)ipo7=YQ|h)~)ay1@)n3batd_BWKk_k6ooFT|xC|4;e|L+nkIT3%RlgiAXDwC# zR>m#FqZ@kFAGMmVV+=&8=N|?C9q%#EK~vuFTujtptjU9cEbtl z^=nmlkcUY|Rx%LAI(E}0scwky$X*D+68K!Ok;Oc-jc^qn=jtiRDDSkB4*1*A_2C4Ye4HNRkeos*`fyj_x81JChq^vY zx;lky}*mU9nNxOC$_fq3NLZUInDIYC)Pd6m*YIYW^L>kn+y%v9=l zn+oMISsUy;IFijwWDZQmc1(?=52^0l^sb*jo&1b`J&+rm4qs$mmW(DC1`Gp+0mFb{ zz%XDKFbo(53GHFi_0E_56SP!rX<^UF)K!UZeltdF37P|G%TiYb){pcT?nz z!BZ5zo5m=miX#5M`0P^@@%wX>H57M0;3V_n`+rRF?+3^p!lUV_!zrfX$N$(^rRQU| zY}!mkQdjmQoOf+rw%5yUMl~ynGTC?#BL_3tu?cxOH=*s#z5zKg!7yMLFbo(53GHFkl!k3>XG(Sq8+97q?jaUwM}=pRLL_ed15c|2o9im#_B3Wfq@Z-sj6Fn&S6M zc^y-E=P!P~`|+pv`m!G&<<}^Zn(*IbU;r8ZCK1C9j5E#R2(R4o!y0});`U6&Q7j@c zFrzUZauO$=Ir`J(Z~2Xej0YDVr1mVvuutt6bKzyD{0GRQez9ZO4P}FhA%s164$tzJ z(!M`J77nOQf=u#%9~mO$LmTzWJtX(fa`nqTmu`?T3Gvh63`W$3v|fQ5v#0ML^k2JP G=>K2ixKTR* literal 0 HcmV?d00001 -- 2.39.5