SpreadProcessing: Implement import of calculated formula values from XLSX

Telerik Document Processing Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Completed

Last Updated: 29 Mar 2021 12:09 by ADMIN

ADMIN

Nikolay Demirev

Created on: 11 May 2016 10:34

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Implement import of calculated formula values from XLSX

The cell contains the following data in OOXML:

<f>SUM(1,2,3)</f> - The formula
<v>6</v> - the calculated value

The formula value is imported, but the calculated value is skipped. The feature will be useful if Manual calculation option is supported: https://feedback.telerik.com/Project/184/Feedback/Details/191275-spreadsheet-add-support-for-different-calculation-options-automatic-or-manual

2 comments

ADMIN

Peshito

Posted on: 29 Mar 2021 12:09

Hello,

This item will be available in R2 2021 Release.

It is also available with Telerik UI for WPF's latest internal build - LIB 2021.1.504 (05/04/2021) if you need it earlier.

Regards,
Peshito
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tom

Posted on: 18 May 2016 12:03

I was planning on moving from EpPlus (free open source implementation of Excel) to Telerik Spreadsheets, but cannot use Telerik Spreadsheets in their current state as the excel files contain range names/formulae which are incorrectly recalculated. EpPlus cannot handle range recalculation, but has the advantage that it just reads formula values until you call .Calculate().