Telerik Forums
Telerik Document Processing Forum
or
Ask question
All Questions
Unanswered
Answered
817 questions
3 answers
1.8K+ views
HTML to PDF Conversion CSS styles and Table of Contents internal links not working
We have a requirement to convert a HTML document to PDF. When we try to import the HTML using HtmlFormatProvider the CSS styles are not imported and we also loose the table of contents hyperlink in the document. In turn the PDF which is exported does not seem to have the styles applied. Please could you provide your suggestion on how to achieve HTML to PDF conversion along with CSS styles.
WordsProcessing
Peshito
Telerik team
 answered on 26 Mar 2019
1 answer
136 views
Changing Cells colors with a 30 megs file

Good day,

I'm importing an Excel file and I need to validate all the cells an then import the result in our database.

When I have and error I change the Cell color. For small file I don't fell a performance issue. But on big file it's not possible. It take about half a second to change the color.

I turn off the History mode on the Woorkbook.  wb.History.IsEnabled = false;

This is my code with cellSelection.SetFill(SolidErrorFill); commented to have better speed. How can I achieve a better speed ?

Thanks!

01.public override IExcelRuleResult Evaluate(Worksheet ws)
02.       {
03.           var result = new ExcelRuleResult();
04.           result.ExcelIsValid = true;
05.           CellRange cr = ws.UsedCellRange;
06.           if (cr != null)
07.           {
08.               for (int rowIndex = 1; rowIndex <= cr.ToIndex.RowIndex; rowIndex++)
09.               {
10.                   // Read Row 0 for header name and validate if all the cells have the same format
11.                   var sale = new Sale();
12.                   for (int columnIndex = cr.FromIndex.ColumnIndex; columnIndex <= cr.ToIndex.ColumnIndex; columnIndex++)
13.                   {
14.                       RangePropertyValue<ICellValue> rpv = null;
15.                       CellSelection cellSelection = null;
16.                       //var rpvName = ws.Cells[0, columnIndex].GetValue();
17.                       var columnName = (layout.Layouts[columnIndex] as XlsxLayoutBase)?.ColumnName;
18.                       var columnLayout = layout.Layouts[columnIndex] as XlsxLayoutBase;
19.                       string value = null;
20.                       if (columnLayout != null)
21.                       {
22.                           try
23.                           {
24. 
25.                               cellSelection = ws.Cells[rowIndex, columnIndex];
26.                               rpv = cellSelection.GetValue();
27.                               if (rpv.Value is FormulaCellValue fcv)
28.                               {
29.                                   value = fcv.GetResultValueAsString(new CellValueFormat(columnLayout.FormatString));
30.                               }
31.                               else
32.                               {
33.                                   value = rpv.Value.RawValue;
34.                               }
35. 
36.                               if (columnLayout.DataType == EnumDataType.Date)
37.                               {
38.                                   // Assembly: ServiceStack.Text .ToDoubleInvariant()
39.                                   value = FormatHelper.ConvertDoubleToDateTime(value.ToDoubleInvariant())?.Date.ToString("O");
40.                               }
41. 
42.                               if (columnLayout.Mandatory && string.IsNullOrWhiteSpace(value))
43.                               {
44.                                   //cellSelection.SetFill(SolidErrorFill);
45.                                   // We have {rowIndex+1} so it's the same line excel, 0 Base array in c# and Excel start at 1
46.                                   result.Messages.Add($"Mandatory Value: ({value}) for ColumnName ({columnName}) at Row {rowIndex + 1}");
47.                                   result.ExcelIsValid = false;
48.                               }
49.                               else
50.                               {
51.                                   //MapperHelper.AssignFieldValue(value, sale, columnName);
52.                               }
53.                           }
54.                           catch (Exception ex)
55.                           {
56.                               //cellSelection?.SetFill(SolidErrorFill);
57.                               result.ExcelIsValid = false;
58.                               // We have {rowIndex+1} so it's the same line excel, 0 Base array in c# and Excel start at 1
59.                               result.Messages.Add($"Exception Column Value: ({value}) for ColumnName ({columnName}) at Row {rowIndex + 1}  {ex.Message}");
60.                           }
61.                       }
62.                   }
63.                   Sales.Add(sale);
64.                   Console.WriteLine(rowIndex);
65.               }
66.           }
67.           return result;
68.       }
SpreadProcessing
Nikolay Demirev
Telerik team
 answered on 25 Mar 2019
1 answer
89 views
Best way of storing contents of RadPanel using DrawImage

HI,

I have an application which is generating a PDF report using FIxedContentEditor, some of the report must contain a dump of the contents of various RadPanel controls, my current implementation first creates a bitmap of the control using control.DrawToBitmap and then converts this to a BitmapSource and then an ImageSource.

Its not particularly fast and takes around 2.5 seconds for a single 3000x2000 full page image to be added to the PDF, is there a better / faster / more efficient way this can be achieved ?

Regards

Toby

PdfProcessing
Georgi
Telerik team
 answered on 21 Mar 2019
3 answers
240 views
Create new interactive forms field for each item in list

Good Morning, 

 

I'm currently working on a project which consists in using a foreach on a list which then I would like to create a new texbox for each of the items. 

Also please note that I'm new to this so sorry if I haven't explained it properly.  

When running the debugger it complains of the item having the same key when it comes around to create the second textbox. Which it would be referring to the the  "txtBox". 

 

Please see the snippet below: 

            foreach (var c in list)

            {
                  TextBoxField txtBox = new TextBoxField("txtBox");
                   
                    txtBox.IsRequired = true;
                    txtBox.IsReadOnly = true;
                    document.AcroForm.FormFields.Add(txtBox);
                    txtBox.Value = "abc";
                    editor.Position.Translate(0, 110);
                    editor.DrawWidget(txtBox, new System.Windows.Size (300, 100));
            };

 

 

Thanks

Marco

PdfProcessing
Georgi
Telerik team
 answered on 20 Mar 2019
4 answers
1.2K+ views
Invalid FORMATETC structure (Exception from HRESULT: 0x80040064 (DV_E_FORMATETC))

Hi, when the form that contains the RadSpreadSheet component appear, the focus of mouse stay on a cell, when press CTRL + V and press TAB have this error when execute the app from .exe after compile the app in release mode, when execute the app from Visual Studio the error not appear.

 

 

 

 

 

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Runtime.InteropServices.COMException (0x80040064): Invalid FORMATETC structure (Exception from HRESULT: 0x80040064 (DV_E_FORMATETC))
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at System.Windows.DataObject.System.Runtime.InteropServices.ComTypes.IDataObject.GetData(FORMATETC& formatetc, STGMEDIUM& medium)
   at Telerik.WinForms.Spreadsheet.Uniscribe.ScriptItemize(String pwcInChars, Int32 cInChars, Int32 cMaxItems, ScriptControl psControl, ScriptState psState, ScriptItem[] pItems, Int32& pcItems)
   at Telerik.WinForms.Spreadsheet.Uniscribe.ScriptItemize(String s, ScriptControl control, ScriptState state)
   at Telerik.WinForms.Spreadsheet.Uniscribe.ContainsComplexScript(String str)
   at Telerik.WinControls.Spreadsheet.UI.TextBlock.DrawRunGDI(Run run, RunLayoutInfo runInfo, Single fontSizeScale, PointF location, NativeTextRenderer renderer)
   at Telerik.WinControls.Spreadsheet.UI.TextBlock.DrawGdi(Single angle, Graphics nativeGraphics, Single fontSizeScale)
   at Telerik.WinControls.Spreadsheet.UI.TextBlock.PaintElement(IGraphics graphics, Single angle, SizeF scale)
   at Telerik.WinControls.RadElement.DoOwnPaint(IGraphics graphics, Single angle, SizeF scale)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChild(RadElement child, IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.VisualElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChild(RadElement child, IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.VisualElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChild(RadElement child, IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.VisualElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChild(RadElement child, IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.VisualElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChild(RadElement child, IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.VisualElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChild(RadElement child, IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.VisualElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChild(RadElement child, IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.VisualElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChild(RadElement child, IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.VisualElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChild(RadElement child, IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.VisualElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChild(RadElement child, IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.VisualElement.PaintChildren(IGraphics graphics, Rectangle clipRectange, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadElement.Paint(IGraphics graphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadItem.PaintOverride(IGraphics screenRadGraphics, Rectangle clipRectangle, Single angle, SizeF scale, Boolean useRelativeTransformation)
   at Telerik.WinControls.RadControl.OnPaint(PaintEventArgs e)
   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
   at System.Windows.Forms.Control.WmPaint(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at Telerik.WinControls.RadControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3324.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
SPL
    Assembly Version: 0.0.0.0
    Win32 Version: 0.0.0.0
    CodeBase: file:///C:/Users/502699069/Documents/SPL%20Con%20Telerik_1/SPL/bin/Release/SPL.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3324.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3353.0 built by: NET472REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2556.0 built by: NET471REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
CrowdStrike.Sensor.ScriptControl
    Assembly Version: 4.21.8406.0
    Win32 Version: 4.21.8406.0
    CodeBase: file:///C:/WINDOWS/SysNative/CrowdStrike.Sensor.ScriptControl8406.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2556.0 built by: NET471REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3324.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2612.0 built by: NET471REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
SPL_EntityLibrary
    Assembly Version: 0.0.0.0
    Win32 Version: 0.0.0.0
    CodeBase: file:///C:/Users/502699069/Documents/SPL%20Con%20Telerik_1/SPL/bin/Release/SPL_EntityLibrary.DLL
----------------------------------------
Telerik.WinControls.UI
    Assembly Version: 2019.1.117.40
    Win32 Version: 2019.1.117.40
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Telerik.WinControls.UI/v4.0_2019.1.117.40__5bb2a467cbec794e/Telerik.WinControls.UI.dll
----------------------------------------
Telerik.WinControls
    Assembly Version: 2019.1.117.40
    Win32 Version: 2019.1.117.40
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Telerik.WinControls/v4.0_2019.1.117.40__5bb2a467cbec794e/Telerik.WinControls.dll
----------------------------------------
Oracle.DataAccess
    Assembly Version: 4.112.3.0
    Win32 Version: 4.112.3.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/Oracle.DataAccess/v4.0_4.112.3.0__89b483f429c47342/Oracle.DataAccess.dll
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3260.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3221.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Data.Entity
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2556.0 built by: NET471REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.Entity/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Entity.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2556.0 built by: NET471REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
TelerikCommon
    Assembly Version: 2019.1.117.40
    Win32 Version: 2019.1.117.40
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/TelerikCommon/v4.0_2019.1.117.40__5bb2a467cbec794e/TelerikCommon.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.7.2612.0 built by: NET471REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Telerik.Windows.Documents.Spreadsheet
    Assembly Version: 2019.1.114.40
    Win32 Version: 2019.1.114.40
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Telerik.Windows.Documents.Spreadsheet/v4.0_2019.1.114.40__5803cfa389c90ce7/Telerik.Windows.Documents.Spreadsheet.dll
----------------------------------------
Telerik.WinControls.RadSpreadsheet
    Assembly Version: 2019.1.117.40
    Win32 Version: 2019.1.117.40
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Telerik.WinControls.RadSpreadsheet/v4.0_2019.1.117.40__5bb2a467cbec794e/Telerik.WinControls.RadSpreadsheet.dll
----------------------------------------
WindowsBase
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3324.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
Telerik.Windows.Documents.Core
    Assembly Version: 2019.1.114.40
    Win32 Version: 2019.1.114.40
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Telerik.Windows.Documents.Core/v4.0_2019.1.114.40__5803cfa389c90ce7/Telerik.Windows.Documents.Core.dll
----------------------------------------
PresentationFramework
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3324.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.dll
----------------------------------------
PresentationCore
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3324.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/PresentationCore/v4.0_4.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf
    Assembly Version: 2019.1.114.40
    Win32 Version: 2019.1.114.40
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf/v4.0_2019.1.114.40__5803cfa389c90ce7/Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf.dll
----------------------------------------
Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml
    Assembly Version: 2019.1.114.40
    Win32 Version: 2019.1.114.40
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml/v4.0_2019.1.114.40__5803cfa389c90ce7/Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.dll
----------------------------------------
Telerik.Windows.Documents.Fixed
    Assembly Version: 2019.1.114.40
    Win32 Version: 2019.1.114.40
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Telerik.Windows.Documents.Fixed/v4.0_2019.1.114.40__5803cfa389c90ce7/Telerik.Windows.Documents.Fixed.dll
----------------------------------------
System.Xaml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3324.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xaml/v4.0_4.0.0.0__b77a5c561934e089/System.Xaml.dll
----------------------------------------
Telerik.Windows.Zip
    Assembly Version: 2019.1.114.40
    Win32 Version: 2019.1.114.40
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Telerik.Windows.Zip/v4.0_2019.1.114.40__5803cfa389c90ce7/Telerik.Windows.Zip.dll
----------------------------------------
System.Deployment
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2556.0 built by: NET471REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Deployment/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


SpreadStreamProcessing
Dess | Tech Support Engineer, Principal
Telerik team
 answered on 19 Mar 2019
11 answers
917 views
Encrypt an existing PDF file
How can i encypt an existing PDF file? I just want to set the password on it.
PdfProcessing
Tanya
Telerik team
 answered on 14 Mar 2019
4 answers
137 views
Issue with NameConverter.ConvertRowNameToIndex(cell)

Hi, im trying to convert a string value("C5") to row, debugging get the error 

-NameConverter.ConvertColumnNameToIndex(cell)'NameConverter.ConvertColumnNameToIndex(cell)' threw an exception of type 'Telerik.Windows.Documents.Spreadsheet.Utilities.LocalizableException'int {Telerik.Windows.Documents.Spreadsheet.Utilities.LocalizableException}
+Data{System.Collections.ListDictionaryInternal}System.Collections.IDictionary {System.Collections.ListDictionaryInternal}
+FormatStringArguments{string[1]}string[]
HResult-2146233088int
HelpLinknullstring
+InnerException{"'C5' is invalid column name."}System.Exception {System.InvalidOperationException}
LocalizationKey"Spreadsheet_ErrorExpressions_InvalidColumnName"string
Message"'C5' is invalid column name."string
Source"Telerik.Windows.Documents.Spreadsheet"string
StackTrace"   at Telerik.Windows.Documents.Spreadsheet.Utilities.NameConverter.ConvertColumnNameToIndex(String columnName)"string
+TargetSite{Int32 ConvertColumnNameToIndex(System.String)}System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo}
+Static members
+Non-Public members

 

 


SpreadProcessing
Nikolay Demirev
Telerik team
 answered on 13 Mar 2019
5 answers
222 views
Mail merge component for non-UI application
I search for a component for sending mails:
- It should be used in a non-UI application.
- The input provided to the mail merge component is a template retrieved dynamically from a data source as string.
- The template contains HTML code and arbitrary placeholders, which should be replaced by values provided e. g. from e.g. a dictionary. The templates are not created yet. Hence, the syntax for the templating language may be dictated by the component. It would be good if the templating language supported advanced concepts like control flow statements or at least alternatives.
- The email should be sent via SMTP as HTML mail.
- Email attachments are needed.
- Email address validation would be nice.

Do you offer sth. like this?
General Discussions
Tanya
Telerik team
 answered on 11 Mar 2019
1 answer
112 views
Model editor

Hi,

Working on a web application, i've built a mail merge program on server side. This last one reads a word document as a model and performs a merge by using Telerik librairies.

 

In this case, the models are very user dependant (basically every agency has its own format for each type of document), so I need to provide a graphical tool to format the models, add and remove merge fields. Is there any telerik component capable of doing so ? Or, is there any other suggested solution  ?

 

Best resgards

 

WordsProcessing
Nikolay Demirev
Telerik team
 answered on 11 Mar 2019
1 answer
250 views
Set a static header

I'm using Rad Fixed Content Editor to export pdf but i cant find a way to set a static header through my main table.

I mean i have a document with a table and other contents. I want to set a static header for this table only

Please help me

PdfProcessing
Georgi
Telerik team
 answered on 06 Mar 2019
Narrow your results
Done
Selected tags
Tags
PdfProcessing
WordsProcessing
SpreadProcessing
ZipLibrary
General Discussions
SpreadStreamProcessing
+? more
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
41 42
43
44 45
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
Want to show your ninja superpower to fellow developers?
Learn how