[GH #9252] Issue with handsontable data binding when used with hyperformula

Tags: #<Tag:0x00007f2492037ec0>

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 https://jsfiddle.net/sbaudh/nkhqt1rz/2/ Please help me on this.

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.

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
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.

Hi @sumit.baudh

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

1 Like

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

Any update on this?

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

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

Hi @sumit.baudh

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

Is there any update?

Hi@sumit.baudh

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