diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs index 78e6d55..cc4ed87 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs @@ -1167,6 +1167,7 @@ && shiftedRange.RangeAddress.FirstAddress.ColumnNumber <= matchRange.RangeAddress.FirstAddress.ColumnNumber && shiftedRange.RangeAddress.LastAddress.ColumnNumber >= matchRange.RangeAddress.LastAddress.ColumnNumber) { + #region change if (a1RowRegex.IsMatch(rangeAddress)) { var rows = rangeAddress.Split(':'); @@ -1247,12 +1248,21 @@ matchRange.RangeAddress.LastAddress.ColumnLetter, matchRange.RangeAddress.LastAddress.FixedRow, matchRange.RangeAddress.LastAddress.FixedColumn))); } + #endregion } else { sb.Append(matchString); } } + else + { + sb.Append(matchString); + } + } + else + { + sb.Append(matchString); } } else @@ -1310,6 +1320,7 @@ && shiftedRange.RangeAddress.FirstAddress.RowNumber <= matchRange.RangeAddress.FirstAddress.RowNumber && shiftedRange.RangeAddress.LastAddress.RowNumber >= matchRange.RangeAddress.LastAddress.RowNumber) { + #region change if (a1ColumnRegex.IsMatch(rangeAddress)) { var columns = rangeAddress.Split(':'); @@ -1390,12 +1401,21 @@ matchRange.RangeAddress.LastAddress.ColumnNumber + columnsShifted, matchRange.RangeAddress.LastAddress.FixedRow, matchRange.RangeAddress.LastAddress.FixedColumn))); } + #endregion } else { sb.Append(matchString); } } + else + { + sb.Append(matchString); + } + } + else + { + sb.Append(matchString); } } else diff --git a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs index 556d636..06e5252 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs @@ -15,11 +15,12 @@ static void Main(string[] args) { - var fileName = "Issue_6364"; + var fileName = "Issue_6373"; //var fileName = "Blank"; //var fileName = "Sandbox"; var wb = new XLWorkbook(String.Format(@"c:\Excel Files\ForTesting\{0}.xlsx", fileName)); - + var ws = wb.Worksheet(2); + ws.Row(75).InsertRowsBelow(1); //var wb = new XLWorkbook(); //var ws = wb.Worksheets.Add("Shifting Formulas"); //ws.Cell("B2").Value = 5;