We use the PDF viewer in an WPF project and see sometimes faulty pdfs in the telerik viewer. If I open the pdf file in acrobat it lloks fine. Do you know this problem ?
Attached you find the original file and a screenshot from PDF viewer. Other files are shown correct in the telerik viewer.
public FloatingChartShape(Worksheet worksheet, CellIndex cellIndex, IChartData values, IChartData categories)
And others if necessary.
After Excel introduced the dynamic array support, files produced with the older Excel versions have formulas that may be displayed with @ in some contexts. For example a file that had the following:
=SUM(IF(A1:A10=1, B1:B10, 0))
Will be displayed like so:
=SUM(IF(@A1:A10=1, B1:B10, 0))
This is done in order to preserve the behavior of the files created in older versions of Excel.
The files created by SpreadProcessing are also treated by Excel as if they are created by pre-dynamic array Excel. Please, introduce support for the new behavior.
Workaround: this is the missing part after the export:
MS Excel offers the following text styling options:
When a format string of type: _ * # ##0_ ;_ * -# ##0_ ;_ * "-"??_ ;_ @_ is set through code and the culture settings of the machine are set so that the number grouping symbol is space, the resulting format string comes out incorrect on export: _,*,# ##0_,;_,*,-# ##0_,;_,*,"-"??_,;_,@_,
This will happen every time the symbols in-between and after _ and * coincide with the number group separator.
When importing a document containing a Plain Text SDT with multiple paragraphs an exception is thrown:
Telerik.Windows.Documents.Flow.Model.Annotations.StructuredDocumentTags.Builders.SdtBuilderFailureException: "This content control type cannot be inserted around multiple paragraphs."
If a worksheet has page breaks, but Fit to pages is also set to true, the page breaks should not be respected.
wb.ActiveWorksheet.WorksheetPageSetup.PageBreaks.Clear();
An exception is thrown when the file contains the following format string
" PE @ "??0.0;-" PE @ "??0.0;" PE @ New";" PE @ "_0_0@
The exception is thrown in the ValidateNumberFormatDescriptors method.
In excel, if you set word wrap to cell content, make the column wider and then autofit the column in which it is, the content will fit to a reasonable width, as seen in the image below.
When doing the same in SpreadProcessing, the result is always a narrow column:
CellSelection cellSelection = sheet.Cells[0, 0];
cellSelection.SetIsWrapped(true);
ColumnSelection columnSelection = sheet.Columns[0];
columnSelection.SetWidth(new ColumnWidth(100, true));
columnSelection.AutoFitWidth();Result:
Here are the same steps performed in WPF RadSpreadsheet, which uses RadSpreadProcessing for its engine:
