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

Thanks for lead with the quotes. It looks like the problem was two fold. 
When exporting to text, I needed to select the check box "quote all text 
cells".

Upon opening the .csv file, I needed to click the "quoted field as text" 
box in the text import prompt.

New question. When I selected the "quoted field as text" box in the 
import prompt, I never had to do this again. The setting was changed for 
future uses. However, when saving, the "quote all text cells" box is 
always unchecked. Is there anyway way I could make this the default setting?

Andrew



On 3/14/2012 6:02 PM, Andreas Säger wrote:
> 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    "."


--
Research and Teaching Assistant
Department of Crop Sciences
University of Illinois at Champaign-Urbana


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