'mm') to ensure the offset it applied correctly. The field should also contain the measurement system (e.g. Specify the name of a field containing the X and/or Y offset that must be applied to the image. These options are used to offset the image within its containing frame by an amount specified in the selected field. If your data also contains picture scaling information, this option can be used to nominate the field containing this value. Pictures will always be imported and scaled to the percentage specified by the Scale pop-up. Some of the image may be outside of the box. The picture will be proportionally scaled to fill the picture box but, unlike Proportionally Fit, it will completely fill the box ensuring there is no white space around the image. 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 ( ). A formatting string should be defined for when the field contains a positive number and a negative number.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |