Codejock Developer Community : Format thousands separator http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 12:16:18 +0000 Sat, 23 May 2009 20:32:07 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=14362 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Format thousands separator : Did somebodytried to useformated...]]> http://forum.codejock.com/forum_posts.asp?TID=14362&PID=49296&title=format-thousands-separator#49296 Author: mdoubson
Subject: 14362
Posted: 23 May 2009 at 8:32pm

Did somebody tried to use formated values in PropertyGrid? Regional settings can use decimal point or comma also use comma as thousand saparators and so on. Same question about currency values.
 
btw - each ReportRecordItem have Format property so you can keep value as common sense sortable and present it in the item caption after format applied
 
We can also add Column-based format which can be apply for any item of  thic column (easy assing in the code).  
Next step - use internal UnitManager which can convert on-fly any unitized value from permanent unit to dynamic presentation unit so app can run in different countries and connected to same common database
We also need to think about more rich set of column (item) types (e.g. support images or other blob data)
]]> Sat, 23 May 2009 20:32:07 +0000 http://forum.codejock.com/forum_posts.asp?TID=14362&PID=49296&title=format-thousands-separator#49296 <![CDATA[Format thousands separator : First step with the value formatted...]]> http://forum.codejock.com/forum_posts.asp?TID=14362&PID=49268&title=format-thousands-separator#49268 Author: DavidSpain
Subject: 14362
Posted: 22 May 2009 at 5:46am

First step with the value formatted text and then pass the same numerical value to the property sortpriority.

It works!

Thank you, Aaron!

]]> Fri, 22 May 2009 05:46:20 +0000 http://forum.codejock.com/forum_posts.asp?TID=14362&PID=49268&title=format-thousands-separator#49268 <![CDATA[Format thousands separator : Hi, If you assign values (numbers)...]]> http://forum.codejock.com/forum_posts.asp?TID=14362&PID=49265&title=format-thousands-separator#49265 Author: Aaron
Subject: 14362
Posted: 22 May 2009 at 4:45am

Hi,
 
If you assign values (numbers) to ReportItems it will sort correctly (even without any format).
 
Set rec = wndReportControl.Records.Add()
        Set recItem = rec.AddItem(i) 'Sort OK
        
        Set recItem = rec.AddItem(i & " Kb") 'Sort not OK
        
        Set recItem = rec.AddItem(i) 'Sort OK
              recItem.Format = "%s Kb "
 
        Set recItem = rec.AddItem(FormatNumber(i / 3, 2))
              recItem.Format = "%s kb 'Sort not OK 
              recItem.SortPriority = i / 3 'Now it sorts OK
But you have to be carefull with SortPriority: Public Property SortPriority() As Integer
 
 
]]> Fri, 22 May 2009 04:45:14 +0000 http://forum.codejock.com/forum_posts.asp?TID=14362&PID=49265&title=format-thousands-separator#49265 <![CDATA[Format thousands separator : Hello friends! Regarding...]]> http://forum.codejock.com/forum_posts.asp?TID=14362&PID=49256&title=format-thousands-separator#49256 Author: DavidSpain
Subject: 14362
Posted: 21 May 2009 at 12:57pm

Hello friends!

Regarding the formats of cell in the report grid,
We have seen that there are plenty of potential.
However, we do not know how to do that in the case
digital formats, separate the thousands:

For example:
1234  -->  1.234
100000  --> 100.000
5876154 --> 5.876.154

Is there any way through format property?

We can pass it as text, but then it does not order the data correctly.

Many thanks in advance.


Product: Xtreme SuitePro (ActiveX) version 13.0.0
     Platform: Windows XP (32bit) - SP 2
     Language: Visual Basic 6.0
]]> Thu, 21 May 2009 12:57:49 +0000 http://forum.codejock.com/forum_posts.asp?TID=14362&PID=49256&title=format-thousands-separator#49256