Open
Description
Read and complete the full issue template
Do not randomly delete sections. They are here for a reason.
Do you want to request a feature or report a bug?
- Bug
- Feature
- Question
Did you test against the latest CI build?
- Yes
- No
built from f77503d5
If you answered No, please test with the latest development build first.
Version of ClosedXML
e.g. 0.104.1
What is the current behavior?
An exception occurs when calling XLColumn.InsertColumnsAfter
ClosedXML.Parser.ParsingException: 'Error at char 0 of '': Unexpected token EofSymbolId.'
> ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.RefAtomExpression(bool replaceFirstAtom, object refAtom) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.RefSpillExpression(bool replaceFirstAtom, object refAtom) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.RefRangeExpression(bool replaceFirstAtom, object refAtom) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.RefIntersectionExpression(bool replaceFirstAtom, object refAtom) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.RefImplicitExpression(bool replaceFirstAtom, object refAtom) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.RefExpression(bool replaceFirstAtom, object refAtom) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.AtomExpression(bool skipRangeUnion, out bool isPureRef) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.PrefixAtomExpression(bool skipRangeUnion, out bool isPureRef) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.PercentExpression(bool skipRangeUnion, out bool isPureRef) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.PowExpression(bool skipRangeUnion, out bool isPureRef) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.MultiplyingExpression(bool skipRangeUnion, out bool isPureRef) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.AdditiveExpression(bool skipRangeUnion, out bool isPureRef) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.ConcatExpression(bool skipRangeUnion, out bool isPureRef) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.Expression(bool skipRangeUnion, out bool isPureRef) 不明 シンボルが読み込まれていません。
ClosedXML.Parser.dll!ClosedXML.Parser.FormulaParser<object, object, ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences>.Formula() 不明 シンボルが読み込まれていません。
ClosedXML.dll!ClosedXML.Excel.CalcEngine.Visitors.FormulaReferences.ForFormula(string formula) 行 41 C# シンボルが読み込まれました。
ClosedXML.dll!ClosedXML.Excel.XLDefinedName.RefersTo.set(string value) 行 70 C# シンボルが読み込まれました。
ClosedXML.dll!ClosedXML.Excel.XLWorksheet.MoveDefinedNamesColumns(ClosedXML.Excel.XLRange range, int columnsShifted, ClosedXML.Excel.XLDefinedNames definedNames) 行 1496 C# シンボルが読み込まれました。
ClosedXML.dll!ClosedXML.Excel.XLWorksheet.WorksheetRangeShiftedColumns.AnonymousMethod__0(ClosedXML.Excel.XLWorksheet ws) 行 1196 C# シンボルが読み込まれました。
ClosedXML.dll!ClosedXML.Excel.EnumerableExtensions.ForEach<ClosedXML.Excel.XLWorksheet>(System.Collections.Generic.IEnumerable<ClosedXML.Excel.XLWorksheet> source, System.Action<ClosedXML.Excel.XLWorksheet> action) 行 14 C# シンボルが読み込まれました。
ClosedXML.dll!ClosedXML.Excel.XLWorksheet.WorksheetRangeShiftedColumns(ClosedXML.Excel.XLRange range, int columnsShifted) 行 1196 C# シンボルが読み込まれました。
ClosedXML.dll!ClosedXML.Excel.XLWorksheet.NotifyRangeShiftedColumns(ClosedXML.Excel.XLRange range, int columnsShifted) 行 1536 C# シンボルが読み込まれました。
ClosedXML.dll!ClosedXML.Excel.XLRangeBase.InsertColumnsBeforeInternal(bool onlyUsedCells, int numberOfColumns, bool formatFromLeft, bool nullReturn) 行 1090 C# シンボルが読み込まれました。
ClosedXML.dll!ClosedXML.Excel.XLRangeBase.InsertColumnsAfterInternal(bool onlyUsedCells, int numberOfColumns, bool formatFromLeft, bool nullReturn) 行 1016 C# シンボルが読み込まれました。
ClosedXML.dll!ClosedXML.Excel.XLColumn.InsertColumnsAfter(int numberOfColumns) 行 105 C# シンボルが読み込まれました。
What is the expected behavior or new feature?
An exception does not occur.
Is this a regression from the previous version?
Yes, v0.102.3 works as expected.
Reproducibility
This is an important section. Read it carefully. Failure to do so will cause a 'RTFM' comment.
Without a code sample, it is unlikely that your issue will get attention. Don't be lazy. Do the effort and assist the developers to reproduce your problem. Code samples should be minimal complete and verifiable. Sample spreadsheets should be attached whenever applicable. Remove sensitive information.
Code to reproduce problem:
public void Main()
{
using XLWorkbook book = new("test.xlsx");
book.Worksheet(1).Column(1).InsertColumnsAfter(2);
}- I attached a sample spreadsheet. (You can drag files on to this issue)
test.xlsx
Metadata
Metadata
Assignees
Labels
No labels