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.
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: 02 Aug 2024 11:09 by ADMIN
Release 2024.3.802 (2024 Q3)
Created by: SAI RADHA MANI
Comments: 0
Category: SpreadProcessing
Type: Feature Request
3
Enable the customers to import SVG images and use them in their documents.
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
Completed
Last Updated: 18 Mar 2021 15:05 by ADMIN
Release R2 2021
Created by: Joshua
Comments: 1
Category: SpreadProcessing
Type: Bug Report
0
After copy-paste, the workbooks used in the WorksheetFragment are disposed of, but their NamesCollections are not cleared.
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.
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: 05 Mar 2021 08:41 by ADMIN
Specific documents are imported with a wrong column width which leads to a wrong preview of the cell content.
Unplanned
Last Updated: 26 Feb 2021 10:13 by ADMIN
When the cell content overflows the cell width the left cell border is not exported to PDF.
Unplanned
Last Updated: 03 Nov 2023 10:46 by ADMIN
Created by: CTI
Comments: 0
Category: SpreadProcessing
Type: Bug Report
1

In some cases when cells are merged the cell borders are not correctly imported.