Enumerations¶
- class numbers_parser.NegativeNumberStyle(*values)[source]¶
How negative numbers are formatted.
This enum is used in cell data formats and cell custom formats using the negative_style keyword argument.
- MINUS = 0¶
Negative numbers use a simple minus sign.
- RED = 1¶
Negative numbers are red with no minus sign.
- PARENTHESES = 2¶
Negative numbers are in parentheses with no minus sign.
- RED_AND_PARENTHESES = 3¶
Negative numbers are red and in parentheses with no minus sign.
- class numbers_parser.FractionAccuracy(*values)[source]¶
How fractions are formatted.
This enum is used in cell data formats and cell custom formats using the fraction_accuracy keyword argument.
- THREE = 4294967293¶
Fractions are formatted with up to 3 digits in the denominator.
- TWO = 4294967294¶
Fractions are formatted with up to 2 digits in the denominator.
- ONE = 4294967295¶
Fractions are formatted with up to 1 digit in the denominator.
- HALVES = 2¶
Fractions are formatted to the nearest half.
- QUARTERS = 4¶
Fractions are formatted to the nearest quarter.
- EIGHTHS = 8¶
Fractions are formatted to the nearest eighth.
- SIXTEENTHS = 16¶
Fractions are formatted to the nearest sixteenth.
- TENTHS = 10¶
Fractions are formatted to the nearest tenth.
- HUNDREDTHS = 100¶
Fractions are formatted to the nearest hundredth.
- class numbers_parser.PaddingType(*values)[source]¶
How integers and decimals are padded in custom number formats.
- NONE = 0¶
No number padding.
- ZEROS = 1¶
Pad integers with leading zeroes and decimals with trailing zeroes.
- SPACES = 2¶
Pad integers with leading spaces and decimals with trailing spaces.