From 1461cf947c6db725f8fbf8e20d3f281668029aa3 Mon Sep 17 00:00:00 2001 From: Dominik Stadler Date: Sat, 14 Mar 2015 17:50:55 +0000 Subject: [PATCH] Add second verification of bug 56325 to ensure it is really fixed git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1666718 13f79535-47bb-0310-9956-ffa450edef68 --- .../apache/poi/hssf/usermodel/TestBugs.java | 29 ++++++++++++++++++ test-data/spreadsheet/56325a.xls | Bin 0 -> 23552 bytes 2 files changed, 29 insertions(+) create mode 100644 test-data/spreadsheet/56325a.xls diff --git a/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java b/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java index 873647805c..73256b6897 100644 --- a/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java +++ b/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java @@ -32,6 +32,7 @@ import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; +import java.io.OutputStream; import java.util.ArrayList; import java.util.Arrays; import java.util.Calendar; @@ -71,6 +72,7 @@ import org.apache.poi.ss.usermodel.Name; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; +import org.apache.poi.ss.util.CellRangeAddress; import org.apache.poi.util.TempFile; import org.junit.Ignore; import org.junit.Test; @@ -2526,6 +2528,33 @@ public final class TestBugs extends BaseTestBugzillaIssues { wb = HSSFTestDataSamples.writeOutAndReadBack(wb); assertEquals(0, wb.getNumberOfSheets()); } + + @Test + public void bug56325a() throws IOException { + HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("56325a.xls"); + + HSSFSheet sheet = wb.cloneSheet(2); + wb.setSheetName(3, "Clone 1"); + sheet.setRepeatingRows(CellRangeAddress.valueOf("2:3")); + wb.setPrintArea(3, "$A$4:$C$10"); + + sheet = wb.cloneSheet(2); + wb.setSheetName(4, "Clone 2"); + sheet.setRepeatingRows(CellRangeAddress.valueOf("2:3")); + wb.setPrintArea(4, "$A$4:$C$10"); + + wb.removeSheetAt(2); + + Workbook wbBack = HSSFTestDataSamples.writeOutAndReadBack(wb); + assertEquals(4, wbBack.getNumberOfSheets()); + +// OutputStream fOut = new FileOutputStream("/tmp/56325a.xls"); +// try { +// wb.write(fOut); +// } finally { +// fOut.close(); +// } + } /** * Formulas which reference named ranges, either in other diff --git a/test-data/spreadsheet/56325a.xls b/test-data/spreadsheet/56325a.xls new file mode 100644 index 0000000000000000000000000000000000000000..a1e52cb5de57e992bc0dec284ae4bd1e5246f09d GIT binary patch literal 23552 zcmeHP3v3+48UFWtw$E`Mb{yR#49 z2`V+{)|$PYfB*UZfByOB-kEv>Mdm1RQUfQ6dItMRFMDO1VgBH(H&?sPmJG_jz?*CZlDi(II0NFRfmz z?izAKWQDr=raITC^GKWxIi|{-QIrKzEoUJ!CU?`_Bl62qW3{wOr*z0R>B0H`iDRc> z$YOb(M#^e>OGeLDrRiKB4tHImLvoyjjdUq)3|g#mNQ;dfl4I$R9LtB`Fr-@)xYA^6 zy{U_x&D^c2ufe^o^((g4S4Zc{ESbTAHrp1*HR&$?Wq3F(b_;?6nk>A3nePbcD}GlVGmKdf8fbarGv{vbM0{rEr6bVK5- zo_Rz}dln<7?C?y69(_RB-%I~V0R6`S^d|!7hXUwN2GAc5pno@jerEtZNS`45qY7u7 z$3EW+pqu)5`AvPi^dAJ^JRLxPCV>8n0Qxrq=sydf=c~_86;8RwKBk|Hvgr3#R^C^B zU%5mND*nnWy}kYTl;cw*dQ8!a5kZt6{s#=|u>5mY0DW!%eYP(h(cGkK@dTqYlb-c| z)1ON%`m3@5ms2p7QhLVRbX4D@m)Z0V4ruE`x?@n`L0`ai~$rarIA&A6Os;S9Iv zSv?=i*e%0cS22{6Sc z$xA{s-vSJ&c}ZZK>6*fa7fz^<290rsW53NZNP zRe8MmkPAqy)SuA}@i^@?SR{)2^Tvzs{U#k; z|Cuh3!&2f8l71-+2-ef##M z*}Od1>;!Pq${aM@QpYeKT7OJe>N4;;m1_1^>iqfh9;KR_n>|W7X_iu?Wpu*gkg2?r z=2dEzOQ{e01I+EGl+!Ao&Qf}BTm+@e-bm|vl(K}S2aK$xyfvGhtr`8Fhp$UN^2j4u z5X%RgrnQ7QX}OzQ@0iP=hS@P$Gqjc42fVew+&SYktc7PdV|C1QI_0Uwkt0VuPUECm zwIB`H>ad)~N%IbwFdui+f_~sKZGY@~tv@bBfoL|odTK$tvwF^;M!Q=yvp4#M+!~a! z<2EwhMz%nL;}!?THi$<%+PFv(?N05y5wt27kW@=J$i*%YWc;e52YXpmG(I0)vC4iIGgZ4wSLJr@wZhzPR@C$>4* zBpd|O^PxdfE#V+>7YH)`HVFrrkqZbHy~Aw6MXDTZ5)Lvc7m!p-ILK5N2r~XQae^F( zjFt*KzNBG(UA#WNvaK!Am0U0wTPuS!UFI;N)#(w^fOYjciAz1wN@>GiLb@c0_dYa$ zA;YCKnrJ`!*8AyVUh`>#Q9vEnCMc#-7t`PsQxhV_oP#Ja#fkRwXaDFgX0$G*(JN+p zh!}I0qQsOW+TVTub$>BqbTLg{F|$L&a2}H}T4|#F%|HFsU(8rt%tEi2c_CsrUC4-u zCECyY?eG3##_3`fdBrq@h%tw?%4lVY_K)9r&0kCv#WaO`+7yUs%E8l8EzhOi^cOQ; z7vtk;wIO1ho|bBP>$zk8VkYQfd^~MNh#04*rCR>*=JWnyF4D#Lc-ov0F-}iQwWLm* z@fR~u7vtk;mxPFMdRnUG*z0fmiKT7A7gNlla8HXv%%U7T zt)cPTM^Bq#7|?KJW7=e0jE|>H3lZb=w1&nr2k-S4Q>}~f@wAyCVw|4V(DC(VwrO5i*U+@R5wL#%gI_Ojl)agZd^|4{CKj<_Y6#k=w z)@h(lpAk9q^Dp^>*4d!&79Dh!2I}+>k%8^s_XnMBgTgm-(0UEj=?@~;KK`OV=nNYa zo}hy+&_JE7FY@n$SNeg*WG0@jvZ{6aVC*t?%Nvu@MY0OZjoY(N;9@R{V1X2>>!8nuQvzMS; z&awn>c}WQ<5xgP7O|EAcV0PwWu3VWbcOWtfyD9KCV)f2M+phTPL}%w282t+@VFlGV!0Sz4JnODi*X0E@PB28z;yvAA26 z;vxuH4U^o0zgCD6A@AIQ67bH{cuTO`(B_THjd&8=lr2*~5Jj2kTA64%hBAHFm(`=j zzHPEMTVmcoDN4-KN|dIDdrG)vjl&)gEYqynv%9mkt2No(vp2peu_rkgyUGm}S(vVn zHL?er zb5*X0TUZcgVU5IiA2W!n6Rq1jx^~1dSI`tKs(@v$hC=lH4k)?<3Yv2Sj*8ea~4%I;r*0TSX;OGnqP#P&@8zgAOb0^(AOYUo{P^zE()P?Yt?Y%H>(50|)0 zV7TFODfE|hiN0h{E5eHwn2n1OnAZWAHSK{Em-b|}3>&)uv93Fr7>sRmV?>6bzYrq{rMT8;MP4pcTOo~$ z%yytPb5=+*b5=+*a|a^jav9g?*7qeE)@twM1z8e#+L+>@R7(`0njC3MwI9m!5uYk|8|(I_;}CU{2@4M%%< zz1<+hQU%eSqz7ng4@DO#2pZgM{it#(*ZKnOZp9I^wpNZVRw>Kybd=4lJzWf0W_WFO zD;gP2*;%^f`wyD}~gvxu>)mqe@!LSd0 z*8nSa$gRqQY!3FI9e9dzIc1UDthNY$4Ym3rUn#>gHttL$k_$*V&3627+oz& z#u{6mQUBd1;GPAyJxn zRAqi6au6CFblh3>7efw#cE~|v4fcb!-$5e)w@H{A$}3zO%F82s?_nQpu-FLHkUcem zb{M6uD{&S)dSmj@kKX^?+HD(}w<`Ks!AVvR{C$Kp!<5lKrI@gQbTs?6`3H!)MbH{VEQLJXL8V#wbN&)X-_<*J+FsIt{VXL!&l2A7AC@H1pkRT51qv1@SfF5mf&~f|C|ICifr14J7ARQ2ZGo`)f8^B5rw-4XRB_-w%>U

pkRT|r3E;T=aiUpU%t!d<`M3x z;9Q#T^f}k(7938OIcMkmog3LW@8=w!AMf*>Kj-<}*u>3uoa=KvfZw0NP0 ze>uQU>^c3Of)q!Zid2Kd`_u4Shcq2&2GUHVSxB>yc>iN0{uYkU&H~qA+behS#_=fw zza8f13;7&XQmi%}QX~3NJjS!g33Zk$%^&xfZD>(8LwXNBQ`x5U*kzG({>6U)&dR3_ zxfUGHkCbo}%SN>cnBS+c?%c)Su5=>B{-DR?_MT@#KKl^+PpJ2gg literal 0 HcmV?d00001 -- 2.39.5