[prev in list] [next in list] [prev in thread] [next in thread] List: kde-edu-devel Subject: Re: LabPlot date import format From: Alexander Semke <alexander.semke () web ! de> Date: 2021-01-12 19:27:33 Message-ID: 12684057.uLZWGnKmhe () linux-2rd5 [Download RAW message or body] Hi Bill, On Montag, 11. Januar 2021 20:47:05 CET Bill Gee wrote: > Fedora 33, LabPlot 2.7.0 > [...] > > I create a project, then add a spreadsheet to the project. Then I impor= t to > the spreadsheet from the CSV file. In the import screen I specify the d= ate > format as "MM/dd/yyyy mm:hh:ss". LabPlot seems to completely ignore the > format I give it, as evidenced by the dates on the graph. The DateTime values seem are compeltely off on your screenshot... We impro= ved the support for DateTime in 2.8 greatly and I cannot reproduce this in 2.8= , please see the attached export of the worksheet. I'm also attaching the project file in case you want to check it in 2.8 once you have this versio= n. > I also try > changing the format in the definition of the x-axis, but it has no appar= ent > effect. The drop-down boxes for both screens does not contain a date > format that will work. > Is there a way to tell LabPlot what the format of the date string is? The format of the axis labels can be changed in the properties explorer. C= lick on the axis and go to the tab "Labels" and select the format you want to h= ave. In your case you most probably want to get rid of the common "MM/dd/yyyy"- prefix. So, you just specify "hh:mm:ss" instead of the pre-selected "MM/dd= / yyyy hh:mm:ss" format that is taken over from the original formt the data = was imported with. The screenshot of the properties explorer where you see the= se settings is also attached. Here I'm also not quite sure how much of this was already working in 2.7. Ideally we get 2.8 running in Fedora. I contacted the package maintainer b= ut unfortunately didn't get any reply yet :-( Is it the only file with 17569 rows that you need to plot now or do you ha= ve many such files? If it's the only file and you only need those two plots f= or the temperature and for the air pressure, I can quickly produce the plots = for you. Maybe reach out to me directly for this and we can quickly finalize t= his. In parallel I'll try to find somebody else at Fedora who can help with packaging of LabPlot. Best Regards, Alexander ["cave_pressure_temperature.lml" (cave_pressure_temperature.lml)] _ ңJ&xO)t<ܔ yӗ=dSy-_!|M9(8oTC \ G{ِW}ҿo#xN; Gy_x1_}YC뀳? \ ,_s[۵[,Ak,zCC!Co~cvw.UfbjgYo+YuEs 0s˖2Wf2 g.5Ӂ =ʫz.d!%7^_`|6@䔖oVwdz˖*˾E=D]V'Y7D] ت`|]zp) 쮊H` 8 1o3eܩ sST՛~^ 1Q,FY,{CU ͺǘ-4{$U?F!Nj(r;e}V#WZ5VnQi֯ՈЕ 0AڹwzDS'T8to|)9=?'#~ }a߮=DŃ{k\3+sUIԽ!U87Æqox;n,[li:QԺJ \ n,[=@0l8 :.A㳷n#^JK-Rތv&Gua'پیG<T9^N'9 J{@B˪uv%\Z`!Ç1g>jƩxкFm{)y^UvfMSp4={a \ R4wzwC/9}skscqqn1EÖ;`de)pw!/Z(.F$.e&8~g=P$MOtrhXUWg?&Tޚah+SfƲޕB;q˓k \ tCb+Ͱs9}u84FFeLh%^!Uu{"ũ?.kDBM,Tc;2^vwosX],{s{ç՝Kwz9Ӿ=(˅*~չ`gq<T4%\8LVU \ U+MU^~[Du \ GIX"p]exGS&ӕj|<αc99uBco8UKnnY6""u[Z 5sAe%dgs]k^CZ J0ǨQ~<[8\2UˍS&)A1H{) \ 4-6rV/P;1,}88er)ٸ,zb-o6A2.i \ fLyMzoX52KH!R~xzT&ngVMQ_G:ԾuɾVxy.wNS4qf TQCa,&{KW &=sxkP&?tylߑQ l[z4Kl~ \ I|Qno`is;^ט ^^,_UUc!赴7dTB,+xI+d?Ymȸ(,Y \ +tB?t_ѷf;`m_Ὁl?MD:˚9s5}szӐ8` \ xK]kٛ;*"'ơǝ8ru7iE;rS \ kyTF1E$$KXIڌ6yW}tzHLqoZ@f_ \ >%/c6efĪ \ };C1w~FYr'5$C\fG{MVS k/k{c. rR[xmBlAT \ QyRd&Ȍw kCdKaӀWؘd>j< e氎50:1fȅt \ "y2 pDg53&aQW%@TN~&K{F-Jc,= \ 3JdҪܹ8t3E:&5%;ɯP%/ɞYeC-u,U|iso4A&:15BCa|śy̎[59k'HG&d7Z5Oq \ . marZ`mWVn 2-U#3Q:N5&Nugr \ #nBp^KW54&^艵7^ .H%e`'bִ,l츣^Wz1GR \ /7.mg4ƍ|yr_R]}egn<:Lrz9^Ke"F \ <>4{>?=曆2,o%o$K}iFb$kS~#X>CaVCcܴE3A#H\ 'dryEA 5\ϑ,J8^JX̛5zUr2Q%zMK/1xYR0kߊkԌMC~ `^k A7Zz OgYway%V(O ς:P'Yn!P1y \ <~~'C4ׁ͂D$']s kky) W. \ LL;.z-k"!CXwsE'FXfo.%Et n#i-U]9dG^$I2$č$l%(,i'`Y JsLѬiXVR( ky&^g4} &tBMBψ"Cm?1 \ ϓOԵ5KS֗Љ8Ān%(Ji@лPخm25?!x5K`I \ }+wDV"mbKUEoAo ʇ۴pa \ rșJ`ipgx;?Ms˜@1V?K B&;F2mND g \ MMR}-DEC`- mĚqH sqԼcEw#SO ;5iӊcv_*4 \ *Ih||| #oKԈͻ(X%1dG56\q\G7Yzu \ (Xe+p>rP=p{3~m \ {TE`%]ӝWk1=YX.:UJi^ bI@]0P \ o3$3oD],mAN6{J?N k(kލȹCFGW7hRW$eLj~| \ { (TeџIgE z創VE*kV;&{TX"-^)|mg \ /.Dja8eD^^E>#ʟL ַ" (yOH; \ ;;ָ!7q-{pigp},uCw'FU˙U(6K Ӓ_& \ z~3 4[r{9%ԩfr%̥0Y \ e| aw^/-+F-O_j \ dSdJ'!4ZUEQ_~WM9% \ əkftʁ͕q[2hhgD4lnf}ǢxYY"< \ 9uչ]ی:tiӯk vjGu4!x'٦lpF| \ Z2kxp[s)\XIyb/%r2>E9tXzM&. b,CuaPgxm MP xwIc*ǛFO0,2Ϭ2d Ds,h$ u=cS4Xo"`5ϧ"xA,FXs[W5/8 \ l\>y^YzObL/WCL1K?%z)>ŭYz-I쑚1LO2O \ (ۥ)qƒ")DUØ!8wc7mi[|X `m7:)QQ~B<ݬŋJfwpG#tl=u~/B:,⮥ \ J뼷 $]1XW ݀cpb]&̽_EQ[xez]l N8I˝އÙdMfzOq̗x`Mјd8Z \ i>*'a+MwxJ1Hx^3C];h%xZ_5Qhx-)5tL:' \ 3:EFMۮz DWE: 5?[0'dp?gŚ;i L9.C O X߾%x5)F]&rb!{gHc!dEу_f`M<kz[1OmzZꌾl3M"i%Eere 1 Xc^N,&^o5pIoKͧnpNcWy^8?VXGwʆDX&ޫ \ \2p;rVT٬o7Z#YUl3RɅ]˝]#yɖIEf<+Ya$3C%gLPML!^8z}bRbu9i`dd'3ggyp~ j]Dߒ}y+ ;oq&]7z|(v[]_ґ1US*kQ>ktJlgOv !g8OPIv883K:?1YͲW\sY7y'4NJSL[? "Kd<!G;:cal\6 cp kr/kwT*e!Pw APJ"pr?^XNZ(Ȕ4.Djإ/iYūbʽN2^[AWP Zaa7x4GI4Gfp՚}6*<