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]
