Unplanned
Last Updated: 27 Jan 2020 11:11 by Guy
ADMIN
Deyan
Created on: 26 Apr 2016 04:13
Category: SpreadProcessing
Type: Feature Request
5
SpreadProcessing: Implement cell reference to whole columns and rows, e.g. $1:$2 and A:D
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. 
7 comments
Guy
Posted on: 27 Jan 2020 11:11

Hi

Am I mistaken in saying that implementing this feature is simply a matter of taking the cell reference and substituting "A:D" with "A1:D[row_count]", for example?

Thanks

Guy

ADMIN
Tanya
Posted on: 03 Dec 2019 11:18

Hello Guy,

The logic for creating cell references is internal and I am afraid that there is no option to modify it in a way so it can parse references to rows or columns. Furthermore, this is part of the core logic in the control and even modifying the source code should be done carefully to preserve the already existing functionalities. Adding support for references to rows or columns also means integrating that with the different features that would need to operate with such references. 

Regards,
Tanya
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Guy
Posted on: 28 Nov 2019 12:43

Hi

Ok, thank you. Is there any workaround we can use to allow SpreadProcessing to support references like this?

Thanks,

Guy

ADMIN
Tanya
Posted on: 28 Nov 2019 11:32

Hi Guy,

The 'Approved' status means that we agree that a specific functionality would be a nice addition to the component and the task is included in our prioritization and planning processes. However, the feature is still not scheduled and I cannot say in which release it will be included.

Regards,
Tanya
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Guy
Posted on: 27 Nov 2019 09:29

Hi

I see that this was approved for development - do you have an ETA on when it will be released?

Thanks,

Guy

ADMIN
Tanya
Posted on: 27 Feb 2018 08:08
Hi Guy,

Thank you for the feedback. 

This task is currently not scheduled for implementation and I cannot say a particular timeframe when it might be available. Continue following this item so you can be notified when its status changes.

Regards,
Tanya
Guy
Posted on: 19 Feb 2018 19:10
This is crucial for supporting clients' existing spreadsheets. Is there any indication of when this will make it to a release?