Bug 59009 - SharedStringsTable addEntry
Summary: SharedStringsTable addEntry
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2016-02-16 10:49 UTC by Julia Andrea Rodríguez Amaro
Modified: 2016-02-16 11:31 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Julia Andrea Rodríguez Amaro 2016-02-16 10:49:46 UTC
When adding two String cells (XSSFCell)  with the following values:
"  O"
" O "

The method  public void setCellValue(RichTextString str) from XSSFCell adds the same value for both of them. 
--> Both are shown as "  O" in Excel file, this is the value of first String processed.

This happens because  public int addEntry(CTRst st) (from SharedStringsTable class) treats both string as the same value. The generated XML for the cells is in both cases:

<t xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">O</t>

<t xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">O</t>
Comment 1 Julia Andrea Rodríguez Amaro 2016-02-16 11:31:46 UTC
The problem is solved in version 3.13 (last stable version)