Thanks Mark. I will try and do that. I have also contributed two methods (CLEAN and ADDRESS) to POI 3.8 and try keep doing that :). But will it be possible for .xls format too? On Fri, Jan 28, 2011 at 5:06 PM, Mark Beardsley <[email protected]>wrote:
> > No, not as far as I am aware. The trick to get around this os very simple > however; use Excel to reate a template file and set the calculation options > on that as you want them. Next, use POI to open the template and populate > then save it away. The calculation options should still be set as they were > when you read the template file as POI passes through unchanged anything it > does not yet parse. > > Now, can I ask which version of the file format you are targetting? If the > SpreadsheetML version (.xlsx) would you consider adding this functionality > into the api? As you no doubt know, the .xlsx files are simply zipped xml > so > it should be quite straightforward to identify where the options are stored > within this file. Once you know this, identifying the necessary openxml > classes and then coding supporting XSSF ones should be possible. If you > want > to have a go at this, then post specific questions onto the dev list. > Contributions from users are always welcomed as the whole project is run on > a voluntary basis - people like Yegor, Nick, David and Josh (to mention > just > a few) have contributed a lot of their spare time to pushing the api > forward > and are always welcoming and supportive of assistance. > > Yours > > Mark B > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Formula-Calculation-Option-with-POI-tp3361199p3361289.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
