Unplanned
Last Updated: 11 Mar 2024 13:20 by ADMIN
TestTeam
Created on: 09 Jan 2023 15:53
Category: SpreadProcessing
Type: Bug Report
4
SpreadProcessing: The result of a formula is not updated when the formula depends on a reference to another reference which is imported after it
This happens only on import, that is, if the values are created through UI or through the model, it does not happen. A sheet has a formula A which depends on a cell B and this cell also has a reference to another cell C and the formula A is so placed in the sheet so that it will be imported before cell B. When cell C is updated, the value in A will not be recalculated.
4 comments
ADMIN
Dess | Tech Support Engineer, Principal
Posted on: 11 Mar 2024 13:20

Hello, Tony,

The public feedback portal allows us to be better aware of the needs of our customers by reviewing all requests and measuring their popularity. Our roadmap and priorities depend largely on the business value and customers' demand for specific features, and we take into account the most popular requests when planning our future development efforts. 

Make sure that you cast your vote for the item in order to increase its priority. The more votes an item gathers, the higher its priority becomes. You can click the Follow button to get notified if any status changes occur.

Meanwhile, the suggested temporary solution is expected to have a positive impact on the formula recalculation.

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik

A brand new ThemeBuilder course was just added to the Virtual Classroom. The training course was designed to help you get started with ThemeBuilder for styling Telerik and Kendo UI components for your applications. You can check it out at https://learn.telerik.com
Tony
Posted on: 08 Mar 2024 17:39
This is still an issue today. I've imported a sheet with references of cells that are, themselves, referencing other cells and they are not updating.
ADMIN
Anna
Posted on: 23 Jan 2023 10:13

Hello,

I understand that the situation is very inconvenient. We are doing our best to distribute our resources as efficiently as possible and we schedule what we'll fix according to the number of users impacted and how simple it is to fix and, unfortunately, this issue still hasn't made its way to the top of our list. Please, accept my apologies.

That being said, I can offer the following workaround:

            CellRange usedCellRange = worksheet.UsedCellRange;
            for(int row = 0; row < usedCellRange.RowCount; row++)
            {
                for (int col = 0; col < usedCellRange.ColumnCount; col++)
                {
                    ICellValue cellValue = worksheet.Cells[row, col].GetValue().Value;
                    if(cellValue.ValueType == CellValueType.Formula)
                    {
                        worksheet.Cells[row,col].SetValue(cellValue);
                    }
                }
            }
This code has to be run once, only after a file is imported. I hope this helps and, please, don't hesitate to tell us if you encounter any issues with the workaround, we'd like to know.

Regards,
Anna
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Anthony
Posted on: 19 Jan 2023 10:24

I have to say that I am extremely disappointed that this bug has a status of Unplanned. This bug makes this control unusable. 

We have clients that are using this control to make financial decisions, decisions that they can no longer trust because the values are not correct. I have already wasted several hours today working with a client to try and figure out what was going on.