Completed
Last Updated: 02 Aug 2024 11:09 by ADMIN
Release 2024.3.802 (2024 Q3)

It would be beneficial for the clients if every cell has this "cached value" even if the formula can't be evaluated for some reason with the SpreadProcessing - no need for recalculation, just reading the value. It should read the last values while the document was being saved at the originator.

Getting a method like "GetCachedValueString ..." , ideal with the same formatting used for the cell and localization, would be helpful. 

Completed
Last Updated: 02 Aug 2024 11:09 by ADMIN
Release 2024.3.802 (2024 Q3)
When importing a xlsm document, an error occurs: "The axes are incorrectly paired." 
            string fileName = "file.xlsm"; 
            Telerik.Windows.Documents.Spreadsheet.Model.Workbook workbook;
            IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsm.XlsmFormatProvider();

            using (Stream input = new FileStream(fileName, FileMode.Open))
            {
                workbook = formatProvider.Import(input);
            }
Unplanned
Last Updated: 29 Jul 2024 10:58 by Divya
XlsFormatProvider: Handle import of documents with null format strings.
Unplanned
Last Updated: 23 Jul 2024 08:28 by Valery

Optimize font fallback mechanism.

Currently, in NET Standard, if no fonts are provided on PDF export, while resolving the fonts the application falls back to different fonts multiple times for each cell which causes a decrease in performance.

Unplanned
Last Updated: 22 Jul 2024 15:56 by ADMIN

Exception "Format string is not in the correct format" is thrown when importing a file with the following format string: "US$"#,##0.0"m";($#,##0.0)

The exception is thrown in the ValidateDateTimeFormatDescriptor method. 

Unplanned
Last Updated: 17 Jul 2024 13:13 by Matthias
When the Normal style is modified (e.g. the IsWrapped property is set to true and now all cells have default text wrap set) and some individual cells have local values set that are the default ones (e.g. some cells are now set to NOT be wrapped), when the file is imported and then exported, the local values will be lost.
Unplanned
Last Updated: 25 Jun 2024 07:47 by Rob Vest
Created by: Rob Vest
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Add support for Radar charts.
Unplanned
Last Updated: 14 Jun 2024 08:50 by ADMIN
With the current implementation, references like in the following expression cannot be evaluated and are treated as strings:
=SUM('C:\Users\Your user name\Desktop\[Workbook_1.xlsx]Sheet1'!A1:B2)
Unplanned
Last Updated: 12 Jun 2024 13:59 by ADMIN
Created by: Paul
Comments: 2
Category: SpreadProcessing
Type: Feature Request
6

Add support for images embedded in cells.

Similar to clicking "Place in Cell' in MS Excel which embeds the floating image into the cell:

 

Alternative: Floating Images

Unplanned
Last Updated: 07 Jun 2024 05:34 by Development
Created by: Development
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Support for importing and exporting WEBP images should be implemented.
Unplanned
Last Updated: 06 Jun 2024 14:29 by ADMIN
Created by: Brian
Comments: 4
Category: SpreadProcessing
Type: Feature Request
2
Add support for TEXT function. TEXT lets you change the way a number appears by applying formatting to it with format codes.

A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions

This function can be implemented as a custom function. Check the following resources for more details on how to achieve that:

- http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions
- https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/CustomFunctions
Unplanned
Last Updated: 06 Jun 2024 12:52 by Development

Currently, these are the supported image formats:

If we try to import an Excel document containing an image with another format, the following error occurs:

System.Collections.Generic.KeyNotFoundException: 'The given key was not present in the dictionary.'

Unplanned
Last Updated: 06 Jun 2024 09:30 by Sailaja
Created by: Sailaja
Comments: 0
Category: SpreadProcessing
Type: Feature Request
3
Add support for custom document properties (CustomDocumentProperties).
Declined
Last Updated: 04 Jun 2024 09:37 by ADMIN

I am using .net 7. I originally hit it with Telerik.UI.for.Wpf.70.Xaml.2023.3.1114. I updated to Telerik.UI.for.Wpf.70.Xaml.2024.1.423 to see if it was fixed but it still appears to happen.

I have attached a sample program which shows the behavior. Original.xlsm was created in Excel and has an image embedded in cell A1. Call ImportWorkbook with the path to the original file. Then export that workbook (unchanged) to the destination file.

Workbook workbook = ImportWorkbook( originalFileName );
ExportWorkbook( workbook, destinationFileName );
        private Workbook ImportWorkbook( string  fileName )
        {
            Telerik.Windows.Documents.Spreadsheet.Model.Workbook workbook;
            IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsm.XlsmFormatProvider();

            using( Stream input = new FileStream( fileName, FileMode.Open ) )
            {
                workbook = formatProvider.Import( input );
            }
            
            return workbook;
        }

        private void ExportWorkbook( Workbook workbook, string fileName )
        {
            Telerik.Windows.Documents.Spreadsheet.FormatProviders.IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsm.XlsmFormatProvider();

            using( Stream output = new FileStream( fileName, FileMode.Create ) )
            {
                formatProvider.Export( workbook, output );
            }
        }
The exported file is missing the image.
Unplanned
Last Updated: 30 Apr 2024 13:44 by ADMIN
If the conditional formatting is missing, the copy operation is executed with no errors.
Duplicated
Last Updated: 26 Apr 2024 12:52 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
This would allow repeating header rows on every printed page. More information related to this functionality may be found on the following link:

https://support.office.com/en-us/article/Print-rows-with-column-headers-on-top-of-every-page-d3550133-f6a1-4c72-ad70-5309a2e8fe8c
Unplanned
Last Updated: 24 Apr 2024 12:37 by Jean-Pierre
PdfFormatProvider: NetStandard: Converting multiple XLSX copies to PDF with separate SpreadFixedTextMeasurers generates a different first document. 
Unplanned
Last Updated: 24 Apr 2024 08:05 by Sudhakar

Incorrectly resolved fill between local formatting and cell style.

A fill (fillId) of a cell style (cellStyleXfs) is respected instead of the fill (fillId) of the local formatting (cellXfs).

Unplanned
Last Updated: 19 Apr 2024 08:44 by Noe
Created by: Noe
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
Add support for R1C1 formula style.
Unplanned
Last Updated: 17 Apr 2024 10:24 by Joshua
Created by: Joshua
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Make the CsvParser public.