Bug 92846 - In calculation: 1 times 0 would result in 1
Summary: In calculation: 1 times 0 would result in 1
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.8.2 release
Hardware: All Windows (All)
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-07-20 18:42 UTC by suzumoshi
Modified: 2015-07-20 21:32 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Error calculating (16.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-07-20 18:42 UTC, suzumoshi 		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 suzumoshi 2015-07-20 18:42:02 UTC 
Created attachment 117347 [details]
Error calculating

Calculating in K3=B3*j3 (B3=1; J3=1) gives 1
Calculating in K4=B4*J4 (B4=0; J4=1) gives 1
Comment 1 m_a_riosv 2015-07-20 21:32:01 UTC 
Hi @suzumosh, thanks for reporting.

The file has the Menu/Tools/Cell contenss/Autocalculate off, activating it or doing a hard recalc [Ctrl+Shift+F9] solves the issue.

As 4.2.8 is end of live no more patches for it.

In any case works fine 4.4.4.3, so resolved as worksforme, please if you are not agree reopen it.