Excel StyleClass and Style Evaluated Just Once (for First Row)

[sgurevich]

I have EL values for styleClass attributes at the cell level of the worksheet, which set style of the cell conditionally. Based on the worksheet produced where the first row's formatting is applied to subsequent rows regardless of their context and the following Parser code:

   private StyleMap getStyleMap(UIComponent component)
   {
      if (cellStyleCache.containsKey(component))
      {
         return cellStyleCache.get(component);
      }
      ...

I assume the intention is to not reevaluate value expressions for each row of the spreadsheet. I can see the performance benefit; however, this approach differs from the typical JSF behavior, as far as I understand. Correct me, if I am missing something.

Standing in the corner with a burst bubble,

Sean

[nickarls]

There could be an attribute for disabling of cacheing (or just checking if its EL or not) but there would have to be a collection of used styles to reuse since there can only be 256 styles in a workbook. The equals() on the style would be largeish. Performance was one concideration for the current design but the hard limit on number of styles was another

[sgurevich]

I'll throw the idea of having some way to reevaluate styles on subsequent rows up on JIRA as a change request. You guys can evaluate whether it makes sense from your end. I'm sure that, in my case, I'll have to look at implementing speadsheet building myself under these circumstances. If this change request were to go through, then I might be able to put off reimplementation by adding text through conditional statements in EL form to highlighted data. Ugly, but it would get the job done until the pretty styles can be added.

Fortunately, in my case, there are only a handful of styles, but they'll vary greatly across rows. ;-) Thanks for the quick response and the knowledge sharing about the limit on styles. I was not aware.

Sean

[lavanyak]

Hi,

I am having similar issue, my excel StyleClass and Style are evaluated just once i.e. for First Row.

Is there any workaround for that.

Thanks.

[lascaux]

I have the same problem using style (trying to apply background color to some particular cell ...)
I'm using seam 2.1.2.GA ...

Or is there any code snippet to override the Cell rendering of JXL ?

Thanks

Sylvain

[lascaux]

I have the same problem using style (trying to apply background color to some particular cell ...)
I'm using seam 2.1.2.GA ...

Or is there any code snippet to override the Cell rendering of JXL ?

Thanks

Sylvain

[mfdonovan]

So I've been using this option for varied styles for one e:cell. In the case where we needed to have our negative numbers display differently. Seems like a hack, but it's working in seam 2.2.2.

Either inline or in a stylesheet, here's the convention.

xls-format-mask: '###,##0;[red](###,##0)';