Hi,
Is there an option in handsontable that user can’t able to type more than 3 decimal values, and even the length of the value should not exceed 10 digits, please provide me an working example to fix this.
Thanks,
Bala
Can I get help for this issue
you would need to create a custom editor for
can’t able to type more than 3 decimal values, should not exceed 10 digits
I tried using that, but this seems to be more complicated, Is there any plugin that supports handsontable and meet my requirement.
That shouldn’t take longer than a few lines of code. This demo should help http://jsfiddle.net/handsoncode/x4bjnms2/1/
it trims down all the chars after 10th char.
When you hit Enter the cell trims down excess chars
This is good, but it’s not gonna meet my requirement, will explain my requirement completely, please share an example that gonna meet my requirement.
My requirement is: In the cell it should not allow the user to type text and any symbols except dot(.), also the user should not type more than 3 decimal values and 5 whole number digits.
I guess, your example will not meet my requirement, so please provide me an example that will meet my complete requirement.
Thanks,
Bala
a development of demand and custom solutions are a part of our commercial offer. If you’d like to order the development please let me know. I’d need to schedule it.
I am not asking for the complete development, actually I am doing Proof Of Concept for our requirements with handsontable, if handsontable suits all our requirements then I can suggest my company to purchase this product for grid system, So I had did many Proof Of Concepts for our requirement, and still some are there, So once I proven that handsontable will meet our requirement to my company, then they are ready to purchase it, that’s y I’m seeking help from forum which I didn’t know how to implement.
If you help me to prove my company that handsontable will help us to meet all our requirement, then I’m sure that we gonna purchase it with support.
I can guide you how to implement the solution that you need (no matter if this is POC, self-project or final application) but I cannot do it for you. If there is something that is unclear please ask. We both (me and you) need to be sure that you understand how Handsontable works before a purchase. If something is too hard to do or understand I will ask the team to make it more readable. We constantly work on improving the documentation and provide blog posts to help our current and future Clients to develop their applications.
Do you have any other missing requirements for your POC? What is the deadline?
That was I’m asking guide me to implement that, I felt better if that had an example.
As of now I have only one more POC to do which that population of data from one table’s one column to another table’s column, Next weekend is my deadline to finish these POC.
Once I complete these two, then only can come to know the next requirement for POC.
Oh I see, so this is a work in progress project.
Please share a demo with your recent progress and I’ll check what is missing in the code for the editor to work as described:
should not allow the user to type text and any symbols except dot(.), also the user should not type more than 3 decimal values and 5 whole number digits.
Yeah, it’s under work in progress project only.
Here is the link that has the demo(Angular 5ykm8c (forked) - StackBlitz) for controlling the precessions, but it actually doesn’t.
I am not sure how to pass the values in Angular but will ask my colleague and be back with news as soon as possible.
Yeah sure, and even had updated an example to check the precession control, even that’s not working, please check and let me know where I had made mistake here is the link for that https://stackblitz.com/edit/angular-5ykm8c-ale11n?file=src%2Fapp%2Fheroes%2Fheroes.component.ts
Hi
I was able to create a validator that checks the length of the value https://stackblitz.com/edit/angular-5ykm8c-a33qmq?file=src/app/heroes/heroes.component.ts
Now it cell is invalid when the input is above 10 chars
This seems to be good, but what exactly I have to do is should not let the user to type in the field after 10 characters, Eg: If trying to type the 11th character it have to prevent it’s typing itself.
One more doubt, is there a chance to use angular directives inside handsontable, if yes please guide me how to achieve that.
I will need to ask that my colleague as we need to check what is in the editor itself to check if the value is too long or it has some characters but as it is a ~before event we do not get all the data.
That’s okay… but I need only idea to achieve that
here is a demo that my colleague has created as a POC https://stackblitz.com/edit/angular-5ykm8c-umsfub?file=src/app/heroes/heroes.component.ts
nice to see this, but only concern is it accepts text also, can you help me to fix that.