One of the options grouped under alignment is Shrink to Fit. Shrink to fit will automatically reduce the font size until text fits in a cell.
Importing XLSX file in Blazor Web Assembly for .NET 5.0 is very slow.
<InputFile OnChange="@HandleFileSelected" />
async Task HandleFileSelected(InputFileChangeEventArgs e)
{
var ms = new MemoryStream((int)e.File.Size);
Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();
using (Stream ey = e.File.OpenReadStream(e.File.Size))
{
await ey.CopyToAsync(ms,(int)e.File.Size);
ey.Close();
}
oWorkbook = formatProvider.Import(ms);
}
Hello,
I am writing a piece of code in VB that converts Excel files that a user uploads into PDF files. It merges all of them into one fixed document and exports that fixed document to a PDF. Whenever I upload specifically the "Schedule" default layout from Google Sheets, exported to xlsx format, all my times are changed from 9:30 AM or 1:28 PM to 9:12 AM and 1:12 PM respectively.
Reproduction Steps:
A few key notes that may help with resolving the issue :
Below I have written a snippet of my code, as well as included the xlsx file and the pdf file that results from it. I am using one of the latest versions of Telerik Document Processing, having been downloaded on 6/25/2021.
Case".xlsx"
Using infileStream As Stream = File.OpenRead(inputFilePath)
Dim inputFormatter AsNew Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider
Dim imported As Spreadsheet.Model.Workbook = inputFormatter.Import(infileStream)
imported.ActiveWorksheet.WorksheetPageSetup.PaperType = Model.PaperTypes.Letter
imported.ActiveWorksheet.WorksheetPageSetup.CenterHorizontally = True
imported.ActiveWorksheet.WorksheetPageSetup.FitToPages = TrueDim format AsNew Spreadsheet.FormatProviders.Pdf.PdfFormatProvider
Dim fixedDoc As Fixed.Model.RadFixedDocument = format.ExportToFixedDocument(imported)
primaryDoc.Merge(fixedDoc)
EndUsing
Add support for preserving and exporting the macros in a macro-enabled workbook. Macros are pieces of code written in Visual Basic for Applications (VBA) which are used to automate repetitive tasks in excel. The macros are part of the excel file. When a file contains a macro its extension becomes xlsm. SpreadProcessing should be able to import and export xlsm files and edit the macros in them.
Expose an easy way to create .xlsx documents from DataTable objects.
The cell contains the following data in OOXML: <f>SUM(1,2,3)</f> - The formula <v>6</v> - the calculated value The formula value is imported, but the calculated value is skipped. The feature will be useful if Manual calculation option is supported: https://feedback.telerik.com/Project/184/Feedback/Details/191275-spreadsheet-add-support-for-different-calculation-options-automatic-or-manual