Sometimes an unexpected space was got behind the data of some cells when using HSSF to read excel files which are created by Microsoft Excel2000(9.0.6926 SP- 3). No complex formats are used in the excel files. OS: Windows 2000 professional Japanese POI Version: both poi-2.0-RC2-20040102.jar and poi-2.5.1-final-20040804.jar
Created attachment 13378 [details] This is a sample excel file which the bug was found. Unexpected spaces will be found when get the values of [MARKET_CODE] column.
CVS HEAD with the richtext support now corrects this issue. Jason