Questions on Telerik Document Processing Forum

2 answers

625 views

Good morning,

I am trying to finish off a project and I am having trouble getting the PDF assemblies and namespaces sorted out.

I am using VS 2015, and the Telerik UI for WinForms version2018.3.2016

I wanted to export a RadPanel that has a few controls. But I can't seem to find the RadFixedDocument class, or the Telerik.Windows.Pdf namespace at all.

I was following documentation at Getting Started and RadFixedDocument Class and I have all the named assemblies referenced, but I still cannot see the Telerik.Windows.Pdf namespace at all. Much less the sought after RadFixedDocument object.

At this point I am sure I have more assemblies referenced that I actually need, I have attached a screenshot of what I have included so far.

Can anyone help me find what I am missing??

Thank you,

Mike

PdfProcessing

answered on 26 Oct 2018

1 answer

617 views

Line Spacing in RadFlowDocument

How can I set the line spacing in all table cells contained in one section equal to 0?

Regards

WordsProcessing

answered on 17 Oct 2018

1 answer

153 views

enableAfterSingleClick

Hello All,

I Have a RadButton and on click event, I am generating PDF File. Response.BinaryWrite is used so that user can save the file to desk.

The user shouldn't be clicking the button twice for which I have enabled the option SingleClick to True. The issue is that I have to Enable back the button once the user has completed the download of the file.

Need help with this.

Regards,

JP

General Discussions

answered on 15 Oct 2018

1 answer

118 views

Export to HTML

Do you have any way to export to HTML?. I need to display the preview of a Spreadsheet in the browser. I can do It for Word documents but for Spreadsheets there is not a direct way.

Do you have any example about this?, I need the preview to display properly the Styles of the Spreadsheet. I suggested to my client to use the PDF export but he didn't like.

Thanks.

SpreadProcessing

answered on 05 Oct 2018

4 answers

1.2K+ views

Issue around downloading Telerik.Windows.Documents.Spreadsheet.for.Net40 from nuget

We recently upgraded Sitefinity 9.1 to Sitefinity 11.0.

We process excel spreadsheets using "Telerik.Windows.Documents.Spreadsheet.Model" which references Telerik.Windows (2015.1.225.45) nuget package with .Net Framework 4.5

Sitefinity 11 uses .Net Framework 4.7.1 and seems like "Telerik.Windows.Documents.Spreadsheet.for.Net40" is the replacement for "Telerik.Windows.Documents.Spreadsheet.Model"? Is this true? If so I'm trying to download ...for.Net40 from Telerik nuget and I get an following error-

Unable to resolve dependency 'Telerik.Windows.Zip.for.Net40'.

I could not find this from Telerik's nuget package. Am I heading in the right direction? Appreciate help in advance.

SpreadProcessing

answered on 02 Oct 2018

1 answer

876 views

RadFlowDocument Landscape Orientation

I want to create the RadFlowDocument in Landscape. I used the Section. But I don't know how to use Section to insert text and insert line. Is there a easy way to change the whole document to Landscape mode?

Currently, I only find a full example of using editor.InsertText and editor.InsertLine. So, I am using the same method. Adding section could only change the margin, not the page orientation for whole document.

Section section = new Section(doc);
doc.Sections.Add(section);
section.PageMargins = new Telerik.Windows.Documents.Primitives.Padding(40, 40, 40, 40);
section.PageOrientation = PageOrientation.Landscape;
section.Rotate(PageOrientation.Landscape);

editor.InsertLine...

Thanks.

WordsProcessing

answered on 27 Sep 2018

6 answers

1.1K+ views

XlsxFormatProvider throw exceptions

Hi,

I have data in IList and i am trying to export the same to excel(.xls or .xlsx any one). But i am getting the exception. So if any one can put a light on it.
for (var i = 0; i < this.RowList.Count; i++)
{
for (var j = 0; j < this.Columns.Count; j++)
{
   worksheet.Cells[i, j].SetValue("Test");
}
}
if (workbook != null)
{
XlsxFormatProvider formatProvider = new XlsxFormatProvider();
formatProvider.Export(workbook, stream); // Exception here
}

{System.TypeInitializationException: The type initializer for 'Telerik.Windows.Documents.Spreadsheet.Measurement.FontManager' threw an exception. ---> System.UnauthorizedAccessException: Invalid cross-thread access.
at MS.Internal.XcpImports.CheckThread()
at MS.Internal.XcpImports.Font_GetSystemGlyphTypefaces()
at System.Windows.Media.Fonts.get_SystemTypefaces()
at Telerik.Windows.Documents.Spreadsheet.Measurement.FontManager..cctor()
--- End of inner exception stack trace ---
at Telerik.Windows.Documents.Spreadsheet.Measurement.FontManager.IsMonospaced(String fontFamily)
at Telerik.Windows.Documents.Spreadsheet.Model.FontProperties.get_IsMonospaced()
at Telerik.Windows.Documents.Spreadsheet.Measurement.RadTextMeasurer.Measure(String text, FontProperties fontProperties, Nullable`1 wrappingWidth)
at Telerik.Windows.Documents.Spreadsheet.Measurement.RadTextMeasurer.MeasureMultiline(String text, FontProperties fontProperties, Nullable`1 wrappingWidth)
at Telerik.Windows.Documents.Spreadsheet.Layout.LayoutHelper.CalculateCellContentSize(ICellValue cellValue, CellValueFormat format, FontProperties fontProperties, Int32 indentFactor, Nullable`1 wrappingWidth)
at Telerik.Windows.Documents.Spreadsheet.Layout.LayoutHelper.CalculateAutoColumnWidth(Worksheet worksheet, Int32 columnIndex, Int32 fromRowIndex, Int32 toRowIndex, Boolean respectNumberValuesOnly)
at Telerik.Windows.Documents.Spreadsheet.Model.ColumnSelection.<>c__DisplayClass8.<AutoFitWidth>b__7(CellRange cellRange)
at Telerik.Windows.Documents.Spreadsheet.Model.SelectionBase.ExecuteForEachRange(IEnumerable`1 cellRanges, Action`1 action, Predicate`1 canExecute)
at Telerik.Windows.Documents.Spreadsheet.Model.SelectionBase.ExecuteForEachRangeInsideBeginEndUpdate(IEnumerable`1 cellRanges, Action`1 action, Predicate`1 canExecute)
at Telerik.Windows.Documents.Spreadsheet.Model.ColumnSelection.AutoFitWidth(Boolean expandOnly)
at Telerik.Windows.Documents.Spreadsheet.Model.CellSelection.<>c__DisplayClass1`1.<SetPropertyValue>b__0(CellRange cellRange)
at Telerik.Windows.Documents.Spreadsheet.Model.SelectionBase.ExecuteForEachRange(IEnumerable`1 cellRanges, Action`1 action, Predicate`1 canExecute)
at Telerik.Windows.Documents.Spreadsheet.Model.SelectionBase.ExecuteForEachRangeInsideBeginEndUpdate(IEnumerable`1 cellRanges, Action`1 action, Predicate`1 canExecute)
at Telerik.Windows.Documents.Spreadsheet.Model.CellSelection.SetPropertyValue[T](ICellProperty`1 property, T value)
at Telerik.Windows.Documents.Spreadsheet.Model.CellSelection.SetValueInternal(ICellValue cellValue, CellValueFormat newFormat)
at Telerik.Windows.Documents.Spreadsheet.Model.CellSelection.SetValue(String value)
at OnGuard.Connext.FrontEnd.Library.SL.ViewModel.ExportOptionsViewModel.ExportToFile()}

SpreadProcessing

answered on 20 Sep 2018

4 answers

223 views

Digital certificate - Document changes and Signing time

Hello,

We have been trying to use create a service for automatic document signing.

Right now we have two problems:

1) When you sign a document through acrobat, it gives you an option of locking the document. If you do this, on the signature properties you can read something like: "The certifier has specified that no changes are allowed to be made to this document."

Do we have access to any variable that grants control over this behaviour?

2) When signing a pdf with a digital certificate, the signing time includes the time zone for example: "2018/09/11 12:07:20 + 01'00'". Is there any way to retrieve the same format so we can put it on the appearance? (If we just use the signatureField.Signature.Properties.TimeOfSigning.toString(), it does not include the timezone)

I'll be willing to supply any other code necessary.

Thank you in advance.

PdfProcessing

answered on 20 Sep 2018

5 answers

164 views

Package.AddStream losing stream information

Hi.

I have recently started using the ZipLibrary and I am facing an issue when adding streams to a ZipPackage. I am trying to add two streams to the ZipPackage, one for a PowerPoint file and the other for a Excel file. Once it is packaged, I want to write it to the OutputStream. Before I add the streams to the package, their size is significantly larger and have data because when I export them as individual streams (outside of a zip) it works just fine. Once added it looks like they lose all of their data and when it outputs, the PPTX and XLSX files are empty and corrupt respectively.

Here is my code below as well as the SendZipToClient snippet from another forum post, is there anything wrong with it or is it an issue from the ZipLibrary?

Additional Info:
.NET version: 4.5
Current Browser: FireFox 21.0
Telerik version for ASP.NET AJAX: 2013.1.417.45
Language: C#

private void StreamReports(Dictionary<int, MemoryStream> ReportStreams)

{

string destPPTXFile = string.Format("{0}.pptx", txtPresentationName.Text);

string destXLSXFile = string.Format("{0}.xlsx", txtPresentationName.Text);

MemoryStream outputStream = new MemoryStream();

ZipPackage zipPackage = ZipPackage.Create(outputStream);

MemoryStream powerpointStream = ReportStreams[0];

MemoryStream excelStream = ReportStreams[1];

zipPackage.AddStream(powerpointStream, destPPTXFile);

zipPackage.AddStream(excelStream, destXLSXFile);

SendZipToClient(outputStream, zipPackage);

}

private void SendZipToClient(MemoryStream memStream, ZipPackage Package)

{

string destFile = string.Format("{0}.zip", txtPresentationName.Text);

Package.Close(false);

memStream.Position = 0;

if (memStream != null && memStream.Length > 0)

{

Response.Clear();

Response.AddHeader("content-disposition", "attachment; filename=\"" + destFile);

Response.ContentType = "application/zip";

Response.BufferOutput = false; // to prevent buffering

byte[] buffer = new byte[1024];

int bytesRead = 0;

while ((bytesRead = memStream.Read(buffer, 0, buffer.Length)) > 0)

{

Response.OutputStream.Write(buffer, 0, bytesRead);

}

Response.End();

}

ZipLibrary

answered on 18 Sep 2018

4 answers

337 views

Error when importing file with external image links using DocxFormatProvider

I have the following code which fails at the `.Import` statement:

public byte[] PopulateHtmlAndTextBookmarks(byte[] input, List<BookmarkInfo> bookmarks)

{

// Get the bytes into the Telerik doc object and load that into an editor

DocxFormatProvider provider = new DocxFormatProvider();

RadFlowDocument document = provider.Import(input);

The error is "System.ArgumentNullException: 'Value cannot be null. Parameter name: relationshipId'"

The issue appears to be that I have two images in that file (Open XML relationship IDs "rId7" and "rId8") that point to external URLs. If I change those images to point at files inside the DocX container it works fine.

Does DocxFormatProvider work with external image links?

(I'm using 2018.2.619.40)

PS I've tried to attach the file but it says only .jpg, .jpeg, .gif, .png are allowed

WordsProcessing