Created attachment 119414 [details] manually added values I have a csv file with values in % like: 0,24%;2015-10-06 09:16:54 0,05%;2015-10-06 09:21:54 0,24%;2015-10-06 09:26:54 0,15%;2015-10-06 09:31:54 If I import it in localc, it seems to be correct but I cannot do anyting with the imported values. For example If I try to generate a simple graph with 0.24% to 0.15% the graph is blank whereas If I fiel another cases with the same values it works (see ok & nok.png)
Created attachment 119415 [details] imported csv values
Step to reproduce: import the test.csv attached file and try to generate a graph on % values.
Created attachment 119416 [details] test.csv
Hi remyD, In your screenshot "imported cvs values", percent values are left aligned. This means they are imported as text. If you select one of them, input line will show a quote as the fisrt character. You have in this case to select Detect special numbers in the Text Import window, on opening, to import these percent values as values. Next, reverse the colon order of time and percent values will make easy to select the first colon as label to format x axis, after cells formatting to Time.
Created attachment 119425 [details] a sample with these values
Hi jack, You are right, I have followed your procedure and it works. Sorry for the false positiv. Which status should I use for this ticket? Resolved?
Status is to set to RESOLVED NOTABBUG. Have a good day, Jacques