https://bugs.documentfoundation.org/show_bug.cgi?id=172696
Bug ID: 172696
Summary: EDITING: imported csv values exhibit strange behavior
with sum
Product: LibreOffice
Version: unspecified
Hardware: ARM
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
After importing a csv with dollar amounts, addition works but summing doesn't.
=a1+a2 yields a correct answer
=SUM(A1:A2) does one of two things, neither of which matches the above:
1. it might stay as "=SUM(A1:A2)" and
2. it might show 0
No amount of formatting the source cells will work.
Manual entry of the same value, even with dollar signs, functions properly.
If this is user error, please advise.
--
You are receiving this mail because:
You are the assignee for the bug.
