Re: [jXLS-user] Cell processor

[Leo]

Title: Re: [jXLS-user] Cell processor

Hi George,

You should use a special notation for formulas by including it in $[ ].
For example $[SUM(A1:A10)] . The _expression_ inside $[] will be converted to Excel formula.
See here http://jxls.sourceforge.net/reference/formulas.html .

--
Regards,
Leo

Friday, September 23, 2011, 4:58:44 PM, you wrote:

Hi Leo,    thanks for this, I have another question please, how do get jXls to render an Excel formula correctly? e.g. something like  =userfn() + 95.0 * a$1   renders as text and will not calc unless I give it focus and press return, then it’s fine.   Regards George   From: Leo [mailto:leon...@gmail.com]  Sent: 11 September 2011 06:02 To: George Brennan Cc: 'jxls-user@lists.sourceforge.net' Subject: Re: [jXLS-user] Cell processor   Hello George, For the moment the row processor and cell processor are not really supported. They can work only in some limited cases. I expect this to be revisited in the future releases so they will again be working as expected. -- Leo Wednesday, September 7, 2011, 5:44:27 PM, you wrote: Hi,   I’ve been looking at the row processor and cell processor in the current release of  JXLS and can’t get the examples or tests to work. The row and col objects passed do not appear to support the wider POI methods or have any access to the workbook styles. Also the code for net.sf.jxls.parser.Cell on the Internet doesn’t appear to be the same as the SVN codebase which doesn’t have and version/revision info in it.   Any suggestions where I should look? Regards George     George Brennan Architect COMAC CAPITAL LLP| STRATTON HOUSE|5 STRATTON STREET |LONDON|W1J 8LA  Tel: +44 207 864 6455|Email: gbren...@comaccapital.com COMAC Capital LLP is a Limited Liability Partnership registered in England and Wales, Company No: OC316831.  Registered Office: Stratton House, 5 Stratton Street, London, W1J 8LA. Authorized and regulated by the Financial Services Authority of the United Kingdom ("FSA").  A list of members is available for inspection at the registered office.     COMAC Capital LLP DISCLAIMER: This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments. COMAC Capital LLP is a Limited Liability Partnership registered in England and Wales, Company No: OC316831.  Registered Office: Stratton House, 5 Stratton Street, London, W1J 8LA. Authorized and regulated by the Financial Services Authority of the United Kingdom ("FSA").  A list of members is available for inspection at the registered office. --  Best regards,  Leo                            mailto:leon...@gmail.com

-- 
Best regards,
 Leo                            mailto:leon...@gmail.com

------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2dcopy2
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user