Issue with handsontable data binding when used with hyperformula

Questions
1

I am binding data in handsontable with Array of objects with column mapping as suggested in documentation https://handsontable.com/docs/binding-to-data/#array-of-objects-with-column-mapping.
and also using HyperFormulas with handsontable but I am not getting formula result in my cells instead of them I am only getting formula written in my cell.

This is the link for replicating the issue Edit fiddle - JSFiddle - Code Playground Please help me on this.

2

Hi @sumit.baudh

If you declare data object like in this example: https://jsfiddle.net/aszymanski/9cL1og2x/3/ then everything works fine. You just need to fill all of the data array fields so they match the dataSchema. We are currently discussing if that’s a bug or not, but this is workaround for the time being.

3

Thanks for your response
@adrian.szymanski
but that’s the actual issue if i don’t have have complete data in first row it wouldn’t work well.
your example-

image
image459×100 6.57 KB

in your example you have complete data in first row

but in my case-
image
I am not having complete data in first row (having first name and last name columns blank).

So the issue is when we don’t have complete data(data as per schema) it won’t work well.

4

Hi @sumit.baudh

Yes, we know about it and as I said previously we are currently discussing if that’s a bug.

1 Like
5

Thank you @adrian.szymanski will be waiting for your response.

6

Any update on this?

7

Hi @sumit.baudh

We’ve reported this issue on our GH for further discussion. You can track it’s progress here: https://github.com/handsontable/handsontable/issues/9252

8

Hi @adrian.szymanski,
Still this issue has not been assigned to anyone.

9

Hi @sumit.baudh

Yes, it isn’t on our roadmap yet. I’ll let you know when we start working on it.

10

Is there any update?

11

Hi@sumit.baudh

No, we haven’t start working on it yet.

12

Hi @adrian.szymanski, is there any update?

13

@sumit.baudh

I have your ticket pinned to the GitHub issue. When we start working on it, I’ll let you know. For now we are focusing on different issues.

1 Like
14

Hi @sumit.baudh

Our developer just updated the subject you were interested in here Data binding from array of objects · Issue #9252 · handsontable/handsontable · GitHub.

Since the topic is quite old, I will close it. However, if you’d still find any issues, please feel free to create a new thread or contact me at support@handsontable.com