#82 Excel formula doesn't work after I updated the version to 0.10.0

[Motohiro Serizawa]

I was using following formula for JETT 0.9.0. It worked.

$[N3-(IF(M3="-",0,M3)+K3)]

this evaluated to

=N9-(IF(M9="-",0,M9)+K9)

But, When I upgraded to 0.10.0, the formula doesn't work any more.
it evaluated to

=N9-(IF(M9="-",0,M9)+**K3**)

"K3" is allways "K3".

I figured out this formula worked.

$[N3-(IF(M3="-",0,M3) +K3)]

There is a space in front of "K3". This worked as

=N9-(IF(M9="-",0,M9) +K9)

Please anyone tell me the reason.
I have to explain this matter to my client.

Thanks

[psn1]

Hi !

In FormulaParser.java:
....
case TOKEN_COMMA:
case TOKEN_RIGHT_PAREN:
case TOKEN_DOUBLE_QUOTE:
addCellReferenceIfFound();
mySheetName = null; <==== insert this
myCellReference = null; <==== and this
break;

[Aron Gombas]

I created another ticket which may or may not be the same: https://sourceforge.net/p/jett/tickets/84/

[Randy Gettman]

Motohiro,

I have duplicated the issue, and it was an error in FormulaParser. Psn1's fix is correct and I have applied it. This code and the associated test case is now checked in.

This will be part of the next JETT build.

[Randy Gettman]

This was included in JETT 0.11.0, which was released on May 14, 2018.