[vox-tech] Preserving carriage returns in OpenOffice.ort Calc cells when referring to them

[Henry House]

> So I've got a spreadsheet with some cells that contain carriage returns.
> 
> When I refer to them (e.g., "$A2", or "=IF(NOT(ISBLANK($D12));$D12;$C12)",
> the carriage returns appear to get stripped, or converted to spaces.
> 
> Is there a way to prevent this?  I tried using "CELL("CONTENTS";$D12)",
> but that did the same thing.
> 
> I'm at a loss.  Thx!

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. What is the underlying motivation here?
Perhaps there is a better solution that gets around the limitations of
spreadsheets.

-- 
Henry House
+1 530 753 3361 ext. 13
Please don't send me HTML mail! My mail system frequently rejects it.
The unintelligible text that may follow is a digital signature.
See <http://hajhouse.org/pgp> to find out how to use it.
My OpenPGP key: <http://hajhouse.org/hajhouse.asc>.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature on this e-mail;
	please ignore if you do not have signature-checking
	software
Url : http://lists.lugod.org/pipermail/vox-tech/attachments/20070926/07887027/attachment.pgp