Unplanned
Last Updated: 18 Mar 2024 08:00 by ADMIN
When importing an xlsx document with a comment that does not have an author, an exception is thrown "Sequence contains no matching element" Note that this is a different bug from the very similar SpreadProcessing: Exception "Sequence contains no matching element" thrown in files containing notes or comments (telerik.com)
Completed
Last Updated: 14 Mar 2024 09:00 by ADMIN
Release 2024.1.305 (2024 Q1)

Hi there I have a pdf and whenever I try to Import the PDF file into PdfFormatProvider.Import method for flattening purposes, it throws null reference exception.

I have added a sample .net project with PDF added as source. You just need to run the project on your end. I am using version 2023.3.1106 of document processing library.

I am using ASP.NET 4.8 framework.

Thanks

Duplicated
Last Updated: 14 Mar 2024 06:01 by ADMIN
Created by: Santhanu
Comments: 0
Category: Telerik Document Processing
Type: Feature Request
0
Enable the customers to create and modify .ppt and .pptx (PowerPoint) files.
In Development
Last Updated: 01 Mar 2024 10:57 by ADMIN

The value of the TextBoxField is not visible until the field is clicked.

Workaround: Force content update:

foreach (var widget in textBoxField.Widgets)
{
    widget.RecalculateContent();
}

If the update still doesn't fix the issue, change the font prior to setting the value of the field:

foreach (var widget in textBoxField.Widgets)
{
    widget.TextProperties.Font = FontsRepository.Helvetica;
}
Another option could be to set the ViewersShouldRecalculateWidgetAppearances to true in order to force the viewers to update the appearance of the widgets.
In Development
Last Updated: 29 Feb 2024 15:50 by ADMIN
Created by: Daniel
Comments: 0
Category: Telerik Document Processing
Type: Feature Request
0
The ImageInline class in the WordsProcessing library has a Description available as a property of the Image property. The FloatingImage class also has an Image property but it is internal and its Description property is not available for users of the SpreadProcessing library.
Unplanned
Last Updated: 26 Feb 2024 15:11 by hyuk

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."

Unplanned
Last Updated: 29 Jan 2024 10:38 by Ye

If a worksheet has page breaks, but Fit to pages is also set to true, the page breaks should not be respected.

Workaround: Remove the page breaks before printing:

wb.ActiveWorksheet.WorksheetPageSetup.PageBreaks.Clear();

 

Duplicated
Last Updated: 22 Dec 2023 15:04 by ADMIN

 

 

The table styles are not imported correctly from HTML. The back color is not respected. The column width is incorrect. The font size is different.

Font is not in proper case- All the cases are in lower case

Unplanned
Last Updated: 21 Dec 2023 12:28 by Kenneth

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.

Unplanned
Last Updated: 21 Dec 2023 12:17 by Kenneth

Exception "Format string is not in the correct format" is thrown when importing a file with the following format string: "US$"#,##0.0"m";($#,##0.0)

The exception is thrown in the ValidateDateTimeFormatDescriptor method. 

Unplanned
Last Updated: 12 Dec 2023 09:28 by Ye

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:

 

Unplanned
Last Updated: 08 Dec 2023 14:57 by Prabhu
 Implement text orientation when importing/exporting to/from HTML
Duplicated
Last Updated: 30 Nov 2023 10:29 by ADMIN

Hi,

We are using HTMLFormatProvider and PDFFormatProvider for converting HTML  string to PDF file.  The below issues are identified while converting PDF.

 

1. Text Foreground  and Background color is not working in pdf.

HTML:

<p><span style="color: rgb(216, 55, 98); background-color: rgb(28, 122, 144); font-size: 30px;">Test</span></p>

We get the same issue even though we added below code.

foreach (Run run in document.EnumerateChildrenOfType<Run>())
{
    if (!run.Properties.HighlightColor.HasLocalValue)
	{
		run.HighlightColor = run.Shading.BackgroundColor.LocalValue;
	}
}

Attached the PDF file 

2. Strikeout is not working in PDF

  Sample HTML:

<!DOCTYPE html>
<html>
<head>
<title>Page Title</title>
</head>
<body>
<p><span style="font-size: 24px;"><del>Delete Strike Through line in the paragraph</del></span></p>
</body>
</html>

attached the PDF file .

It would be appreciated , if you provide the solution for those issues

 

Regards,

Babu

 

 

Unplanned
Last Updated: 27 Sep 2023 05:34 by Trevor
Created by: Trevor
Comments: 0
Category: Telerik Document Processing
Type: Feature Request
0
The SUMPRODUCT function is currently not implemented.
Unplanned
Last Updated: 26 Sep 2023 12:15 by Sam
If a table has AutoFit layout type, but the preferred width of one of the cells is small, the cell does not expand during layout. The expected behavior would be that the cell expands to accommodate its contents, even if the preferred width is smaller.
Unplanned
Last Updated: 21 Sep 2023 08:36 by Avrohom Yisroel
Created by: Avrohom Yisroel
Comments: 0
Category: Telerik Document Processing
Type: Bug Report
0
The th tag should be imported with a heading style.
Completed
Last Updated: 19 Sep 2023 10:32 by ADMIN
Release R3 2023
If the same rule, which uses a formula, is applied on more than one range the result data validation is incorrect, because the formula is translated wrong. E.g. if a custom rule with a formula =IsNumber(A1) is applied on A1:C6 and F1:F6, the rule for cell A1 would be =IsNumber(F1) instead of IsNumber(A1)
Completed
Last Updated: 12 Sep 2023 11:26 by ADMIN
Release R3 2023

A NullReferenceException is thrown when copying a sheet containing a chart with Marker whose FIll is null.

There is a workaround which should be applied before copying the sheet:

foreach (FloatingChartShape chart in wsPureCompTemplate.Charts)
{
    foreach (SeriesGroup seriesGroup in chart.Chart.SeriesGroups)
    {
        foreach (SeriesBase series in seriesGroup.Series)
        {
            LineSeries lineSeries = series as LineSeries;
            if (lineSeries != null && lineSeries.Marker != null && lineSeries.Marker.Fill == null)
            {
                lineSeries.Marker.Fill = new NoFill();
            }

            ScatterSeries scatterSeries = series as ScatterSeries;
            if (scatterSeries != null && scatterSeries.Marker != null && scatterSeries.Marker.Fill == null)
            {
                scatterSeries.Marker.Fill = new NoFill();
            }
        }
    }
}

Completed
Last Updated: 07 Sep 2023 13:41 by ADMIN
Release R3 2023
The print title defined name can contain any type of formula or literal and the document will still be valid. However, SpreadProcessing expects a cell range reference and throws and exception if the name contains something different.
Completed
Last Updated: 10 Aug 2023 13:07 by ADMIN
Release R3 2023
Importing an XLS document containing _xlfn.SINGLE defined name causes an InvalidOperationException.
1 2 3 4 5 6