Steema Central

Code: Select all

private static readonly long _OAStartTicks = DateTime.FromOADate(0).Ticks;

public Form1()
{
	InitializeComponent();
	ConvertOADate(40906.75); // both methods create the same Tick-Value
	ConvertOADate(40906.75 + 10.0 / TimeSpan.TicksPerDay); // Add 1 us --> they don't agree anymore
	ConvertOADate(40906.75 + 100.0 / TimeSpan.TicksPerDay); // Add 10 us --> they don't agree anymore
	ConvertOADate(40906.75 + 1000.0 / TimeSpan.TicksPerDay); // Add 100 us --> they don't agree anymore
	ConvertOADate(40906.75 + 10000.0 / TimeSpan.TicksPerDay); // Add 1 ms --> it's the same again
}

private void ConvertOADate(double value)
{
	DateTime dt = DateTime.FromOADate(value);
	DateTime dt2 = new DateTime(_OAStartTicks + (long)Math.Round(value * TimeSpan.TicksPerDay));
	if (dt.Ticks != dt2.Ticks)
		MessageBox.Show("DateTime values are not equal");
	else
		MessageBox.Show("DateTime values are equal");
}

Code: Select all

var formattedDateTime = string.Format("{0:dd.MM.yyyy HH:mm:ss.ffffff}", new DateTime(799998999912354811L));

Code: Select all

        private void InitializeChart()
        {
            Steema.TeeChart.Styles.Line line1 = new Line(tChart2.Chart);
            line1.FillSampleValues(5);
            tChart2.Axes.Bottom.Labels.Items.Clear();
            long value1 =799998999912354811L; 
            for (int i = 0; i < line1.Count; i++)
            {
                var formattedDateTime = string.Format("{0:dd.MM.yyyy\nHH:mm:ss.ffffff}", new DateTime(value1));
                value1 = value1 + 100000000000000000L;
                tChart2.Axes.Bottom.Labels.Items.Add(line1.XValues[i], formattedDateTime);
             
            }
          
            tChart2.GetAxisLabel += new GetAxisLabelEventHandler(tChart2_GetAxisLabel);
        }