poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shruti surulkar <shrutisurul...@yahoo.co.in>
Subject Using POI for reading shared formulae
Date Wed, 17 Nov 2010 08:47:05 GMT


I am using POI in my project for reading and writing into excel through
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message