ngHandsonTable with HandsonTable Pro

Getting help Questions
1

Hi ,

We are exploring ngHandsontable for one of our application .

That application is using AngularJS 1.*.

We are trying with ngHandsontable directive.

We have following questions ?

  1. Can we use HandsonTable pro with ngHandsonTable ? will it support all the features for nghandsontable directive

  2. Do we have VLookup type functionality ?

  3. How i can do validation based on existing set of data which i am getting for WEB API (Ajax) ?

Please share your inputs ASAP.

2

Hi @netamitk

ngHandsontable hasn’t been updated for a long time. The last Handsontable PRO version that is supported is 1.7.0. Here, at the release notes section, you can check what we have added in higher versions.

We support the VLOOKUP formulas. It has been added in December, 2016 via pull request VLOOKUP and HLOOKUP support by vudknguyen · Pull Request #1 · handsontable/formula.js · GitHub

When it comes to this question

How i can do validation based on existing set of data which i am getting for WEB API (Ajax) ?

Can you specify when you would like to filter values and what are the conditions

3

We have angularjs application . what should i used for this application ?

4

You can always use the Handsontable without a wrapper. Even if your app runs on AngularJS you can use the vanilla (latest) version.
Some operations may be faster with the wrapper, but as previously mentioned the latest version supported is 1.7.0 and since the day it has been published we have added few more callbacks and fixes.

5

can you share example of vlookup .

We want to lookup data from another sheet in excel ?

6

Hi @netamitk

I do not have any working demo, However, please take a look at the test scenario in the following commit https://github.com/handsontable/formula.js/pull/1/files