Completed
Last Updated: 20 Jul 2021 15:00 by ADMIN
Release LIB 2021.2.712 (12 Jul 2021)
Created by: Robby
Comments: 3
Category: SpreadProcessing
Type: Feature Request
0
Make it possible to change the series fill color.
Unplanned
Last Updated: 15 Jul 2021 14:33 by ADMIN
The current implementation of the XlsFormatProvider supports the BIFF8 format only.
Unplanned
Last Updated: 06 Jul 2021 12:17 by ADMIN
ADMIN
Created by: Tanya
Comments: 4
Category: SpreadProcessing
Type: Feature Request
5
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.
Declined
Last Updated: 06 Jul 2021 09:46 by ADMIN

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);

  }  

Unplanned
Last Updated: 05 Jul 2021 12:00 by ADMIN
Created by: Christophe
Comments: 0
Category: SpreadProcessing
Type: Feature Request
7
At this point, XlsFormatProvider doesn't support images and they are not imported into Workbook while reading an .xls file.
Unplanned
Last Updated: 02 Jul 2021 08:31 by ADMIN

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:

  1. Make a new sheet on Google Sheets using the "Schedule" layout.
  2. Export it to .xlsx
  3. Read the file into a spreadsheet, convert that spreadsheet to a PDF, save it, and open the PDF.
  4. All of the times should be incorrectly written.

A few key notes that may help with resolving the issue :

  • The conversion from .xlsx to a Workbook datatype does not have any issues. When importing to Workbook then exporting to XLSX, the sheets remained unchanged.
  • MS Excel does not have any issues viewing the exported XLSX file with the correct times, which means it is most likely a problem with the ExportToFixedDocument process.
  • Writing times in the same format manually and exporting it from Google Sheets does not create this bug. So far, I have only found that the "Schedule" layout will cause this 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

Unplanned
Last Updated: 28 Jun 2021 05:23 by ADMIN
Unplanned
Last Updated: 28 Jun 2021 05:15 by ADMIN
Exporting XLSX file in Blazor Web Assembly for .NET 5.0 causes a PlatformNotSupportedException. The issue is logged as a regression in the GitHub repo of ASP .NET Core here: https://github.com/dotnet/aspnetcore/issues/32995. It is a regression in the .NET Framework.
Unplanned
Last Updated: 25 Jun 2021 07:15 by ADMIN
Created by: Rishi
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Export collection of object to a worksheet
Completed
Last Updated: 24 Jun 2021 14:53 by Vili
Release R3 2021
ADMIN
Created by: Nikolay Demirev
Comments: 16
Category: SpreadProcessing
Type: Feature Request
22
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.
Completed
Last Updated: 24 Jun 2021 10:08 by ADMIN
Release R3 2021
Created by: Christophe
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Add support for exporting Markup-Enabled file format to PDF.
Unplanned
Last Updated: 23 Jun 2021 06:24 by ADMIN
Handle the case where a formula cannot be parsed and continue loading the document. Now there is an exception and the document is not loaded. 
Completed
Last Updated: 10 Jun 2021 13:32 by ADMIN
Release R2 2021 SP1
Exception when copying worksheet that contains a shape
Unplanned
Last Updated: 07 Jun 2021 09:35 by ADMIN
Created by: N
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
The Open Document Format for Office Applications (ODF), also known as OpenDocument, is an open standard file format for spreadsheets, charts, presentations, and word processing documents using ZIP-compressed[6] XML files.

The most common filename extension for spreadsheets is .ods.
Unplanned
Last Updated: 28 May 2021 07:19 by ADMIN
Created by: Sean
Comments: 2
Category: SpreadProcessing
Type: Feature Request
0
Introduce support for  data connected query
Completed
Last Updated: 17 May 2021 08:30 by ADMIN
Release R2 2021
Expose an easy way to create .xlsx documents from DataTable objects.
Unplanned
Last Updated: 30 Apr 2021 10:54 by ADMIN
Created by: Shawn
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Add support for Microsoft Office XML formats - https://en.wikipedia.org/wiki/Microsoft_Office_XML_formats
Completed
Last Updated: 29 Mar 2021 12:09 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 2
Category: SpreadProcessing
Type: Feature Request
6
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
Completed
Last Updated: 29 Mar 2021 11:53 by ADMIN
Release R2 2021
Exporting documents containing two or more cell styles with the same properties, but different names cause invalid document.
Unplanned
Last Updated: 22 Mar 2021 07:26 by ADMIN
SpreadProcessing: Setting cell value to a numeric constant like double.NaN causes an error when the document is loaded in Excel