https://issues.apache.org/bugzilla/show_bug.cgi?id=50440

--- Comment #4 from Tommy Y Li <[email protected]> 2010-12-09 17:48:52 EST ---
(In reply to comment #1)
> Are newlines really valid characters within the formula though?
> 
> Are you creating the formula with the newline it in through POI or excel?

New lines (created using alt+enter in formula bar on Windows Excel 2010 OR
command+option+return in Mac Office 2008) are valid, i.e. Excel correctly
calculates the formula.

I created the formula using Excel and used Apache POI to read the workbook.

I attached a test harness in Groovy and a spreadsheet (xlsx) that has new line
chars in the formula.

Cheers,

Tommy.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to