Apologies all for tardiness in replying I eventually went with the Data > Validity suggestion triggered from a ? Symbol next to the relevant cell
And I knew about the date layout bit - honest I did :) Thanks for the help Graham :-) ->--------------------< On 09/09/2012 12:39, Brian Barker [via Document Foundation Mail Archive] wrote: > At 03:19 09/09/2012 -0700, Graham Lovatt 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 > > Easy: just put that text into the cell! The nature of spreadsheets > is that anything you type into a cell replaces what is already in > it. Your user will overwrite the message with the actual data. > > Alternatively, you could insert a note in the relevant cell (Insert | > Note or right-click | Insert Note). The user would need to > understand the note indicator and know how to hover over it to see > your advice - or you could choose Show Note if you want the note to > be permanently visible. > > Incidentally, your example date of 01/01/2012 is uniquely unhelpful, > since it could represent either month-day-year or > day-month-year! You probably need something like 31/12/2012 or > 12/31/2012. Mind you, the exact format of entry may not matter, as > the spreadsheet will interpret the input according to the locale and > display it according to the formatting of the cell. > > I trust this helps. > > Brian Barker > > > -- > For unsubscribe instructions e-mail to: [hidden email] > </user/SendEmail.jtp?type=node&node=4006367&i=0> > 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 > > > > ------------------------------------------------------------------------ > If you reply to this email, your message will be added to the > discussion below: > http://nabble.documentfoundation.org/calc-message-in-cell-tp4006357p4006367.html > > > To unsubscribe from calc - message in cell, click here > <http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4006357&code=Z3JhaGFtQGxvdmF0dC5jby51a3w0MDA2MzU3fDIxMTU1MDA5NjI=>. > NAML > <http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > > ----- IGraham W764 LibreOffice 3.5.2.2 -- View this message in context: http://nabble.documentfoundation.org/calc-message-in-cell-tp4006357p4006653.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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