Bug 374871 - can not import ascii data with a date to a spreadsheet
Summary: can not import ascii data with a date to a spreadsheet
Status: RESOLVED FIXED
Alias: None
Product: LabPlot2
Classification: Applications
Component: frontend (show other bugs)
Version: Frameworks
Platform: openSUSE Linux
: NOR normal
Target Milestone: ---
Assignee: Alexander Semke
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-01-10 14:41 UTC by Stefan Brandner
Modified: 2018-08-04 07:27 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In: 2.5

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan Brandner 2017-01-10 14:41:42 UTC 
labplot2 Version 2.3.0 KDE Framework 5.26.0 Qt 5.6.1

I have a ascii file with two columns. First is a date in the format (yyyy-MM-dd hh:mm:ss) second is the output of an air sensor. The two field are separated by a ';'. Unfortunately the date field is not recognized by the import tool.
Also copy and paste to the column does not work. When the column is set to "Date and time" a date in the above format is possible when entered manually.

First fields of the ascii file:
"Date";"CO2/VOC level"	 
2016-12-21 09:27:53;629	  
2016-12-21 09:28:53;642	  
2016-12-21 09:29:53;656	  
2016-12-21 09:30:53;638	  
2016-12-21 09:31:53;621	  
2016-12-21 09:32:53;627	  
2016-12-21 09:33:53;629	  
2016-12-21 09:34:53;635	  
2016-12-21 09:35:53;644	  
2016-12-21 09:36:53;658	  
2016-12-21 09:37:54;678	  
2016-12-21 09:38:54;681	  
2016-12-21 09:39:54;679
Comment 1 Alexander Semke 2017-01-10 19:59:14 UTC 
This is a current limitation of LabPlot - it's not possible to import date-time values nor is it possible to plot them. This is on our TODO-list and we'll add this in near feature.
Comment 2 Alexander Semke 2018-08-04 07:27:11 UTC 
Hi Stefan,

importing of datetimes is possible starting with 2.5 release. Plotting of such data is implemented recently and is available in the current master - this will be part of the 2.6 release. Give it a try.

Regards,
Alexander