Unplanned
Last Updated: 28 Sep 2017 14:52 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
Implement support for form controls (Button, Combo Box, Check Box, Spin Button, List Box, Option Button, Group Box, Label, Scroll Bar).
Unplanned
Last Updated: 16 May 2018 10:03 by ADMIN
At this point the culture used by RadSpreadProcessing (in the FormatHelper and internally in SpreadsheetCultureHelper) is determined by the current thread culture on startup. Provide ability to:
- to change the culture at runtime. Currently, when the thread culture is changed, RadSpreadProcessing is "stuck" with the original one.
- set this culture independently of the current thread's one.
Completed
Last Updated: 31 May 2016 17:18 by ADMIN
Unplanned
Last Updated: 05 Oct 2016 07:04 by ADMIN
If shape extent is declared, the two cell anchor points for the drawing element are ignored. For example if the TwoCellAnchorElement's from and two points declare that the image should be anchored starting from cell A1to F10 and further in the drawing declaration there is defined extents element with image size values, anchor element's points are ignored. 
Unplanned
Last Updated: 21 Sep 2017 06:13 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
Add support for ROW function: https://support.office.com/en-us/article/ROW-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d?ui=en-US&rs=en-US&ad=US

Examples:

=ROW() returns the row in which the formula appears
=ROW(C10) returns the row of the reference - 10


Workaround: This could be implemented as a custom function: http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions.html
Completed
Last Updated: 09 Jun 2017 08:15 by ADMIN
ADMIN
Created by: Deyan
Comments: 3
Category: SpreadProcessing
Type: Feature Request
2

			
Unplanned
Last Updated: 13 Sep 2018 12:11 by ADMIN
Generating document which consists of merged cells in a row and some values then inserting a row on the top and then exporting the document or setting it to the RadSpreadsheet causes wrong merged cells.

If the generation is done on a workbook which is already set to the RadSpreadsheet everything is OK.

Workaround: The document can be exported and then imported again before the row is inserted.
Unplanned
Last Updated: 17 Jan 2017 15:35 by ADMIN
When the column width is not an integer number, but a decimal fraction one, the width which is exported is not calculated correctly. 

For example, if there is a cell with some text and its column's width is autofit, it's exported with different actual width.

In addition, if the exported xlsx file is imported back in the Spreadsheet, the column width is a bit different from the one which was exported (only for the first export-import roundtrip).
Unplanned
Last Updated: 21 Aug 2018 10:56 by ADMIN
Having cell with custom format string set to "MMM" does not apply correctly. Instead of showing the date in the defined format (for instance "Aug"), what actually is displayed is "MMM".
Unplanned
Last Updated: 05 Sep 2018 14:44 by ADMIN
When the scale factor of a document is smaller, the borders don't seem to scale correctly when exported to PDF. They appear much thicker than they would when exported from Excel.
Unplanned
Last Updated: 21 Sep 2018 13:02 by ADMIN
When inserting cells a check is performed for data loss. This check should take into account the value property, but should not take into account properties like cell value format and data validation. 

Workaround: clear the values at the end of the worksheet before inserting cells.
worksheet.Cells[1048575, 0, 1048575, 16383].ClearDataValidationRule();
Unplanned
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.
Unplanned
Last Updated: 10 Apr 2019 14:35 by ADMIN
Exporting empty workbook without any worksheet is not allowed according to the specification and such documents cannot be opened in Excel. Ensure the customers cannot create such documents using the API of SpreadProcessing.
Unplanned
Last Updated: 09 May 2017 06:59 by ADMIN
Comparison operators (equal '=', not equal '<>') doesn't work as expected with references to empty cells. For example, expressions of type '=IF(A1="", TRUE, FALSE)' are evaluated to false when A1 cell is empty. 

In MS Excel, such expression is evaluated to TRUE if the cell is empty - i.e. empty cell value is considered equal to an empty string "".

Workaround: Use ISBLANK function if possible. Its results are consistent with MS Excel.
Unplanned
Last Updated: 05 Apr 2018 14:21 by ADMIN
The r attribute of a cell defines the reference the cell is pointing to in a style similar to A1. Setting this attribute is optional but when set to an empty string, it cannot be imported - an ArgumentException is thrown with message "cellName" by the Guard class in NameConverter.ConvertCellNameToIndex().

Here is an example of such a definition:

<row r="1" spans="1:12">
  <c r=""/>
</row>


MS Excel and Libre Office can open such documents.
Unplanned
Last Updated: 11 Mar 2020 10:05 by ADMIN
Some of the leftmost borders are omitted when exported to PDF.
Unplanned
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.
Unplanned
Last Updated: 27 Apr 2018 16:24 by ADMIN
When there are split panes in a workbook, the topLeftCell property can be omitted. In this case, the format provider throws NullReferenceException.
Unplanned
Last Updated: 18 Jul 2017 12:58 by ADMIN

Add support for superscript and subscript font effects for cell formatting. Currently, this is not supported by the model and is omitted on import.
			
Unplanned
Last Updated: 11 Apr 2018 07:09 by ADMIN
ADMIN
Created by: Anna
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
The ADDRESS function is used to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS(2,3) returns $C$2.