Sum of sums

aleksandra_budnik · July 2, 2018, 8:28am

you’re welcome

rishabhbhs · July 2, 2018, 9:59am

Normal formula for addition is ‘=SUM(D3:X3)’
This formula works well when we know the upper limit. But, how can we add the values in a row when we don’t know the upper limit?

P.S.: I cannot use ‘=SUM(3:3)’ because the row contains data other than numbers.

aleksandra_budnik · July 3, 2018, 9:52am

Sorry the formula plugin does not support it yet

rishabhbhs · July 3, 2018, 12:26pm

Okay. Does OFFSET formula work in handsontable? If yes, please provide a working jsFiddle.

aleksandra_budnik · July 3, 2018, 12:38pm

Hi @rishabhbhs

OFFSET is not on the list of formulas

github.com

handsontable/formula-parser/blob/develop/src/supported-formulas.js

const SUPPORTED_FORMULAS = [
  'ABS',
  'ACCRINT',
  'ACOS',
  'ACOSH',
  'ACOT',
  'ACOTH',
  'ADD',
  'AGGREGATE',
  'AND',
  'ARABIC',
  'ARGS2ARRAY',
  'ASIN',
  'ASINH',
  'ATAN',
  'ATAN2',
  'ATANH',
  'AVEDEV',
  'AVERAGE',
  'AVERAGEA',

This file has been truncated. show original

rishabhbhs · July 3, 2018, 1:34pm

I had already searched there. I just wanted to be double sure. Thanks!

But, I’ll suggest that OFFSET should be implemented and hence, added to the list. This formula will not only help in tackling my problem, but also in other situations like adding data on even rows, adding data in batches of 5, etc.

It will bring handsontable closer to the Excel.

aleksandra_budnik · July 4, 2018, 7:18am

We do not work on this project currently so I have added the issue at https://github.com/handsontable/formula-parser/issues/47 to do not forget about it.

rishabhbhs · July 4, 2018, 7:22am

Okay. Thanks!

I’ll try to help when I’ll be free from my project.

aleksandra_budnik · July 4, 2018, 7:39am

We are going to rewrite the core of the formula plugin later this year. However there are some legal issues that we need to finish first.

rishabhbhs · July 4, 2018, 7:48am

Okay. Thanks for the information.

aleksandra_budnik · July 4, 2018, 7:59am

You’re welcome @rishabhbhs

I’d be glad to see the formula among the rest in the new Core.