Can we change values as Millions, Thousands, etc,. dynamically
Hello,
When you need to change number formatting dynamically you can either use toolbar functionality (Format -> Format cells) or you can use setFormat
API call. The setFormat
API call has the following signature setFormat(format: Object, measureUniqueName: String). Please find the information on how to compose the format object here: https://www.webdatarocks.com/doc/number-formatting/. In case you need to edit the existing formatting, you can run getFormat(measureUniqueName: String)
to get the formatting and then use setFormat()
to rewrite it.
Please let us know if it solves the case.
Regards,
WebDataRocks Team
Thanks for the quick response,
I need to present numeric value 20,00,000(2 Million) as below based on user selection
If User select show in millions then value is 2.00M
If User select show in Lakhs then value is 20.00L
If User select show in Thousands then value is 2000.00L
Is this possible with number formatting?
Hello Ramarkishna,
Thank you for your feedback. Currently, there is no native support for such formatting. However, you can easily implement your own custom formatting using customizeCell
approach: https://www.webdatarocks.com/doc/customizecell/.
Please let us know if everything works fine for you.
Regards,
WebDataRocks Team