[Libreoffice-bugs] [Bug 44817] FILEOPEN .xls, SUM() with more than 30 comma separated summands cell should show formula + value instead of error message

[bugzilla-daemon at freedesktop.org]

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

Kohei Yoshida <kohei.yoshida at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         AssignedTo|kohei.yoshida at gmail.com     |libreoffice-bugs at lists.free
                   |                            |desktop.org

--- Comment #16 from Kohei Yoshida <kohei.yoshida at gmail.com> 2012-08-05 21:46:42 UTC ---
(In reply to comment #15)
> @Kohei Yoshida:
> Your secreenshot seems to show something completely different? Here we discuss
> the problem that EXCEL (or may be only viewer) is more tolerant concerning SUM
> formulas with too many arguments.

No, Excel is LESS tolerant, as it doesn't take more than 30 arguments, whereas
Calc does!

> May be that EXCEL is limited to 30 arguments there, and even may be that the
> EXCEL format rules limit creation of that function to 30 arguments.

It's not maybe, it's the truth.

> But: EXCEL (Viewer) SHOWS without any problems, and so it is definitively a
> problem that we can't do so, because LibO  is too intolerant. But yardstick
> should be EXCEL, not the Viewer.

Try re-calculate in Excel.  Excel only shows the cached result that we put in.

Sorry, I'm completely lost.  I don't understand what you guys want to see
fixed.  I'll remove myself from further discussion.  Perhaps ask someone else
for a second opinion.

Thanks.

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