Cell containing an ampersand becomes mutiple cells

[GoogleCodeExporter]

Hi Prasanta,

Thanks for your work on this library, it is helpful.  The problem I have come 
across is that if a Google Spreadsheet cell contains an ampersand ("&"), then 
the cell is broken up into several cells in the library's data model.  For 
example, if a Google Spreadsheet cell says "Ketchup & Mustard" then this 
datamodel produces three cells containing "Ketchup", "&", and "Mustard."

What steps will reproduce the problem?

1. Open this spreadsheet using the example program, which contains some 
countries and capitals.  Some of the country names contain ampersands ("&").  
https://docs.google.com/spreadsheet/ccc?key=0Ak3kVVPQFOAedEZBNkR0aEZvZEFXcGp4a2l
wMk44U3c&hl=en_US
2. Note how the cells containing an ampersand ("&") parse as multiple cells -- 
there are multiple values for "Country".
3. Screenshot demonstrating the problem is at 
http://xenotropic.net/apps/Error_showing_amps.jpg

This is problematic if you are trying to build an app that expects a certain 
structure to the spreadsheet (for example, just with three columns).  If one of 
those three cells has an ampersand, you get five columns in the datamodel.  I 
want to know that when I call "cells.get(2).getValue()" I'm going to get the 
data in the third column, but that isn't the case here.

Thanks,

Joe

Original issue reported on code.google.com by joseph.m.morris on 23 Oct 2011 at 6:25