Unable to shiftRows with xlsm sheet

["kola.nareshreddy" <ma...@gmail.com>]

I'm trying to shift rows in xlsm sheet using XSSFSheet but couldn't do it and
getting the below exception.
I was able to perform XSSFSheet.shiftRows on xlsx successfully but failing
with xlsm sheet.

Any one has any idea?

Thanks in advance.


java.lang.RuntimeException: not implemented yet
	at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getExternalSheetIndex(XSSFEvaluationWorkbook.java:117)
	at
org.apache.poi.ss.formula.FormulaParser.createAreaRefParseNode(FormulaParser.java:613)

	at
org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:460)

	at
org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:266)

	at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1117)

	at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1077)

	at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1064)

	at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1424)

	at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1524)

	at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1508)

	at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1465)

	at
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1445)

	at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1566)

	at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:174)

	at
org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter.updateNamedRanges(XSSFRowShifter.java:112)

	at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows(XSSFSheet.java:2178)

	at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows(XSSFSheet.java:2125)





--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Unable-to-shiftRows-with-xlsm-sheet-tp5710847.html
Sent from the POI - User mailing list archive at Nabble.com.