Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

While tables in writer also support the same numeric formats spreadsheets do, they do not apply a number recognition automatically in contrast. Thus input numbers are indeed treated as alphanumeric by default if not explicitly formatted otherwise (I don't know a way to change that). As distinguished from spreadsheets ('Data' > 'Sort...') sorting text tables ('Table' > 'Sort') will offer a choice to treat data either 'Alphanumeric' or 'Numeric'. 'Alphanumeric' mode will always take the first character as most significant and therefore judge "51" greater than "499". In 'Numeric' mode text table sorting will apply a type conversion into a standard numerical type in advance and therefore judge 499 > 51. This will even remain in effect if the part of the cell content being recognisable as numeric is followed by alphabetic characters (with or without space).

(As always with "Smart Features" there are more implications than mortals can think of.)

While tables in writer also support the same numeric formats spreadsheets do, they do not apply a number recognition automatically in contrast. Thus input numbers are indeed treated as alphanumeric by default if not explicitly formatted otherwise (I don't know a way to change that). As distinguished from spreadsheets ('Data' > 'Sort...') sorting text tables ('Table' > 'Sort') will offer a choice to treat data either 'Alphanumeric' or 'Numeric'. 'Alphanumeric' mode will always take the first character as most significant and therefore judge "51" greater than "499". In 'Numeric' mode text table sorting will apply a type conversion into a standard numerical type in advance and therefore judge 499 > 51. This will even remain in effect if the part forepart of the cell content being recognisable as numeric is followed by alphabetic characters (with or without space).

(As always with "Smart Features" there are more implications than mortals can think of.)

While tables in writer Writer also support the same numeric formats Calc spreadsheets do, they do not apply a number recognition automatically in contrast. Thus input numbers are indeed treated as alphanumeric by default if not explicitly formatted otherwise (I don't know a way to change that). As distinguished from spreadsheets ('Data' > 'Sort...') sorting text tables ('Table' > 'Sort') will offer a choice to treat data either 'Alphanumeric' or 'Numeric'. 'Alphanumeric' mode will always take the first character as most significant and therefore judge "51" greater than "499". In 'Numeric' mode text table sorting will apply a type conversion into a standard numerical type in advance and therefore judge 499 > 51. This will even remain in effect if the forepart of the cell content being recognisable as numeric is followed by alphabetic characters (with or without space).

(As always with "Smart Features" there are more implications than mortals can think of.)

While tables in Writer also support the same numeric formats Calc spreadsheets do, they do not apply a number recognition automatically in contrast. Thus input numbers are indeed treated as alphanumeric by default if not explicitly formatted otherwise (I don't know a way to change that). As distinguished from sorting spreadsheets ('Data' > 'Sort...') sorting text tables ('Table' > 'Sort') will offer a choice to treat data either 'Alphanumeric' or 'Numeric'. 'Alphanumeric' mode will always take the first character as most significant and therefore judge "51" greater than "499". In 'Numeric' mode text table sorting will apply a type conversion into a standard numerical type in advance and therefore judge 499 > 51. This will even remain in effect if the forepart of the cell content being recognisable as numeric is followed by alphabetic characters (with or without space).

(As always with "Smart Features" there are more implications than mortals can think of.)

While tables in Writer also support the same numeric formats Calc spreadsheets do, they do not apply a number recognition automatically in contrast. Thus input numbers are indeed treated as alphanumeric by default if not explicitly formatted otherwise (I don't know a way to change that). As distinguished from sorting in spreadsheets ('Data' > 'Sort...') sorting in text tables ('Table' > 'Sort') will offer a choice to treat data either 'Alphanumeric' or 'Numeric'. 'Alphanumeric' mode will always take the first character as most significant and therefore judge "51" greater than "499". In 'Numeric' mode text table sorting will apply a type conversion into a standard numerical type in advance and therefore judge 499 > 51. This will even remain in effect if the forepart of the cell content being recognisable as numeric is followed by alphabetic characters (with or without space).

(As always with "Smart Features" there are more implications than mortals can think of.)

While tables in Writer also support the same numeric formats Calc spreadsheets do, they do not apply a number recognition automatically in contrast. Thus input numbers are indeed treated as alphanumeric by default if not explicitly formatted otherwise (I don't know a way to change that). As distinguished from sorting in spreadsheets ('Data' > 'Sort...') sorting in text tables ('Table' > 'Sort') will offer a choice to treat data either 'Alphanumeric' or 'Numeric'. 'Alphanumeric' mode will always take the first character as most significant and therefore judge "51" greater than "499". In 'Numeric' mode text table sorting will apply a type conversion into a standard numerical type in advance and therefore judge 499 > 51. This will even remain in effect if the forepart of the cell content being recognisable as numeric is followed by alphabetic characters (with or without space).

(As always with "Smart Features" there are more implications than mortals can think of.)imagine.)

While tables in Writer also support the same numeric formats Calc spreadsheets do, they do not apply a number recognition automatically in contrast. Thus input numbers are indeed treated as alphanumeric by default if not explicitly formatted otherwise (I don't know a way to change that). As distinguished from sorting in spreadsheets ('Data' > 'Sort...') sorting in text tables ('Table' > 'Sort') will offer a choice to treat data either 'Alphanumeric' or 'Numeric'. 'Alphanumeric' mode will always take the first character as most significant and therefore judge "51" greater than "499". In 'Numeric' mode text table sorting will apply a type conversion into a standard numerical type in advance and therefore judge 499 > 51. This will even remain in effect if the forepart of the cell content being recognisable as numeric is followed by alphabetic characters (with or without space).

(As always with "Smart Features" there are more implications than mortals can imagine.)