Hello,

I'm using Telerik Documents Processing 2023.1.410

With WordsProcessing, if I add a table in a footer it will automatically add a space after the table

Here an example, my table is the same size as my image in background and I removed all margin of the section:

Here the code:

Footer footer = section.Footers.Add(HeaderFooterType.Default)
section.PageMargins = new Padding(0,96,96,0);
section.FooterBottomMargin = 0;

Table table = footer.Blocks.AddTable();
TableRow row = table.Rows.AddTableRow();
TableCell cell = row.Cells.AddTableCell();
Paragraph paragraph = cell.Blocks.AddParagraph();
paragraph.Inlines.AddRun("Something");

I didn't any properties to manage spaces around a Table like in Paragraph.

It can be reproduced without the image

Work around:

If I add a new paragraph at the end and remove all spaces of this paragraph then it works

Here the code added:

paragraph = footer.Blocks.AddParagraph();
paragraph.Spacing.SpacingAfter = 0;
paragraph.Spacing.SpacingBefore = 0;
paragraph.Spacing.LineSpacing = 0;

Regards,
Hervouet Thomas

Hi 

is there possible Telerik RadSpreadProcessing able to print repeat column on every printed page?

When importing an XLSX that has "Date" number-formatted cells, and those cells have the 5-digit representation of th edate, XslxFormatProvider.Import(bytes) will throw a KeyNotFoundException. The exception message is "The given key '58' was not present in the dictionary" for the particular case we're looking at.

Unfortunately, we cannot provide the file itself, as it has PHI in it. And, when we open it in Excel and resave it, Excel will automatically convert the 5-digit representation to a normal date. This new file will import just fine. However, we're trying to cut out that intermediate step.

Pertinent portion of the stack trace:
   at System.ThrowHelper.ThrowKeyNotFoundException[T](T key)

Export should take into account JavaScript and produce PDF similar to the original page.

When exporting RadFlowDocument that contains TOC field, resultant PDF document should contain link point to the page shown in TOC.


note this is different from already existing request as this request is to link to the page, which is possible in telerik PDF export as demonstrated here and not to the bookmark.

1. Line Height is not converted properly.  for example, if we set the line height is 1.5 in angular UI editor, in PDF is not shown properly,

2. Table alignment is not proper -  After resizing the in the angular editor, the same alignment is not converted in PDF. I think colgroup and cols custom tags are not considering while converting the PDF.

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.

I have read that there limitations to PDF files being imported, however, the file being imported  was generated with FixedContentEditor, so, should be able to import?

Hi, 

I am trying to convert a HTML body to a PDF using HtmlFormatProvider and PdfFormatProvider. 

It works well when I try to create a pdf with "normal" characters, but when I use characters like "åäö" the characters is either missing or replaced with other character. 

I have found a similiar issue but that was due to the fact that the person was using .net core I am using .net framework. 

Am I missing something when I am converting it to a PDF or is there a limitation with special characters like "åäö". 

        private string CreateAndStorePdf(string htmlBody)
        {
            Telerik.Windows.Documents.Extensibility.JpegImageConverterBase jpegImageConverter = new Telerik.Documents.ImageUtils.JpegImageConverter();
            Telerik.Windows.Documents.Extensibility.FixedExtensibilityManager.JpegImageConverter = jpegImageConverter;

            var provider = new HtmlFormatProvider();
            var document = provider.Import(htmlBody);
            var exportProvider = new PdfFormatProvider();
            var fixedExportProvider = new Telerik.Windows.Documents.Flow.FormatProviders.Pdf.PdfFormatProvider();
            var fileName = "_original.pdf";

            try
            {
                using (var outputStream = new MemoryStream())
                {
                    exportProvider.Export(fixedExportProvider.ExportToFixedDocument(document), outputStream);
                    outputStream.Seek(0, SeekOrigin.Begin);
                    var pdfBytes = new BinaryReader(outputStream).ReadBytes((int)outputStream.Length);

                    return fileName;
                }
            }
            catch (Exception ex)
            {
                Log.Error(ex, "The pdf could not be created.");
                return null;
            }
        }

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

I open an xlsx file thant i create with Excel and edit it with RadSpreadProcessing.

But then I can't display it in a RadSpreadsheet control. An error is displayed during execution on localhost.

Here is the error message:

Exception non gérée à la ligne 48298, colonne 17 dans http://localhost:53844/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=;;System.Web.Extensions,+Version=4.0.0.0,+Culture=neutral,+PublicKeyToken=31bf3856ad364e35:fr-CA:bc17b1ef-7a1b-49cb-a795-5f1c64597a53:ea597d4b:b25378d2;Telerik.Web.UI:fr-CA:b87b3d5b-f055-4852-bdaf-fef1991116e3:16e4e7cd:f7645509:22a6274a:33715776:8674cba1:7c926187:88144a7a:b7778d6c:c08e9f8a:59462f1:a51ee93e:24ee1bba:6d43f6d9:e330518b:1e771326:8e6f0d33:864068a5:6a6d718d:58366029:874f8ea2:4cd1fec6:71188da4:487c8be1:670fdf23:d944e0f6:c442ac3f:ec7335e:2e4adfe5:b4bec146:77613e24:69667591:a4c22f0d:e0037459:2f872eeb:75e7b247:b9057478:e8e3832e:728f182a:c4143936:5f88c545:6ed7f76e:32b48b51:935ec1c6:f0c58c30:16dc2978:1611ddf4:1bfaef2a:26e91122:c128760b:a7e79140:185812c5:f46195d3:6b3f73b3:2003d0b8:aa288e2d:b092aa46:a44b89c4:c8618e41:e4f8f289:1a73651d:16d8629e:2bef5fcc:a9b7ace7:e085fe68:52af31a4:5fa37e7e

0x800a139e - Erreur d’exécution JavaScript: Expected op «,» but found punc «;» (input: IF(D8<>0;E8/D8;0))

If a workbook was created with Excel, an error prevents it from being opened programmatically in a RadSpreadsheet control. Although it can be displayed there using the open button of the RadSpreadsheet. This error does not occur if you copy the contents of this workbook into the RadSpreadsheet and then save it with the save button on the RadSpreadsheet.

Thank you

I'm trying to use RadWordsProcessing

to replace text in .docx documents.

when i try to open a document i have an error:

BadImageFormatException: Could not load file or assembly 'PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. Reference assemblies should not be loaded for execution.  They can only be loaded in the Reflection-only loader context. (0x80131058)

Hello Support,

I am generating pdf using PdfFormatProvider. In this i am passing html data which should be converted into pdf. For that I have written below code.

HtmlFormatProvider htmlFormatProvider = new HtmlFormatProvider();

RadFlowDocument htmlDocument = htmlFormatProvider.Import(htmlContentValue);

 var anotherpara = sectionBody.Blocks.AddParagraph();

editor.MoveToParagraphStart(anotherpara);

editor.InsertDocument(htmlDocument, options);

This works fine and also get pdf with expected value. But I would like to set spacing between two lines which I could not set or its not working. For that I have added below code.

I have also attached screenshot for it. like how its showing on pdf

editor.ParagraphFormatting.AutomaticSpacingAfter.LocalValue = false;
editor.ParagraphFormatting.AutomaticSpacingBefore.LocalValue = false;
editor.ParagraphFormatting.SpacingAfter.LocalValue = 0;
editor.ParagraphFormatting.SpacingBefore.LocalValue = 0;

So could you please let me know fix for it.

Attempting to open a Pdf document containing an unsupported action type results in a NotSupportedActionException being thrown (see PdfProcessing: Add support for actions of type Launch).

Can the behavior be changed to ignore unsupported actions and allow the document to be opened?

Importing XLSX file in Blazor Web Assembly for .NET 5.0 is very slow.

          <InputFile OnChange="@HandleFileSelected" />

async Task HandleFileSelected(InputFileChangeEventArgs e)

{

   var ms = new MemoryStream((int)e.File.Size);
        Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();
        using (Stream ey = e.File.OpenReadStream(e.File.Size))
        {
            await ey.CopyToAsync(ms,(int)e.File.Size);
            ey.Close();
        }
        oWorkbook = formatProvider.Import(ms);

  }  

The common annotation properties are described in table "Entries common to all annotation dictionaries" of the Pdf specification.

Declined: Handling a partial annotation import-export could lead to exporting invalid PDF documents.