[Bug 123668] Excel import: newlines in formulas not supported
https://issues.apache.org/ooo/show_bug.cgi?id=123668 Edwin Sharp changed: What|Removed |Added CC||el...@mail-page.com --- Comment #1 from Edwin Sharp --- Excel 2007: A1 =SUM( B3 =B1 IMHO Calc shouldn't mimic this useless feature. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 123668] Excel import: newlines in formulas not supported
https://issues.apache.org/ooo/show_bug.cgi?id=123668 Prosper Uniger changed: What|Removed |Added Keywords||interop_OOXML --- Comment #2 from Prosper Uniger --- (In reply to Edwin Sharp from comment #1) > Excel 2007: > A1 =SUM( > B3 =B1 That's odd, my ancient but fully patched Excel 2003 can read and write formulas with newlines. here the link to the POI bug report and how they fixed it: https://issues.apache.org/bugzilla/show_bug.cgi?id=50440 added interop_OOXML since the bug is with .xlsx-files only > IMHO Calc shouldn't mimic this useless feature. But the current behavior suggests the user everything went fine, while parts of the formula are missing. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 123668] Excel import: newlines in formulas not supported
https://issues.apache.org/ooo/show_bug.cgi?id=123668 Regina Henschel changed: What|Removed |Added Status|UNCONFIRMED |CONFIRMED CC||rb.hensc...@t-online.de Ever confirmed|0 |1 --- Comment #3 from Regina Henschel --- The line feed character belongs to the white spaces, that are allowed in ODF1.2. see section 5.14 Whitespace in ODF1.2 part 2, "Evaluators shall treat SPACE (U+0020), CHARACTER TABULATION (U+0009), LINE FEED (U+000A), and CARRIAGE RETURN (U+000D) as whitespace characters." and even more, "Evaluators should retain whitespace entered by the original formula creator and use it when saving or presenting the formula, and should not add additional whitespace unless directed to do so during the process of editing a formula." For details see http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html So this is not only a valid request for interoperability with OOXML but also a needed feature for ODF1.2. Currently UI replaced entered line feeds with a space character. This makes sense because AOO hasn't got a 'multiple line' input line yet. But opening too replaces line feeds with space characters and if I understand section 5.14 correctly, that should not happen. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 123668] Excel import: newlines in formulas not supported
https://issues.apache.org/ooo/show_bug.cgi?id=123668 Barrie changed: What|Removed |Added CC||bar...@quantimatics.com -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 123668] Excel import: newlines in formulas not supported
https://issues.apache.org/ooo/show_bug.cgi?id=123668 --- Comment #4 from Barrie --- I find this defect to be a big headache. I create applications in MS Excel and I liberally use the alt + enter feature when creating large formulas. The line feeds provide a lot more readability. Some of my user community like to use OO Spreadsheet but the apps I send them are rendered useless because all these long formulas are decapitated to show only the first line. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 123668] Excel import: newlines in formulas not supported
https://issues.apache.org/ooo/show_bug.cgi?id=123668 --- Comment #5 from Edwin Sharp --- (In reply to Barrie from comment #4) > I find this defect to be a big headache. I create applications in MS Excel > and I liberally use the alt + enter feature when creating large formulas. > Please do share an example. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 123668] Excel import: newlines in formulas not supported
https://issues.apache.org/ooo/show_bug.cgi?id=123668 --- Comment #6 from Barrie --- Created attachment 81916 --> https://issues.apache.org/ooo/attachment.cgi?id=81916&action=edit A subset of an MS Excel app using line feeds in formulas -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 123668] Excel import: newlines in formulas not supported
https://issues.apache.org/ooo/show_bug.cgi?id=123668 --- Comment #7 from Barrie --- Comment on attachment 81916 --> https://issues.apache.org/ooo/attachment.cgi?id=81916 A subset of an MS Excel app using line feeds in formulas Edwin, This may be a repeat of an earlier comment - not sure. The attached .xlsx file contains a fragment of an MS Excel app that uses line feeds to clarify long formulas. Without the line feeds, parsing the formula makes me both cross eyed and cross. When this file is opened in OO only the first line of the formulas are captured and usually is leads to an Err condition. Thanks for your interest -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.