SpreadProcessing: Formula evaluation causes an endless loop when importing a specific file

Telerik Document Processing Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Unplanned

Last Updated: 07 Nov 2024 11:51 by ADMIN

EuroEager2008

Created on: 21 Dec 2021 09:29

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: Formula evaluation causes an endless loop when importing a specific file

Formula evaluation causes an endless loop when importing a specific file

4 comments

ADMIN

Peshito

Posted on: 07 Nov 2024 11:51

Hello,

With the upcoming Q4 2024 Telerik Document Processing Libraries release, a new timeout mechanism for importing and exporting documents will be introduced. The FormatProviders' Import and Export methods have a mandatory TimeSpan? timeout parameter, after which the operation will be canceled.

Regards,
Peshito

ADMIN

Dimitar

Posted on: 22 Dec 2021 09:25

Hi Magne,

I agree with you that this should work like in Excel. Hopefully, our developers will be able to fix this soon.

As to the latest internal build at hand, you need to download the assemblies from your account (depending on the product you currently use: see attached) and manually change the references in your project.

Let me know if I can assist you further.

Regards,
Dimitar
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/.

Attached Files:

EuroEager2008

Posted on: 21 Dec 2021 13:28

Thanks Dimitar

You say formulas below SPMLiveDataReport!C42 is not evaluated by Excel.
The whole idea according to our design team is that certain areas (ranges) in DB_SPM is meant for extensions (e.g. N461 and down), array formula in SPMLiveDataReport is used for this.

Therefore deleting formulas below SPMLiveDataReport!C42 is not an option.

I hope you can achieve the same result as Excel, no matter formula complexity etc. as long as all "elements" in formulas are indeed implemented. If not implemented, I expect an error message instead (#ERROR, #VALUE etc.).

How can I "refresh" my references to newest internal build?

EuroEager2008

Posted on: 21 Dec 2021 12:08

Thanks Dimitar

You say formulas below SPMLiveDataReport!C42 is not evaluated by Excel.
The whole idea according to our design team is that certain areas (ranges) in DB_SPM is meant for extensions (e.g. N461 and down), array formula in SPMLiveDataReport is used for this.

Therefore deleting formulas below SPMLiveDataReport!C42 is not an option.

I hope you can achieve the same result as Excel, no matter formula complexity etc. as long as all "elements" in formulas are indeed implemented. If some formula is not implemented, I expect an error message instead (#ERROR, #VALUE etc.).

How can I "refresh" my references to newest internal build?