From 9fd5fb147d012c6a0bbe8c7bf66ca042ed47307e Mon Sep 17 00:00:00 2001 From: Yegor Kozlov Date: Sun, 2 Jun 2013 23:39:41 +0000 Subject: [PATCH] Bug 55047: REPT formula support git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1488811 13f79535-47bb-0310-9956-ffa450edef68 --- .../poi/ss/formula/eval/FunctionEval.java | 1 + .../apache/poi/ss/formula/functions/Rept.java | 74 ++++++++++++++++++ .../TestReptFunctionsFromSpreadsheet.java | 31 ++++++++ .../spreadsheet/ReptFunctionTestCaseData.xls | Bin 0 -> 28160 bytes 4 files changed, 106 insertions(+) create mode 100644 src/java/org/apache/poi/ss/formula/functions/Rept.java create mode 100644 src/testcases/org/apache/poi/ss/formula/functions/TestReptFunctionsFromSpreadsheet.java create mode 100644 test-data/spreadsheet/ReptFunctionTestCaseData.xls diff --git a/src/java/org/apache/poi/ss/formula/eval/FunctionEval.java b/src/java/org/apache/poi/ss/formula/eval/FunctionEval.java index 3ce3fe2772..d66e878c92 100644 --- a/src/java/org/apache/poi/ss/formula/eval/FunctionEval.java +++ b/src/java/org/apache/poi/ss/formula/eval/FunctionEval.java @@ -89,6 +89,7 @@ public final class FunctionEval { retval[27] = NumericFunction.ROUND; retval[28] = new Lookup(); retval[29] = new Index(); + retval[30] = new Rept(); retval[31] = TextFunction.MID; retval[32] = TextFunction.LEN; diff --git a/src/java/org/apache/poi/ss/formula/functions/Rept.java b/src/java/org/apache/poi/ss/formula/functions/Rept.java new file mode 100644 index 0000000000..a971e6b6d6 --- /dev/null +++ b/src/java/org/apache/poi/ss/formula/functions/Rept.java @@ -0,0 +1,74 @@ +/* ==================================================================== + Licensed to the Apache Software Foundation (ASF) under one or more + contributor license agreements. See the NOTICE file distributed with + this work for additional information regarding copyright ownership. + The ASF licenses this file to You under the Apache License, Version 2.0 + (the "License"); you may not use this file except in compliance with + the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. +==================================================================== */ + +package org.apache.poi.ss.formula.functions; + +import org.apache.poi.ss.formula.OperationEvaluationContext; +import org.apache.poi.ss.formula.eval.*; + +import java.math.BigDecimal; + +/** + * Implementation for Excel REPT () function.

+ *

+ * Syntax:
REPT (text,number_times )
+ *

+ * Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. + * + * text : text The text that you want to repeat. + * number_times: A positive number specifying the number of times to repeat text. + * + * If number_times is 0 (zero), REPT returns "" (empty text). + * If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point. + * + * The result of the REPT function cannot be longer than 32,767 characters, or REPT returns #VALUE!. + * + * @author cedric dot walter @ gmail dot com + */ +public class Rept extends Fixed2ArgFunction { + + + @Override + public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval text, ValueEval number_times) { + + ValueEval veText1; + try { + veText1 = OperandResolver.getSingleValue(text, srcRowIndex, srcColumnIndex); + } catch (EvaluationException e) { + return e.getErrorEval(); + } + String strText1 = OperandResolver.coerceValueToString(veText1); + double numberOfTime = 0; + try { + numberOfTime = OperandResolver.coerceValueToDouble(number_times); + } catch (EvaluationException e) { + return ErrorEval.VALUE_INVALID; + } + + int numberOfTimeInt = new Double(numberOfTime).intValue(); + StringBuffer strb = new StringBuffer(strText1.length() * numberOfTimeInt); + for(int i = 0; i < numberOfTimeInt; i++) { + strb.append(strText1); + } + + if (strb.toString().length() > 32767) { + return ErrorEval.VALUE_INVALID; + } + + return new StringEval(strb.toString()); + } +} diff --git a/src/testcases/org/apache/poi/ss/formula/functions/TestReptFunctionsFromSpreadsheet.java b/src/testcases/org/apache/poi/ss/formula/functions/TestReptFunctionsFromSpreadsheet.java new file mode 100644 index 0000000000..3aebcc5050 --- /dev/null +++ b/src/testcases/org/apache/poi/ss/formula/functions/TestReptFunctionsFromSpreadsheet.java @@ -0,0 +1,31 @@ +/* ==================================================================== + Licensed to the Apache Software Foundation (ASF) under one or more + contributor license agreements. See the NOTICE file distributed with + this work for additional information regarding copyright ownership. + The ASF licenses this file to You under the Apache License, Version 2.0 + (the "License"); you may not use this file except in compliance with + the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. +==================================================================== */ + +package org.apache.poi.ss.formula.functions; + +/** + * Tests REPT() as loaded from a test data spreadsheet.

+ * + * @author cedric dot walter @ gmail dot com + */ +public class TestReptFunctionsFromSpreadsheet extends BaseTestFunctionsFromSpreadsheet { + + @Override + protected String getFilename() { + return "ReptFunctionTestCaseData.xls"; + } +} \ No newline at end of file diff --git a/test-data/spreadsheet/ReptFunctionTestCaseData.xls b/test-data/spreadsheet/ReptFunctionTestCaseData.xls new file mode 100644 index 0000000000000000000000000000000000000000..572f7d4bbf626ee79e146b0bc89368ea4aed2e2a GIT binary patch literal 28160 zcmeHQ4RBo5bw0aVNh|*#$r#)G+0SbmOSU9rNthoS%aZ&9jr=pRC{WBePtudM^=eny z9~(2cC@su%3P}^2zy#dp2WZ-c68;M5losf8LfSEDn}(qwo|JSblTI?tK$B^b0^9Gq z_r2Y>Z{I%ehBR#_dw1^cyXW0|&bjBDd+xdS-6#G1-?hK-xhF6Bj(E~GX^{8xEz;zI zhj4v`Q*IO7&*xcmeg|+3P(A%Wl0Zuoifn3>!+ozb|IK_znxOFSNLZeTyo7I&e?dMd zbF_m=YbqU|G=4E@Sn*(n$is^;ylX=dSY%jEBe%Ont}H_j&jZ$#bgB>k6_-R?1n_kIE<5EG!evp%F19A#s_I zG`@e4HA3Lyc?#eI@zHY5zAQaQjgSnSgO8B3oTElqmY;)4L^K~zM@6Z(2jb`oh2*M0 zJ|gF=aTXR4jN`0CWRc<{h|_I>oYKYy&RJvYIckJtFtE2XKE0i_?bx&}xf&Z=P?3+7 zkxQfznw8kv*qW|2YkCiLZaLWD6b^Q-jI4&|xTNI%Eo0Wyt)-P>(kz!2EA{l2;z60H z)?+xtytO>o?5bDF2I&(yL{>H!4rg}pV21)6?A&4lV%;(DeW+vmAyDa&PJGbR-EM>7 zZnVKDX)!2Wa!n~Q-GfqkiZvI>!NDTY&9V{tC=zwr7w9^T6=`?N3*-@j2anxsWnx?G z@4czm%E(3Xs9b;>!GO-}=Ut9${y3Ed)V^ZjmvuWJ=ZPKq^>+lHXKLJE82`HX!h@|jZk7vO(V0shAo;Ez{;KU4w!r3&!JD!_lQ0{or| z@Jjqt!vD0w(+sgFJ1ofI_bb3PKjrl`KjrX8D&Tpt0{oc@@V~48|D6i(KdS(*m7hOV zc%o(U(RR|}!0&5se_-JQ3ng;Ds=uHBpPqhU)eEa6@|=Pfia_qCS0=%mN ze1k81A#nQnlSLKaiye4D@7m7KbKu{Q{kU9(cvSHZ_o?w~ILK)@ys-l}aEWRj_zwY9 zNyFQ5?Z@X52VRh;9xvxR@NdY6ae0x0f2jj6@c%_y&Nlwj?d{7JE`wekRB%iVnlA8b zy=Z+kA(r#g%QC0FhkwlePJd02Z3X$PaNwT$0E2?TADwK!#6n0qgwvTyUN}3*WWyVA zsr(xaQY9@)5gTmR525H^-vck9Yn1SFM|7#&QJ_cs*U7`%pSklyv|CP;zW0eWfs4Nev8HKqP9S+A>P13V zSp^cBVPz!rt5qPOX;wx;CtL**nrmewbZAu|p$S(;LN{Io5}I{oB=qg)L~>>{SUa2u zsz4H~9nKn6APLsah1DSm)($4tYB&kj&c)Rs3DyqQ&n`|-D4k36*y-yJ)(+O!)gTGh z&dTbL1ZxKoLN%NOYsaV#Nw9WSSBE56JJ^yqcXtGvMnMB`O?60uwX?Q5B*EHQR~?dI z?OawJl3?wuuMSDDb~*}37%!ccrhG{p#<9a2`Io_pVd)CSbmOfj%i$=;e#5vJ3#M<0E( zjH$uF!7`=@^D;%4gWF-s4J(ggH==rAT;Pq9yJ~IFU2B7$S{qzmXh3aKfh8tW-s#># z18Rcdou`2}j=@%+?J`IK&lgH5II8=~58OuSMS}fJm)}t~;MPBljlf{P(_ame{9rJW zfohO==O?cr@WEoya>}|>F7?eN4H$)cr0yLsSE5F76b}v_^_P17%%{r+%+GHWd$o8K zn9}i%uWNB!Mt(k2V5&SWzPbd-X{&-g<-d2@g~Tf!Y+<|nN!g0kG0J@YOaY1G<(^lD!c@nR9Iy9^{z9zjiJd&E1BJNGP*}jGNQ3lD6%rY7*9}oWt|w(jXWfi z_*jyZET8s3g&{miY>rsdXWx1|-^gnvV9BrJ9udj3d&%^blZge8(UXKC(`Ze%SdJ**wR*k%s>^E zc4qX;XWsNDv)oI@$I{jWka1hunbEht{G30T6<#tvmbN~CjN8)AjQ-P`&-;_P&`ZY0 z(l!Q=aa-D%(K9c;?oZ|-FBu<8yF7r5+tSXAKKJeK`jffXOUB32`UA+gE$z(cyRSau zPv#Pm*&J+X2FPr#!qWQsKlSu$nheaG2cil-?NTopA4^*sK*nupef_WBf1f{@m0mJF zmevtK#%*bR{eS)1L;hq|dCB-#T2}xWx25&DnSv*pCD z;G2{jj`5iYz2cHW2*z~$$A{*x$@+YH4DJzW)ATk1x%;IB$lnCo~%{QTLho^26P6QY08hE16i_CWq6LX%+iU%JD*rp8009=<&2@&Mzu!QA+Cqxtx!QciuLaFq39B zl|F8aTeoFTMt7H@3SW_Llbv!K4zN=9Nu~c37^kAt1tU=Li(IohYPZS#sq?|cim z`;Z4^OMZ#$g1o4%lpF(+DImKJDCcmU1~d*rM+#`0VWaah@1Si#=#TA`-KiApe@iLu z&_(%(>;~49X9RF3$YBwEaB!W6O^&)TgL9X3u1?2g`FTB8|0g(^5k;AomkuUK< zuH9<| z2_uv1lXE$kX|7c7;iVAD^-#|o#t99w=$g12~S=nJYr4RzR7Fg zE8sInZ6nskUGz>3g^^P5la6QP7F83ZzeuhI|FYN0Wz!~HpJ&ntU4lttFHDj>O~Wwh z^z<@F`FiY8IsHA2jjY08#2A7O`bz~D5|G@B;gVL)i>PcBhH#0Q!*1S!1DY`Hy{W8q zGCEO;BfJ2EjySSlO3*)NR^U#T<8HZ2Rh$HL$#J*3Bto98PqJ_Pcey5wcrb%0go!6tQ2qEN4@KB0Cjc zAlK4V$K%-qq_wHERYNP(GY;#>LUEK=`H%?_#WsZ^m8AuE_C*>lR46ELt^J5Hs*=4A z%H45By0=b=Cf1IF&x=HEG}B4?J?;7jOBoF>#4K_nD5Np29M|XP@)=+#34c6#lYHE@ zf%6IUt{tCoAem6TJph)EtE)ZeJ3VR+c6T+T7?-2Uf{Habf(~Pb=T^^V`7q9ki`+Ny}yyhZVfp;K~ zq8P(YN+qq~9u|86%gmGN=^K7@0Zrd@3_zS=nnqqhlN`CsWBR zcJqj65|Nv+-qzFl)kFOT+Ti|lJUt8NIdNQ(BL2=v#3Dy6L?H^9F=1umQw|kW2L}+L z!VShU#&jw@i;&f@j+%*_id=0rP4WiTO(T;vlT&7TDxLu;);F^~AAvhb8tK$AV}Sfw zCVHa?cCpQ*5`M-Q?i%UZLDtfiVIor=`kpbP1BHwc+od^(br~@PQPyM@RK~1KE|HBH zAZ)}&QnRy=L+o8R0w7RQjAyO1i7R6&bu4L2r&F_vnJdt_V_?-Va>;Bw0p>|Ei+Ie4 zZMBk9+hP>lbSekD1wM_T9y}d@89*)Z>P9!)#-^bq}Y!iPNve}t^<0T&Lt=d zV=|XcgSo_UP|W1!=2B_$KVi+7N8_nnx)Z4PQ2@svJ*V$O#-y1<9qM066gN~C=|RZw z;dClDN4Y}48B|Q9j`bKXVanDfW$OxU(@IXtLX^mjVF(0LNv5(eyeyPLbe1DlyLz!- zBVDS3%RG<8VQFcL{ebkQ&3Gc0w$O=j+OA#97>6y~O@az^Fr}qNLK$ceYagXH+J@b& z42)tLz~eoi$6~8skd~qCaln=fs!f*LSDl({N4IE=_M zn!9h8NF9S2O3S9ebk=~hm03-hS+ge;!a@$#nwd%E64a%UHIGriNwk{~bKxFpv)vT_Mnnd%R;&N=MB!Mi~63@~X;RaX``l3KXt^Cz;D) zm2p5zlXWv3E(F6#aIP>WAiPNo@WVN}8Cw#VpmxMFSkoP+hlVj^)2!QXWaG2YcgKcq zemW6WZ8*daLhSBB!sLXZs;9I=x&f5dYjoUhrBj_<#@NpN;}~SwTpAuY7Bf1m*|{u? z5q_$(CnLgPjs^vm3YK9SQ_$+HY1;!w2>qEYK0`Yw&9J79YnU7OPsb0>WDU**>^>n5 zCTJ&_?OEsQFQ}NA8Dmqg)7e7Dx;stngo}=cs8oLnT);RvPB3l~spMe{&g=}#wZE_H z%FS0AlQU-8gpW^Sctcwyl34SrL!&qBT-}4ydr5c^^uXdm*X=4EYC{j+{iC

GPmhTRBx~@ORm)L+&M`jVB6#7;A$3f>eYn;YD%IP8-Xi=KBaxJXV4d5awCzMV^ zP9|Ep>_A-3Grjg{6i5OAU6^NZ84-4|h>KPQW5Em4kz;AS2A_IRds$mj_u^wL8Irq* z0vDPtJID8O-7ucz^1`TjciZ=rE%3z(_K+p^fCrLwi3nS{jjisHWUH#dn&g+(pzo2> zR_;Zrn&feat3*{Icf+ba+mWv!C0CZn(Gb_T@)|d8)EVVxD$ElQlYm?6PoVn;_Kg1urO+my^%*Ay zHXisl33#4_JJ0s^;&41EdxrMjFf=M-I}hv_9hDoBal{V1+Lw+a+)_(U*}rdWd~E3Y zaoKOqS?L4u+btR0IX=E~OvbDXRyK@DWuFR7`w?^|Qt3UZDNFhWCg$eIlqYdsYr$-* z=e01#-A!RCpQ(#4e;sLU#R^&>qqc;7WFw& zS?0FGvx|%6CU|!D{V3+swc#Q@?utmHSYC|T#kudyvxbre$FMWcHhJb*Quo3*_jqBP zfxIxzTV5Dxd10KByfDrpUKr;yFO0LA7lxNLA**5>z}b)9ZiEt1^CbOWD?YkJzcr#} zOV*@bMpO%3YCwrGS}5EE4Mk)J=&i;teYH;Xpe>l{7RvH4V*Hg2GPF{f!|Kn_=#Zb7 zxYN~&jX6z|e;1@xy);O?qjHXcv>WVwg?TICdr5@#jM{ z>PCf{0UuG*Y<8v?lY&zlua#-!|TRNa+_#BI{Rf70xeet#@yT>5 zlbX&NJ8#2YleU7bTjn46$X7$#aew{~qg%gq=xZT8^Z=-*x&-PHs7s(Ofw~0h5~xd{ zE`hoP>Jq3+pe}*B1nLs-l|az?Km6(|ub%F?xb4&fSpRqZzib#p6U{)OQ0@+x&-PHs7s(Ofw~0h5~xd{ zE`hoP>Js>0mH?mQbN$L^=v?CJlSajLHP`xF9dp^sH9Ob1Ja@}=KiBv?g~Mn5T<7y7 z3J=S0t(x_r5*Wj4i+mH)z{wq+Bjl^`wWMXzs7@x6 z8tur4@>}FZ^^L^tAWo>n{&Qv72P#g?U49iY!K#PL%t{k25F!GqL@lTj)B5eV|2|1wx@{9N@j L^uLRQZTkNW%CjeG literal 0 HcmV?d00001 -- 2.39.5