Back to Blog
Easycatalog cc serial6/4/2023 ![]() ![]() The aspect ratio of the original image will not be maintained when using this option. The picture will be scaled to fit the picture box but, unlike Proportionally Fit, it will completely fill the box ensuring there is no white space around the image. There may be white space around the image if the image frame has a different aspect ratio to the image. The picture will be proportionally scaled to fit its containing picture box. The picture will not be scaled when it is imported See our in-depth usage of Scaling/Alignment, with examples here : Specifies the characters to be appending to the numeric content of the field.Ĭharacters can be optionally removed when the content of the field matches the specified criteria.Įxample using Remove - Remove ".00" from numbers over 99. The field will be prefixed with the euro symbol. Specifies the characters to be inserted before the numeric content of the field. Values will be formatted to two decimal places. Specifies the number of digits that will appear after the decimal point. Values greater than a thousand will use a comma as a thousands separator. The thousands separator is used to divide the value into groups of three, right-to-left from the decimal point. Specifies a character or characters to use to as the thousands separator. Specifies the decimal separator (radix point) character(s) to use. The position "*" character specifies that a minimum of 2 decimal places are required. No decimal point is provided in the format string, therefore the value will appear as a whole number.Ĥ places are available after the decimal point - the output value is truncated, not rounded.Īs the characters "USD" do not have any special meaning, they appear untranslated in the output. The comma may be used to separate groups of digits. Only 2 positions are available after the decimal point. Used after the decimal point, the * character indicates the minimum number of characters that must appear.įor example, you can specify that a field must appear with at least two decimal places, but more will be output if required. May or may not be present as a divider between groups of digits, such as thousands, millions, etc. No rounding will be performed on the value. Specifies where the decimal point should appear and, by the use of the # character after the point, how many decimal places the number should be formatted to. The # character indicates where digits from the source field should appear. The two formatting strings are separated by a semi-colon ( ). Create a filter on the GROUP_COLOR fieldįilteredset = recordset:filter('GROUP_COLOR',FIELD.A formatting string should be defined for when the field contains a positive number and a negative number. Recordset = DATASOURCE.get():getrecordset() Next we change the backgound color of the cell with result:cell(i,2):setfill(content) using the value from content. Using a loop we count over each cell.įirst we get the value in the table cell with result:cell(i,2):getcontent() and store that in content. In order to color the column cell we need to know how rows are actually in the table which is found by result:rowcount(). ![]() In column 2 the RGB color value is mentioned. ![]() Result:cell(i,2):setfill(content) - set cell background color Using the table result set the column 4 cell style to "Brian2"Ĭontent = result:cell(i,2):getcontent() - get RGB color from column 2 cell text Result:setcellstylerange("Brian2", 4, 4, 1, result:rowcount()) ![]() Using the table result set the column 3 cell style to "Brian2" Result:setcellstylerange("Brian2", 3, 3, 1, result:rowcount()) Using the table result set the column 2 cell style to "Brian2" Result:setcellstylerange("Brian2", 2, 2, 1, result:rowcount()) Using the table result set the column 1 cell style to "Brian1" Result:setcellstylerange("Brian1", 1, 1, 1, result:rowcount()) Result = filteredset:tableof('COLOR_NAME','RGB','PART_NO1','PRICE_1x10')Ĭreate a table from each filteredset from the fields 'COLOR_NAME','RGB','PART_NO1','PRICE_1x10' and store it in result. If the GROUP_COLOR is GREEN, filter and keep the GREEN records all together If it does, put the record into filteredset.Įg. Using the field GROUP_COLOR check every record in recordset and see if it matches. With all the records in recordset sort them using the numbers in the field PRICE_1x10įilteredset = recordset:filter('GROUP_COLOR',FIELD.get('GROUP_COLOR'):content()) Go to the existing data source panel and get all the records and store them in recordset Recordset = DATASOURCE.get():getrecordset()` ![]()
0 Comments
Read More
Leave a Reply. |