/// <summary>
/// open cursor
/// </summary>
/// <param name="reverse"></param>
/// <param name="startPosition"></param>
/// <param name="useLocate">If this is the 1st access to the table, locate values should be considered.
/// if not - use only ranges</param>
/// <returns></returns>
internal GatewayResult OpenCursor(bool reverse, DbPos startPosition, BoudariesFlags boundariesFlag)
{
CurrentCursor.CursorDefinition.SetFlagValue(CursorProperties.DirReversed, reverse);
CurrentCursor.CursorDefinition.StartPosition = startPosition;
// build the RangeData list
CurrentCursor.RuntimeCursorData.Ranges = RangeBuilder.Build(boundariesFlag);
GatewayCommandBase cursorCommand = GatewayCommandsFactory.CreateCursorOpenCommand(CurrentCursor, LocalDataviewManager.LocalManager);
//String r = CurrentCursor.Serialize();
return(cursorCommand.Execute());
}
public void SingleValue_WithError()
{
errorFinder = new ErrorFinder();
var range = new RangeBuilder().WithWorksheet().WithSingleValue((int)CVErrEnum.ErrNA).Build();
SetRangeExtentionsStub();
var result = errorFinder.GetAllErrorCells(range).ToArray();
Assert.AreEqual(1, result.Length);
Assert.AreEqual(CVErrEnum.ErrNA.GetEnumDescription(), result.First().ErrorMessage);
}
/// <summary>Parses the unicode range.</summary>
/// <param name="unicodeRange">the string which stores the unicode range</param>
/// <returns>
/// the unicode range as a
/// <see cref="iText.Layout.Font.Range"/>
/// object
/// </returns>
public static Range ParseUnicodeRange(String unicodeRange)
{
String[] ranges = iText.IO.Util.StringUtil.Split(unicodeRange, ",");
RangeBuilder builder = new RangeBuilder();
foreach (String range in ranges)
{
if (!AddRange(builder, range))
{
return(null);
}
}
return(builder.Create());
}
public void DiscardInvalidRanges()
{
RangeBuilder b = CreateBuilder();
b.Add(-1, 10);
b.Add(5, 110);
Assert.Equal("bytes=-1-10,5-110", b.Build("bytes", 100));
b.Options.Value.DiscardInvalidRanges = true;
Assert.Null(b.Build("bytes", 100));
b.Add(6, 10);
Assert.Equal("bytes=6-10", b.Build("bytes", 100));
}
public void MergeOverlappingRanges()
{
RangeBuilder b = CreateBuilder();
b.Add(0, 10);
b.Add(10, 11); //start and end is the same as other ranges
b.Add(0, 10); //duplicate overlap
b.Add(5, 11); //overlap that is not ordered
b.Add(15, 20); //a non-overlapping range
b.Add(5, 6); //small range after overlaps
Assert.Equal("bytes=0-10,10-11,0-10,5-11,15-20,5-6", b.Build());
b.Options.Value.MergeOverlappingRanges = true;
Assert.Equal("bytes=0-11,15-20", b.Build());
}
public void Range_WithErrors()
{
errorFinder = new ErrorFinder();
var values = new object[, ] {
{ 1d, "1", "abc" }, { (int)CVErrEnum.ErrGettingData, "321 , 321", null }
};
var range = new RangeBuilder().WithWorksheet().WithCells().WithSingleValue(values).Build();
SetRangeExtentionsStub();
var result = errorFinder.GetAllErrorCells(range).ToArray();
Assert.AreEqual(1, result.Length);
Assert.AreEqual(CVErrEnum.ErrGettingData.GetEnumDescription(), result.First().ErrorMessage);
}
public void RepairConditionalFormat_TwoRowsSelected_SecondToFirst()
{
var firstRow = new RangeBuilder().WithConditionalFormatting(0).WithWorksheet().WithPaste();
var secondRow = new RangeBuilder().WithConditionalFormatting(1).WithWorksheet().WithCopy();
var rangeBuilder = new RangeBuilder()
.WithRows()
.WithCount(2)
.WithIndexer(new[] { firstRow.Build(), secondRow.Build() });
var selection = rangeBuilder.Build();
formatFixer.FillRange(selection);
secondRow.MockObject.Verify(x => x.Copy(Missing.Value), Times.Once);
VerifyPasted(firstRow.MockObject);
}
public void RemoveAllSpaces_EmptyValue_Null()
{
var value = " \r\n \t";
var rangeBuilder = new RangeBuilder()
.WithWorksheet()
.WithAreas()
.WithSingleValue(value)
.WithSetValue();
var selection = rangeBuilder.Build();
emptySpaceTrimmer.RemoveAllSpaces(selection);
rangeBuilder.MockObject.Verify(x => x.set_Value(It.IsAny <object>(), It.IsAny <string>()), Times.Once);
rangeBuilder.MockObject.Verify(x => x.set_Value(It.IsAny <object>(), It.Is <string>(v => v == null)));
}
public void HighlightDuplicates_SomeCellsAreNull_Success()
{
var cells = new[]
{
new RangeBuilder().WithSingleValue(1).Build(),
new RangeBuilder().WithSingleValue(2).Build(),
new RangeBuilder().WithSingleValue(3).Build(),
null,
new RangeBuilder().WithSingleValue(3).Build(),
new RangeBuilder().WithSingleValue(4).Build(),
};
var selection = new RangeBuilder().WithEnumrableRanges(cells).Build();
duplicatesHighlighter.HighlightDuplicates(selection);
Assert.AreEqual(1, RangeExtensionsStub.SetColorInvocations.Count());
}
internal HeadObjectRequest(HttpMethodType method) : base(method)
{
Range = new RangeBuilder();
IfETagMatch = new ETagBuilder();
IfETagNotMatch = new ETagBuilder();
ResponseCacheControl = new CacheControlBuilder();
ResponseContentType = new ContentTypeBuilder();
//Amazon does not support the extended filename RFC in their presigned requests
ContentDispositionOptions contentDisp = new ContentDispositionOptions();
contentDisp.UseExtendedFilename = false;
ResponseContentDisposition = new ContentDispositionBuilder(Options.Create(contentDisp));
ResponseContentLanguage = new ContentLanguageBuilder();
ResponseContentEncoding = new ContentEncodingBuilder();
}
public void RepairConditionalFormat_OneRowSelected_NoAction()
{
var firstRow = new RangeBuilder();
var rangeBuilder = new RangeBuilder()
.WithConditionalFormatting(1)
.WithWorksheet()
.WithRows()
.WithCount(1)
.WithIndexer(new[] { firstRow.Build() })
.WithPaste();
var selection = rangeBuilder.Build();
formatFixer.FillRange(selection);
firstRow.MockObject.Verify(x => x.Copy(Missing.Value), Times.Never);
rangeBuilder.MockObject.Verify(x => x.Copy(Missing.Value), Times.Never);
}
public void ToggleCase_ConvertedRightOrder(string initial, string result)
{
var firstCell = new RangeBuilder().WithSingleValue(initial).Build();
var rangeBuilder = new RangeBuilder()
.WithEnumrableRanges(new[] { firstCell })
.WithSingleValue(initial)
.WithWorksheet()
.WithAreas()
.WithSetValue();
var selection = rangeBuilder.Build();
caseToggler.ToggleCase(selection);
rangeBuilder.MockObject.Verify(x => x.set_Value(It.IsAny <object>(), It.IsAny <string>()), Times.Once);
rangeBuilder.MockObject.Verify(x => x.set_Value(It.IsAny <object>(), It.Is <string>(v => result == v)));
}
public void ToggleCase_SingleCell_Converted()
{
var rangeBuilder = new RangeBuilder()
.WithEnumrableRanges(new[] { new RangeBuilder().WithSingleValue("abc").Build() })
.WithWorksheet()
.WithAreas()
.WithSingleValue("abc")
.WithSetValue();
var selection = rangeBuilder.Build();
caseToggler.ToggleCase(selection);
var expected = "ABC";
rangeBuilder.MockObject.Verify(x => x.set_Value(It.IsAny <object>(), It.IsAny <string>()), Times.Once);
rangeBuilder.MockObject.Verify(x => x.set_Value(It.IsAny <object>(), It.Is <string>(v => expected == v)));
}
public void TrimSpaces_SingleCell_Converted()
{
var value = "a \r\nb c\t";
var rangeBuilder = new RangeBuilder()
.WithWorksheet()
.WithAreas()
.WithSingleValue(value)
.WithSetValue();
var selection = rangeBuilder.Build();
emptySpaceTrimmer.TrimSpaces(selection);
var expected = "a b c";
rangeBuilder.MockObject.Verify(x => x.set_Value(It.IsAny <object>(), It.IsAny <string>()), Times.Once);
rangeBuilder.MockObject.Verify(x => x.set_Value(It.IsAny <object>(), It.Is <string>(v => expected == v)));
}
private void SetupApplicationForAddWorkbook()
{
app = new Mock <Application>(MockBehavior.Strict);
var wbs = new Mock <Workbooks>(MockBehavior.Strict);
var wb = new Mock <Workbook>(MockBehavior.Strict);
var wss = new Mock <Sheets>(MockBehavior.Strict);
var ws = new Mock <Worksheet>(MockBehavior.Strict);
//wss.Setup(x => x[1]).re
var rangeBuilder = new RangeBuilder().WithSetValue();
range = rangeBuilder.MockObject;
range.Setup(x => x.get_Value(It.IsAny <object>()));
range.Setup(x => x.set_Value(It.IsAny <object>(), It.IsAny <object>()));
ws.Setup(x => x.Cells[It.IsAny <int>(), It.IsAny <int>()]).Returns(rangeBuilder.Build());
wb.Setup(x => x.Worksheets).Returns(wss.Object);
wss.Setup(x => x[1]).Returns(ws.Object);
wbs.Setup(x => x.Add(Missing.Value)).Returns(wb.Object);
app.Setup(x => x.Workbooks).Returns(wbs.Object);
}
public void Validate_Success_And_Fail()
{
var cells = new[]
{
new RangeBuilder().WithSingleValue(true).Build(),
new RangeBuilder().WithSingleValue(true).Build(),
new RangeBuilder().WithSingleValue(false).Build(),
new RangeBuilder().WithSingleValue("").Build()
};
var selection = new RangeBuilder().WithEnumrableRanges(cells).WithWorksheet().Build();
validator
.Setup(x => x.CheckValue(It.IsAny <object>()))
.Returns((bool x) => x ? ValidationResult.Success : ValidationResult.Fail("Fail =("));
var result = cellsValidator.Validate(selection, ValidationType.Xml);
Assert.AreEqual(1, result.Count);
validator.Verify(x => x.CheckValue(It.IsAny <object>()), Times.Exactly(3));
}
public void RepairConditionalFormat_MultipleRows_CopiedFromFirstRow()
{
var firstRow = new RangeBuilder().WithConditionalFormatting(1).WithWorksheet().WithCopy();
var secondRow = new RangeBuilder().WithConditionalFormatting(0).WithWorksheet();
var thirdRow = new RangeBuilder().WithConditionalFormatting(1).WithWorksheet();
var lastRow = new RangeBuilder().WithConditionalFormatting(0).WithWorksheet();
var rangeBuilder = new RangeBuilder()
.WithConditionalFormatting(1)
.WithWorksheet()
.WithRows()
.WithCount(4)
.WithIndexer(new[] { firstRow.Build(), secondRow.Build(), thirdRow.Build(), lastRow.Build() })
.WithPaste();
var selection = rangeBuilder.Build();
formatFixer.FillRange(selection);
firstRow.MockObject.Verify(x => x.Copy(Missing.Value), Times.Once);
VerifyPasted(rangeBuilder.MockObject);
}
public void HighlightDuplicates_ThreeItems_Success()
{
var cells = new[]
{
new RangeBuilder().WithSingleValue("abc").Build(),
new RangeBuilder().WithSingleValue("a").Build(),
new RangeBuilder().WithSingleValue("b").Build(),
new RangeBuilder().WithSingleValue("c").Build(),
new RangeBuilder().WithSingleValue("a").Build(),
new RangeBuilder().WithSingleValue("b").Build(),
new RangeBuilder().WithSingleValue("qwe").Build(),
new RangeBuilder().WithSingleValue(2d).Build(),
new RangeBuilder().WithSingleValue(3d).Build(),
new RangeBuilder().WithSingleValue(2d).Build()
};
var selection = new RangeBuilder().WithEnumrableRanges(cells).Build();
duplicatesHighlighter.HighlightDuplicates(selection);
Assert.AreEqual(3, RangeExtensionsStub.SetColorInvocations.Count());
}
private static bool AddRange(RangeBuilder builder, String range)
{
range = range.Trim();
if (range.Matches("[uU]\\+[0-9a-fA-F?]{1,6}(-[0-9a-fA-F]{1,6})?"))
{
String[] parts = iText.IO.Util.StringUtil.Split(range.JSubstring(2, range.Length), "-");
if (1 == parts.Length)
{
if (parts[0].Contains("?"))
{
return(AddRange(builder, parts[0].Replace('?', '0'), parts[0].Replace('?', 'F')));
}
else
{
return(AddRange(builder, parts[0], parts[0]));
}
}
else
{
return(AddRange(builder, parts[0], parts[1]));
}
}
return(false);
}
public Download WithRange(RangeBuilder builder)
{
_request.Range = builder;
return(this);
}
public static void MustBeInRange <T>(this T value, RangeBuilder <T> rangeBuilder)
{
Range <T> range = rangeBuilder;
value.MustBeInRange(range);
}
public void ZeroRange()
{
RangeBuilder b = CreateBuilder();
Assert.Null(b.Build());
}
