Hi Lars,

this feature is implemented.

Just use a useerdefined numberformat for your Cells, something like this :

0,00 °C

Apply it to your cells and build a chart.

Best regards

Frank

resolved

closed

thanks,

but (oh no! "but" ! ...)

just as an addition:

if working with "text numbers" (issue 6357) is implemented in the 
future, such text-formated cells as I described above should be 
automatically recognised.

You know I'm often about saving as many mouse clicks and keyboard 
work as possible (and that is something current CPU power can be used 
for, not like other performance issues (issue 4664)).

also,

if the cell already contains "number + unit", specifying a custom 
mask "## unit" doesn't "do what one would like", because the cell 
content (was)is text and there is no single number fitting "## unit"; 
the undelying mask is "## unit" already though. So removing 
the "text" 'unit' makes the remaining part be number only and the 
mask is applied showing up as "number unit" in a number mask.

It will be better if there is automatic recognition of such text 
transforming it to "number unit" if unit specified in custom number 
mask matches the unit text in cell content.

So this should occur when applying masks; and when letting a chart be 
build upon that data, this transformation occurs only internally of 
the chart to get the data, the actual cell mask is not changed.

Do you think it's worth to reopen?

>You know I'm often about saving as many mouse clicks and keyboard 
>work as possible (and that is something current CPU power can be 
>used for, not like other performance issues (issue 4664)).

If you wonder then why there is number + unit if I could have just 
written number (and if necessary put the unit into the next columns 
cell and copying it as often as I need to), well, the Data came from 
a csv file and was not enterd by me...!

No