Re: export formula to excel using EGSimpleTableParser

I am less aware of how this class works than the EGSimpleWorkbookHelper class, which I added. But I do not think I added formula support either.

But I do see that the EGSimpleTableParser gives you access to the HSSFWorkbook instance. These classes _are_ just attempts to provide easier access to this class. If the EGSimpleTableParser is not doing something correctly, you should be able to use the HSSFWorkbook instance and you will be able to do whatever you want. Hopefully you can get to the instance at the correct point in the process.

If you think a reasonable use-case should be supported, go ahead and add an issue in the repo. If you haven't already.

cheers - ray

On Mar 23, 2013, at 3:45 AM, Jake Bearkley wrote:

> Hi All,
> 
> I am using EGSimpleTableParser to export an excel spreadsheet which I want to contain a formula
> 
> In Styles.plist I have a defined a class "formula" which defines cellType = CELL_TYPE_FORMULA
> 
> my td I create is 
> 
> <td class="formula">=1+2</td>
> 
> but when I open the generated file, the cell is treated like a string.
> 
> Other values specified in Styles.plist eg font = bold are correctly interpreted by Excel.
> 
> Any help is appreciated.
> 
> Thanks in advance
> 
> Bearko
> 
> 
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar_______________________________________________
> Wonder-disc mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/wonder-disc

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

_______________________________________________
Wonder-disc mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wonder-disc