-
FEATURED COMPONENTS
First time here? Check out the FAQ!
Hi,
I would like to know how to change the the default currency "$" to "£" when formatting cells. My calculations are based on sterling amounts and I can see that the listbox which is generated resides in formatNumber.zul:
<listheader label="Sample:" />
</listhead>
<listitem label="-$1,234.10" value="$#,##0.00" />
<listitem label="$1,234.10" value="$#,##0.00;$#,##0.0"
style="color: red;" sclass="redItem"/>
<listitem label="($1,234.10)" value="$#,##0.00_);($#,##0.00)" />
<listitem label="($1,234.10)" value="$#,##0.00_);($#,##0.00)"
style="color: red;" sclass="redItem"/>
</listbox>
However when i make changes to the currency symbols, the changes are not reflected in the application. How can this be achieved?
Thanks very much
hi, you need to set data format of the cell
refer to
http://books.zkoss.org/wiki/ZK%20Spreadsheet%20Essentials/Working%20with%20ZK%20Spreadsheet/Configure%20and%20Control%20ZK%20Spreadsheet/Change%20Cell's%20Style%20and%20Text%20Format#Select_Data_Format
and refer to the formatNumber.zul's control java code: FormatNumberCtrl.java
Asked: 2012-11-28 15:18:05 +0800
Seen: 55 times
Last updated: Nov 29 '12