Completed
Last Updated: 11 Jun 2019 12:46 by ADMIN
Release R2 2019 SP1
The data validation rule should have values for formula1 and formula2 elements, which define the start and end values for a range to validate between. When such values are missing, a NullReferenceException is thrown on import and the document cannot be imported.

Details:

System.NullReferenceException: Object reference not set to an instance of an object.
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.DataValidationElement.CopyPropertiesToSingleArgumentContext(SingleArgumentDataValidationRuleContext context)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.DataValidationElement.CopyPropertiesToDataValidationRuleContext(DataValidationRuleContextBase context)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.DataValidationElement.ListRuleFactory(IXlsxWorksheetImportContext context)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.DataValidationElement.OnAfterRead(IXlsxWorksheetImportContext context)
...
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.WorkbookFormatProviderBase.Import(Stream input)
Unplanned
Last Updated: 07 Sep 2018 14:07 by ADMIN
ADMIN
Created by: Anna
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
The OFFSET function returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. 
Completed
Last Updated: 23 May 2019 13:14 by ADMIN
When the worksheet contains many formulas which use large ranges (e.g. covering 50000 cells) as arguments and these formulas have to be calculated, this causes OutOfMemoryException. 
Unplanned
Last Updated: 12 Dec 2016 14:47 by ADMIN
Steps to reproduce: 

1. Enter in a cell =Today()
2. Show Format Cells dialog and set Custom format "d"

Expected: The value is the day of the month.
Actual: The date is formatted as short date but has to be day of the month.
Unplanned
Last Updated: 18 Jan 2017 07:35 by ADMIN
When importing and exporting xlsx document with email address hyperlink the exported document shows invalid document message when opened in Excel: "We found a problem with some content in 'file.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of thes workbook, click Yes.". The document can be only partially recovered and information is lost.
Unplanned
Last Updated: 21 Sep 2017 06:37 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Add support for the AVERAGEIF function:  https://support.office.com/en-us/article/AVERAGEIF-function-faec8e2e-0dec-4308-af69-f5576d8ac642

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria:

AVERAGEIF(range, criteria, [average_range])


Workaround: This could be implemented as a custom function: http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions.html
Unplanned
Last Updated: 21 Sep 2017 06:30 by ADMIN
ADMIN
Created by: Petya
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Add support for the SUBTOTAL function: https://support.office.com/en-us/article/SUBTOTAL-function-7b027003-f060-4ade-9040-e478765b9939

It computes the subtotal for some ranges, given the code for the subtotal function:

SUBTOTAL(function_num,ref1,[ref2],...)

where function_num is code referring to some of the functions: AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, SUM, VAR, VARP.

Note that we should implement the support for all of the above functions. As of now, COUNTA, VAR, VARP are not supported.

Workaround: This could be implemented as a custom function: http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions.html , but multiple functions (4 as of now) has to be additionally implemented.
Unplanned
Last Updated: 29 Sep 2017 07:17 by ADMIN
ADMIN
Created by: Tanya
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Add API for registering custom image decoders, e.g. for .emf and .wmf images.
Unplanned
Last Updated: 04 Oct 2016 07:30 by ADMIN
For example, if a user wants to set a 5x5 array of values in the worksheet he has to iterate through all the values one by one and set it to the worksheet. With that API the user should be able to set the entire array with just one method call giving it the array.
Completed
Last Updated: 11 Jan 2019 12:35 by ADMIN
When a chart is inserted in a document, generated by SpreadProcessing or WordsProcessing, the chart seems to lack any bars. The reason is that some theme information is missing, which effectively makes shapes take their default color, which is transparent. The same applies for shapes inserted in any Document Processing-generated OOXML documents - docx, xlsx.

Workaround: (applicable for Excel) Manually change the theme for the document in MS Excel:
- Choose Page Layout -> Themes -> Themes dropdown -> Office.
Unplanned
Last Updated: 25 Sep 2017 13:56 by ADMIN
Now there is no public API that allows the users to check if a Worksheet is empty or not. The UsedCellRange property returns a cell range that is only the cell A1 even if it is empty too.

Possible solution is to expose IsEmpty property of the CellRange.

Workaround: Check if Worksheet.UsedCellRange contains only A1, and that additionally A1 is empty.
Unplanned
Last Updated: 26 Sep 2017 06:49 by ADMIN
The value of Worksheet.UsedCellRange could be calculated during the import of the workbook - as all cells are processed anyway. This will improve the performance of the first usage of this property, which is very common scenario. Also xlsx documents can have optional 'dimension' element which is used to specify the used cell range:

<dimension ref="A1:C2"/>.
Unplanned
Last Updated: 25 Sep 2017 14:04 by ADMIN
Some functions are exported from Excel with the _xlfn. prefix as compatibility measure with older versions of MS Excel (future functions, see here https://msdn.microsoft.com/en-us/library/dd907480(v=office.12).aspx , https://support.office.com/en-ca/article/Issue-An-xlfn-prefix-is-displayed-in-front-of-a-formula-882f1ef7-68fb-4fcd-8d54-9fbb77fd5025 )

RadSpreadProcessing do not support these and the spreadsheet treats the function as not supported even when it is.

Example:

    <row r="1" spans="2:2" x14ac:dyDescent="0.25">
      <c r="B1" t="b">
        <f>_xlfn.ISFORMULA(C2)</f>
        <v>0</v>
      </c>
    </row>


This could be observed with the ISFORMULA function.
Unplanned
Last Updated: 27 Apr 2018 16:25 by ADMIN
ADMIN
Created by: Deyan
Comments: 2
Category: SpreadProcessing
Type: Feature Request
1
Split allows you to split the window into different panes that each scroll separately. 

This feature is different than the horizontal/vertical split of freeze panes, which is supported.
Unplanned
Last Updated: 28 Sep 2017 14:45 by ADMIN
Create API allowing conversion of .NET standard numeric format strings to Excel/RadSpreadsheet's number formats.

For example, G3 .NET numeric format should be converted to scientific notation RadSpreadsheet mode - CellValueFormat("0.00E+00").
Unplanned
Last Updated: 29 Sep 2017 06:29 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Add support for theme effects (format schemes). They are described in OOXML using the 'fmtScheme' element. Thing of providing predefined sets.

In MS Excel the UI for changing is located in Page Layout tab -> Themes -> Effects.
Unplanned
Last Updated: 10 Mar 2020 12:55 by ADMIN
Created by: Lee
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Currently, adding hyperlinks to images is not supported.
Unplanned
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.
Unplanned
Last Updated: 12 Mar 2020 09:43 by ADMIN
Adding a formula with the SetValueAsFormula method is slow
Unplanned
Last Updated: 16 Mar 2020 13:31 by ADMIN

Setting SetIsBold method to true on a CellSelection, resets the font size of those cells to 11 points.
See the generated file of the attached program.
Cells C1:F1 have font size 11 instead of expected 9.

 

PS: Is it really necessary to have a support plan to report bugs?