Based on how Excel works, VLookup doesn't need to be sorted, if the 4th parameter is FALSE.  The 4th Parameter determines whether an approximate search is used or an exact match is used.  by default true is used and an approximate search requires a sorted range.  However, if set to FALSE,  then the range doesn't need to be sorted.  the value is checked against the entire column of cells and can be unsorted. 

We process spreadsheets that use VLOOKUP with 4th parameter set to FALSE and unsorted data in range.  These work in Excel, but not in Telerik Spreadsheet processing.

thanks, 

When importing a document with a style set in a parent <div> element its children`s (heading (<h1>-<h6>) and <div>) content doesn't inherit it.

Steps to reproduce:

1. Import the following HTML string:

   <div style="background-color: green;">
   	<h1>Test heading</h1>
   	<div>Test div</div>
   </div>

2. Export it as PDF (or any other supported format)

Actual vs Expected:
 

Even without flattening the form the Barcode font gets lost.

Noticed that manually setting the font using the font name with spaces seems to work.

Other custom fonts on our form appear to work, however the Free 3 of 9 does not.

Attached a project to demonstrate some issues we're seeing that need resolving in order to use the component.

1. When using a font like Tahoma on a form field, the value no longer displays or contains garbled text.

2. Input file is 24KB, output is 2MB!

3. Rotated field lose their rotation after being flattened.

4. Simulate merging with other files, 100 times the file is now 150MB! It's as though it's not re-using the fonts, but keeps adding the same ones.

5. when merging, but not flattening, the form fields are all lost on pages after page 1

When a TrueType font is defined, the mapping of character codes to glyph indices depends on the built-in cmap table mappings defined in the font and the Encoding property defined in the PDF dictionary.

However, the current implementation maps all characters with cmap tables for Microsoft Symbolic and Macintosh Roman, which causes incorrect mapping results, e.g. space characters are mapped to an Ê glyph.

The issue is also described in the following public item: TryGetCharCode for OpenTypeFont uses wrong cmap and returns wrong charcode.

Workaround: Change the font  of the TextBoxField's widget appearance:
foreach (var widget in field.Widgets)
{
    widget.TextProperties.Font = FontsRepository.Helvetica;
}

When merging documents` pages using the PdfStreamWriter the Form Fields are not copied:

using (PdfStreamWriter fileWriter = new PdfStreamWriter(File.OpenWrite(document2Name)))
{
	// Iterate through the files you would like to merge 
	for (int i = 0; i < 2; i++)
	{
		// Open each of the files 
		using (PdfFileSource fileToMerge = new PdfFileSource(File.OpenRead(document1Name)))
		{
			// Iterate through the pages of the current document 
			foreach (PdfPageSource pageToMerge in fileToMerge.Pages)
			{
				// Append the current page to the fileWriter, which holds the stream of the result file 
				fileWriter.WritePage(pageToMerge);
			}
		}
	}
}

A possible workaround is to use the RadFixedDocument`s Merge() method: 

document1.Merge(document2);