Unplanned
Last Updated: 04 Nov 2024 19:40 by Bradley
ADMIN
Created by: Deyan
Comments: 9
Category: SpreadProcessing
Type: Feature Request
61
Add support for creating Tables and applying tables styles (predefined ones or custom).
Unplanned
Last Updated: 20 Feb 2024 16:05 by Hatef
ADMIN
Created by: Deyan
Comments: 12
Category: SpreadProcessing
Type: Feature Request
31
At this point, the formatting can be applied only to the whole cell content.
Unplanned
Last Updated: 15 Mar 2023 14:12 by ADMIN
ADMIN
Created by: Deyan
Comments: 4
Category: SpreadProcessing
Type: Feature Request
31
Add support for pivot tables.
Unplanned
Last Updated: 29 Dec 2022 07:04 by ADMIN
ADMIN
Created by: Deyan
Comments: 12
Category: SpreadProcessing
Type: Feature Request
25
Allow to password-protect a workbook, so that it cannot be shown (read) without the password.
Unplanned
Last Updated: 06 Mar 2017 14:48 by ADMIN
ADMIN
Created by: Deyan
Comments: 2
Category: SpreadProcessing
Type: Feature Request
19
Add support for array formulas (CellFormulaType "array"). These formulas can accept as parameters and return results containing whole arrays (one- or two- dimensional) of data. In MS Excel, such formulas are inserted with CTRL + SHIFT + Enter, and visualized enclosed with curly brackets ('{' and '}'). 
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: 21 Sep 2017 08:33 by ADMIN
Add API to get the list of ranges to which a defined name refers.

Example:
List<CellRange> ranges = workbook.Names["definedName"].Ranges;
CellSelection selection = worksheet.Cells[ranges];

The cell range referred by the defined name could be accessed using code similar to the following one:
foreach (var name in workbook.Names)
{
    if (name.Name == givenName)
    {
        string[] v = name.RefersTo.Split("!".ToCharArray());

        foreach (Worksheet sheet in workbook.Sheets)
        {
            if (sheet.Name.ToUpper() == v[0].Replace("=", String.Empty).ToUpper())
            {
                string rangeName = v[1];
                string firstIndexName = rangeName.Split(":".ToCharArray())[0];

                int rowIndex;
                int columnIndex;
                bool isRowAbsolute;
                bool isColumnAbsolute;
                bool nameRefersToIndex = NameConverter.TryConvertCellNameToIndex(firstIndexName, out isRowAbsolute, out rowIndex, out isColumnAbsolute, out columnIndex);

                if (nameRefersToIndex)
                {
                    sheet.Cells[rowIndex, columnIndex].SetValue(givenValue);
                }
            }
        }
    }
}

Unplanned
Last Updated: 28 Mar 2018 12:44 by ADMIN
ADMIN
Created by: Deyan
Comments: 6
Category: SpreadProcessing
Type: Feature Request
14
XLSB is binary format that should theoretically allow fast reading and writing to the file. 
Unplanned
Last Updated: 15 Nov 2016 12:02 by ADMIN
ADMIN
Created by: Tanya
Comments: 2
Category: SpreadProcessing
Type: Feature Request
13
Allow the customers to work with Shape objects.
Unplanned
Last Updated: 09 Dec 2022 11:26 by Dimitar
Created by: Dimitar
Comments: 0
Category: SpreadProcessing
Type: Feature Request
10
Introduce calculation chain functionality. This will provide a better mechanism for handling dependent expressions.
Unplanned
Last Updated: 12 Apr 2024 13:53 by ADMIN
Currently, the numbers in a CSV file are parsed as numbers, and the leading zeros are lost. In MS Excel, leading zeros could be preserved when the values are imported as text using the more sophisticated text import wizard (http://www.upenn.edu/computing/da/bo/webi/qna/iv_csvLeadingZeros.html ).

Workaround: The values could be extracted using a third-party (or custom) CSV parser, and inserted manually into the model, using CellSelection.SetValueAsText method (http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/working-with-cells/cell-value-types.html ).
Unplanned
Last Updated: 30 Apr 2018 13:57 by ADMIN
ADMIN
Created by: Deyan
Comments: 2
Category: SpreadProcessing
Type: Feature Request
9
IFERROR returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.

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/WPF/CustomFunctions
Unplanned
Last Updated: 28 Sep 2017 14:52 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
8
Implement support for form controls (Button, Combo Box, Check Box, Spin Button, List Box, Option Button, Group Box, Label, Scroll Bar).
Unplanned
Last Updated: 08 Mar 2017 15:15 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
8
Add support for strikethrough font effect for cell formatting. Currently this is not supported by the model and is omitted on import.
Unplanned
Last Updated: 20 Feb 2024 11:17 by ADMIN
CellSelection.SetValue method causes memory leak of CellReferenceRangeExpression objects in some cases when cell value is referenced by formulas. The memory leak is small, but the remaining CellReferenceRangeExpression continue to listen to some events, causing performance issues when their number become large - the time to set the value increases with each set.
Unplanned
Last Updated: 07 Nov 2018 09:20 by Uwe
ADMIN
Created by: Tanya
Comments: 1
Category: SpreadProcessing
Type: Feature Request
8

Provide the ability to work with images in headers/footers of a worksheet. Note that large images put in headers are visualized as watermarks on printing/exporting to PDF.

Watermark in Excel: https://support.office.com/en-us/article/add-a-watermark-in-excel-a372182a-d733-484e-825c-18ddf3edf009

 

Unplanned
Last Updated: 03 Oct 2022 08:41 by ADMIN
Add support for manual calculation option, which allows not to recalculate all the formulas on value change, but on manual request. 

MS Excel supports this feature in Formulas -> Calculation -> Calculation Options, with the following options: Automatic, Automatic Except for Data Tables, Manual.
Unplanned
Last Updated: 14 Aug 2018 07:49 by ADMIN
ADMIN
Created by: Dinko | Tech Support Engineer
Comments: 0
Category: SpreadProcessing
Type: Feature Request
7
Provide the customers with the ability to export workbooks to HTML files.
Unplanned
Last Updated: 07 May 2019 10:50 by ADMIN
Provide an API used to recalculate all formulas in the document similar to the Excel Interop Calculate function
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.
1 2 3 4 5 6