Format the values of a column in the Table in Flex and calculate the percentage. flex percentage

Format the values of a column in the Table in Flex and calculate the percentage. flex percentage

1. Problem background

In general, you need to format the value of a column in the table, multiply the value by 100, keep two decimal places, and add "%"

2. Implementation instance

<? Xml version = "1.0" encoding = "UTF-8"?> <S: Application xmlns: fx = "http://ns.adobe.com/mxml/2009" xmlns: s = "library: // ns.adobe.com/flex/spark" xmlns: mx = "library: // ns.adobe.com/flex/mx "width =" 100% "height =" 100% "fontSize =" 12 "fontFamily =" "> <s: layout> <s: basicLayout/> </s: layout> <fx: Script> <! [CDATA [import mx. collections. arrayCollection; import mx. events. flexEvent; [Bindable] // bind table data to private var gridArray: ArrayCollection = new ArrayCollection ([{week: "Monday", apple: "3676", rate: "0.7868 "}, {week: "Tuesday", apple: "4534", rate: "0.65454" },{ week: "Wednesday", apple: "6758", rate: "0.876454 "}, {week: "Thursday", apple: "9808", rate: "0.34224" },{ week: "Friday", apple: "6567", rate: "0.9876523 "}, {week: "Saturday", apple: "9000", rate: "0.566777 "},{ Week: "Sunday", apple: "4533", rate: "0.988787"}]);/*** format the ratio in the table */private function formatDataGrid (item: object, column: DataGridColumn): String {var tempData: Number = item. rate * 100; var data: String = dataFormatter. format (tempData); return data + "%" ;}]]> </fx: Script> <fx: Declarations> <! -- Format the number --> <mx: NumberFormatter id = "dataFormatter" precision = "2" rounding = "up"/> </fx: Declarations> <mx: VBox width = "100%" height = "100%" paddingBottom = "10" paddingLeft = "10" paddingRight = "20" paddingTop = "10" horizontalAlign = "center"> <mx: dataGrid id = "dataGrid" width = "100%" height = "90%" dataProvider = "{gridArray}" textAlign = "center"> <mx: columns> <mx: dataGridColumn headerText = "" dataField = "week"/> <mx: DataGridColumn headerText = "apple" dataField = "apple"/> <mx: dataGridColumn headerText = "ratio" dataField = "rate" labelFunction = "formatDataGrid"/> </mx: columns> </mx: DataGrid> </mx: VBox> </s: application>

(1) Multiply the decimal number by 100.

Var tempData: Number = item. rate * 100;

(2) format the value and retain two decimal places.

Var data: String = dataFormatter. format (tempData );

(3) Add a percent sign

Return data + "% ";

3. Implementation result

The Operation character formatting for table formatting is different from that for numeric formatting.

It is more suitable to use hand-drawn images. If the picture is wrong, you can erase it again. Select the line type for the rough border. The drop-down menu for the outer box is displayed. Select the line type. What does Gray shading mean? Is it the border color? This is also selected in the drop-down menu, select the color and line type, then select the drawing border, and then frame to add the border range is OK. Very simple.
As for the internal line, do a good job first, and then make the outer frame, which is simple.

In a workbook, how can we find data greater than a certain value in a column and copy them to a new workbook?

We recommend that you use the format = "formatting condition" to set a value greater than this value and distinguish it with special coloring;
Or use the IF formula.