Progress® Telerik® UI for WPF Feedback Portal
Back to Feed
Request a Feature Report a Bug
Declined
Last Updated: 26 Aug 2019 11:51 by ADMIN
CB
Created on: 19 Aug 2019 16:07
Category: Spreadsheet
Type: Feature Request
0
Link spreadsheet cells from one sheet to another

Hello,

 

In the spreadsheet control you cannot link/use in a function cells from one work sheet to cell(s) in another work sheet. Would like to have the same behavior and functionality of Excel, which allows you to use data from one sheet in any other sheet in the work book. Need the ability to create a sum of (or any other function available) cells from another worksheet in my current worksheet, within the same workbook.  

1 comment
ADMIN
Nikolay Demirev
Posted on: 26 Aug 2019 11:50
Hi Chamberlen Betat,

This feature is supported. You can use cells from other worksheets in the same workbook by using syntax like the following int the cell formulas:
=Sheet1!A1

The example will set a formula in the worksheet which will be equal to the value of the cell A1 in Sheet1 worksheet. You can use the same syntax in any other formula. Here you can read more about the cell references: https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/cell-references.

As the feature is implemented I am marking this feature request as Declined.

Regards,
Nikolay Demirev
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.
Create an account Log In
View
Type
Status
Category