Completed
Last Updated: 20 Sep 2021 14:07 by ADMIN
Release R3 2021 SP1
When importing a document containing a destination that does not refer to a formula an exception is thrown: System.NullReferenceException: 'Object reference not set to an instance of an object.'
Declined
Last Updated: 20 Sep 2021 11:54 by ADMIN

I open an xlsx file thant i create with Excel and edit it with RadSpreadProcessing.

But then I can't display it in a RadSpreadsheet control. An error is displayed during execution on localhost.

Here is the error message:

Exception non gérée à la ligne 48298, colonne 17 dans http://localhost:53844/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=;;System.Web.Extensions,+Version=4.0.0.0,+Culture=neutral,+PublicKeyToken=31bf3856ad364e35:fr-CA:bc17b1ef-7a1b-49cb-a795-5f1c64597a53:ea597d4b:b25378d2;Telerik.Web.UI:fr-CA:b87b3d5b-f055-4852-bdaf-fef1991116e3:16e4e7cd:f7645509:22a6274a:33715776:8674cba1:7c926187:88144a7a:b7778d6c:c08e9f8a:59462f1:a51ee93e:24ee1bba:6d43f6d9:e330518b:1e771326:8e6f0d33:864068a5:6a6d718d:58366029:874f8ea2:4cd1fec6:71188da4:487c8be1:670fdf23:d944e0f6:c442ac3f:ec7335e:2e4adfe5:b4bec146:77613e24:69667591:a4c22f0d:e0037459:2f872eeb:75e7b247:b9057478:e8e3832e:728f182a:c4143936:5f88c545:6ed7f76e:32b48b51:935ec1c6:f0c58c30:16dc2978:1611ddf4:1bfaef2a:26e91122:c128760b:a7e79140:185812c5:f46195d3:6b3f73b3:2003d0b8:aa288e2d:b092aa46:a44b89c4:c8618e41:e4f8f289:1a73651d:16d8629e:2bef5fcc:a9b7ace7:e085fe68:52af31a4:5fa37e7e

0x800a139e - Erreur d’exécution JavaScript: Expected op «,» but found punc «;» (input: IF(D8<>0;E8/D8;0))

If a workbook was created with Excel, an error prevents it from being opened programmatically in a RadSpreadsheet control. Although it can be displayed there using the open button of the RadSpreadsheet. This error does not occur if you copy the contents of this workbook into the RadSpreadsheet and then save it with the save button on the RadSpreadsheet.

Thank you

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);
 
Duplicated
Last Updated: 14 Sep 2021 08:04 by ADMIN
Created by: Monique
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Add support for Excel 5.0/95 Workbooks.
Unplanned
Last Updated: 13 Sep 2021 16:04 by ADMIN
Created by: Martin
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
From the OOXML Specification: A comment is a rich text note that is attached to and associated with a cell, separate from other cell content.
Completed
Last Updated: 03 Sep 2021 12:34 by ADMIN
Release R3 2021

Exporting sheet properties corrupts the file and it cannot be opened in Excel.

In the latest version we export: 

<sheetPr>
<pageSetUpPr fitToPage="true" />
<tabColor rgb="FF92D050" />
</sheetPr>

Excel cannot read this and tries to recover the file unsuccessfully. This works in R3 2020.

Unplanned
Last Updated: 03 Sep 2021 08:35 by ADMIN
When importing a document containing a formula with an invalid reference an exception is thrown: FormulaParseException: 'Unused input [A1] after attempting to parse the formula [#REF!A1]'
Completed
Last Updated: 01 Sep 2021 12:14 by ADMIN
Release R2 2021
When a csv is exported the entire range which has values is exported. When export is done in Excel, the cells of this range which are empty are marked by an additional field, separated by a comma. This comma is present in SpreadProcessing only in places where it is obligatory for example in the middle of the row. Obligatory comma in this context means that without it the file will not be read correctly by Excel or SpreadProcessing. In places where it is not obligatory, like in an empty row or in the end of the row, it is skipped. These non-obligatory commas do not influence how the file will be interpreted by Excel, however, according to the most-popular csv spec, they should be present, which means that there could be parsers which are unable to parse the resulting file. (2.4 Each line should contain the same number of fields throughout the file.) 

Example:
Exported by Excel:
---------------------------------------
Product,Unit Price,Units in Stock,Discontinued
Chai,$18.00 ,39,
Chang,,17,
Chef Anton's Cajun Seasoning,$22.00 ,53,No
,,,
Chef Anton's Gumbo Mix,$21.35 ,0,No
---------------------------------------
Exported by SpreadProcessing:
---------------------------------------
Product,Unit Price,Units in Stock,Discontinued
Chai,$18.00 ,39
Chang,,17
Chef Anton's Cajun Seasoning,$22.00 ,53,No

Chef Anton's Gumbo Mix,$21.35 ,0,No
---------------------------------------
Note the extra commas in the empty row and in the end of the first two rows in the SpreadProcessing sample.
Unplanned
Last Updated: 25 Aug 2021 12:06 by ADMIN
Created by: Julian Turner
Comments: 9
Category: SpreadProcessing
Type: Feature Request
3
RadSpreadsheetProcessing does not support chart color customization apart from selecting the color of the outline (set by Series.Outline.Fill). You cannot set the color of the fill of column charts etc.
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: 22 Jul 2021 11:16 by ADMIN
Created by: Dimitar
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Introduce support for the XLOOKUP function.
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.

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

  }  

1 2 3 4 5 6