Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

Sets or returns the maximum value to be used in the category (x) axis, represented as DateTime

Signature
C#C#
Wiki Markup
{description}
{excerpt}Sets or returns the maximum value to be used in the category \(x) axis, represented as DateTime{excerpt}
{signature:C#}
 public System.DateTime MaximumValueAsDate{ get; set; }
Signature
{signature}{signature:vb.net
vb.net
}
Public Property MaximumValueAsDate() As Date
Remarks

When creating new charts, or reading in charts where this value is not set, this property will return 0, which represents that this property does not contain a value and Excel will automatically determine an appropriate maximum for your category axis. Unfortunately, there is no way to distinguish between this state and when the MaximumValue property is actually set to zero.

This property can be set to less than the CategoryAxis.MinimumValueAsDate, although that is an illegal state. We allow this so that the order of operations does not matter when setting both the MinimumValue and MaximumValue to different values. However, if the MaximumValue is still less than the MinimumValue when you try to save, the MinimumValue will be treated as the MaximumValue and vice versa so that the resulting file is not corrupt.

These properties will only effect the axis if CategoryAxis.DisplayType is set to TimeScale.

...

{signature}
{remarks}When creating new charts, or reading in charts where this value is not set, this property will return 0, which represents that this property does not contain a value and Excel will automatically determine an appropriate maximum for your category axis. Unfortunately, there is no way to distinguish between this state and when the MaximumValue property is actually set to zero.

This property can be set to less than the [CategoryAxis.MinimumValueAsDate], although that is an illegal state. We allow this so that the order of operations does not matter when setting both the MinimumValue and MaximumValue to different values. However, if the MaximumValue is still less than the MinimumValue when you try to save, the MinimumValue will be treated as the MaximumValue and vice versa so that the resulting file is not corrupt.

These properties will only effect the axis if [CategoryAxis.DisplayType] is set to TimeScale.

{remarks}
{scrollbar}