Creating and Setting up a Date Cell

• Spread Designer Instructions
• ActiveX Instructions
• DLL Instructions

Overview

If you prefer, you can limit the date values allowed in the date cell. By default, the maximum date value allowed is 12/31/2100 and the minimum date value allowed is 01/01/1990. However, you can set the maximum and minimum date values to any dates between 01/01/1000 and 12/31/9999.

With dates containing two-digit century values, you can determine how the century is calculated. You set a four-digit calculation date and Spread calculates the century by using years between the calculation date and the calculation date minus 99 years. For example, if you specify a calculation date of 2099, the dates range between the year 2000 and 2099. In this case, the century for all date calculations is 20. As another example, if you specify a calculation date of 2029, the dates range between 1930 and 2029. The century is either 19 or 20, depending on the last two year digits. In this case if the last two year digits are 30–99, the century is 19; if the last two year digits are 00–29, the century is 20.

By default, the text is left-aligned and displays at the top of the cell. You can change the horizontal and vertical alignment of text in a date cell. You can display text in the cell horizontally or vertically. If the text orientation is vertical, you can specify that text wraps from right to left or left to right. You can also rotate text 90, 180, or 270 degrees from the horizontal position.