Quick Fix for AdvancedDataGrid not maintaining widths when data provider refresh

clock January 31, 2016 03:30 by author Flexicious

Recently, we addressed an issue for a customer:

Issue : One thing I have found is that (in some cases) if I set the dataprovider for the datagrid after the datagrid is initially created, the widths are correctly set, but if I set the dataprovider in the mxml code for the grid and bind an array collection to it, the column width settings are not respected.    

 

Another issue we have is that when we change the dataprovider content for the grid, the columns resize themselves after refreshing the dataprovider.  An example project showing this is attached.  In this project, the dataprovider contains a single record and is loaded when the datagrid loads.  When hitting the 'Refresh Data Provider' button at the bottom of the app, I clear the dataprovider, refresh the dataprovider, add the record back to the dataprovider, and then refresh the dataprovider again.  As you can see, the column widths spontaneously resize themselves after the refresh.  Can you please advise as to how we can better control our column widths under these conditions.

Solution:

The problem here is that there are two rounds of code that run to calculate the widths of columns. The first round is the default SDK code - we need it to run to figure out the initial set of column widths. The second pass is our code, which basically adds support for things that are covered using our columnWidthMode. Column Width Modes are an very nuanced topic, as you can observe from this documentation : http://www.flexicious.com/resources/docs29/com/flexicious/nestedtreedatagrid/FlexDataGridColumn.html#columnWidthMode. But irrespective of that - the issue is that once they are calculated, the input for the next round of calculations is not the same as before. So what we have done, is added a property - autoApplyColumnWidths - this will cause the column widths to calculate only once, and that too when you call it. This way, we dont override the initially calculated column widths. 

 

<grids:ExtendedAdvancedDataGrid  id="dgCfgList" 

dataProvider="{devConfigListArr}"

autoApplyColumnWidths="false"

 

And then you manually call applyColumnWidths after you set the data provider - make sure you call validateNow prior to this, so the first pass of the width calculation executes.

devConfigListArr.refresh();

dgCfgList.validateNow();

dgCfgList.setColumnWidthsUsingWidthMode();




Flexicious 3.3 Released

clock January 1, 2016 01:44 by author Flexicious

As we close out a terrific 2015 and ring in 2016, we have been hard at work here at Flexicious wrapping up our newest release 3.3. As with the past couple releases, this one is huge as well, and the full scope of this release has been broken into almost half a dozen individual blog posts that we've been publishing over the past few weeks. As you consume all of this, please keep this in mind - we are and will always be committed to Flex, and our Flex products. We will continue to invest and improve on them - but we ask your help. We are probably among the last few companies still actively developing Flex products. While we've diversified from a technology perspective Flex has always been our favourite stack -its where we feel most at home. Fortunately, we have numerous customers who are just as passionate about the techonology as we are, and have been supporting us via regular renewals. WE thank you and hope we live up to your expectations. For those of you who have not renewed but are still using Flex, please, consider renewing. This gives us the motivation we need to continue to improve and add new features.    

  • Bug Fixes

    • We have a column that can have the values as BLANK (empty string ” “), CAT, and DOG. When I select to filter on BLANK fields, only my column values that contain “ “ will filter, but when I load the preference string into the grid, it does not display my saved filter to be BLANK like it should. It defaults to ALL being selected (BLANK, CAT, DOG).

    • If we have a custom filter render, DynamicFilterControl. The filter works but when we save the preference and the reapply it does not work.

    • Fix for source code could not be compiled with Flex 3.x

    • We have server side persisted preferences.  When I go from a grouped saved preference to a non-grouped filtered preference I loose all data.

    • This only happens in a scenario of grouped to filtered.  If I go from a grouped to sorted or some other simple preference it works correctly.

    • Fixed issue where Print and PDF of grids with horizontal scroll policy auto but columns not wide enough causing last column to stretch cause weird appearance in the print view

    • Added Support for PDF and Export of Grouping Data

    • Added support for column headers to include the full column group text

    • Added support for export and print views to include full column group text.

    • We are no longer able to move columns whenever the Drag Bar Grouping Feature is enabled on the report.

    • When we upgraded to the newest Flexicious, we no longer had the ability to persist the numeric filters when grouping preferences are set.

    • Added column glyph when you are dragging columns (So the user can drag and drop to rearrange columns as well as do the grouping using the Drag Drop grouping)

    • Fixes for drag drop grouping with legacy preferences.

    • If you have an ExtendedAdvancedDataGrid with text input filters, if you also have lockedColumns > 0, then when you type into one of the text input filters, the filter will lose focus after filtering.

    • Fix for textColor - I want my text color in my renderer to stay the color black but it still goes grey even when I set the disabledColor property on the column.  Without the renderer, it works great.

    • Bug fix for label size on treemap/TreeMapPainter.as

    • Fix for XML Exporter not writing out footer.

    • Scroll H-Scroll bar to extreme right. Try to drag any column to the extreme right of the grid. Now try to drag another column, user unable to drag any column if user tries to shift column after last column

    • Bug Fix for fix for LineChartPainter - drawing from 0,0 does not work

    • Fix for able to enter characters like '?' and '*' in the numeric input.

    • Fix for copy selected objects with dynamic levels not working, and checkbox selection with enableStickControlKeySelection false.

  • Enhancements

    • Added support for grid wide column spanning cells. If you return -1 indicates the cell should occupy just its own spot. Any number greater than one would position the cell so it covers the width of that number of cells

    • Added selectedObjectsAtAllLevels - [Read Only] A list of selected objects from the data provider. This is the sdk equivalent of selectedItems. We do not have selectedItems, but selectedObjects will almost always be the same as selectedItems. The only exception is when you use server side paging. In this case, selectedObjects will contain all the items selected, on all pages. When a row is selected in the grid, we store the the selected object in the selectedObects array collection. This allows for multiple pages of data that comes down from the server and not maintained in memory to still keep track of the objects that were selected on other pages. Please note, for hierarchical grids, each level has its own collection of selected keys. The grid.selectedObjects returns the selectedKeys at the top level. To access the selected keys at a lower level, you may navigate to that level using grid.columnLevel.nextLevel...nextLevel.selectedKeys

    • Added support for enableFTERenderer

    • Added support for enableBackground (for grids that don’t paint a background)

    • Made FDGC4 work (for memory)

    • Added Performance improvement - enableStyleCache - http://blog.flexicious.com/post/Upcoming-33-release-Performance-Improvements.aspx

    • Support for clearing grouping criteria – clearGrouping() added to DragDropGroupingBehavior.as

    • Added cellEditEnterKeyTabsToNextEditableCell : By default, the enter key will look for a cell below the current cell. As opposed to the tab key which will navigate to cells starting to the right. Setting this flag to true will cause the user to navigate to the next editable cell (just like the tab key)

    • Changes so that responsive behavior only kicks in once per resize

    • Added documentation for responsive behaviors/ResponsiveBehavior.js

    • Better text rendering for alive pdf printer for multiline text.

    • Updated build scripts to include new files for Responsive code

    • Support for tree map label font size in TreeMap.

    • Added labelFontSizeFunction to TreeMapSeries : Function that determines the label font size. If null, the chart will calculate its own Should take a label Object, a String object, and return a number.

    • Added support for Line Chart Painters to draw broken lines: drawBrokenLines added to LineSeries : When there is a NAN value encountered while drawing a series, we currently just draw a broken line. You can set this flag to false and it will draw through the points to the next real point.

    • All Charts – Support for skipping drawing labels when there is no text returned – One of the biggest things slowing down charts is the issue of drawing a LOT of data points. Each data point requires potentially a label (UIComponent) created – this is especially true for Axes. What this changes does is that via the labelFunction, if you return blank, we don’t draw the label associated with the data point (for an axis, we draw the tick, but not the label on the tick). This allows you to render a lot more data points on the chart with fewer labels.

    • Added allowNoneSelection to MultiSelectComboBox - By default, the combobox does not allow you to select none items. Since it is usually used in search scenarios, you have to select something to search on. However, in cases where you are using the MSCB in non-standard scenarios, setting this flag to true will let the OK button be enabled.




Upcoming 3.3 release - Custom Stylesheets for HTML and Word Exports

clock January 1, 2016 00:48 by author Flexicious

A minor new enhancements to the upcoming 3.3 release is the support for addition of styling information for Word and HTML Exports. You can now add support for backgrounds, borders, fonts, colors, etc to the generated file. The style information is contained in the constants class, and you can modify this:

Below is the default, which you can customize as you see fit. 

 

Constants.HTML_EXPORT_CSS= "<style>"+
   
"table {font-family: Arial, Verdana, sans-serif;border-collapse: collapse; border-spacing: 0; }       "+
   
"td {border: 1px solid #CCC; text-align: center;width: 10em;padding: 1em;}    "+
   
"th {border: 1px solid #CCC; text-align: center;padding: 1em;background-color: #DFDFDF;}"+
   
"tr {height: 1em;}"+
   
"table tr.even {background-color: #F1F1F1;}"+
   
"table tr.footer {border: 1px solid #CCC; text-align: center;padding: 1em;background-color: #DFDFDF;}"+
    
"table tr.odd {background-color:#fefefe;}</style>";

Constants.WORD_EXPORT_CSS= "<style>"+
   
"table {font-family: Arial, Verdana, sans-serif;border-collapse: collapse; border-spacing: 0; }       "+
   
"td {border: 1px solid #CCC; text-align: center;width: 10em;padding: 1em;}    "+
   
"th {border: 1px solid #CCC; text-align: center;padding: 1em;background-color: #DFDFDF;}"+
   
"tr {height: 1em;}"+
   
"table tr.even {background-color: #F1F1F1;}"+
   
"table tr.footer {border: 1px solid #CCC; text-align: center;padding: 1em;background-color: #DFDFDF;}"+
   
"table tr.odd {background-color:#fefefe;}</style>";




Upcoming 3.3 release - Responsive DataGrids

clock December 24, 2015 00:28 by author Flexicious

Readers of our blog know that the past few weeks have seen tremendous development activity on the product. The upcoming 3.3 release adds a highly requested feature : Support for Responsive DataGrid (Responsive Datatables)

Displaying data across various different screen sizes and resolutions has been a challenge few have been able to solve effectively. There are many solutions online, but we have gone a step further by taking Flexicious Ultimate, which is arguably among the most powerful DataGrid component for Flex applications, and added support for responsive rendering. We wanted to give you flexibility over how you want the grid to behave, so we have implemented 3 (THREE!!) different responsive modes:

1.   API to show or hide the scroll bar on basis of the screen width. Below a certain pre-configured screen width, a scroll appears, and allows the user to scroll through all the columns. Above this screen width, there is no scrollbar.

2.     An API for a priority model, where each column can be assigned a priority and the columns appear or be hidden on basis of screen width.

3.     A new column type, TransposedColumn added to accommodate smaller screens, below a certain pre-configured width, all the columns in the grid are replaced by the Transposed Column which contains, within a single cell, all the information that was held in the
previous cells in a transposed manner.

That said, lets talk about each of these modes and what they mean:

1)                      The Scrollbar mode - ResponsiveBehavior.SCROLL_BAR_  : This mode basically says, below a certain threshold (scrollBarWidthTreshhold – default 1000px), the grid will display no scrollbar. But above this width, a scrollbar is shown. This is distinct from the horizontalScrollPolicy=auto. As some of you may know, column widths are a highly nuanced topic. The widths work very differently when horizontal scrollbar exists vs not [You set this via the horizontalScrollPolicy on the grid]. There is also the additional complexity of the columnWidthMode attribute on each column that makes this further nuanced. The one thing to keep in mind is that the responsive mode does not really ‘change’ the behaviors associated with horizontal scroll policy. It merely flips the horizontal scroll policy to on or off on basis of the width of the grid in comparison to the scrollBarWidthThreshold. The behavior of individual columns in this mode still respects the original behavior. There is a lot more information about how each column is sized in each horizontal scroll policy mode, which is clarified here : http://www.flexicious.com/resources/docs29/com/flexicious/nestedtreedatagrid/FlexDataGridColumn.html#columnWidthMode

2)                      The Priority mode - ResponsiveBehavior.COLUMN_PRIORITY_MODE : This mode will show or hide columns on basis of the priority associated with them, and the threshold set on the behavior. There are 5 priority modes. Below are the settings for each priority modes – Please note, these are default values and can be configured to whatever values you like.

/**

*  The width below which columns with priority 1 are not visible.

* @type {number}

*/

this.columnPriority1WidthTreshold = 1120;

/**

*  The width below which columns with priority 2 are not visible.

* @type {number}

*/

this.columnPriority2WidthTreshold = 960;

/**

*  The width below which columns with priority 3 are not visible.

* @type {number}

*/

this.columnPriority3WidthTreshold = 800;

/**

*  The width below which columns with priority 4 are not visible.

* @type {number}

*/

this.columnPriority4WidthTreshold = 640;

/**

*  The width below which columns with priority 5 are not visible.

* @type {number}

*/

this.columnPriority5WidthTreshold = 480;

3)                      The Transposition mode - ResponsiveBehavior.TRANSPOSED_COLUMN_MODE : Similar to the scrollbar mode, this mode will show or hide a transposed column on basis of the current width of the grid in comparison to the value defined for the transposedColumnTreshold (default 450). Below this threshold value, all the columns disappear, and a single column appears which is a transposed version of all the columns in the grid. The advantage of this mode is that all the information rendered in all columns is visible. This mode currently only works with flat data (not hierarchical data). The biggest disadvantage obviously is that you loose the sorting capability across all columns, but you can enable the muticolumn sort and that allows you to modify the sort using the sort popup.

As with any newly added feature, we are hoping to make this seamlessly integrate across all other features (for example, the print/export currently does not work with Transposed columns). We are actually looking for feedback on how this will work in general, so please feel free to share your thoughts

 

Wondering what this looks like?.

1) Here is the default grid (notice the large number of columns)


 

2) Here is the same grid, smaller width, with scrollbar responsive mode (notice the scrollbar at the bottom, which was not there prior to the grid being resized)

3) Here is the same grid, with the priority responsive mode (notice not all columns are visible) the ones with lower priority are hidden.

4) Finally, Here is the same grid, with the transposition responsive mode.


As may have been obvious from the slew of posts about our upcoming features, we have been hard at work trying to make the product even better, if you have not renewed your subscription, show us your support and now would be the time to do it!

 

Finally, below is the sample code used to implement this. (You will need the latest 3.3 release - we have a pre-release available if you want to take it for a spin)

Responsive.zip (274.47 kb)



Upcoming 3.3 release - Pure Native PDF!

clock December 21, 2015 19:54 by author Flexicious

One of the most exciting features to be added to 3.3 and one that we think a lot of you are going to be able to use immediately is the support for native PDF. As most of you are aware the current PDF mechanism basically grabs screen shots of the grid and adds to the page. This works great and most scenarios but the biggest drawback of this mechanism is the quality of the PDF. This is because a screenshot is at the end of the day a bitmap image. It is not a vector and it doesn't scale.

In this release we're basically changing how the AlivePDFPrinter works. Conceptually if you think about our print mechanism what we do is we basically just render the grid to either the printer or the PDF. The grid already takes care of the complex mechanism of figuring out the page size, identifying which rows belong to which page how much data can be fit within a single page and all of that good stuff. So far all we did is let the grid take care of the rendering mechanism and then capture the screen shot of the grid. In this release what we're doing is extending the printer to instead of capturing the screenshot of the grid we basically take the rendering information from the grid and then use that to render native PDF objects.

From design standpoint our PDF pages basically include a report header, page header, the grid area, the page footer and the report footer.  The report header and a report footer are on the first page and the last page respectively. The page header and page footers exists on all pages.  Report headers footers and page headers footers are always a fixed size. You define the sizes when you define these renderers.  Once the sizes for these fixed areas is allocated the grid then takes up the remaining size and on basis of the size of the grid on each page we have to identify which cells in which rows exist on each page. We do all of these calculations up front and then use that information to build the preview. What we can do now with this release is use the same information to render out natural PDF using the API provided by the PDF library which is our case, Alive PDF.

Now that you understand technically what the change means let's talk about what it means to you from a code change perspective. the most obvious change to  enable this behavior is to basically said a flag on the PDF options object.

/**

        * Flag added in 3.3 to enable passing an image to the pdf printer as opposed to the

        * actual display object. Defaults to true, because currently we just add a snapshot of the

        * current view to the PDF page. If this flag is set to false, we will pass the actual display object

    * (and not the image snapshot) to the pdf printer. The pdf printer then has to be smart enough to

        * parse through the Display Object, and call the appropriate APIs on the pdf library to convert

        * the Display Object to PDF version of it.

        * */   

        public var pdfUseScreenShot:Boolean=true;



And then set this flag to false:

protected function vbox1_creationCompleteHandler(event:FlexEvent):void

              {

                    grid.pdfOptions.pdfUseScreenShot = false;

                   

              }

When you set this flag to false what it tells the grid  is that instead of capturing the screenshot of the grid what we want is to capture the information from the page itself.  All of this work is done in the printer.


The next thing you have to do is to use the updated version of the printer you can download this here:

 

The final caveat to keep in mind is that there are two modes for the printer - there's a wrap mode and the no wrap mode.  On the screen if the text with the the cell is larger than the area of the cell in other words if there's not enough space to render the entire content of the cell we usually just cut off the part of the cell text that cannot fit within the area. We can replicate that same behavior in the printer or we can try to fit as much as possible by wrapping the text.  The advantage of not wrapping is that the PDF looks cleaner but the disadvantage is that the information is cut off.  On the other hand if you set the wrap mode to true we'll be able to fit more information but it looks a little cramped. Below are sample outputs - Before, After with wrap, and After No Wrap.

You can flip the wrap setting using the following line of code in AlivePDFPrinter:

           private var pdfWrapText:Boolean=false;

 

To Summarize:

  1. This release includes pure native pdf exports as opposed to the older screenshot based pdf

  2. Now PDF’s can be scaled, they are no longer bitmap images

  3. You can select and copy text from generated PDF files

  4. PDFPrinter supports wrap and no wrap modes (example outputs follow)

  5. To use, set the flag on pdfOptions, and use the new AlivePDF Printer

  6. If you have customized report/page header/footer, modify the AlivePDFPrinter to account for that.

  7. Help us improve this feature by providing feedback!


 

 

 

Enjoy!

Before / After documents : 

Older Screenshot based PDF.pdf (108.29 kb) (Flexicious 3.2 or earlier)

Pure Native PDF With Wrap.pdf (498.74 kb) (Flexicious 3.3)

Pure Native PDF No Wrap.pdf (491.82 kb) (Flexicious 3.3)

Alive PDF Printer Class : AlivePdfPrinter.as (18.18 kb)

Sample Project: OnePager.zip (172.25 kb)



Upcoming 3.3 release - Drag & Drop Grouping within Nested Tables

clock December 15, 2015 08:31 by author Flexicious

For those of you reading our blog regularly, you are probably aware this release is heavy on performance and memory optimization. 

But that does not mean we did not enhance/add features. This blog post covers an interesting use case that we added support for.

You may have read our announcement from ealier this year that we added drag and drop grouping support : http://blog.flexicious.com/post/Drag-Drop-Grouping-For-Ultimate-Flex-DataGrid.aspx 

One of our customers wanted to extend this drag and drop grouping support to inner level tables. Now we realize this is a edge case, but since we already had all the code for grouping at the top level ready, we could easily extend that to accomplish the scenario this specfic customer was looking for.

Basically, what they asked for was this:

3)      We need to ask you to add the following features to the Flexicious Ultimate DataGrid :

a.      Dynamic Group in combination with nested tables. We need to be able to Dynamic Group any column of any table (no matter its nested level). Of course that the grouping  will take place in the nested tabled related to the field being grouped.

So we did this. Below is the screenshot of this feature:

 

 

Below is the sample code used. Please note, to run this, you need to have the latest version (upcoming 3.3) of the Flexicious library. If you have a valid subscription, please request a build or if you wish to evalualte, please download a trial.

 

Sample.zip (134.27 kb)



Upcoming 3.3 release - Memory Improvements

clock December 15, 2015 06:43 by author Flexicious

The latest release has added quite a few things on the performance front. Especially performance while scrolling. More information here : http://blog.flexicious.com/post/Upcoming-33-release-Performance-Improvements.aspx 

An additional improvement that was made was in regards to memory management. This is something that goes deep into the internals of the grid, so most of you have not had to care about this, but the data area of the grid uses a very lightweight FlexSprite that contains a primitive TextField instance to draw out the data cells. This makes the grid perform well. However, you may ask, why have both FlexSprite AND TextField. The basic problem is this – each cell in the grid is responsible for drawing its own borders as well as backgrounds. , we need the FlexSprite to draw the border and background, and TextField to display text. This is because FlexSprite cannot display text by itself, and TextField cannot draw borders and backgrounds (it does not have a graphics object). So we have a text field wrapped inside a FlexSprite. This allows us to provide features like nested tables, column and row spans, inner level footers/filters/toolbars and a lot more.

However, for plain vanilla grids, this may be a little bit of a overkill. So in those situations, you might be better served using this new flag we recently added – enableFTEDataRenderer – This accomplishes two things – First, it uses the native UIFTETextField introduced in Flex 4. So if you are using custom fonts, you don’t have to include both embedAsCff true and false versions. Second, the UIFTETextField is capable of BOTH rendering text AND drawing graphics. Although ultimately it still wraps a text primitive within it, you may observe lower memory usage with UIFTETextField. We have found this to be a hit or a miss, because UIFTETextField does add some of its own complexity, but in some situations where you see the grid taking up more memory than ideal, try setting enableFTEDataRenderer="true"

Note that the default for this is false, it has to be explicitly enabled.

 

 



Upcoming 3.3 release - Performance Improvements

clock December 14, 2015 23:10 by author Flexicious

In every release of the our product, the one thing that we consistently focus on is how to improve performance. This release is no different. We carefully profile our code to eliminate redundancies, and optimize our routines to make our code more performant. Over the years, this has made our product extremely well performant in most cases, but in we continue to make it better.

In this release, we have targeted one area in particular – scrolling. Now this does not make a lot of difference if your grid does not occupy a large percentage of your screen. However, if you have grids that span across your entire screen, the time it takes to paint that many cells as you scroll is sometimes more than ideal. So, we have introduced a new property, enableStyleCache – this will cache a number of style calculations required to render each cell. This will not work if you have grids that use col spans or row spans, or some other edge cases, so switch it back to false if you see rendering issues. But for the most common scenarios, setting this property to true should get you atleast a 50% improvement in scrolling performance, as well as a slight improvement in initial rendering performance.

This can be demonstrated by some hard numbers like shown in the screenshot below.

 

 

As you can see, the amount of work being done as you scroll has been significantly reduced because of the caching introduced.


That said, many times performance issues arise due to very specific configuration settings that we may not have encountered in our settings. So if you run into any of this, please don’t hesitate to get back to us if you notice any other areas that could use performance improvements – please send us a sample that we can run and profile to understand the issues better a'nd help you achieve better performance out of the product.

Note that this behavior can be disabled by setting enableStyleCache="false" (The default is true). If you observe any rendering issues, please send us a test case, and you can disable this new performance enhancement by setting the enableStyleCache back to false.



Drag Drop Grouping - Header Text Function

clock September 23, 2015 16:13 by author Flexicious

Recently a request came in to be able to customize the text used in the grouping drag drop bar for grids that support drag drop grouping. A new property has been added to support this :

grid.dragDropGroupingBehavior.dragBarTextFunction

protected function hbox1_creationCompleteHandler(event:FlexEvent):void

                        {

                              //grid.dataProvider = FlexiciousMockGenerator.instance().getFlatOrgList();

                              grid.dragDropGroupingBehavior.dragBarTextFunction = myFunction;

                        }

                        private function myFunction(col:FlexDataGridColumn):String{

                              return col.headerText + '123';

 

                        }

 

Attached is a complete example

OnePager.mxml (6.68 kb)

 



Few FAQs

clock August 7, 2015 05:46 by author Flexicious

Below are a few questions that have come up in the past few days that are actually asked quite frequently. So wanted to post it up here for quick reference.

Question : We are setting the errorString to the FlexDataGrid by calling dataGrid.setErrorByObject method. This is disabling the entire row. We don't want the row to be disabled we just want cell to show the errorString.  Currently the behavior is datagrid row is getting disabled and errorString is appearing. Since the row is disabled we are not able to hover, select the row any more.We tried calling rowDisabledFunction and returning null but that is not working rows are still disabled.

Answer : So the rows are not actually disabled, just that the rollover colors are not applied. The way the grid works, is if there is a row in error state, the errorBackgroundColor style is always applied. This works fine, since it is unusual to have all rows in error as appears in your example

If you want the grid to have rollover error cells, you can always define a custom rowBackgroundColorFunction, as demonstrated in the attached example.

                  public function myrowBackgroundColorFunction(cell:IFlexDataGridCell):*{

                        if(grid.currentCell.rowInfo==cell.rowInfo){

                              return cell.getStyleValue("rollOverColor");

                        }else if(cell.level.isItemSelected(cell.rowInfo.data)){

                              return cell.getStyleValue("selectionColor");

                        }

                        return null;

 

                  }

 

Question : We have a requirement to perform cancel edit when enter is pressed on the last row.For some odd reason, when grid.destroyItemEditor() is called, the blue rectangle is still drawn, unlike when escape is pressed.This blue edit border is still there even after the user click the cell next to it. Is there a workaround to force the editor border not to be drawn when destroItemEditor() is called?

Answer : For this issue, please try calling grid.getCurrentEditor().drawFocus(false); focusManager.setFocus(grid); before calling destroyItemEditor.

 

Question : We need to perform certain action each time the user moves/tabs out from an editable cell of the datagrid. Is there any focus out handler for the same?
Answer : Please use itemEditCancel

 

Question : How to make certain columns picked up excel report and ignored the others? 
 Answer : You can set excludeFromExport=true for the colums you want to exclude from the export.

 

      Question : 

Hi,

I used
multiColumnSortNumberStyleName for the columnGroup and sortIcon for the column sortArrowSkin="mx.skins.spark.DataGridSortArrow"
Below is my style

.multiColumnSortNumberStyle
{
    fontFamily: AmplitudeEmbedded;
    color: #FFFFFF;
    rollOverColor: #FFFFFF;
    fontSize: 14px;
    gap: 3;
    paddingTop: 0;
    paddingBottom: 0;
    paddingLeft: 5;
    paddingRight: 0;
    dataCellEmbeddedFonts: true;
    backgroundColor: aqua;
}

Sort Numbers are getting visible with Grey color where i have given color as white. But when i rollover on to the column header sort numbers are disappearing. When i rollout sort numbers are visible.
I  tried to change the backgroundColor for multiSortColumn but still it is taking the column header color only.

Can you please send me an example where
columHeaderColors, multiColumnSortNumberStyleName and sortArrowSkin are used.

Answer : Please see below:


 

 

McsStyle.mxml (853.00 bytes)