https://bugs.freedesktop.org/show_bug.cgi?id=68720
Priority: medium
Bug ID: 68720
Assignee: [email protected]
Summary: FORMATTING: The cells in a column that contain the
currency symbol is not properly formatted as currency
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.0.0.alpha0+ Master
Component: Spreadsheet
Product: LibreOffice
Problem description:
The cells in a column that contain the currency symbol is not properly
formatted as currency type.
Steps to reproduce:
1. Have a proper CSV file (view attachment). As example:
///// CSV FILE BEGIN /////
A;B;C;
;€ 10;;
;€ 10;;
;€ 10;;
///// CSV FILE END /////
2. Import CSV file in Calc, then select column: B. Format as: currency.
3. Jump to end of selected range, then insert SUM() function.
4. You get 0 instead of realvalue, because the content of the cells is treated
as text.
Current behavior:
Expected behavior:
Operating System: All
Version: 4.2.0.0.alpha0+ Master
--
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
