Hello, it does not work evaluate, when the table is in another sheet
Formula = + Table24 [[# This row], [ASSEMBLY H.]] + Table24 [[# This row], [DIRECT H.]] + Table24 [[# This row], [TRAVEL H.]] + Table24 [ [#This row], [H.NAVE]] + Table24 [[# This row], [H. DRIVING]]
org.apache.poi.ss.formula.FormulaParseException: The specified named range 'Table24' does not exist in the current workbook.
Excuse my English.
does not work, result ...
Formula = + Table24 [[# This row], [ASSEMBLY H.]] + Table24 [[# This row], [DIRECT H.]] + Table24 [[# This row], [TRAVEL H.]] + Table24 [ [#This row], [H.NAVE]] + Table24 [[# This row], [H. DRIVING]]
org.apache.poi.ss.formula.FormulaParseException: The specified named range 'Table24' does not exist in the current workbook.
Excuse my English.
B4X:
Dim jo como JavaObject = xls
Dim evaluator As JavaObject = jo.RunMethodJO ("getCreationHelper", Null) .RunMethodJO ("createFormulaEvaluator", Null)
Log ("EVALUATOR =" & evaluator.RunMethodJO ("evaluar", Array (row.getCell (12))). RunMethod ("formatAsString", Null))
[/ CODE]
I also try with ...
[CODE=b4x] Dim chlp As XSSFCreationHelper = xls.CreationHelper
Dim eval As XSSFFormulaEvaluator = chlp.createFormulaEvaluator
Dim evaluatedcell As XSSFCell = eval.evaluate(row.getCell(12))does not work, result ...