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,
Dear Team,
when I create a pdf with your components (RadFixedDocument, RadFixedPage, FixedContentEditor) I cannot add a "german umlaut" in that report because then it cannot be viewed in your own pdfviewer- control (the exception is: Error loading document: Position is out of range).
I tried to solve this in "creating/ loading" arial.ttf as external font (even this is weird as idea), but this also did not work.
What is your solution for that?
I bought the Telerik components basically for PDF processing, this simply needs to work...
Many thanks for an urgent update on that!
Best regards
Tobias
We found a small gap in Telerik's code, while defining name of Excel Sheet tab name (through Telerik Spreadsheet) --> using:
IWorksheetExporter CreateWorksheetExporter(string name);
of:
Telerik.Documents.SpreadsheetStreaming.IWorkbookExporter
When defining name of Excel sheet longer than 31 characters, Telerik code throws ArgumentException "Sheet name should be limited to 31 characters."
This is fine and correct - Excel sheet tab could be set UP TO 31 characters.
When using "shorter" name - like 30 characters, it works.
But when using exactly 31 characters, same Exception is thrown, which shouldn't be the case, as:
- Excel allows UP TO 31 charaters
- also you Exception message is clear that name should be limited TO 31 characters ;)
Best Regards,
Namyslaw Szymaniuk
public string AppendPdfList(string[] append)
{
PdfFormatProvider provider = new PdfFormatProvider();
RadFixedDocument targetDocument = new RadFixedDocument();
provider.ImportSettings.DocumentUnhandledException += (o, args) => { args.Handled = true; };
// Iterate through the files you would like to merge
foreach (string documentName in append)
{
RadFixedDocument sourceDocument = provider.Import(File.ReadAllBytes(documentName));
targetDocument.Merge(sourceDocument);
}
TelerikPdfHelper.ClearDuplicatedFonts(targetDocument);
OutputFilename = Path.GetTempFileName();
File.WriteAllBytes(OutputFilename, provider.Export(targetDocument));
return OutputFilename;
}
Results in System.NotImplementedException: 'The method or operation is not implemented.
Having issues when setting form text field that is rotated. The flatten method does not respect the alignment Middle/Right.
Also the field border does not get rotated.
See attached example.
Building Document Processing source code produces assemblies with the wrong VersionReleaseNumber. This leads to version 2022.1.<version_date> instead of 2022.2.<version_date>.
Workaround: Update VersionReleaseNumber to equal 2 in "...\Telerik_UI_For_WinForms_2022_2_510_DPL_source\DPL\Build\Imports\CommonConfig.targets"