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:
Getting these Visual Studio warnings in using current Telerik.Maui and Telerik.Blazor in Build:
Detected package version outside of dependency constraint: Telerik.Documents.Spreadsheet.FormatProviders.Xls 2023.1.307 requires Telerik.Zip (= 2023.1.307) but version Telerik.Zip 2023.1.410 was resolved.
Detected package version outside of dependency constraint: Telerik.Documents.Spreadsheet.FormatProviders.OpenXml 2023.1.307 requires Telerik.Zip (= 2023.1.307) but version Telerik.Zip 2023.1.410 was resolved.
Detected package version outside of dependency constraint: Telerik.Documents.Flow.FormatProviders.Doc 2023.1.307 requires Telerik.Zip (= 2023.1.307) but version Telerik.Zip 2023.1.410 was resolved.
Detected package version outside of dependency constraint: Telerik.Documents.Fixed.FormatProviders.Image.Skia 2023.1.307 requires Telerik.Zip (= 2023.1.307) but version Telerik.Zip 2023.1.410 was resolved.
Detected package version outside of dependency constraint: Telerik.Documents.Fixed 2023.1.307 requires Telerik.Zip (= 2023.1.307) but version Telerik.Zip 2023.1.410 was resolved.
Detected package version outside of dependency constraint: Telerik.Documents.Core 2023.1.307 requires Telerik.Zip (= 2023.1.307) but version Telerik.Zip 2023.1.410 was resolved.
Detected package version outside of dependency constraint: Telerik.Documents.CMapUtils 2023.1.307 requires Telerik.Zip (= 2023.1.307) but version Telerik.Zip 2023.1.410 was resolved.
Please be sure similar warnings will not be generated in your upcoming June releases.
Thank you.
The project file references ONLY the two very latest Telerik Maui and Blazor Nuget packages, no other Telerik dlls, etc. It would seem the outdated references are internal to at least one of those nuget packages you furnish. I do not see that I have any means on my end to resolve them.
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.
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.