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: [email protected]
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
