From 3f6f9da0ceb7d9dbff2cf983cb3e2ed33ff27e2c Mon Sep 17 00:00:00 2001 From: Dominik Stadler Date: Wed, 7 Jan 2015 14:13:34 +0000 Subject: [PATCH] Add reproducer for bug 57074 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1650059 13f79535-47bb-0310-9956-ffa450edef68 --- .../poi/hssf/usermodel/TestUnfixedBugs.java | 22 ++++++++++++++++++ test-data/spreadsheet/57074.xls | Bin 0 -> 26112 bytes 2 files changed, 22 insertions(+) create mode 100644 test-data/spreadsheet/57074.xls diff --git a/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java b/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java index b6a535347a..2615545660 100644 --- a/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java +++ b/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java @@ -17,6 +17,8 @@ package org.apache.poi.hssf.usermodel; +import static org.junit.Assert.assertEquals; + import java.io.IOException; import junit.framework.AssertionFailedError; @@ -24,10 +26,12 @@ import junit.framework.TestCase; import org.apache.poi.hssf.HSSFTestDataSamples; import org.apache.poi.hssf.record.RecordFormatException; +import org.apache.poi.hssf.util.HSSFColor; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; +import org.junit.Test; /** * @author aviks @@ -122,4 +126,22 @@ public final class TestUnfixedBugs extends TestCase { } } } + + @Test + public void testBug57074() { + Workbook wb = HSSFTestDataSamples.openSampleWorkbook("57074.xls"); + Sheet sheet = wb.getSheet("Sheet1"); + Row row = sheet.getRow(0); + Cell cell = row.getCell(0); + + HSSFColor bgColor = (HSSFColor) cell.getCellStyle().getFillBackgroundColorColor(); + String bgColorStr = bgColor.getTriplet()[0]+", "+bgColor.getTriplet()[1]+", "+bgColor.getTriplet()[2]; + //System.out.println(bgColorStr); + assertEquals("215, 228, 188", bgColorStr); + + HSSFColor fontColor = (HSSFColor) cell.getCellStyle().getFillForegroundColorColor(); + String fontColorStr = fontColor.getTriplet()[0]+", "+fontColor.getTriplet()[1]+", "+fontColor.getTriplet()[2]; + //System.out.println(fontColorStr); + assertEquals("0, 128, 128", fontColorStr); + } } diff --git a/test-data/spreadsheet/57074.xls b/test-data/spreadsheet/57074.xls new file mode 100644 index 0000000000000000000000000000000000000000..c29485a2773f706a8c1853d2ffd1caf62022245f GIT binary patch literal 26112 zcmeG^2V7Iv*EaznhzhtsMNDxZBFIn>7qSE@OF+enjR*;(K!PDyabmUAR;v}Q3mny= zt$U+Zt=iU!Qg@ZazIef>Tz+&9iU>z;e=d3U}1Tw?R< zS6f>DMtG?oF(H*23u4BB3*Z_vP1c0C!3Ew|YBU-KNC;fkr+<+JUW2Y4P;+!}Hl$o7!i zLUw@M4zd{XJCGeAw};#Ta!1IWAUi?s4A~iS7sxJR<#_@6lE5T>}yX5|XG6Qd$Fb)2AoMXUkq&`Dm}6s5B%C5wv2n z24r2kljg@Dnw!DH--wWGHa!SOLT*4#Aeq?SgOnL^g*;6ht4>T#m#W17tto)&kSIVM z4uGzG;YvXE2&^y)#ih!#hALHQqm;_D0zkBeFoTHT3~+2lkDDmzUV7{cPf`WF1vh)O zYTpwu@U;~$>`(DNr$cfy;wxh!%PqddZdE$prh7Ki&WsyQpbTQNrtu@43Dk`F!al6`bLbaU_-tX zeI960n>Sjt`5Q6%yb+_{8!!aKk7p0QrUKIa4HyJ4jC+RwUZZTi)#N`7-@rpieBOW| z055%$6pI>pIGEZ)D2La!V+Y6fUE8;JmpJ!M=*-?EI6IiW104f+g|i@dK0HR6JVGDI z5qb{rj%ShF-1YguJ+g8FRUP?QJZ@T4A9($H5+XrWx`IiyC zI`@}=6gTKSK>tC~nM>D2%q8j~)}!!)K1MHnVN411l zE=x>Bb1Ch}*Vv6>P1ifYmA!N@ZA%KVJH-ODmggWikk#1NVi7DF09Zb8DZ?V@Vajim2;9MhI55F&2 zOCT6?1%U#oybR~2GS!y0BYiAu@JF*_Tq||eOhV^3hKEe4{ z+LI;ZPmLG?6`Kx-5srOh3V&7)|0nE#Rum91YfN~x@$9@^`^a>;zWsIZFY5?jS_6Jf z{5RDR|9?gw9Ai=Y>+GRBDm=u>-mQ4M^y)BtDfQ=NZJ_@C9lXLk+ooi)H~;=hC9 z<5*SSJ{u?;$E*}S-^Qk>O;H7}m z)&T#;AiO#7r2L<0*%O98j<+dXSHEki{x~M5@N*=ZkX(2tF!(r5uY%*yoPp!mT?-e( zWpy}DE{^RfzRo^O{o*)Z%V#89Li}X-<9q;x>-1bl_0+}50@lt99L5nk{*0a3_F}=n zd3H8u@p*dUJcCxBL_)Uc?11wS6wbrPc?}w8(ggxrv8~wJtc7@js5zN{2Gu1$a&=6s ze4@yeOw@xTf)M6Dn$vL}js)my2wp8spwlF*PQVNn>OjEs>gzy&1I{|BgrmMX5unNH zM1XZ(CjzY8IuT%{)QJF_MV$z+z0`>S8)}^hFf!GN0Gn8y2(S&;i2xg=Q38Knd%!4a zQgeGSr42UOPB}TMH(}YX`z|ZI~FZ9h^e0g(k*p2j`$`!Nhp& z;3Re}m>91e7(#QHz>WU9glRjTUdC$&r_rl4sga5C+QE7FS}-wQJ2;VF3ns>EM_fB5 z#%t%D+A%R+J1{Hp=Hf6*B{erdT+Dc*O_;TonwfN{9TVfV)3J6;jMq-5+A%R+J5IG@ zV!U=b>zH7FseqVi^!j1gcJP7b$SF;gVdwH*Ue17FPG4S#`)VRF%%r@$T*t&*%XsqS z$r`aXi44FjI56N%Q$qu=i6XvIxW>gOg&jLg21{00SXfOdKR>@}N^xPVQV3&Mtlx>bA628w}BZzP6WUz)su?8gFxd!9;Q9t%tYg7oQYR$nDAdW{Ce#UOscA>T5+no za}OY>YGZzWV+I_-upLEU4MlOt1iW_cNrMR%_AqZyUIi6R|Qq>81>k;r>RWMOBnD;v90|cfuk7dyA{HDrn zzU=Fux+Z;fnxMNuW$4>;qNp=ZlYW3E09{bviEw#pOzXH z(~K{sdv!5gjEKR&X9AT1hBBAR%6@%lSWI)im>$)|xET?H;ZiF`1aV{7$yMH(pX4kukT$lET$!j>2BQ9+JTtvweYm!@Lk2X42!Yli!tD7?Tv`xdRlS# z?cKW!i?QR2G2m%VM#OMEtvLMRt-XfDwBm~~;At*K#Be>WIK244Wy4}x^TinOv~EVk za6PR!d}rxh!(!U-#Tf83FC${Oo>m-QaeljDG4?3N+qkERL5z1TJk8VV%WW4KF&NMw z>0(-2z8C|Z*1?DvuBUl=U0V31VKEMTF$O%Xvk@^|PxJITbYY2MG41$b40u{sBVxFo z=IOQdt0RWRi1}g+c$&KrFobJpe>co9(~eb4!CUxDoq0^T9s-L@$tw*r?Nr4Se1p%_mB*Cp4}=U{f7mcnrz)o4 z34Ep=Jf_^*C*;L~0fv~0U?(Yb;Q|tq^F+S-H7{tRF(Cmk$V=9}fg4~?4JHtD^iA-OUqP!6q44xd=>^CZ&l3rRnK;qRBkHY&8u*uTrKs$xpM#^f1{d6;(R?Ho%6?4aG#oWykni7{>6HT5-tglJ~ z6A%(eH?HBXC>^Rv4*X* zV`0lA*1dw(KW=f&0h`BxI%B~fa7e?}K32BYy)2+?FqjWfD#1~E>+=<~)|iqIFq)F* zsyGk9@&aKjuO_ew3Fgv5rHRRMMT!{43Oq$ktiiIOpb+}L9289f1(`7dbpdEF?ZPH9 z?9dg>K{F;0&J#9)K?a98#6CWA8w1Rl_*VmSjo&v1u0cVNxfho?#6UjtrUsZZaj*vF zOxHk2nRn+hhgir92qw)8Fvobv)R;NfEc1j7Ne`$<5~j$^23N?|uQFkCC=c!@&IDh? zO0Q~YIPbw$8cvS0I6RpF8 zOXU)1j$Zn@3J8dd1W#Ady{*VfYkdJ+Rt;7yVE-7fh*YYjd7@GJJcJFQy&w-YD1}q) zIO?IQz?=#j(r`YcD$p`_Y)E77*pSBD%@bM@UjhU3sBAT@@eg@ITL9}QYJ=)^&JFn( zA@%AU0acnXcdRDN9jgg*hoP)jZUeAg2YnS9G=PeThBB*k1AjCbx@vE9)i}929jxV{ zPi0~S)e{Hap@xb>dsX*#0kY^rSt!-$0lc{flU9@k8l0(pQ|eTD^9yKqHjXf*W$)0% zY)D_IBQi8mrNEHIgjYX(MTM3SsfU6D6|^fhY8eWv_!6fUo-K+evpJI_UqI<>;173C zkD{fG1(kE?RRokBgCTwp;0soilQGnTsxYtxrNCQM4WZJTWaf4nzdG?B&ID461qYQ*2 zeJ(QJt8j%vL2yC5f4tlB`svN-a?&W=KIL3`chKTPI>= zm?TM=jEH6w5m&58GY(=MWSYgl0*cAluO%0I5F-fu(X^EO01 z--gInkBBy;riQ$hjR5*h0~ZcSOGEfE(oAUl+NJ?AFn;0mz8(F9mNc)KhQ6+GNkg0L zV2A*zHK%z;W@n6&s-k3i?GH7~f+pUOHgQL!X~dyXrASm%Cy6{6u&`rlM?bqH)*LMO z&`ZUOrIr-4T0G)law2IXitK{Ixq+7=8;GNgDSEZQ3y~JaTxtVR6#JKU^vhAwn4`9i zKpR8x-C{>SA|=fYp(RVRl2r0c9L|F+@XwA0J7Qx98-{-=*@-C_obh8ZWAe4Z9_#y{ zKm-{+e|;bz74S70dH`mS5GT!2dw6->AN*PCeeh=~Y>tm)8 z;x1wlsrdHknTS!*ei91rLg6m-_z{KV;(J`1Izn$1KHn8gfhPw|QC17cQz`Z|dh7() zGMaAt;m1Mjb!Q!yyME4`>j?53_E81Gq+J9Iv0|ZBc)$Rqt_ivwW><-weV``S97}h< zp;D9#XDj$R5UV#{h%Ocmy+SqoVW0XxPiS9EXc4p}-b25N>H5Jnn}Wh32Ro8Q!gHoU zwudfXzs|z(%<^Diw(P|l&jQ+$WBXBWM6XBq*I0n-6N{jNVY9mX`H=paoDV;ua36+iqIlOTFMhT`IrK=6D*VuE9X!o$g6g6g4z5Jjy>v;vXxC ziy0goH!PYG1Sh9Rs{{ za`p@y_|x#l>GnfymJMIt?7Np)pSHi8eIsGp!cGUb%qu9Fydiqa(w_4By$*XHnsMf6 z&&Z6QwzNH>C|Iz(VVAFW{@iYD(7}wa=DxQhIK` z@&+qoa+R_%6UR^9SakWj{PQRB$Nzo%QIXdlw@+U6{X8OL>F0$9n+kh)mtMX6%em9< z*&mqh8zgbQwPp5@_OnXN8k8(pwT?*o_xa(QbBSp-d%BdlEPgzsQus&F)NZR4Q@?KU z#g^g9F_Y{|O^!?Unw744RowJU$|=WvFTAf`*;KLLQ*D0hrRu|&=}}LgBptFfOLc8E z=fT)ak3CNFmGK|_{@wBEV=Kaj$=b}ZKlfY1W#xNTh|;$Yvh%sO@5o<+uSHL5p_sO4 z`0e6-SH9TY_QcPnCY4=+bB3%5UMeqnkT*O+-L13Vu?l(FrYBb_VivwStWqoQ{ncr} zM29}JMpe9jB+~s>(TIw6^EJYf*E7r4EY|eD=6$IBQ1z}^YZjVLQ>J|9HmEX2G$N;e zyR)sW@7`&9_ffAq)+M_mUfM2Ld1YnAwmy~evW4!NoU-LNeS51nj4#+>_SE-i`~Z7d zS8JauK`>p}qD%KNW;Yg;mKC?P`Z2=yR-@UyikFTns(4TR!>L~#hN*Um((|ur?2;-9 zvNU0T7g}9@ZFA4$@SyMfWH0W-{Wae5^y@*AwLj!IU%3!*>du;H+wM)6J;izD6~)1R ze@)r^`lP?-vcjGTMIn1vtt;xV;r+i)5AEjjm(+HU&!49|H$H3n@!f5AL*(W?lG0}! zKJX%O`zIH^@-G`0++l|N(e^2qkBVBw3RVREGBPab+tc#!j1z9dM+uu0&E5IMmcjdS zY?QMS%N~!K6x3esbTu6mE0u|kqE`S#>>Pal77C$U=pNIiAr&}f&~ z3-L2&mJOLZ`ul$6%~vjZnpO7U)5GI_vi{T8=E&G#k4sO!sFeNq<(ROSS$*D*TXAa8 z`{Jb24^F!dp49h`cgmEb_Q$+D`S5kgFRJO5Hy%{RzjSf=dEYk`lNbA~oG`MZW6G4n z1)DbR^bj_@alF-{y=6E0pS*pgT6D?n_OG$)F9r0>-yb&jQc&-aN2G2EZJs>rcfWA7xb=$O z(p4M3?ltn$UEPbk(|);qwkUY$<5L~qyLafz)ZHKS>0PAmQR>uB)8u)1jO|9Z_@^_U zY)ni|%fI{CzS4uk7G_%wkNErUHww!)VdduBsPo}T;`V*F2 zR&Kia%Dkd-l*ehOW)&{KUwPSojP*r_yALM*_*vBM%pE^$8$&I9f%EA%KbSTqKE!6r*EeR4^f~v{^-o={ zJl#KIf5%0yY@F7cCY<+n`{~fGm3fnHnO(FWH{<=OZHJ|tXqI{Ymq9MQc9`3jmI*H= zj9auZ;NjZkQR;n`7iD`|r6kW-vijjLufn1a#!l>h;;-AM+i$lU{n3^Up)*gM9^QAe z@3?ix_AKA=^CV9jrymzsj9I_q>H3JHnfJ4jk0^SH?>RkK@4aEa{REq#>j#%gn_b`6 zJuKv5&(VSJ7X0Ga>QraPhorQDBL7jE&7}>OX0^4v*L7*g{nu$D+ibmg|HYJbji2ss zSaS1^@h0T~hmTzPX~xn|2j5gobqP#=;#;}!Ouo8tMViy8BZK9c^5oFzUAvUcbxeEG z*DoP*(~SLN4t{@OS7vEL(?FH?^B7Gd^^iMWTRmU3+7TczA9*C|m&%`ZU078fI!89* z(6RX&nvL{Wy4tPa(!we04t>0C*vi0h2|G51wzT>Dm)(fF>l!TUCkpyu(Y)oap5CAT zYVPPQ%Bax7(424E+1_}!-}G~{kJ%gw2wGvkEU?h|PIRY)hf(vlWu@jE_nq%B^v1EE zVg05Lx%qCTgSgXmlkgcKgO=?#?|k^ngf%}ste9E;-kKJL=j0yWMXuU=L7o+JfBT{l zYX-glVEb<8?AA9`_q|U3(JFZ3gY7xa*-LJ$4LkJZm0lYf4OP9rs9$8}>QLWeOWQTK zKE5})M^sLNTlt}u3CFTCiZ`Y?Z_3X2@ZAyXDhKD^lI-4?_Bi6(v{pk`U;a`RcTx4x z@`CG{==-xrzjVm5E3x!XdQW+0_N-y$+b)DH+Ir*Xb;>6DUR_aC4$6YXLi=l-EnKEP znET_7p)r;Imt98Y49|?|?Y+ZZQ!xJ9S*0Vp?Hp+Jeuj^1%x{|?A3WOqvW4|N$$(g| zKvkntq~EP;1HV|eY;JB`NtdkyR^>}j{fva@6TmT zhFxCLL4MggX`92&?K_T_xTmiv^~xK6`pkm63r37OxnF+m`HVu>c?q2!IqcXj%{!5N zGHJoiaMj|ycXlB-!ff}#t{IDOec*L;>1KGo?u7WmGiNR|Iq~Pn>y1x7OR*R@ynM@_ ziO;qcZWu9PYs{0`7BSD47soZdu(QFozaO>Ry|gHQ=iY{CSEl9k?Z0Q?^V~KodT&1d zOLx`9Pj>kB+}-XA&+nC&OA|lYk&&lb*yH+aAN#zf$-RyZPR#iI&a8J;XF{$_nP9)} z^TM1vpKadRZZlg>^$JAQ0=ev?Jl=EQw}ulMQ~ zoA3EVEV&k#fBo64d#~-D6pw)4zXqxR4x^1bey0+uUhC#>Mqcw`p$k7ajaG;O2Er(&);w4=t3fl(1Xgz&2$SuiS4 z!$KxITEMZe8^FdwHia3B92iB&U`&C_$c^aO7H1EdL$6CIx{uQi+Jt?w<}j1*1=Q}4 zd(d-B_@3B<-g^MV8(?1a&J*t3;WtT4$r%6C_AHP3bG-%XEl_WPdJEKBpxy%Y7O1yC zy#?wmP;Y_%9~SruK4lQVdMvY2O<;{OUI@FiAf5GN&jL~ao1zP<7GSHHrVs9yrD-s% zLW;;ly6Q~G&bC%`X99t3xR`Lf#vDaLI^hnGPqaWQ@|vzF6M`Qu5^@nJ9qCm+_>OQp zZg3#|={<9p2`kbw^>h-#Peoc06LTsOw;{ll*&YG?)p2G=S&GP(q;P0pl@^DlCPB<% zHivutk?KA>9R2XrZ#L5rL}=uAJFay!|^+w>(l=|3sl0!12ejv6DpaL&@X=d zczOBDs8s89b4A3(Y1<`OOM{=zWH$EU^Zt-=8$&2$^pyn2O(El6_ePLsL5A=9$Rfzi zAb$-ReeD(y;cw3%&akjh|0wYQ|Hu#qhCwD;sZ=Qv#W9H)iCKvmITRP+5%MIJGD|5_ zi-X4|Nzhm7_pfQ)573YlvU+!zz3 zN=!cpPz?p|V@Od4?lR^7Y@l}CXbIeUl4rhKM>DeOkN>;{1hCBme?mMHzFQbY jKB%(*{K<80RICjHY(M|RRw`CjUFEZM|J3>4EdRd%9w1WR literal 0 HcmV?d00001 -- 2.39.5