Bug 107982 - In excel file if a cell is summed into a column and this cell refers to another sheet in the same workbook, it doesn total in sum.
Summary: In excel file if a cell is summed into a column and this cell refers to anoth...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
5.3.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-21 02:30 UTC by Arun Bhatia
Modified: 2017-05-21 12:35 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
excel file sum is coming wrong (21.17 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-05-21 02:30 UTC, Arun Bhatia 		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 Arun Bhatia 2017-05-21 02:30:07 UTC 
Created attachment 133427 [details]
excel file sum is coming wrong

Version: 5.3.3.2
Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; Layout Engine: new; 
Locale: en-US (en_US); Calc: group

In excel file if a cell is summed into a column and this cell refers to another sheet in the same workbook, it doesnt total in sum.
Comment 1 Jacques Guilleron 2017-05-21 12:35:07 UTC 
Hi Arun,

Select Drivers.O1 and Data menu > Calculate > Recalculate.
I didn't verify elsewhere, but H1 and J1 have to be recalculated too.

Due to Tools > Options > LibreOffice Calc > Formula
Recalculation on file Load
Excel 2007 and newer 
set to 
Never recalculate

Setting Recalculation on File Load on
Prompt user 
will let you choose.