https://bugs.documentfoundation.org/show_bug.cgi?id=172553
Bug ID: 172553
Summary: Formatting cells as decimal fails for SUMME
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Keywords: implementationError
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 207519
--> https://bugs.documentfoundation.org/attachment.cgi?id=207519&action=edit
ods with example
LC is configured to use German language settings.
Importing csv to LC causes numbers treated as text because they are suroundet
by "".
Select cells and use format cells
select decimal number with Koma as decimal
click ok
enter =SUMME(A1:A8) in another cell -> Result 0
enter =A1+A2+...+A8 in different cell -> Result -33,71
--
You are receiving this mail because:
You are the assignee for the bug.
