Issue 128174 - Want to format different digits differently, but doing so unwantedly converts number to text
Summary: Want to format different digits differently, but doing so unwantedly converts...
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.6
Hardware: PC All
: P5 (lowest) Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2019-08-15 00:53 UTC by gwojnar
Modified: 2019-08-15 04:46 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description gwojnar 2019-08-15 00:53:58 UTC
Using v.4.1.6

I would like to format different digits of a number differently, e.g., I would like the whole number part to be one color and the part after the decimal point another color; also more involved coloring schemes with more than 2 colors. Sometimes when data is normally integer type and special circumstances arise I will use digits after a decimal point to flag the special circumstances, e.g., 237.002003 might indicate a true value of 237 but with special issue A, type 2, and special issue B, type 3; in such cases I would like the columns www.xxxyyy to have 3 different colors, perhaps with xxx or yyy bold type.

If I color different columns in such way by hand, then the number is converted to text.  All attempts to re-convert the text back to a number cause the special formatting to disappear.

This would be a nice feature to have if it doesn't already exist.  It would be nicer still if it could be implemented with conditional formatting.
Comment 1 Peter 2019-08-15 04:46:11 UTC
Okay, I fixed some settings.