Approved
Last Updated: 14 Aug 2019 08:07 by ADMIN
Currently, row/column groups cannot be collapsed/expanded through the public API. User should be able to specify row's/column's "collapsed" attribute indicating whether the outlining is in a collapsed state.
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: 28 Jun 2019 11:06 by ADMIN
Currently, the chart lines support only solid fill for their outlines.
Approved
Last Updated: 28 Jun 2019 10:07 by ADMIN
The API should be able to provide a way to move the X-axis away from the 0 value on the Y-axis or to the bottom of the chart when there are negative Y-axis values.

In Excel this can be achieved by right click on the axis, then from the context menu select "Format Axis".  Go to the "Labels" group and then in the "Label position" field select the desired value.
Approved
Last Updated: 18 Jun 2019 08:40 by ADMIN
Created by: olivier legaignoux
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
The COUNTIFS function returns the count of cells that meet one or more criteria.
Approved
Last Updated: 27 May 2019 15:48 by ADMIN
Sometimes the customers need to obtain the result of a formula without adding it as a value to a specific cell.
Approved
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
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: 25 Mar 2019 12:51 by ADMIN
Created by: Dima
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
The AlternateContent element is used to store content which is not defined by the specification.
Declined
Last Updated: 19 Mar 2019 16:39 by ADMIN
ADMIN
Created by: Deyan
Comments: 1
Category: SpreadProcessing
Type: Feature Request
2

			
Approved
Last Updated: 18 Mar 2019 14:39 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: 14 Mar 2019 14:39 by ADMIN
ADMIN
Created by: Deyan
Comments: 4
Category: SpreadProcessing
Type: Feature Request
28

			
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.
Approved
Last Updated: 25 Feb 2019 21:10 by Stephen
ADMIN
Created by: Deyan
Comments: 13
Category: SpreadProcessing
Type: Feature Request
13
Provide ability for working with comments in a spreadsheet document.
Approved
Last Updated: 19 Feb 2019 13:34 by ADMIN
Add support for Point Markes customization options for the Charts.
Approved
Last Updated: 19 Feb 2019 11:27 by ADMIN

Add support for Hidden and Empty Cells options:

https://support.office.com/en-us/article/display-empty-cells-null-n-a-values-and-hidden-worksheet-data-in-a-chart-a1ee6f0c-192f-4248-abeb-9ca49cb92274

Approved
Last Updated: 11 Feb 2019 10:30 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)
Approved
Last Updated: 07 Nov 2018 09:20 by Uwe
ADMIN
Created by: Tanya
Comments: 1
Category: SpreadProcessing
Type: Feature Request
1
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.
Approved
Last Updated: 24 Oct 2018 12:51 by ADMIN
ADMIN
Created by: Anna
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
The row declaration is the following:

<row r="8" spans="1:18" ht="15.75" x14ac:dyDescent="0.25">

The dyDescent attribute is described as follows:

The dyDescent attribute is a double attribute, as specified in [XMLSCHEMA2/2] section 3.2.5, that specifies the vertical distance in pixels from the bottom of the cells in the current row to the typographical baseline of the cell content if, hypothetically, the zoom level for the sheet containing this row is 100 percent and the cell has bottom-alignment formatting. See section 2.2.4.12 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2016]. The dyDescent attribute has a side effect; it sets the customHeight attribute to true even if the customHeight attribute is explicitly set to false. 

Note: Since the dyDescent attribute is not implemented, the height is not recognized to be custom and therefore it is not imported at all. The row has the default height.
Approved
Last Updated: 27 Sep 2018 15:54 by ADMIN
ADMIN
Created by: Tanya
Comments: 2
Category: SpreadProcessing
Type: Feature Request
3
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.
1 2 3 4 5