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:
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
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();
}
}
}
}
Hello,
I'm using Telerik Documents Processing 2023.1.410
With WordsProcessing, if I add a table in a footer it will automatically add a space after the table
Here an example, my table is the same size as my image in background and I removed all margin of the section:
Here the code:
Footer footer = section.Footers.Add(HeaderFooterType.Default)
section.PageMargins = new Padding(0,96,96,0);
section.FooterBottomMargin = 0;
Table table = footer.Blocks.AddTable();
TableRow row = table.Rows.AddTableRow();
TableCell cell = row.Cells.AddTableCell();
Paragraph paragraph = cell.Blocks.AddParagraph();
paragraph.Inlines.AddRun("Something");
I didn't any properties to manage spaces around a Table like in Paragraph.
It can be reproduced without the image
Work around:
If I add a new paragraph at the end and remove all spaces of this paragraph then it works
Here the code added:
paragraph = footer.Blocks.AddParagraph();
paragraph.Spacing.SpacingAfter = 0;
paragraph.Spacing.SpacingBefore = 0;
paragraph.Spacing.LineSpacing = 0;
Regards,
Hervouet Thomas