Issue 127910 - The range operator (colon) doesn't work in the SUM function
Summary: The range operator (colon) doesn't work in the SUM function
Status: CLOSED FIXED_WITHOUT_CODE
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.1.5
Hardware: PC Windows 10
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2018-10-12 00:11 UTC by Dick Gray
Modified: 2018-10-13 02:29 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Dick Gray 2018-10-12 00:11:44 UTC 
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.
Comment 1 Marcus 2018-10-12 18:41:35 UTC 
A cell range is defined with the colon (like F30:F37). When using additionally a "-" it's interpreted as minus operator.

Result:
Sum up all cells from F30 to F37 and then subtract F27 from it.

As you haven't given any sample (an attached spreadsheet would be great) I can only guess.
Comment 2 Dick Gray 2018-10-12 18:50:29 UTC 
Marcus, I've tried entering "=SUM((F30:F37)-F27)", with the same result. How then would you express it?
Comment 3 Matthias Seidel 2018-10-12 19:14:50 UTC 
(In reply to Dick Gray from comment #2)
> Marcus, I've tried entering "=SUM((F30:F37)-F27)", with the same result. How
> then would you express it?

Can you try:
=SUM(F30:F37)-F27
Comment 4 Dick Gray 2018-10-12 23:25:54 UTC 
Dang! That worked, thanks! The fn description is a little misleading, I think.
Comment 5 Dick Gray 2018-10-12 23:29:40 UTC 
Closing the issue out.