0

ZK Spreadsheet how to change default currency from $ to £?

asked 2012-11-28 15:18:05 +0800

ML2012 gravatar image ML2012
17 2

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

delete flag offensive retag edit

1 Reply

Sort by » oldest newest

answered 2012-11-29 03:06:47 +0800

samchuang gravatar image samchuang
4084 4

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

link publish delete flag offensive edit
Your reply
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow

RSS

Stats

Asked: 2012-11-28 15:18:05 +0800

Seen: 55 times

Last updated: Nov 29 '12

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More