Jump to content


Photo

thousand separator for footer/column


  • Please log in to reply
2 replies to this topic

#1 emailaya

emailaya

    Master Member

  • Members
  • PipPipPipPipPip
  • 984 posts

Posted 30 September 2008 - 01:28 PM

hi

i have a footer to calculate the sum of numbers in a certain column.
how can i make it to show a comma as a thousand separator in the footer/column value?
thanks

#2 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,289 posts
  • Gender:Male

Posted 30 September 2008 - 03:32 PM

Hello Emailaya,

You first need to set FormulaMaskKind in Column.Footer to mkFloat, then set FormatMask to something like: #,##0.00

I hope that it helps,

Best regards
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#3 emailaya

emailaya

    Master Member

  • Members
  • PipPipPipPipPip
  • 984 posts

Posted 30 September 2008 - 03:40 PM

silly me
works like a charm
thanks!




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users