Hi again Nick, The XLS extraction is going great. For XLSX can I use the same mechanism?
Thanks, - Chris On 1 Nov 2012, at 17:25, Chris Bamford wrote: > Hi Nick, > > On 1 Nov 2012, at 16:11, Nick Burch wrote: > > Yes. Formulas in Excel (.xls) are stored with two parts. One is the last > value (number or string) that the formula evaluated to. The other is the > formula itself, stored in a parsed format. With the false flag, you get the > last result Excel calculated returned. With true, we try to turn the parsed > formula tokens back into a string. For your case, the formula is actually > shared across multiple cells, and another bit of POI is objecting because the > sharing is expected to be resolved but hasn't been > > Thanks for the clear explanation. It would seem to me that returning the > last result Excel calculated (setting it to false) is likely to be what is > expected most of the time. It could well be good enough for what I need. > > Cheers > > - Chris > > > Chris Bamford > Senior Developer > > 2 - 8 Balfe Street > Kings Cross, > London, N1 9EG > > mobile +44 7860 405292 > tel: +44 (0) 207 843 2300 > web www.mimecast.com > > > The information contained in this communication from [email protected] is > confidential and may be legally privileged. It is intended solely for use by > [email protected] and others authorized to receive it. If you are not > [email protected] you are hereby notified that any disclosure, copying, > distribution or taking action in reliance of the contents of this information > is strictly prohibited and may be unlawful. > > > Mimecast Ltd. is a company registered in England and Wales with the company > number 4698693 VAT No. GB 123 4197 34 > Registered Office:2 - 8 Balfe Street, Kings Cross London, N1 9EG Email > Address: [email protected] > > This email message has been scanned for viruses by Mimecast. > Mimecast delivers a complete managed email solution from a single web based > platform. > For more information please visit http://www.mimecast.com
