java.lang.RuntimeException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • I have a Excel-template eith a Sheet named "Page 6 DATA" with a formula looking like this =INDIRECT("'Page 6 DATA'!R1C1",false) This formula causes the following Error when "Force formula recalulating" is set in the "Microsoft Excel Writer" Step Log: 2015/10/26 14:32:54 - Block this step until steps Select values Page 6 DATA finish.0 - Finished processing (I=0, O=0, R=6, W=6, U=0, E=0) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Unexpected error 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : java.lang.RuntimeException: R1C1 style not supported yet 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.OperationEvaluationContext.getDynamicReference(OperationEvaluationContext.java:150) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.functions.Indirect.evaluateIndirect(Indirect.java:124) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.functions.Indirect.evaluate(Indirect.java:76) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:127) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:525) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:288) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:230) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:264) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:151) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.recalculateAllWorkbookFormulas(ExcelWriterStep.java:249) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.closeOutputFile(ExcelWriterStep.java:227) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:183) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at java.lang.Thread.run(Thread.java:695) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - Finished processing (I=0, O=7, R=6, W=6, U=0, E=1) The poi library seems to be the problem https://poi.apache.org/apidocs/org/apache/poi/ss/formula/OperationEvaluationContext.html#getDynamicReference%28java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String,%20boolean%29 "isA1Style - specifies the format for refStrPart1 and refStrPart2. Pass true for 'A1' style and false for 'R1C1' style. TODO - currently POI only supports 'A1' reference style" It looks like this is an very old issue. Here is one possible solution that is 13 years old? "R1C1 is not supported, and there is no plan to add that support as yet. If you want to easily convert numeric references to A1 style references easily, you can use the AreaReference and CellReference classes in the hssf.util package, which have useful constructors, and whose toString() methods return A1 style references. (remember to use zero based references) " http://user.poi.apache.narkive.com/ra4GFwo4/support-for-r1c1-reference-style
    via by Nikolai Sandved,
  • I have a Excel-template eith a Sheet named "Page 6 DATA" with a formula looking like this =INDIRECT("'Page 6 DATA'!R1C1",false) This formula causes the following Error when "Force formula recalulating" is set in the "Microsoft Excel Writer" Step Log: 2015/10/26 14:32:54 - Block this step until steps Select values Page 6 DATA finish.0 - Finished processing (I=0, O=0, R=6, W=6, U=0, E=0) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Unexpected error 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : java.lang.RuntimeException: R1C1 style not supported yet 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.OperationEvaluationContext.getDynamicReference(OperationEvaluationContext.java:150) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.functions.Indirect.evaluateIndirect(Indirect.java:124) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.functions.Indirect.evaluate(Indirect.java:76) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:127) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:525) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:288) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:230) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:264) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:151) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.recalculateAllWorkbookFormulas(ExcelWriterStep.java:249) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.closeOutputFile(ExcelWriterStep.java:227) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:183) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at java.lang.Thread.run(Thread.java:695) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - Finished processing (I=0, O=7, R=6, W=6, U=0, E=1) The poi library seems to be the problem https://poi.apache.org/apidocs/org/apache/poi/ss/formula/OperationEvaluationContext.html#getDynamicReference%28java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String,%20boolean%29 "isA1Style - specifies the format for refStrPart1 and refStrPart2. Pass true for 'A1' style and false for 'R1C1' style. TODO - currently POI only supports 'A1' reference style" It looks like this is an very old issue. Here is one possible solution that is 13 years old? "R1C1 is not supported, and there is no plan to add that support as yet. If you want to easily convert numeric references to A1 style references easily, you can use the AreaReference and CellReference classes in the hssf.util package, which have useful constructors, and whose toString() methods return A1 style references. (remember to use zero based references) " http://user.poi.apache.narkive.com/ra4GFwo4/support-for-r1c1-reference-style
    via by Nikolai Sandved,
    • java.lang.RuntimeException: R1C1 style not supported yet at org.apache.poi.ss.formula.OperationEvaluationContext.getDynamicReference(OperationEvaluationContext.java:150) at org.apache.poi.ss.formula.functions.Indirect.evaluateIndirect(Indirect.java:124) at org.apache.poi.ss.formula.functions.Indirect.evaluate(Indirect.java:76) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:127) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:525) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:288) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:230) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:264) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:151) at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.recalculateAllWorkbookFormulas(ExcelWriterStep.java:249) at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.closeOutputFile(ExcelWriterStep.java:227) at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:183) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Thread.java:695)
    No Bugmate found.