https://bugs.freedesktop.org/show_bug.cgi?id=56036

--- Comment #11 from Ed <[email protected]> ---
I reported bug 88634.  I don't care if you mark 88634 as a duplicate or not. 
However, for ME, this bug is a showstopper and must be fixed.  I don't care if
you replace the ALT-ENTER with a space so long as the formulas work.

As it is, if I receive an Excel spreadsheet from someone else that has a
Newline in the formula it is unusable.

In the best case LO reports an error and I have to ask the author (who is
hopefully still around) or someone with a copy of Excel to provide me with the
contents of the cell(s) in error.

In the worst case LO does NOT report the error and the spreadsheet provides
incorrect answers.  I can't give you a specific case for this, but it did
appear that LO automatically provided a closing parenthesis that had been
truncated, along with many parts of a formula, after a newline.

I would GUESS that the following Excel formula would NOT provide an error in LO

=SUM(1 + 2
+ 3 + 4
+ 5)

In LO it would may appear as =SUM(1 + 2)

If you want I can try and reproduce this.  I'm just pressed for time right now.
 Let me know.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to