1. Home
  2. Forum
  3. WinForms
  4. Formula is working in Excel as expected but not in sfspreadsheet

Formula is working in Excel as expected but not in sfspreadsheet

Hi I am using thi formula in Excel and I got what I am expecting.

"=SUM(INDEX((Block!F13:F100),0,MATCH(Sheet1!Z1,(Block!F12:F12),0)))"

 Sfspreadsheet implementation below only provide the 1st rows but not providing the sum.

string Sblockqty = "=SUM(INDEX((Block!F13:F100),0,MATCH(Sheet1!Z1,(Block!F12:F12),0)))";

                var fblockqty = spreadsheet1.Workbook.Worksheets["Sheet1"].Range[1, 27];

                spreadsheet1.ActiveGrid.SetCellValue(fblockqty, Sblockqty);

                spreadsheet1.ActiveGrid.InvalidateCell(1, 27);


17 Replies
SS Sampathnarayanan Sankaralingam Syncfusion Team January 10, 2022 02:45 PM UTC

Hi Mark, 

We will validate your reported issue and update you on January 12, 2022. 

Regards, 
Sampath Narayanan.S 


SS Sampathnarayanan Sankaralingam Syncfusion Team January 12, 2022 01:50 PM UTC

Hi Mark, 


We are validating your reported issue.  we will update you with proper details on January 17, 2022. 


Regards, 

Sampath Narayanan.S 


SS Sampathnarayanan Sankaralingam Syncfusion Team January 17, 2022 02:00 PM UTC

Hi Mark, 


We are still validating your reported issue.  we will update you with proper details on January 19, 2022. 


Regards, 

Sampath Narayanan.S 


SS Sampathnarayanan Sankaralingam Syncfusion Team January 19, 2022 02:09 PM UTC

Hi Mark, 

We have created bug report for the reported issue “Index formula doesn't return the result in range/array”. We will fix this issue and include in our Weekly NuGet release scheduled for February 8th, 2022 NuGet release. 

You can track the status of this report through the following feedback link, 

Note: The provided feedback link is private, and you need to login to view this feedback.

We appreciate your patience until then. 

Regards, 
Sampath Narayanan.S 


SS Sampathnarayanan Sankaralingam Syncfusion Team February 4, 2022 12:38 PM UTC

Hi Mark,


We regret for the inconvenience. We are working on this issue. However we are in need to some more details about the Block sheet and the values present in those range to check the exact scenario in our end. Can you please provide a simple sample or the workbook in which the issue is replicated in your end. It will be more helpful us to check the exact case while fixing the issue.



Regards,

Sampath Narayanan.S


MJ Mark Jayvee February 4, 2022 07:46 PM UTC

Hi Sampath,


Thank you for the response.


Please see the attached.


Attachment: Formula_2d826010.rar

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

Hi Mark,


Currently we are checking the issue, we will update you with more details by February 8, 2022.


Regard,
Sampath Narayanan.S



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

Hi Mark, 
 
We are unable to include the fix for this issue in our NuGet package which is release today as promised. However, we are able to provide patch for the reported issue. Can you please confirm, which version you are using currently? 
 
It will be helpful for us to provide patch in that version. We will update with further details based on your confirmation. 
 
Regards, 
Sampath Narayanan.S 


MJ Mark Jayvee February 9, 2022 06:21 AM UTC

Hi Sampath,


version  19.3.0.53


when is your next NuGet package release?


thank you,

Mark


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

Hi Mark, 

The fix will be included  in the upcoming Nuget release which is scheduled for February 15, 2022. If you still need patch, Please confirm us 

Regards, 
Sampath Narayanan.S 


MJ Mark Jayvee February 12, 2022 08:50 AM UTC

Thank you, Sampath. I can wait until the Feb 15, 2022.


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

Hi Mark,


Thank you for your patience.


We are regret to inform you that the fix is not included in this weekly nuget. However we have provided the patch on your version 19.3.0.53


We have fixed the issue “Index formula doesn't return the result in range/array” . You can download the patch from following location. 

  v19.3.0.53

Recommended approach – exe will perform automatic configuration      

Please find the patch setup here:   

https://syncfusion.com/Installs/support/patch/19.3.0.53/1248470/F171810/SyncfusionPatch_19.3.0.53_1248470_2152022072626432_F171810.exe


Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment                       

Please find the patch assemblies alone from: 

https://syncfusion.com/Installs/support/patch/19.3.0.53/1248470/F171810/SyncfusionPatch_19.3.0.53_1248470_2152022072626432_F171810.zip

 

Please find the NuGet’s from the below location: 

https://syncfusion.com/Installs/support/patch/19.3.0.53/1248470/F171810/SyncfusionNuget_19.3.0.53_1248470_2152022072626432_F171810.zip

 

 

 


Assembly Version: v19.3.0.53

Installation Directions: 

This patch should replace the files “Syncfusion.Spreadsheet.Windows” under the following folder.

$system drive:\ Files\Syncfusion\Essential Studio\$Version # \precompiledassemblies\$Version#\4.0 

Eg : $system drive:\Program Files\Syncfusion\Essential Studio\19.3.0.53\precompiledassemblies\19.3.0.53\4.0 

  

To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location, or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies. 

Feedback Link: https://www.syncfusion.com/feedback/31993/index-formula-doesnt-return-the-result-in-range-array


Note: 

To change how you receive bug fixes, ask your license management portal admin to change your project’s patch delivery mode. 

  

https://www.syncfusion.com/support/directtrac/patches 

  

Disclaimer: 

If you have received other patches for the same version for other products, please apply all patches in the order received. Please note that we have created this patch for version 19.3.0.53 specifically to resolve the following issue reported in the forum 171810.


Regards,

Sampath Narayanan.S


MJ Mark Jayvee February 16, 2022 11:46 AM UTC

Hi Sampath,


Thank you for the email.


Could you please check or provide a short clip to show it works? I am trying to use the patch you have provided but it doesn't work on my end.


regards,

Mark


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

Hi Mark, 

Sorry for the inconvenience 

Please find the below patch on your version 19.3.0.53 
 
Recommended approach – exe will perform automatic configuration       
 
Please find the patch setup here:    
 

Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment                        
Please find the patch assemblies alone from:  
 
  
Please find the NuGet’s from the below location:  
  


                 

Regards, 
Sampath Narayanan.S 


MJ Mark Jayvee February 20, 2022 11:44 AM UTC

When will be the next Nuget release which includes this 


SS Sampathnarayanan Sankaralingam Syncfusion Team February 21, 2022 12:57 PM UTC

Hi Mark, 

We have included the fix in this weekly NuGet which is expected to release on February 22, 2022. 

Regards, 
Sampath Narayanan.S 


SS Sampathnarayanan Sankaralingam Syncfusion Team February 22, 2022 01:34 PM UTC

Hi Mark 
  
We would like to let you know that Essential Studio Weekly NuGet packages (v19.4.0.53) has been published in nuget.org with the fix for the issue “Index formula doesn't return the result in range/array”. Please let us know if you have any concerns in this.

 

Regards,
Sampath Narayanan.S 


Loader.
Up arrow icon