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

			
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.
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: 26 Sep 2019 07:47 by ADMIN
ADMIN
Created by: Deyan
Comments: 4
Category: SpreadProcessing
Type: Feature Request
12
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: 27 Sep 2018 15:53 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
11
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: 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: 27 Feb 2018 08:09 by ADMIN
ADMIN
Created by: Deyan
Comments: 5
Category: SpreadProcessing
Type: Feature Request
9
Implement functionality to rotate the content of a cell.
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: 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: 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: 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
6
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 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: 21 Sep 2017 08:37 by Tom
ADMIN
Created by: Nikolay Demirev
Comments: 1
Category: SpreadProcessing
Type: Feature Request
4
The cell contains the following data in OOXML:

<f>SUM(1,2,3)</f> - The formula
<v>6</v> - the calculated value

The formula value is imported, but the calculated value is skipped. The feature will be useful if Manual calculation option is supported: https://feedback.telerik.com/Project/184/Feedback/Details/191275-spreadsheet-add-support-for-different-calculation-options-automatic-or-manual
Approved
Last Updated: 12 Sep 2017 15:17 by ADMIN
ADMIN
Created by: Deyan
Comments: 4
Category: SpreadProcessing
Type: Feature Request
4
At this point, the formatting can be applied only to the whole cell content.
Approved
Last Updated: 08 Mar 2017 15:15 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
4
Add support for strikethrough font effect for cell formatting. Currently this is not supported by the model and is omitted on import.
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);
            }
Approved
Last Updated: 26 Sep 2017 07:14 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
4
Add support for pivot tables.
1 2 3 4 5 6