Re: [users] Bad Bug in 3.0 windoze
Andrew Douglas Pitonyak wrote:
I thought that you could turn that off... (that is when Calc converts
an entered number into a date)
All that I could find, however, was that you can precede the number
with a single quote so that it is entered as text.
very sad... If it is indeed a number, what happens if you then change
the format from date back to a normal number?
I typed 10.13.08 and it was automagically converted to 10/13/08. When I
changed the format from number/general to number/-1234 my now date was
converted to 39734.
If I format the column to text before entry, then 10.13.08 is not
converted to a date.
--
Bill Drescher
william {at} TechServSys {dot} com
Re: [users] Bad Bug in 3.0 windoze
bill wrote: Andrew Douglas Pitonyak wrote: I thought that you could turn that off... (that is when Calc converts an entered number into a date) All that I could find, however, was that you can precede the number with a single quote so that it is entered as text. very sad... If it is indeed a number, what happens if you then change the format from date back to a normal number? I typed 10.13.08 and it was automagically converted to 10/13/08. When I changed the format from number/general to number/-1234 my now date was converted to 39734. If I format the column to text before entry, then 10.13.08 is not converted to a date. A value such as 10.13.08, you want OOo to convert to a text entry. precede your entry with a single quote, and then enter 10.13.08 and it will not attempt to convert the entry to a date. This is the official way to avoid the problem in a Calc document. You can not argue that you do not want the entry as text, because, well, it is not a valid number. It is unfortunately that you can not tell OOo to NEVER recognize an entry as a date, even when a valid date format is used to enter data (especially if it is not entered in the default locale). If it converted a number such as 101308, that would be different. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Bad Bug in 3.0 windoze
What kind of number is it? and what do you use it for? Calc is converting your number to a date becuase it sees 3 diferent numbers separated by a dot, and it asumes it must be something like a date because a date has this kind of format MM.DD.AA and your number looks like a date OCT-13-2008, I think a human being could interpret that number as a date also, but anyway, you could use the single cuot ' to convert the number to a string. 2008/10/21 Andrew Douglas Pitonyak [EMAIL PROTECTED] bill wrote: Andrew Douglas Pitonyak wrote: I thought that you could turn that off... (that is when Calc converts an entered number into a date) All that I could find, however, was that you can precede the number with a single quote so that it is entered as text. very sad... If it is indeed a number, what happens if you then change the format from date back to a normal number? I typed 10.13.08 and it was automagically converted to 10/13/08. When I changed the format from number/general to number/-1234 my now date was converted to 39734. If I format the column to text before entry, then 10.13.08 is not converted to a date. A value such as 10.13.08, you want OOo to convert to a text entry. precede your entry with a single quote, and then enter 10.13.08 and it will not attempt to convert the entry to a date. This is the official way to avoid the problem in a Calc document. You can not argue that you do not want the entry as text, because, well, it is not a valid number. It is unfortunately that you can not tell OOo to NEVER recognize an entry as a date, even when a valid date format is used to enter data (especially if it is not entered in the default locale). If it converted a number such as 101308, that would be different. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- --- Carlos Joel Delgado Pizarro Mosoq Kallpa - Linux Users Group IN - UNSAAC - CUSCO - PERU Linux User Registered # 460895 http://carlosj.perulinux.net
Re: [users] Bad Bug in 3.0 windoze
On Tuesday 21 October 2008 23:14:29 Carlos Joel wrote: Calc is converting your number to a date becuase it sees 3 diferent numbers separated by a dot, and it asumes it must be something like a date because a date has this kind of format MM.DD.AA and your number looks like a date OCT-13-2008, I think a human being could interpret that number as a date also Out of interest, I just wrote 13.10.08 out on a piece of paper and showed it to my husband. I changed the order to British date order, because to be a true test, there had to be a chance that he would (mis?)interpret it. I handed it to him and simply said: What does that say? His reply? 13th October 2008. So yes, a human being could interpret it as a date. Lisi - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Bad Bug in 3.0 windoze
In Calc when I type in a number like a part number, it automatically destroys my entry and makes it a date. I tried changing the format to number and it still ruins the spreadsheet by making the part number a date. It seems to work correctly if I format the part number column as text, but if Calc automatically turns all numbers to a date, it will have no useful value as a program. I never had this problem with 2.4 Floyd - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Bad Bug in 3.0 windoze
At 08:01 20/10/2008 -0600, Floyd Beaver wrote: In Calc when I type in a number like a part number, it automatically destroys my entry and makes it a date. I tried changing the format to number and it still ruins the spreadsheet by making the part number a date. It seems to work correctly if I format the part number column as text, but if Calc automatically turns all numbers to a date, it will have no useful value as a program. I never had this problem with 2.4 It doesn't help to say a number like a part number: if your numbers are indeed plain numbers, Calc will not do what you describe, of course. What format do your part numbers have? If they include such things as points, hyphens, or slashes and your cell format is Number, then - depending on your locale - Calc may indeed interpret your values as dates and convert them appropriately. This is documented, so it is not a bug: it is a feature! (Oh, and Calc does not turn[] all numbers to a date.) You say that you can achieve what you want by formatting the cells as text, and this is indeed what you should do. Another way to achieve the same result is to precede the entered text with an apostrophe: this is a signal to Calc that you want your entry to appear as text and to disable automatic conversion to date format. Note that, if you have custom quotes enabled under AutoCorrect you will need to disable this or else to type Ctrl+Z to undo this correction after typing the apostrophe. It's also worth saying that anyway you really do need to ensure that your values are entered as text in situations like this. Your part number is presumably a string of characters, many of which may be digits. But you do not want this to be represented as a number (any more than a date), as this may be rounded and would be displayed to a chosen number of digits. 12.5 is presumably a different part number from 12.50, but they are the same number. There is also a smallish limit to how many digits you can store in a number; this doesn't apply to strings of digits as text. So your discovered solution - formatting the cells as text - is exactly the one you should be using. (I suspect that millions of OpenOffice users out there may disagree that Calc will have no useful value as a program.) I trust this helps. Brian Barker - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Bad Bug in 3.0 windoze
The Beaver wrote: In Calc when I type in a number like a part number, it automatically destroys my entry and makes it a date. I tried changing the format to number and it still ruins the spreadsheet by making the part number a date. It seems to work correctly if I format the part number column as text, but if Calc automatically turns all numbers to a date, it will have no useful value as a program. I never had this problem with 2.4 Floyd Floyd -- As Brian said, it would help greatly in understanding what is going on if you could give examples of the part number being changed to a date. Calc certainly doesn't turn all numbers into dates, like you claimed. If your version really does do that, there is clearly something amiss. And as was stated, it sounds like you've identified the solution -- format the part number column as text. Part numbers should be treated as text anyway. It wouldn't make any sense to perform numerical computations on them (like adding up a column of part numbers, or multiplying the part number by 2, etc.). Kind of like phone numbers -- other than being composed of numbers, there is no real numerical meaning to them. You wouldn't multiply two of them together, divide one by the other, add 10 to one of them, etc. and expect them to have any meaning as a phone number any more. So it would help if you replied to the list and gave examples of the part numbers that are being changed. Although it sounds like your problem is solved (format as text), so assuming that continues to prevent your problem, there may be no more need to give any specifics. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Bad Bug in 3.0 windoze
I thought that you could turn that off... (that is when Calc converts an entered number into a date) All that I could find, however, was that you can precede the number with a single quote so that it is entered as text. very sad... If it is indeed a number, what happens if you then change the format from date back to a normal number? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
