l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2007 Sep 30 02:15

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] Preserving carriage returns in OpenOffice.ort Calccells when referring to them
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] Preserving carriage returns in OpenOffice.ort Calccells when referring to them

Bill Kendrick wrote:
On Wed, Sep 26, 2007 at 06:32:04PM -0700, Henry House wrote:
AFAIK the standard model of spreadsheets does not allow linebreaks
within cells, so undefined and inconsistent behavior such as you are
encountering is to be expected.
Tell that to MS Excel and OOo Calc. Both allow entry of linebreaks. OOo even
has a help page explaining how to do multiline text.
What is the underlying motivation here?
Storing text in a resource file w/in a mobile app JAR file.
Our build system uses CSV files to determine which assets to use depending
on the attributes of the tsarget handset (feature capabilities, screen size,
language, etc.)
Excel and OO's support of multi-line text in cells is not related to
the possibility of support for multi-line text in CSV, or their mapping
of their internal representations to CSV.

Perhaps there is a better solution that gets around the limitations of
Too late for that. :^/
Encode the string (e.g. "first\nsecond", or use a format (e.g. XML) that
supports multi-line text strings. Although some spreadsheets do support
multi-line text strings in cells, such support is not standardized, and CSV
format cannot include newlines within a field.  If you attempt to do so, the
range of applications that support your kludge will be by limited to those
that understand your chosen method of encoding such embedded newlines.
In other words, manually encoding the string may be your only compatible

BTW: Excel's method of quoting strings in "CSV" is a law unto itself... it
distinguishes newlines inside strings using LF instead of the usual
DOS CRLF end-of-line marker... making Excel's version of CSV effectively
a binary format, which greatly reduces any value it had as a portable
data format.

Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil@dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
O'Reilly and Associates
For numerous book donations.