Questions on Telerik Document Processing Forum

1 answer

427 views

We store some texts in rtf-format in our database. Now I have to convert them to html.

This is an expample of the rtf-text:

{\rtf1\ansi\ansicpg1252\deff0\deflang2055{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\fs20 Dampf- und Gassperre aus Fl\'fcssigkunststoff f\'fcr D\'e4mmung von K\'e4lteleitungen. Flexible, schwerentflammbare und dampfbremsende Beschichtung auf Wasserbasis. Auch geeignet zum Schutz von l\'f6sungsmittelempfindlichen Isolierstoffenbei K\'e4lte-Isolierungen im Innen- und Aussenbereich.\f1\fs17\par
}

To convert it to html I use the following code:

Telerik.Windows.Documents.Flow.FormatProviders.Rtf.RtfFormatProvider rtfProv = new();
      Telerik.Windows.Documents.Flow.Model.RadFlowDocument rtfDoc = rtfProv.Import(rtfInput);
      
      Telerik.Windows.Documents.Flow.FormatProviders.Html.HtmlExportSettings expSettings = new()
      {
        DocumentExportLevel = Telerik.Windows.Documents.Flow.FormatProviders.Html.DocumentExportLevel.Fragment,
        StylesExportMode = Telerik.Windows.Documents.Flow.FormatProviders.Html.StylesExportMode.None,
      };
      Telerik.Windows.Documents.Flow.FormatProviders.Html.HtmlFormatProvider htmlProv = new() 
      { 
        ExportSettings = expSettings 
      };
      string ret = htmlProv.Export(rtfDoc);
      return new HtmlString(ret);

This code works . The output looks like this:

<body><p style="margin-bottom: 0px;"><span style="font-size: 13.333333333333334px;">Dampf- und Gassperre aus Fl&uuml;ssigkunststoff f&uuml;r D&auml;mmung von K&auml;lteleitungen. Flexible, schwerentflammbare und dampfbremsende Beschichtung auf Wasserbasis. Auch geeignet zum Schutz von l&ouml;sungsmittelempfindlichen Isolierstoffenbei K&auml;lte-Isolierungen im Innen- und Aussenbereich.</span></p></body>

How can I remove or replace the style-attribute with the font-size in the span?

WordsProcessing

answered on 29 Sep 2023

1 answer

158 views

XLSX corrupted from csv data source (last version 2023.2.713.20)

Hello,

I have a corrupted XLSX file from CSV dataSource

With other CSV dataSource all is ok

In example in file-attach, I added CSV dataSource with corruption

There are 2 bad lines in generated XLSX file and CSV file have a good format !!!

It's not an issue with codepage or separator !

It's a projet DotNet Core 6 with last version 2023.2.713.20 of API

Do you have encountered this error already ?

Best regards

Cyril REILER

SpreadProcessing

SpreadStreamProcessing

updated answer on 26 Sep 2023

1 answer

361 views

How te remove whitespace below text in table cell?

Hi all,

This is a fragment from my code where I use tables in a RadFlowDocument to list some values. This all works fine for me, except one thing: between the text in a cell en the bottom border of that cell is some white space I can't get rid of. I want the bottom border of the cell to have the same distance to the text in the cell as between the text and the top border (border color set to blue for debugging..)

Tried playing with the row Height, cell padding, etc., but that doesn't change anything.

What am I missing?

  var doc = new RadFlowDocument();

                    var tableStyle = new Style("TableStyle", StyleType.Table);
                    tableStyle.TableProperties.Borders.LocalValue = new TableBorders(new Border(1, BorderStyle.Single, new ThemableColor(Colors.Blue)));
                    tableStyle.TableProperties.Alignment.LocalValue = Alignment.Left;
                    tableStyle.TableCellProperties.VerticalAlignment.LocalValue = VerticalAlignment.Top;
                    tableStyle.TableCellProperties.Padding.LocalValue = new Padding(0, 0, 0, 0);
                    tableStyle.TableRowProperties.TableCellSpacing.LocalValue = 0;
                    tableStyle.CharacterProperties.FontSize.LocalValue = 12;
                    doc.StyleRepository.Add(tableStyle);

                    var section = new Section(doc)
                    {
                        PageMargins = new Padding(50, 50, 50, 50),
                        PageNumberingSettings =
                        {
                            StartingPageNumber = 1,

                        }
                    };
                    doc.Sections.Add(section);

                    var paragraph = new Paragraph(doc);
                    section.Blocks.Add(paragraph);

                    Table table = new Table(doc, 0, 2)//  0 rows, 2 columns. 
                    {
                        LayoutType = TableLayoutType.FixedWidth,
                        PreferredWidth = new TableWidthUnit(700),
                        StyleId = "TableStyle"
                    };
                    // add 2 rows with 2 cells
                    TableRow row = table.Rows.AddTableRow();
                    TableCell cell = row.Cells.AddTableCell();
                    cell.PreferredWidth = new TableWidthUnit(100);
                    paragraph = cell.Blocks.AddParagraph();
                    paragraph.Inlines.AddRun($"Cell R1C1");

                    cell = row.Cells.AddTableCell();
                    cell.PreferredWidth = new TableWidthUnit(600);
                    paragraph = cell.Blocks.AddParagraph();
                    paragraph.Inlines.AddRun("Cell R1C2");

                    cell = row.Cells.AddTableCell();
                    cell.PreferredWidth = new TableWidthUnit(100);
                    paragraph = cell.Blocks.AddParagraph();
                    paragraph.Inlines.AddRun($"Cell R2C1");

                    cell = row.Cells.AddTableCell();
                    cell.PreferredWidth = new TableWidthUnit(600);
                    paragraph = cell.Blocks.AddParagraph();
                    paragraph.Inlines.AddRun("Cell R2C2");

Kind regards,

Kees Alderliesten

PdfProcessing

answered on 13 Sep 2023

0 answers

282 views

Is there a way to get a PDF to export to HTML to display on a page, or is there a good way to get a PDF on a page?

As the title says...

PdfProcessing

asked on 17 Aug 2023

0 answers

601 views

Failed to unzip the File which is zipped by 7Z

public void UnzipTSWFiles(string sourceDirectory, string destinationDirectory, string password)
{
DefaultEncryptionSettings protectionSettings = new DefaultEncryptionSettings() { Password = password };

using (ZipArchive zipArchive = new ZipArchive(output, ZipArchiveMode.Read, true, null, null, protectionSettings))
{
foreach (ZipArchiveEntry entry in zipArchive.Entries)
{
using (Stream entryStream = entry.Open())
using (FileStream fileStream = File.OpenWrite(string.Format("{0}/{1}", targetDirectory, entry.FullName)))
{
entryStream.CopyTo(fileStream);
}
}
}

}

ZipLibrary

asked on 09 Aug 2023

1 answer

268 views

Work with XFA PDF Forms?

I've searched and searched and I cannot find any information around using Telerik.Documents.Fixed with PDF's that have XFA forms. Is this possible? And if so is there any sample code showing how to do it?

Thanks.

PdfProcessing

answered on 21 Jul 2023

1 answer

190 views

RadSpreadProcessing - AutoFitHeight with merged cell

I do notice that the AutoFitHeight works fine when I'm dealing with only a single row without any merged cells.

I have a situation where I have a merged cell which is the combination of cells from the same row (i.e. B2-B5). When trying to use AutoFitHeight, there is no change to the row height.

Is there anything I could do?

SpreadProcessing

answered on 18 Jul 2023

1 answer

115 views

Content Controls Bombobox change colour with selection

We have a scenario where the client is wanting a combobox in a generated Word document to have the color of the combobox change depending on the option selected (these combo boxes are repeated many times in the document so the colour change is important to the client.

Screenshot shows the Combobox in use. Below is the snippet of my code. Is there a way to do what I am after?

RadFlowDocumentEditor editor = new RadFlowDocumentEditor(document);
// In my source (an html document that was converted to a Word Document higher in the code) "#ddlApplies" is where I need to place a ComboBox
// It is in a table cell.
ReadOnlyCollection<FindResult> findResults = editor.FindAll("#ddlApplies", matchCase: false, matchWholeWord: false);
foreach (var item in findResults)
{
	string foundVal = item.Runs[0].Text.Replace("#", "");
	// The full run name consists of "#ddl|Identifier". In Furture dev we will use the Identifier (which is put in as the alias) to identify which control this is so we can read in the document and update other datasets
	//var ddlContentControl = editor.InsertStructuredDocumentTag(SdtType.ComboBox);
	ComboBoxProperties properties = new ComboBoxProperties();
	// Complies --- Green
	// Does not Comply --- Red
	// Minor Variation --- Orange
	// N/A -- Grey
	properties.Items.Add(new ListItem() { DisplayText = "Complies", Value = "Complies" });
	properties.Items.Add(new ListItem() { DisplayText = "Does not Comply", Value = "Does not Comply" });
	properties.Items.Add(new ListItem() { DisplayText = "Minor Variation", Value = "Minor Variation" });
	properties.Items.Add(new ListItem() { DisplayText = "N/A", Value = "N/A" });
	// Setting the alias with the identifier.
	properties.Alias = foundVal.Split("|")[1];
	properties.Lock = Lock.SdtLocked;
	properties.Placeholder = new Placeholder() {
		PlaceholderText = "Select",
		ShowPlaceholder = true
	};
	properties.OutlineAppearance = OutlineAppearance.BoundingBoxes;
	//setting the properties
	properties.RunProperties.CopyPropertiesFrom(item.Runs[0].Properties);
	/***
	Here is where I think I need to set things. But not sure how. Client wants each option to have a different colour. They would prefer the whole cell to change, but happy if I can just get the ComboBox to change.
	
	***/
	
	//inserting the Tag and setting the default value
	editor.MoveToInlineStart(item.Runs[0]);	
	editor.InsertStructuredDocumentTag(properties, item.Runs[0], item.Runs[0]);
	item.Runs[0].Text = "Select";	

}

WordsProcessing

answered on 17 Jul 2023

1 answer

112 views

install document library independent of component UI libary

How can I install the document library alone without installing a component UI library?

I just want to process PDF files

General Discussions

answered on 13 Jul 2023

1 answer

283 views

Is there any example for VB.NET ?

I want to learn more about Word processing and how to create tables in the Word document.
Unfortunately I only ever see c# code.
Can someone show me an example for VB.NET ?
A simple table with cell contents..

WordsProcessing

answered on 13 Jul 2023