Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PS C:\Users\vheimsba\Documents\OTTR> java -jar lutra.jar --mode expand --library et/o-tpl-lib.ttl --libraryFormat stottr --inputFormat tabottr --fetchMissing et/risk.xlsx --output et/riskoutput
- Exception in thread "main" org.apache.poi.ss.formula.FormulaParseException: Parse error near char 31 '[' in specified formula 'IF(ISNA(VLOOKUP(F15,[1]!Tabell2[#All],2,FALSE))=TRUE, "Feil", VLOOKUP(F15,[1]!Tabell2[#All],2,FALSE))'. Expected ',' or ')'
- at org.apache.poi.ss.formula.FormulaParser.expected(FormulaParser.java:269)
- at org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:1483)
- at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:1352)
- at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:905)
- at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:498)
- at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:322)
- at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1548)
- at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1506)
- at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1493)
- at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1867)
- at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1994)
- at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1978)
- at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1935)
- at org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1908)
- at org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:1479)
- at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:1352)
- at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:905)
- at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:498)
- at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:322)
- at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1548)
- at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1506)
- at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1493)
- at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1867)
- at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1994)
- at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1978)
- at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1935)
- at org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1908)
- at org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:1479)
- at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:1352)
- at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:905)
- at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:583)
- at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:322)
- at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1548)
- at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1506)
- at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1493)
- at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1867)
- at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1994)
- at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1978)
- at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1935)
- at org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1908)
- at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1889)
- at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:2036)
- at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:170)
- at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:85)
- at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:271)
- at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:216)
- at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:56)
- at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateFormulaCell(BaseFormulaEvaluator.java:185)
- at org.apache.poi.ss.usermodel.DataFormatter.formatCellValue(DataFormatter.java:1013)
- at org.apache.poi.ss.usermodel.DataFormatter.formatCellValue(DataFormatter.java:971)
- at xyz.ottr.lutra.tabottr.parser.ExcelReader.parseTable(ExcelReader.java:116)
- at xyz.ottr.lutra.tabottr.parser.ExcelReader.parseTables(ExcelReader.java:86)
- at xyz.ottr.lutra.tabottr.parser.ExcelReader.apply(ExcelReader.java:63)
- at xyz.ottr.lutra.tabottr.parser.ExcelReader.apply(ExcelReader.java:49)
- at xyz.ottr.lutra.io.InstanceReader.apply(InstanceReader.java:57)
- at xyz.ottr.lutra.io.InstanceReader.apply(InstanceReader.java:34)
- at java.base/java.util.Optional.map(Optional.java:258)
- at xyz.ottr.lutra.system.Result.map(Result.java:432)
- at xyz.ottr.lutra.system.Result.mapToStream(Result.java:467)
- at xyz.ottr.lutra.system.ResultStream.lambda$innerFlatMap$3(ResultStream.java:241)
- at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:271)
- at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
- at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625)
- at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
- at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
- at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
- at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
- at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
- at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
- at xyz.ottr.lutra.system.ResultStream.forEach(ResultStream.java:216)
- at xyz.ottr.lutra.TemplateManager.lambda$writeObjects$6(TemplateManager.java:477)
- at java.base/java.util.Optional.ifPresent(Optional.java:176)
- at xyz.ottr.lutra.system.Result.ifPresent(Result.java:371)
- at xyz.ottr.lutra.TemplateManager.writeObjects(TemplateManager.java:475)
- at xyz.ottr.lutra.TemplateManager.writeInstances(TemplateManager.java:436)
- at xyz.ottr.lutra.cli.CLI.writeInstances(CLI.java:288)
- at xyz.ottr.lutra.cli.CLI.executeExpand(CLI.java:207)
- at xyz.ottr.lutra.cli.CLI.execute(CLI.java:162)
- at xyz.ottr.lutra.cli.CLI.run(CLI.java:90)
- at xyz.ottr.lutra.cli.CLI.main(CLI.java:69)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement