Approved
Last Updated: 14 Mar 2019 14:39 by ADMIN
ADMIN
Created by: Deyan
Comments: 4
Category: SpreadProcessing
Type: Feature Request
31

			
Approved
Last Updated: 12 Sep 2018 15:38 by ADMIN
ADMIN
Created by: Deyan
Comments: 6
Category: SpreadProcessing
Type: Feature Request
21
If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled.
Completed
Last Updated: 27 Feb 2019 13:20 by ADMIN
ADMIN
Created by: Deyan
Comments: 9
Category: SpreadProcessing
Type: Feature Request
19
Add APIs for creating and manipulating Chart objects.
Completed
Last Updated: 17 Aug 2018 06:27 by Ivo
ADMIN
Created by: Tanya
Comments: 7
Category: SpreadProcessing
Type: Feature Request
18
This will enable printing with the following printing options: 

- Fit Sheet on One Page

- Fit All Columns on One Page

- Fit All Rows on One Page

- Custom automatic scaling


A possible implementation of a similar behavior is to use the PageSize property of WorksheetPageSetup and subtract the corresponding margin values (from the Margins property) from the width to calculate how many columns are fitting in some particular page size with 100% scale factor. 

Available in R2 2018 Official Release version.
Approved
Last Updated: 11 Nov 2019 14:41 by ADMIN
ADMIN
Created by: Deyan
Comments: 6
Category: SpreadProcessing
Type: Feature Request
14
Add support for conditional formatting of cells - allow applying of rules used during visualization of cells to automatically apply formatting depending on their values.
Approved
Last Updated: 25 Feb 2019 21:10 by Stephen
ADMIN
Created by: Deyan
Comments: 13
Category: SpreadProcessing
Type: Feature Request
14
Provide ability for working with comments in a spreadsheet document.
Approved
Last Updated: 22 Nov 2019 11:13 by ADMIN
Expose an easy way to create .xlsx documents from DataTable objects.
Approved
Last Updated: 06 Mar 2017 14:48 by ADMIN
ADMIN
Created by: Deyan
Comments: 2
Category: SpreadProcessing
Type: Feature Request
12
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 '}'). 
Approved
Last Updated: 27 Feb 2018 08:09 by ADMIN
ADMIN
Created by: Deyan
Comments: 5
Category: SpreadProcessing
Type: Feature Request
10
Implement functionality to rotate the content of a cell.
Approved
Last Updated: 12 Aug 2019 12:06 by ADMIN
ADMIN
Created by: Deyan
Comments: 6
Category: SpreadProcessing
Type: Feature Request
10
Allow to password-protect a workbook, so that it cannot be shown (read) without the password.
Approved
Last Updated: 22 Dec 2016 07:08 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
8
Add support for creating Tables and applying tables styles (predefined ones or custom).
Approved
Last Updated: 28 Mar 2018 12:44 by ADMIN
ADMIN
Created by: Deyan
Comments: 6
Category: SpreadProcessing
Type: Feature Request
8
XLSB is binary format that should theoretically allow fast reading and writing to the file. 
Approved
Last Updated: 08 Apr 2019 11:49 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 2
Category: SpreadProcessing
Type: Feature Request
7
Add support for preserving and exporting the macros in a macro-enabled workbook.

Macros are pieces of code written in Visual Basic for Applications (VBA) which are used to automate repetitive tasks in excel. The macros are part of the excel file. When a file contains a macro its extension becomes xlsm.

SpreadProcessing should be able to import and export xlsm files and edit the macros in them.
Approved
Last Updated: 30 Apr 2018 13:57 by ADMIN
ADMIN
Created by: Deyan
Comments: 2
Category: SpreadProcessing
Type: Feature Request
7
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
Approved
Last Updated: 21 Sep 2017 07:21 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
7
Add API for setting custom document properties (metadata). Such are visualized by the common editors, e.g. in MS Excel in the File menu.

Example properties that can be set through the document properties are:

- Title
- Subject
- Author
- Keywords
- Comments
- Last Author
- Creation Date
- Category
- Manager
- Company
Approved
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);
                }
            }
        }
    }
}
Approved
Last Updated: 26 Sep 2017 07:14 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
6
Add support for pivot tables.
Approved
Last Updated: 03 Dec 2019 11:18 by ADMIN
Implement support for cell references to columns and rows, e.g. $1:$2, A:D, etc.

Currently, CellSelection.SetValue throws ParseException, and CellSelection.SetValueAsFormula throws InvalidOperationException. 
Approved
Last Updated: 15 Nov 2016 12:02 by ADMIN
ADMIN
Created by: Tanya
Comments: 2
Category: SpreadProcessing
Type: Feature Request
4
Allow the customers to work with Shape objects.
Approved
Last Updated: 26 Oct 2016 05:38 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
4
For all characters which cannot be represented in XML as defined by the XML 1.0 specification, the characters are escaped using the Unicode numerical character representation escape character format _xHHHH_, where H
represents a hexadecimal character in the character's value. This is dedined in the OpenXML specification in 22.9.2.19 ST_Xstring (Escaped String).

Currently this causes the following issues:

- Documents conaining such characters are imported incorrectly, e.g. <si><t>_x001B_</t></si> is imported as the plain text _x001B_

- ArgumentException with clarification similar to "' ', hexadecimal value 0x1B, is an invalid character." is thrown when trying to export such documents. Example code to reproduce:

            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets.Add();

            CellSelection selection = worksheet.Cells[1, 1]; //B2 cell
            selection.SetValue(string.Format("Error Value: {0} ", Encoding.ASCII.GetString(new byte[] { 27 })));

            string fileName = @"D:\temp\SampleFile.xlsx";
            IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();
            using (FileStream output = new FileStream(fileName, FileMode.Create))
            {
                formatProvider.Export(workbook, output);
            }
1 2 3 4 5