Not understanding the Format PatternLets say I have 212.33 stored in mysql db as Decimal, viewvalue is correct, also shows 212.33If 212.00 is stored in mysql
but in browser it shows 212 only, how to show the “.00” also?Right now the View tag format is Number and viewvalue shows 212 in browserHow do I set the Format Pattern so it shows 212.00?
You may simply specify your own format pattern, e.g. #,##0.00.
Pasted into view tag
Format Pattern: #,##0.00Doesn’t work… maybe need to add modification like:if CheckInteger($this->mydecimalnumber->ViewValue) $this->mydecimalnumber->ViewValue = $this->mydecimalnumber->ViewValue . “.00” ?
It should work. I’ve just tried it in demo2023 project for UnitPrice field in orderdetails table. If the price is 18.00, then it will be displayed as 18.00 too in List and View page.To make sure that setting is implemented as it is, I changed the Format pattern to #,##0.0 (one digit after decimal point), then the result will become 18.0 (work as expected).
I see the problem now. In LIST/VIEW mode it works, but I’m in permanent GRIDEDIT mode which doesn’t show “.00”
In EDIT TAG I don’t see FORMAT PATTERN, how can I change the format of the .EditValue ?I see CUSTOM EDIT TAG but not sure if that will help modify the number format?
Or have to do through server events?
You may use Use View Tag format for edit.