XSSFCell.setCellValue(string) always trims leading and trailing white spaces

[Erick Lichtas <el...@linoma.com>]

Hi all,

 

I am currently using POI 3.5 FINAL to write both XLS and XLSX documents. I
am noticing that when writing string data a XSSF cell, the data is always
trimmed.  The same process when writing to an HSSFCell preserves the leading
and trailing spaces.  Is this a bug or the intended behavior?  Is there a
way in the current release to preserve these leading and trailing spaces for
string data?

 

Thanks!

 

Erick Lichtas

 

 <http://www.linomasoftware.com/> Linoma-Software-Logo

1409 Silver Street, Ashland, NE 68003

1-800-949-4696 x714

 

Re: XSSFCell.setCellValue(string) always trims leading and trailing white spaces

[David Fisher <df...@jmlafferty.com>]

Hi,

This bug was fixed about 4 weeks ago. See https://issues.apache.org/bugzilla/show_bug.cgi?id=48070

You will need to get a nightly build or build from trunk yourself.

Regards,
Dave

On Nov 30, 2009, at 9:03 AM, Erick Lichtas wrote:

> Hi all,
>
>
>
> I am currently using POI 3.5 FINAL to write both XLS and XLSX  
> documents. I am noticing that when writing string data a XSSF cell,  
> the data is always trimmed.  The same process when writing to an  
> HSSFCell preserves the leading and trailing spaces.  Is this a bug  
> or the intended behavior?  Is there a way in the current release to  
> preserve these leading and trailing spaces for string data?
>
>
>
> Thanks!
>
>
>
> Erick Lichtas
>
>
>
> <image003.jpg>
>
> 1409 Silver Street, Ashland, NE 68003
>
> 1-800-949-4696 x714
>
>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus  
> signature database 4649 (20091130) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com