The problem might be a little more difficult. When you serialize the strings,
you have a list of Strings and Rich Text Strings as input, and you output a set
of 1 or more SST records.
When you "coalesce" the string data, you will end up removing some of the
strings from the input list. This will change the index of all the subsequent
strings in the list. That's not important in the SST record. But the LABELSST
records (which contain those index values) must be altered.
Here is an example. Let's say you start with a spreadsheet containing two
cells. The first cell has "Hello", and the second has "World". This would be
represeneted in 3 BIFF Records
SST: String 0 = "Hello"
String 1 = "World"
LABELSST: Index = 0
LABELSST: Index = 1
If you change the second cell from "World" to "POI", you will get
SST: String 0 = "Hello"
String 1 = "World"
String 2 = "POI"
LABELSST: Index = 0
LABELSST: Index = 2
You can see that if you try to get rid of the orphan String 1 = "World", you
will have to change the index value in all the subsequent LABELSST records.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
