Last Updated: 14 Dec 2023 14:24 by ADMIN
Release 2021.R1.SP1
Created on: 23 Apr 2019 06:33
Category: Spreadsheet
Type: Bug Report
SUBTOTAL and COUNTBLANK calculation issue

Dear Concerned,

1. Launch

2. Open Workbook(1).xlsx (attached)

3. Edit B2, D2, F2 with some new values

4. See the results in B4, D4, F4

Calculations are different in Excel.


Attached Files:
1 comment
Posted on: 24 Apr 2019 12:02
Hello Naveen,

Thank you for your feedback! 

Unfortunately, the reported issue is a known bug, reported in our GitHub repository on this link: The reason for the unexpected behavior is that once we have a merged cell and change its value, all the cells in the merged range take the new value. You can check it by yourself if you unmerge a cell after setting a value in it.

I am converting your ticket to Bug report and you can follow its public thread on this link:

I am sorry for the inconvenience, but currently, we cannot provide a workaround. I also cannot say when the bug will be fixed. Each bug is being fixed depending on its priority.

If you have any other questions related to the SpreadSheet or other components, please do not hesitate to contact us.  

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.