Bug 51696 - [EDITING] Severe miscalculation in Spreadsheet
Summary: [EDITING] Severe miscalculation in Spreadsheet
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-03 12:52 UTC by Olivier Hallot
Modified: 2012-07-03 13:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
sample file with error in formula (9.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-07-03 12:52 UTC, Olivier Hallot 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Olivier Hallot 2012-07-03 12:52:03 UTC 
Created attachment 63783 [details]
sample file with error in formula

Hi

The attached spreadsheet shows an error not detected in formula calculation within the spreadsheet, and depends on the location of the formula.,

On cell B6 =SUM(C2:G2)-C3:G3 contains a syntax error that is perfectly signaled.

THE SAME formula in cell C6 does not signal an error, results in 450 which is SUM(C2:G2) - C3
Comment 1 Eike Rathke 2012-07-03 13:36:11 UTC 
It's not a bug, it's a feature ;-)

If you use a range reference with an operator that expects a scalar value a position dependent single reference (intersection) is calculated. For your example the ...-C3:G3 in column C results in C3, in column D it would result in D3, but in column B there is no intersection of column B and the range C3:G3, hence the error.