JBossDeveloper

I'm still out of touch with the code until monday but something like

  <e:formula value="Sheet1!A1+Sheet2!B2"/>

should work. Or shall we say, will work sooner or later ;-)

Currently the style parser seem to support

   // Font attributes
   private static final String FONTNAME = "xlsFontName";
   private static final String FONTSIZE = "xlsFontSize";
   private static final String FONTCOLOR = "xlsFontColor";
   private static final String FONTBOLD = "xlsFontBold";
   private static final String FONTITALIC = "xlsFontItalic";
   private static final String FONTSCRIPTSTYLE = "xlsFontScriptStyle";
   private static final String FONTSTRUCKOUT = "xlsFontStruckOut";
   private static final String FONTUNDERLINESTYLE = "xlsFontUnderlineStyle";
   
   // Background attributes
   private static final String BACKGROUNDCOLOR = "xlsBackgroundColor";
   private static final String BACKGROUNDPATTERN = "xlsBackgroundPattern";
   
   // Cell attributes
   private static final String ALIGNMENT = "xlsAlignment";

   // Column attributes
   private static final String COLUMN_WIDTH = "xlsColumnWidths";

but I'll put the border things on top of the list when expanding the features...

They will probably be something like

xlsBorderColor (all)
xlsLeftBorderColor
xlsTopBorderColor
xlsRightBorderColor
xlsBottomBorderColor
xlsBorderLineStyle (all)
xlsLeftBorderLineStyle
xlsTopBorderLineStyle
xlsRightBorderLineStyle
xlsBottomBorderLineStyle

I think the formula tag is in the latest version. If not, it will be in the new latest version I'll roll out sometimes next week once I get back to work, clean out the most pressing work-stuff that has accumulated during my vacation and migrate my development environment to my new laptop.

If you can wait until tomorrow I'll wrap up some bugfixes/changes and post a fresh version.

There is a new version out that can be downloaded here

Changes:

• Fixed empty string errors (better null handling of data)


• Formulas should now be working, e.g.

<e:formula value="SheetOne!A1+SheetTwo!A1"/>

• Support for border color and line style in datatable exporter, e.g.

  <h:datatable style="xlsBorderColor:red;xlsBorderLineStyle:thick;xlsBorderColorRight:blue;xlsBorderLineStyleRight:dotted" ...>

which should produce cells with thick red borders (but the right border is blue and dotted. You can also use templates with the styles like

  <h:datatable style="xlsBordeColor.foo:red" ...>
  and later on
  <h:outputText style="xlsTemplates:foo" .../>
  

the complete list of new tags are

   xlsBorderColor
   xlsBorderColorLeft
   xlsBorderColorTop
   xlsBorderColorRight
   xlsBorderColorBottom
   xlsBorderLineStyle
   xlsBorderLineStyleLeft
   xlsBorderLineStyleTop
   xlsBorderLineStyleRight
   xlsBorderLineStyleBottom

There is still and issue (in document mode) with format masks and templates due to the fact that the format mask can't be changed later on when cascading templates but it can be worked around by placing the mask at the first template like

<e:cellTemplate name="foo" mask="0.0"/>
and
<e:cell templates="foo"/>

(using templates in the cell but placing the mask in the cell would result in the mask being ignored)

I just noticed that I forgot to fix the typo in horizontal freeze in this release, it's hard to use a thread of 50+ posts for managing bug reports ;-) There will be an update soon.

Hmmm, that one is obsolete, cleaned it up in faces-config.xml. The new jar can be downloaded here. Wonder why I didn't run into that...

This version also has some improvements (hopefully) for freezing and grouping...

A preliminary alpha-version (careful enough?) of the docs can be found here