Get Calculated Value

[DM]

I have a spreadsheet with some formula (es. =A1*B2/5).

So I get the Json data and I see that something like that

{
      "name": "Sheet1",
      "rows": [
        {
          "index": 31,
          "cells": [
            {
              "value": 5,
              "format": "#",
              "index": 1
            },
            {
              "value": 10,
              "formula": "B32*2",
              "index": 2
            }
          ]
        }

is it possibile to use the js to get the calulated data or exist a .net dll to convert js"excel" style formula to data?

[Veselin Tsvetanov]

Hi Mattia,

In the exported JSON, the calculated value of the cell will be available in the value field for that respective cell. In the JSON sample, that you have sent, the value of the cell with formula B32*2 is 10.

Here you will find a small sample demonstrating how such cell value could be retrieved using JS:

var spread = $("#spreadsheet").data('kendoSpreadsheet');
var sheet = spread.activeSheet();
var range = sheet.range('F15');
var value = range.value();

Note, that the above uses methods from the API of the Spreadsheet, the Spreadsheet Sheet and the Spreadsheet Range objects.

Regards,
Veselin Tsvetanov
Telerik by Progress

[Marat]

Hi! Now I using some cell to calculate value like this:

    var spread = $("#spreadsheet").data('kendoSpreadsheet');
    var sheet = spread.activeSheet();
    var range = sheet.range('A3');
    var formula = range.formula("C5+1/96");
    var value = range.value();
    console.log(value);

But I want to take value without using cell. Can I use some funtion to do it like this:

var value = sheet.GetResultValue("C5+1/96");

[Veselin Tsvetanov]

Hello Marat,

I am afraid formulas and their calculated values could not be extracted to be used without a target cell (range). Therefore, the approach that you are already following would be the appropriate one.

Regards,
Veselin Tsvetanov
Progress Telerik