RE: Formula lexical error on ';'

Messages in this topic (3) Reply (via web post) | Start a new topic

.

With formula:

F24+;F25+F26+F27+F28+;F29+F30+F31+F32+;F33+F34+F35+F363;F37+F38+F39+F403;F
413;F42+F43+F44+F453;F46+F47+F48+F493;F50+F51+F52+F533;F54+F55+F56+F57+F5
8+F59+F60+F61+F62+F63+F64+F65+F66+F67+F68+F69+F70+F71+;F72+F73+F74+F75
+F76+;F77+F78+F79+F80+;F81+F82+F83+F84+;F85+F86+F87+F883;F89+F90+F91+F92+
F93+F94+F95+F96+;F97+F98+F99+F1003;F101+;F102+F105+F108+F109+F110+F111+F
112+F1193;F120+F121+F122+F123+F124+F125+F1283;F139+;F140+F141+F142+F143+
F144+F145+;F147+F148+F151+F155+F156

now there is no error in console but error in Excel remains: "=#N/A".

--- In JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com, Pedro Lacerda Pinto
<pedro.lacerda.pinto...> wrote:
&gt;
> The Sum function doesn't support that amount of arguments.
>
>
>
> Try Cell Sum, like:
>
>
>
> =F24+-F25+.............
>
>
>
> Regards
>
>
>
> Pedro Pinto
&gt; Technical Developer
> +351 213 58 56 39 T
> <mailto:pedro.lacerda.pinto...> pedro.lacerda.pinto...
>
> Sitel
&gt; Pç. D.Saldanha, Nº 1,
> Edif. Atrium, piso 3, salas G - H
> 1050-094 Lisboa
&gt; +351 213 58 56 00
> <http://www.sitel.com/> www.sitel.com
>
> _____
>
> From: Bill Seddon [mailto:bill.seddon...]
> Sent: terça-feira, 18 de Março de 2008 16:15
&gt; To: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com
&gt; Subject: RE: [JExcelApi] Formula lexical error on ';'
>
>
>
> I don't think JXL supports parsing array formulas. JXL has to
parse
> formulas you enter to generate the token stream Excel stores.
>
>
>
> But why are you trying to use a formula like this? Why not just
add them
>; together "=F24+F25+..." because there's no advantage of using SUM
().
>
> Or
> try"=SUM
(F24:F102:F105:F105:F108:F112:F119:F125:F128:F128:F139:F145:F147:F14
> 7:F148:F155:F156)&quot; - it works in Excel
&gt;
>
>
>
>
> From: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com [mailto: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com]
On Behalf
&gt; Of hbartolin
> Sent: 18 March 2008 15:56
&gt; To: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com
&gt; Subject: [JExcelApi] Formula lexical error on ';'
>
>
>
> I would like to add following formula in sheet using:
&gt;
> Formula formula=new Formula(COLUMN_PHONENAME, sheet.getRows(),
> sb.toString());
&gt; sheet.addCell(formula);
>
> I guess formula is to long, in Excel I got error and fromula looks
> like "=#N/A". How to fix problem?
>
> Warning: Lexical error:
> SUM
>
(F24;F25;F26;F27;F28;F29;F30;F31;F32;F33;F34;F35;F36;F37;F38;F39;F40;
>
F41;F42;F43;F44;F45;F46;F47;F48;F49;F50;F51;F52;F53;F54;F55;F56;F57;F
>
58;F59;F60;F61;F62;F63;F64;F65;F66;F67;F68;F69;F70;F71;F72;F73;F74;F7
>
5;F76;F77;F78;F79;F80;F81;F82;F83;F84;F85;F86;F87;F88;F89;F90;F91;F92
> ;F93;F94;F95;F96;F97;F98;F99;F100;F101;F102;F105;F108;F109;F110;F11
1;
>
F112;F119;F120;F121;F122;F123;F124;F125;F128;F139;F140;F141;F142;F143
> ;F144;F145;F147;F148;F151;F155;F156)
>
> at char 7 when parsing formula
>
> SUM
>
(F24;F25;F26;F27;F28;F29;F30;F31;F32;F33;F34;F35;F36;F37;F38;F39;F40;
>
F41;F42;F43;F44;F45;F46;F47;F48;F49;F50;F51;F52;F53;F54;F55;F56;F57;F
>
58;F59;F60;F61;F62;F63;F64;F65;F66;F67;F68;F69;F70;F71;F72;F73;F74;F7
>
5;F76;F77;F78;F79;F80;F81;F82;F83;F84;F85;F86;F87;F88;F89;F90;F91;F92
> ;F93;F94;F95;F96;F97;F98;F99;F100;F101;F102;F105;F108;F109;F110;F11
1;
>
F112;F119;F120;F121;F122;F123;F124;F125;F128;F139;F140;F141;F142;F143
> ;F144;F145;F147;F148;F151;F155;F156) in cell
> spec_385916308274_200801.csv!H174
>

Messages in this topic (4) Reply (via web post) | Start a new topic

.