ClosedXML.Parser.ParsingException: 'Error at char 0 of '': Unexpected token EofSymbolId.' #2590
Replies: 4 comments 2 replies
-
Same here, but mine happens when calling sheet.Range("I:J").Delete(XLShiftDeletedCells.ShiftCellsLeft); |
Beta Was this translation helpful? Give feedback.
-
Hi - I get the same exception of Rolling back versions from 0.104.2 to 0.102.3 seems to fix it. |
Beta Was this translation helpful? Give feedback.
-
Hi, Ty |
Beta Was this translation helpful? Give feedback.
-
From 102 to 105: xxxxx.SetFormulaR1C1("SUM($U$11*D11)"); Error message: "Unable to determine token for 'SUM($U$11*D11)' at index 4." Looks like it no longer can parse the "$"-Dollar sign. |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
Hi,
I am not sure if this is the right channel. Hopefully someone can help
But, I have been having a bug with the latest version .. Until 102.3 it worked well though. This is the piece of code that breaks after the latest version
The error that I get is "ClosedXML.Parser.ParsingException: 'Error at char 0 of '': Unexpected token EofSymbolId.'"
Not sure if this can help
at ClosedXML.Parser.FormulaParser
3.RefAtomExpression(Boolean replaceFirstAtom, TNode refAtom) at ClosedXML.Parser.FormulaParser
3.RefSpillExpression(Boolean replaceFirstAtom, TNode refAtom)at ClosedXML.Parser.FormulaParser
3.RefRangeExpression(Boolean replaceFirstAtom, TNode refAtom) at ClosedXML.Parser.FormulaParser
3.RefIntersectionExpression(Boolean replaceFirstAtom, TNode refAtom)at ClosedXML.Parser.FormulaParser
3.RefImplicitExpression(Boolean replaceFirstAtom, TNode refAtom) at ClosedXML.Parser.FormulaParser
3.RefExpression(Boolean replaceFirstAtom, TNode refAtom)at ClosedXML.Parser.FormulaParser
3.AtomExpression(Boolean skipRangeUnion, Boolean& isPureRef) at ClosedXML.Parser.FormulaParser
3.PrefixAtomExpression(Boolean skipRangeUnion, Boolean& isPureRef)at ClosedXML.Parser.FormulaParser
3.PercentExpression(Boolean skipRangeUnion, Boolean& isPureRef) at ClosedXML.Parser.FormulaParser
3.PowExpression(Boolean skipRangeUnion, Boolean& isPureRef)at ClosedXML.Parser.FormulaParser
3.MultiplyingExpression(Boolean skipRangeUnion, Boolean& isPureRef) at ClosedXML.Parser.FormulaParser
3.AdditiveExpression(Boolean skipRangeUnion, Boolean& isPureRef)at ClosedXML.Parser.FormulaParser
3.ConcatExpression(Boolean skipRangeUnion, Boolean& isPureRef) at ClosedXML.Parser.FormulaParser
3.Expression(Boolean skipRangeUnion, Boolean& isPureRef)at ClosedXML.Parser.FormulaParser
3.Formula() at ClosedXML.Parser.FormulaParser
3.CellFormulaA1(String formula, TContext context, IAstFactory3 factory) at ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences.ForFormula(String formula) at ClosedXML.Excel.XLDefinedName.set_RefersTo(String value) at ClosedXML.Excel.XLDefinedName.SetRefersTo(String formula) at ClosedXML.Excel.XLWorksheet.MoveDefinedNamesRows(XLRange range, Int32 rowsShifted, XLDefinedNames definedNames) at ClosedXML.Excel.XLWorksheet.<>c__DisplayClass293_0.<WorksheetRangeShiftedRows>b__0(XLWorksheet ws) at ClosedXML.Excel.EnumerableExtensions.ForEach[T](IEnumerable
1 source, Action`1 action)at ClosedXML.Excel.XLWorksheet.WorksheetRangeShiftedRows(XLRange range, Int32 rowsShifted)
at ClosedXML.Excel.XLWorksheet.NotifyRangeShiftedRows(XLRange range, Int32 rowsShifted)
at ClosedXML.Excel.XLRangeBase.InsertRowsAboveInternal(Boolean onlyUsedCells, Int32 numberOfRows, Boolean formatFromAbove, Boolean nullReturn)
at ClosedXML.Excel.XLRangeBase.InsertRowsBelowInternal(Boolean onlyUsedCells, Int32 numberOfRows, Boolean formatFromAbove, Boolean nullReturn)
at ClosedXML.Excel.XLRangeBase.InsertRowsBelow(Boolean onlyUsedCells, Int32 numberOfRows, Boolean formatFromAbove)
at ClosedXML.Excel.XLRangeBase.InsertRowsBelow(Int32 numberOfRows, Boolean expandRange)
at ClosedXML.Excel.XLRangeBase.InsertRowsBelow(Int32 numberOfRows)
at ClosedXML.Excel.XLTable.set_ShowTotalsRow(Boolean value)
Thank You,
Vasanth Samuel Nelson.
Beta Was this translation helpful? Give feedback.
All reactions