1. Home
  2. Forum
  3. WinForms
  4. SfSpreadsheet Iteration

SfSpreadsheet Iteration

hi,

Please see the attached.

I have 3 sheets in my workbook. I call it sheet1, sheet2, and sheet3.

sheet1 as my datasheet.

sheet2 as my formula.

sheet3 as my pdt output.

On sheet2, Column A is to do my addition.

Row A5, where to put my data came from sheet1. 

For example, When I press a button the sheet2 will perform Addition in row A5, getting the value from sheet1 starting from Row 5 until it finishes.

The result will be stored in Columns D as shown in the attached.

for each Iteration, It will print sheet3.

takenote the values is not stopping at row 8. in actual work it may contain more rows. 


Attachment: ExcelIteration_f2957e9e.rar

8 Replies
SS Sampathnarayanan Sankaralingam Syncfusion Team February 7, 2022 02:34 PM UTC

Hi Mark, 

We have checked the excel file you have provide. As you updated the data is in the sheet1 and the formula is in the sheet 2. You have iterated the “Print this page” text in sheet3. We are able to understand the issue with the provided excel but we are unable to understand the scenario and how you have iterated the text in the sheet3. Can you please provide the simple sample with the video illustration. It will be more helpful for us to find the exact cause for the issue and to provide you a prompt and timely solution. 

Regards, 
Sampath Narayanan.S 


MJ Mark Jayvee February 8, 2022 05:55 AM UTC

Hi Sampath,


please ignore the printing(sheet3) side of the scenario.


regards,

Mark


SS Sampathnarayanan Sankaralingam Syncfusion Team February 9, 2022 02:20 PM UTC

Hi Mark,


We are not able to understand the reported issue. Can you please provide the simple sample and video illustration to replicate issue. It will be more helpful for us to find the exact cause and to provide you the prompt and timely solution.


Regards,

Sampath Narayanan.S


MJ Mark Jayvee February 12, 2022 09:09 AM UTC

Hi Sampath,


Thank you for your email. Please see the attached file.



Attachment: ExcelIteration_f2957e9e_6faaf84e.rar

SS Sampathnarayanan Sankaralingam Syncfusion Team February 14, 2022 02:14 PM UTC

Hi Mark,


You have provided the video illustration in excel and we could not understand the issue you are facing in SpreadSheet only with the provided video illustration in excel. Please provide the video illustration about the replication of issue with SpreadSheet and also please provide the sample to replicate the issue. It will be more helpful for us to find the exact cause and to provide you the prompt and timely solution.


Regards,

Sampath Narayanan.S


MJ Mark Jayvee February 15, 2022 12:26 AM UTC

HI Sampath,


Good day.


Sorry for the misunderstanding of the example. 

The above is not an issue. I am asking if you can provide me an example on how to achieve it.


cheers,

Mark


SS Sampathnarayanan Sankaralingam Syncfusion Team February 15, 2022 11:17 PM UTC

Hi Mark,


We will check the possibilities to achieve your requirement and will update you by February 17, 2022.


Regards,

Sampath Narayanan.S


SS Sampathnarayanan Sankaralingam Syncfusion Team February 17, 2022 01:41 PM UTC

Hi Mark, 

We have created the sample to replicate the scenario shown in the video. Please refer the sample from the below link and let us know if you have any concerns. 


Regards, 
Sampath Narayanan.S 


Loader.
Up arrow icon