Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
Received-SPF: unknown (athena.apache.org: error in processing during lookup of
 markbrdsly@tiscali.co.uk)
Date: Thu, 9 Dec 2010 04:16:37 -0800 (PST)
From: Mark Beardsley <markbrdsly@tiscali.co.uk>
To: dev@poi.apache.org
Message-ID: <1291896997508-3298809.post@n5.nabble.com>
In-Reply-To: <201012091034.oB9AYjkk012971@thor.apache.org>
References: <bug-50440-47293@https.issues.apache.org/bugzilla/>
 <201012091034.oB9AYjkk012971@thor.apache.org>
Subject: Re: DO NOT REPLY [Bug 50440] Newline characters in all formulas
 results in FormulaParseException
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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.

Yours

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