Hello, how can I see a cell with formula and tables.
I have tried with this.
and also with this.
But I get this error ...
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.
I have tried with this.
B4X:
Dim jo As JavaObject = xls
Dim evaluator As JavaObject = jo.RunMethodJO("getCreationHelper", Null).RunMethodJO("createFormulaEvaluator", Null)
'now use evaluator whenever you want to evaluate a cell:
Log("EVALUATOR = " & evaluator.RunMethodJO("evaluate", Array(row.getCell(12))).RunMethod("formatAsString", Null))
and also with this.
B4X:
Dim chlp As XSSFCreationHelper = xls.CreationHelper
Dim eval As XSSFFormulaEvaluator = chlp.createFormulaEvaluator
Dim evaluatedcell As XSSFCell = eval.evaluate(row.getCell(12))
But I get this error ...
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.