#17 The "<>" inequality operator is interpreted a tag and results in parsing error

[Aron Gombas]

Write this in a cell:

| $[A4 <> 123.0] |

...and then try to transform it. The "<>" string is handled like a tag and causes the following error:

net.sf.jett.exception.TagParseException: Matching tag not found for tag: <>, located at Summary, row 6, col 1, within block Block: left=0, right=1, top=0, bottom=6, direction=NONE
    at net.sf.jett.transform.CellTransformer.transformCellTag(CellTransformer.java:191)
    at net.sf.jett.transform.CellTransformer.transform(CellTransformer.java:95)
    at net.sf.jett.transform.BlockTransformer.transform(BlockTransformer.java:72)

Please note that "=($A4 <> 123.0)" is a totally valid formula in Excel.

[Randy Gettman]

The TagParser was being too aggressive in identifying the start of a tag with just finding a "<" character. It didn't take into account the possibility of "<>" (or "<=", "<<", or just plain less-than "<" followed by whitespace).

In the next version of JETT, the TagParser will ignore a "<" if it's followed by whitespace, a ">", another "<", or a "=".

[Randy Gettman]

This change has been implemented in JETT 0.7.0, which was released on May 9, 2014.