:-Håkan, Thank you for the link, the code and instructions.
It will help a lot! And thank you again to everyone who replied. It all helps me very much and I really appreciate it. John Balgenorth On Mar 4, 2015, at 2:56 AM, ha...@exformedia.se wrote: > There is a lession on how to format your display here: > > http://lessons.runrev.com/m/datagrid/l/7327-how-do-i-override-the-default-behavior-for-rendering-data-to-a-cell > > In short you need to override the default behavior of the datagrid column: > > 1. Create a new button and select it > 2. Copy the default behavior script to your button via: > set the script of the selectedobject to the script of button "Default > Column" of stack "revDataGridLibrary" > 3. Tell the datagrid to use your behavior instead via: > set the dgProps["default column behavior"] of group "Your data grid" to the > long id of the selectedObject > 4. Edit the script of your button > > What you need look for is the fillInData function > > Let say you want to display your big sales number as $ 1.000.000 (but still > have the value saved as 1000000) you can change fillInData to > > on FillInData pData > set the text of me to formatNumber(pData, ",", ".", "$ ") > end FillInData > > Then you only need to add the formatNumber function... > > function formatNumber pNum, pSeparator, pCommaSign, pPrefix, pPostfix > local tIsNegative, tRest, tCommaPos > if pNum < 0 then > put abs(pNum) into pNum > put true into tIsNegative > end if > put offset(pCommaSign, pNum) into tCommaPos > if tCommaPos > 0 then > put char tCommaPos to -1 of pNum into tRest > end if > put char 1 to tCommaPos -1 of pNum into pNum > repeat with i = length(pNum)-3 to 3 step -3 > put pSeparator before char i+1 of pNum > end repeat > if tIsNegative then > return pPrefix & "-" & pNum & tRest & pPostfix > else > return pPrefix & pNum & tRest & pPostfix > end if > end formatNumber > > Finally if you just want to target a specific column for your formatting you > can use the dgColumn property (or dgColumnNumber) to ensure you only format > specific columns > > Let's say you have a column named "Value" that you would like to format but > no other columns you can change fillInData to: > > on FillInData pData > put the dgColumn of me into tCol > if tCol is "Value" then > set the text of me to formatNumber(pData, " ", ".", "$ ") > else > set the text of me to pData > end if > end FillInData > > Happy Coding! > > :-Håkan > >> Bob Sneidar <mailto:bobsnei...@iotecdigital.com> >> 4 mars 2015 01:13 >> dgData returns an array. dgText returns delimited text. if the commas are >> thousand delimiters, then strip them. I’ve often thought of trying to >> implement a “displayAs functionality for Datagrids, like Excel does, where >> the value is one thing but the display is another. Your situation really >> underscores the need for this. >> >> Bob S >> >> >> On Mar 3, 2015, at 06:18 , dunb...@aol.com<mailto:dunb...@aol.com> wrote: >> >> An easy way is to extract the full dataset, perhaps with the "dgData". This >> will give you a tab and return delimited list. Then you might sort by a >> function: >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> dunb...@aol.com <mailto:dunb...@aol.com> >> 3 mars 2015 15:18 >> An easy way is to extract the full dataset, perhaps with the "dgData". This >> will give you a tab and return delimited list. Then you might sort by a >> function: >> >> >> sort yourData numeric by goodNumber(item columnOfInterest of each) >> >> >> where: >> >> >> function goodNumber var >> repeat for each char tChar in var >> if var is in "0123456789" then put tChar after temp >> end repeat >> return temp >> end goodNumber >> >> >> Craig Newman >> >> >> >> -----Original Message----- >> From: JB <sund...@pacifier.com> >> To: How to use LiveCode <use-livecode@lists.runrev.com> >> Sent: Tue, Mar 3, 2015 6:33 am >> Subject: Sorting Columns >> >> >> I have a data grid and one of the columns >> has numbers with commas included. If I >> use the property inspector and select the >> header column I can choose sort by text >> or numeric. Due to the commas neither >> of the sort types gives me a correct sort. >> >> Do I need to make another array and strip >> the commas and then use that sort with >> columns from the original array? What is >> the best way to sort numeric columns with >> commas included in the numbers? >> >> John Balgenort >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> JB <mailto:sund...@pacifier.com> >> 3 mars 2015 12:30 >> I have a data grid and one of the columns >> has numbers with commas included. If I >> use the property inspector and select the >> header column I can choose sort by text >> or numeric. Due to the commas neither >> of the sort types gives me a correct sort. >> >> Do I need to make another array and strip >> the commas and then use that sort with >> columns from the original array? What is >> the best way to sort numeric columns with >> commas included in the numbers? >> >> John Balgenort >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode