Hi,
I am trying to specify the time in 24 Hours format with a pattern for it, but it’s not accepting that.
Can someone help me with that, I really appreciate if explained with working examples.
Here’s a demo that may help you to set the format https://jsfiddle.net/handsoncode/z2jwb6fk/ it’s from our blog post about cell dependencies.
1 Like
Great! That’s working fine… Thank you!!!
I have one more doubt, will handsontable support all the formulas in MS-Excel or is there any limitations on using formulas, if so, can provide any alternate to use all the formulas of MS-Excel.
Hm… our formula plugin is in alpha stage of development so it is buggy.
When it comes to the list of formulas you can find it at https://github.com/handsontable/formula-parser/blob/develop/src/supported-formulas.js
That’s really Great!!! Almost I found all the formulas I need…
For sample I tried with one IF and it’s working good but in one case it’s not. The formula I tried is =IF(B1=0,"NO","YES"), by default it has to show NO and if I change the value in B1 to some other value it has to show YES, but irrespective of the values it’s always showing YES, can you please tell me how to fix it.
I really appreciate if there’s an working example of this formula.
That is one of the options that we will need to add. Currently formulas do not recalculate on change and are using source data. However here’s a demo that may help Handsontable example - JSFiddle - Code Playground - you can add a setDataAtCell() method in the afterChange hook to pass yes/no function.
Great!!! Thanks for your suggestion 
You’re welcome
@aleksandra_budnik I have one more issue, I need to get the column Header like the following image.
Mean I need rowspan in the column Header.
Is it possible to achieve like this. If yes, please guide me.
Unfortunately, I cannot help you with that, we only support colspan for columns at this moment.
That’s Okay Fine… Thank You for your guidance.
1 Like