At 20:33 14/10/2007 +0200, Himanshu Ardawatia wrote:
When I try to enter any value like 24.4 in any cell in calc
(openoffice 2.3), it automatically converts it into a date format
like 24.04.2007 which is very annoying because I want it to remain
24.4 (or whatever the decimal number is). Any number like 19.2 or
any decimal number which can possibly seen as a day and month.......
Is there any configuration in calc that can help me configure it for
not considering any decimal number as a date and just let the number
as it be...unless asked for ?
I don't think there is any setting to disable this behaviour. But it
is locale-dependent, so you may like to go to Tools | Options... |
Language Settings | Languages and experiment with the locale setting
and the decimal separator there. Note that these control the
interpretation of input values as well as the display. If you
subsequently change these settings back, the display but not the
interpretation is reset. This means that you may be able to achieve
something useful by selecting other settings, entering your data, and
then putting the settings back to what you really need.
Another workaround - tedious but effective - may be to disguise the
input value so that it is the same number but cannot be
misinterpreted as a date. Your example values could be input as
24.40 and 19.20, for example, without being misinterpreted by
Calc. (Note that this does not change the precision with which the
values are stored: all values are stored to the same precision and
are displayed according to the cell format.) As well as the
day-month cases you have described, Calc can (mis)interpret input
numbers as month-year, so you may have to be alert in order to spot
all the cases that need modified entry.
At 21:03 14/10/2007 +0200, Himanshu Ardawatia wrote:
I wonder if its a bug or any of my settings is wrong still. My
standard setting for 'number' has options : Decimal places = 0 and
Leading zeroes = 1.
Inasmuch as you don't want it to happen: yes, it's a bug. And no:
the number setting controls only the display, not the interpretation
of input values.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
