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.
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.
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:
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
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
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();
}
}
}
}