From b4d27a47bdb48ed659c05b51a784b06c7317322d Mon Sep 17 00:00:00 2001
From: Dominik Stadler <centic@apache.org>
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|BNvk<m!zrMHt~8fG`XZ9Nx=q7oAaaMS7}L=2#v&RdL<<_S1u9K
zUp=*j3I-|_^hd$=pCb5ypa?~hKYsiON})*AAE}5a2t`q_(B^#JcW<+M@vfvotd^PM
zotb@RX5V+7ot>R`cJHe%>*mkCzxEQAgzX4mAzz8G54V`V(>;!Y<@vlEy6GLv6Efj{
z#6V?)7cv~eFO72*U(7HY04~ACd%;=8!1t6P9L8<HW233@(byB&)Oc*=!~JSQ$`Tu9
zIPkVvVOYchIL)|*<4{WKHEz)OU9Edg<83UN!Y1r(vYPr>4{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#Fq<e+n^4a0=@aIyzy$s%222Yg1EB}U{vV(}`0(nX6a$!yDb3siTauu2)2TfP!
zLiuNOCOOXeX)YvIhOuWfou2FwBpdM|y@DL6^dXyHMv!C4!mJgc@c#S6!d2diZpd?f
zieMztNO3Wsv5-B_2^!919xa;8t88cJO1%ooOMIfY@&v1N>Z@kFAGMmVV+=&8<my|$
zp5M7|cmJ^B3B@}!enF9(&#YEb!)Xi8vt%|Xy2PXxwe~TM&&q7V8qzt7o%F(dzmu2r
zN!F!Vc8x+}sZ91j#O4D^^SajHOkS&)^DrpJ>=N|?C9q%#EK~vuFTujtptjU9cEbtl
z^=nmlkcUY|Rx%LAI(E}0scwky$X*D+68K!Ok;Oc-jc^qn=jtiRDDSkB4*1*A_<W(A
zoL2hcFJ?dd#nLT*F}vh1mLB?xX@kF5I_obc>2C4Ye4HNRkeos*`fyj_x81JChq^vY
zx;<su#FGT1AM(tV)V43PyCG~LQht!iMfO61cg9T|pf)d#hVlc{vsG!(!=wi~G&sj3
zPQ#7U&_lj%A`Jz*ffb}-QHRMG1`Gp+0mHz*%D@6wP$6Bl7ORzq*8K4|e!H@3H2U@{
z5p-<);9@tiHz~3>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(53<HJ%!+>GHFi_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(53<HJ%
z!+>GHFkl!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