Bug 95025 - =SUMME()
Summary: =SUMME()
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-13 22:29 UTC by Philipp
Modified: 2015-10-14 08:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Table (20.19 KB, image/jpeg)
2015-10-13 22:29 UTC, Philipp 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Philipp 2015-10-13 22:29:31 UTC 
Created attachment 119566 [details]
Table

It is not possible, I admit formatting as € figures and the addition does not go.
See table.
Comment 1 m_a_riosv 2015-10-13 23:33:07 UTC 
Hi @Guido, thanks for reporting.

Seems your data are text (cell formated as text @ or numbers with an apostrophe at the beginning) not numbers, functions don't do the conversion.

Select the data range, and Menu/Data/Text to column to convert in numbers.
Comment 2 Philipp 2015-10-14 07:52:18 UTC 
Thanks, perfect!