Let's discuss this further :) I agree it would be a killer component for Flex.
A pivot table component is one thing, but first you need to start with a spreadsheet type component (err maybe not, as the start data should not be modifiable). I guess any given itemrenderer would need to observe "all" other itemrenderers in its parent. You would also have to have a special header and row itemrenderers not to mention the specific ones for x and y axis totals. You can then add the ability to drag and drop column headers (haven t figured this one out yet, as they seem glued to their axis). You need some kind of formula parser, I guess regex could do it (once you define a formula language). That language would most definitely need to be very similar to excel, and map to action script through some sort of mapping/parsing process (runtime). As for a starting component Im not sure extending the grid would be up to the job. A pivot table usually requires allot of data (paging is not an option). So support for multiple formats is required (xls, xml, csv, tab separated etc..) What am I missing here :) Jason -----Message d'origine----- De : [email protected] [mailto:[EMAIL PROTECTED] la part de Pan Troglodytes Envoyé : mardi 11 juillet 2006 16:39 À : [email protected] Objet : Re: [flexcoders] Pivot Tables If you'd used pivot tables much, you'd know why I chuckled at your comment. :D Pivot tables are a really cool Excel feature that allows you to graphically fiddle with a set of data, with Excel converting your GUI actions into GROUP BY and rollups and summaries. To my boss, almost every problem looks like a pivot table waiting to happen. If someone would implement a robust, full-featured pivot table component in Flex, they might be able to make a lot of money off it. On 7/10/06, slangeberg <[EMAIL PROTECTED]> wrote: You can perform column sorts automatically on a DataGrid component. What kind of additional functionality are you looking for? Scott On 7/6/06, digitalnovanet <[EMAIL PROTECTED]> wrote: Anyone ever seen a flex or flash based Pivot Table? If not, anyone have an idea how it can be made? -- : : ) Scott -- Jason ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/nhFolB/TM --------------------------------------------------------------------~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
