public void TemplateCoordinatesTest()
{
TemplateDescriptionHelper.TryExtractCoordinates("Template:qwe:QWE123:ASD987", out var range).Should().BeTrue();
range.UpperLeft.ColumnIndex.Should().Be(26 * 26 + 19 * 26 + 4);
range.UpperLeft.RowIndex.Should().Be(123);
range.LowerRight.ColumnIndex.Should().Be(17 * 26 * 26 + 23 * 26 + 5);
range.LowerRight.RowIndex.Should().Be(987);
}
private void AddNewTemplateIntoCache(string templateName)
{
cache.Add(templateName, null);
var cell = SearchTemplateDescription(templateName);
if (cell == null)
{
return;
}
if (!TemplateDescriptionHelper.TryExtractCoordinates(cell.StringValue, out var range))
{
return;
}
var newTemplate = BuildNewRenderingTemplate(range);
if (newTemplate.IsValid())
{
cache[templateName] = newTemplate;
}
}
