Hi everyone,
I need some custom formatting (If one field of a row has a certain value, I
basically need to colour this field and some others of the same row.). I
did a lot of try and error with Excel Conditional Formatting, till I found
out from this mailing list that Conditional Formatting is not copied over
from the excel template.
Now I implemented a RowProcessor according to the example provided here:
http://jxls.sourceforge.net/samples/dynamicstylesample.html
Well, I see the processor method being called ( public void
processRow(Row row, Map namedCells), and I am able to debug data in the row
object during template procession. But what I observe doesn't seem to be
consistent with your example:
*>
// check if processed row has a parent row
if( row.getParentRow()!=null ){
<*
--> row.getParentRow() is always null, for each and every row of my template
*>
row.getRowCollections()
<*
--> is always empty, for each and every row of my template
This is my template:
[row 1] header
[row 2] start outer loop (product)
[row 3] show product data
[row 4] start inner loop (product.customers)
[row 5] show customer data
[row 6] close inner loop
[row 7] close outer loop
Needless to say: The template works and I'm able to fill in all the data.
It's just that I need to find a way to change the formatting if a product's
customer is in a certain state.
Would be great if someone could push me in the right direction...
Cheers,
Jan
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user
