[Libreoffice-bugs] [Bug 49245] : Formula using SUM does work

[bugzilla-daemon at freedesktop.org]

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

Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |NOTABUG
                 CC|                            |LibreOffice at bielefeldundbus
                   |                            |s.de

--- Comment #1 from Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> 2012-04-28 03:13:09 PDT ---
That has nothing to do with sum() or similar, the column simply contains text
strings that can not be identified by sum() as numbers.

Looks like a user error. Something has been done in the wrong way with
Currency, Locale and similar during import. 

When I created a new spreadsheet and do settings to Locale = English (UK) with
correct currency and copy paste sheet from reporter's document to the new sheet
without formatting everything works as expected. 

So I close this one as NOTABUG.

@reporter:
You can get assistance from Documentation at
<http://www.libreoffice.org/get-help/documentation/> and on
<http://ask.libreoffice.org/questions/>
or on the public users mailing list <users at libreoffice.org>, a mailing list
from <http://www.documentfoundation.org/contribution/#lists> or
<http://wiki.documentfoundation.org/Local_Mailing_Lists>

Please feel free to submit a new Bug if discussion with other users leaded to a
assessment that we have an Import LibO bug and a clear and comprehensible
description of the problem. In that case we will need a .xls source document.

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