[libreoffice-users] Re: Calc changes cells with . to 0

Am 14.03.2012 23:40, Andrew Koeser wrote:
> Hey everyone,
>
> I notice that Calc will sometimes change the value of a cell from a
> period to a zero. I notice it mostly when I save from .ods to csv. This
> is an issue, as one of the stats software programs I use denotes missing
> data with a "."
>
> Is there an auto-correct setting that I can change so that it will not
> do this again?
>
> Thanks!
>
> Andrew

A period without any digits gives a text value.
3 tab separated columns of text, date and decimal with points:

> "a"   02/02/12        1.98
> "."   03/03/12        12.5
> "b"   "."   19
> "c"   04/04/12        "."



--
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