https://bz.apache.org/ooo/show_bug.cgi?id=127910
Issue ID: 127910
Issue Type: DEFECT
Summary: The range operator (colon) doesn't work in the SUM
function
Product: Calc
Version: 4.1.5
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: ui
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
If I include a range, e.g. "=SUM(F30:F37-F27)" the result is "#VALUE!". Also
Ctrl-Z doesn't work, so I have to either key the range the hard way
"F30+F31..." or exit the worksheet, discarding the change, and reopen it.
--
You are receiving this mail because:
You are the assignee for the issue.