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)

   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Contexts.XlsxWorksheetImportContext.ImportDirectFormattingInRange(XlsxWorkbookImportContext workbookContext, FormattingRecord directFormatting, PropertyBagBase propertyBag, Int64 start, Int64 end)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Contexts.XlsxWorksheetImportContext.EndImport(XlsxWorkbookImportContext workbookContext)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Contexts.XlsxWorkbookImportContext.EndImport()
   at Telerik.Windows.Documents.FormatProviders.OpenXml.OpenXmlImporter`1.Import(Stream input, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider.ImportOverride(Stream input)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.WorkbookFormatProviderBase.Import(Stream input)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.BinaryWorkbookFormatProviderBase.Import(Byte[] input)
   at .....

 

 

The problem can be found in two places:

1. When the value "7400-5" is pasted, the result in Spreadsheet is 2008956, which is the underlying raw date value.

2. When 7400-5 is written in the control directly, the result is 5/1/7400, which is 2008956 with a date format on it.

Telerik expose beautyfull document processing: you can automate a lot of thinks in document without user interaction.

But doesn't exists nothing about print this documents without user interaction: you have to open document on a webpage in a component and the print it.

 

For example: filling out a form can be done internally by process but not printed it.

 

Renato

 

When auto fitting the width of columns containing conditional formatting sometimes causes NullReferenceException.

Provide support for importing rich text as plain text.

HtmlFormatProvider: Add support for the <header> tag

Some files, where the parts of the xlsx are arranged in specific order, throw InvalidOperationException: "Sequence contains no matching element".

When a workbook is created and then exported, there are about 20mb of unmanaged memory remaining at the end of the application run.

Wrong image resizing leads to cropped images when adding large images

Exporting to PDF documents containing empty table rows results in 0 height of the rows.

I'd like to see EML to PDF support.  It's difficult to reconstruct construct multi-part emails (i.e. emails with pictures) from EML files to render to HTML and then to PDF.  It would be nice if their was a turn-key solution as a part of the Document Processing library.

InvalidCastException when importing documents where the "endobj" keyword in not on a new line.

One cannot build the source code for document processing.

Error Message: StyleCop.MSBuild.5.0.0\build\StyleCop.MSBuild.targets" was not found. Confirm that the expression in the Import declaration "..\Tools\StyleCop.MSBuild.5.0.0\build\StyleCop.MSBuild.targets" is correct, and that the file exists on disk. 

Wrong sheet name in exception message when adding sheet with already existing name

Importing documents containing emojis throws an ArgumentException.

The Row Height is not respected when converting to pdf.

Iterating the rows of the worksheet without reading the cells is not moving to the next row.

Add support for pivot charts.

Add support for generating documents containing notes.