Hi, I read a sheet from a xls file and I want to copy some of the cells in that sheet in a new sheet in another file. I have a problem when a cell in the original sheet contains a formula error. I do not care what type of error it is and I do not want to correct the formula, I just want to copy it. How can I get the formula value if there is a CELL_TYPE_ERROR?
Example: Cell in the original Sheet: =-acc "-acc" is a string, not a name or something like that, but Excel sees it as an #NAME error. I want to copy "-acc" in the new sheet. How can I do it? The original sheet is auto generated by a plugin so I cannot modify it. Thank a lot, Mario -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Get-Formula-Value-when-I-have-a-CELL-TYPE-ERROR-tp4913368p4913368.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]
