Hi, I am using POI in my project for reading and writing into excel through Java. I am facing a problem while trying to read a specific formula from a cell, the formula is "=TRANSPOSE(H44:O44)" and I am using the following code to read it
r.getCell(ic + j).getCellFormula(); But this line throws an error : "Coding Error: Expected ExpPtg to be converted from Shared to Non-Shared Formula by ValueRecordsAggregate, but it wasn't" I am using workbook of type org.apache.poi.ss.usermodel.Workbook, cell of type org.apache.poi.ss.usermodel.Cell, row of type org.apache.poi.ss.usermodel.Row and sheet of type org.apache.poi.ss.usermodel.Sheet. Can anyone help me with this? Thanks in advance for your time. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Using-POI-for-reading-shared-formulae-tp3268698p3268698.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]
