poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Beardsley <markbrd...@tiscali.co.uk>
Subject Re: DO NOT REPLY [Bug 50440] Newline characters in all formulas results in FormulaParseException
Date Thu, 09 Dec 2010 12:16:37 GMT

It seems as though it is perfectly possible to insert line breaks into
formulas, but I believe only those that are concerned with the
'presentation' of data. The examples I have found tend to be like this one;

=CONCATENATE("First line",CHAR(10),"Second line")

where the line break is being used to format the appearance of the results
of the forumla evaluation. 

Logically, I do not think it makes sense - my opinion of course - to do
anything like the OP proposed unless the formula is very long and complex
and the aim is to use whitespace to group the various parts together. Even
having said that, I do not know how Excel itself would parse the forumla as
it was originally posted.


Mark B
View this message in context: http://apache-poi.1045710.n5.nabble.com/DO-NOT-REPLY-Bug-50440-New-Newline-characters-in-all-formulas-results-in-FormulaParseException-tp3298538p3298809.html
Sent from the POI - Dev mailing list archive at Nabble.com.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message