Adding two cells?

Getting help Questions
1

Hi
I consider starting to use HandsOnTable.
After studying a lot of examples
I have not found answer on the most basic question

How to display in cell B4 the sum B1+ B2
or in cell C1 C2C2C3
just to take a couple of examples

That kind of operation is what excel is all about
and it would be just great to understand how it is done in HandsOnTable

I don’t know if this numeric spreadsheet would be suitable to make these tests
http://jsfiddle.net/handsoncode/g1hnaxtt/

Best regards
BO

2

Hi @bengt

Here is a basic example of adding cells B1 to B2 inside a B3 cell Handsontable example - JSFiddle - Code Playground

When user displays the data he sees the result of the calculation

and when he double-clicks the cell he gets the formula

To add formulas you need to add formulas: true to your instance settings (line 16) using Handsontable PRO scripts.

3

Thanks Alexandra
This is exactly what I have been looking for.
Where can I find the set of files needed to run this locally from hard-disk under Windows?
So far I have done 16 different installations and tests with example code without success.

One of the examples is this

http://handsontable.github.io/handsontable-ruleJS/

but I can’t make it work locally on the hard-disk with Chrome or Mozilla

I am also exploring the excellent js library dygraph
and here it was easy to set up a dozen of working examples
on the hard drive. This is the ideal starting point for evaluation

In the next step it will be interesting to explore if the same array of info
can be displayed and edited in HandsOnTable and shown as graph in dygraph

Best regards

BO

4

Hi @bengt

Formulas are a part of our commercial offer, so if you haven’t already bought a license you can test it (locally as well) by downloading our free 30-day trial. Here is a direct link: https://my.handsontable.com/sign-up-trial.html
You would be provided with a .zip file in the ‘Install’ tab. All files there do not require an internet connection and additional downloads.

I am here if you’d have any issues.