[Kst] Feature Request: Time axis in Excel numeric units

[Barth Netterfield]

Hmmm...

I implemented this - but realized there is at least one issue: This
will cause kst to assume that the EXCEL_DATE is in GMT.  However Excel
assumes that EXCEL_DATE is in local time.  The 'work-around' would be
to just tell the plot axis that your TZ is GMT.  But this could be
pretty confusing.

Are there any more authoritative references about how excel does store
date/times in csv files?

cbn

On Tue, May 15, 2012 at 4:55 AM, repaul_schrott-kst at yahoo.de
<repaul_schrott-kst at yahoo.de> wrote:
> I had a look at the sourcecode of plotaxis.[h,cpp] source code.
>
> The required formula is actually much simpler
>
>     JULIAN_DATE = EXCEL_DATE + 2415018.5
> or
>
>     JD18991230  = 2415018.5   // Julian Date of 30-Dec-1899 00:00:00 GMT
>
>     JULIAN_DATE = EXCEL_DATE + JD1899_12_30
>
>
> Thanks
>
> Ralph Paul
>
> _______________________________________________
> Kst mailing list
> Kst at kde.org
> https://mail.kde.org/mailman/listinfo/kst



-- 
C. Barth Netterfield
University of Toronto
416-845-0946