Re: (old) New feature/option to prevent autodata alterations in calc

2013-01-08 Thread kieth lovell
@openoffice.apache.org Cc: kieth lovell m3...@yahoo.co.uk Sent: Sunday, 6 January 2013, 23:36 Subject: Re: (old) New feature/option to prevent autodata alterations in calc Remember, that anything that begins as a number, Calc tries to interpret as a number rather than text. For most users

Re: (old) New feature/option to prevent autodata alterations in calc

2013-01-08 Thread kieth lovell
From: Joost Andrae joost.and...@gmx.de To: dev@openoffice.apache.org Sent: Monday, 7 January 2013, 2:04 Subject: Re: (old) New feature/option to prevent autodata alterations in calc Hi Kieth, For years I have suffered as     1. numbers are turned to dates is it really

Re: (old) New feature/option to prevent autodata alterations in calc

2013-01-07 Thread Joost Andrae
Hi Kieth, For years I have suffered as 1. numbers are turned to dates is it really a number you want to input or do you use a number format ? 2. phone numbers are altered In this case you can start your cell entry using a single quote character. A trailing single quote

Re: (old) New feature/option to prevent autodata alterations in calc

2013-01-06 Thread Andrew Douglas Pitonyak
Remember, that anything that begins as a number, Calc tries to interpret as a number rather than text. For most users, this is exactly what you want most of the time. For a few unlucky people (like you), their average use case is different than others, and you do not want that. It is odd