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-
in your example you have complete data in first row
but in my case-
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.
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 @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.
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.