Bug 121576 - Pulling a Sum function does not copy well
Summary: Pulling a Sum function does not copy well
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-11-21 10:27 UTC by Adam Niedling
Modified: 2018-11-21 12:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example spreadsheet (21.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-11-21 10:28 UTC, Adam Niedling 		Details
Example video (5.50 MB, video/ogg)
2018-11-21 10:43 UTC, Adam Niedling 		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 Adam Niedling 2018-11-21 10:27:33 UTC 
Description:
Take a look at the attached video. The example .ods is also attached.

Steps to Reproduce:
1. Enter a Sum function to get the Sum of a row or column.
2. Pull it down or to the right.
3.

Actual Results:
When I pull it down there will be no Sums in the other cells.
When I pull it to the right the same Sum will be copied to the other cells.

Expected Results:
The sums should be calculated for the other rows/columns.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Adam Niedling 2018-11-21 10:28:43 UTC 
Created attachment 146860 [details]
Example spreadsheet
Comment 2 Adam Niedling 2018-11-21 10:43:07 UTC 
Created attachment 146861 [details]
Example video
Comment 3 Mike Kaganski 2018-11-21 10:58:09 UTC 
You have disabled auto-recalculation for the spreadsheet (Data→Calculate→AutoCalculate). In this case, when you copy across columns, the calculated value is copied along; when you copy across rows, the stored value is not retained (this has something to do with Calc internal units being columns, not rows). But recalculation for the new places does not happen in all cases.

Recalculate manually (F9), or enable AutpCalculation.

Closing NOTABUG. Please feel free to put back to UNCONFIRMED if you believe it's incorrect; please don'r forget to comment why you think so.
Comment 4 Adam Niedling 2018-11-21 11:39:41 UTC 
Sorry about this. Is it possible that AutoCalculate got turned off by itself during a crash/recovery?
Comment 5 Mike Kaganski 2018-11-21 12:08:47 UTC 
(In reply to Adam Niedling from comment #4)

Well - possibly. In the end, that was a crash = unexpected and wrong behavior...