I have this range formula 
  'General Return Details'!$E$3
got using - 
  HSSFName name = wb.getName("organisation_name");

I want to be able to modify the cell reference bit as easy as possible - so
for example calling a method like 
  String newRef = modifyColumnValue(name.getRefersToFormula(), 1);
giving 
  'General Return Details'!$E$4
or
  String newRef = modifyRowValue(name.getRefersToFormula(), -1);
giving 
  'General Return Details'!$C$4

Is there a simple way of doing this or do I have to write my own methods?

thanks in advance

harry
-- 
View this message in context: 
http://old.nabble.com/Is-there-a-simple-way-of-doing-this--tp27128186p27128186.html
Sent from the POI - Dev mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to