As far as I am aware, Excel is simply trying to warn you that there are values in cells that it thinks you may have neglected to include in the formula. In this case, I am going to guess that there is a vlue in cell A91 as well as this would be enough to trigger the error message.
The only way I know of to avoid this problem is to change the Error Checking options for the workbook (Tools>Options>Error Checking in Excel) and here you may have a problem because, as far as I am aware, you are targetting the SS stream to support both binary and SpreadsheetML files and these error checking 'features' were introduced when Office 2007 was released. The best option I know of at the moment it to use Excel and create a template file with the Error Checking options set as you requite them. Then you can open this file with POI and populate it as you are doing now without - hopefully - encountering similar messages. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Error-displayed-in-one-of-the-formula-cells-of-the-Excel-sheet-tp3359452p3360029.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]
