Unplanned
Last Updated: 23 Aug 2021 09:17 by ADMIN
The second axis of the chart is not displayed regardless of the position.
Unplanned
Last Updated: 23 Aug 2021 08:41 by ADMIN
Provide API to set the position of the second axis (left or right).
Unplanned
Last Updated: 13 Aug 2021 06:31 by ADMIN
Wrong text position in a specific file when exporting to PDF
Unplanned
Last Updated: 09 Aug 2021 11:14 by ADMIN
Provide API allowing to import documents on background thread. The API should allow the passing of a CancellationToken in order to cancel the import at any time.
Unplanned
Last Updated: 05 Aug 2021 16:47 by ADMIN

The files are not properly recognized when the base64 string representing the exported XLS file is converted using https://base64.guru/converter/decode/file.

If an XLS file produced by MS Excel is converted with the same tool, it is generated with .bin extension.

 
Unplanned
Last Updated: 15 Jul 2021 14:33 by ADMIN
The current implementation of the XlsFormatProvider supports the BIFF8 format only.
Completed
Last Updated: 21 Jul 2021 12:41 by ADMIN
Release R3 2021

When the column has cells that span several rows, the auto fit of column width is not working.

Workaround: If the document is being generated with the API, autofit the contents before merging the data.

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

  }  

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.
Completed
Last Updated: 15 Sep 2021 13:15 by ADMIN
Release R3 2021

To reproduce: 

CultureInfo cultureInfo = new CultureInfo("es-ES");
var currency_info = new Telerik.Windows.Documents.Spreadsheet.Formatting.FormatStrings.CurrencyInfo(cultureInfo.NumberFormat.CurrencySymbol, cultureInfo);
var format_string = AccountingFormatStringBuilder.BuildFormatString(currency_info, cultureInfo.NumberFormat.CurrencyDecimalDigits);
 
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: 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
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: 28 Jun 2021 05:23 by ADMIN
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 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: 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: 02 Nov 2023 15:50 by ADMIN
Release R3 2023 SP1
Value is treated as a number when the ampersand operator is used.