[libreoffice-users] Re: calc - message in cell

Am 09.09.2012 12:19, IGraham wrote:
> Calc
> How do i (can i) place in a cell a message - that isn't part of the active
> spreadsheet
> I want to tell the user the data type they should be entering as 'date type
> 01/01/2012' and that the message will disappears as the user starts typing
> Thanks for any help


There is no "date type" in a spreadsheet. You can leave it up to the user.

Any of:
2012/9/13
2012-9-13
13 sep
sep 13
13/
and many other input methods yields the exact same date of current 
month's 13th (which is unformatted day number 41165 in September 2012).

Your suggestion "01/01/2012" is ambiguous anyway because it is unclear 
if "01/02/2012" refers to the 2nd of January (USA) or 1st of February 
(other planet).




--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted