Bug 148500

Summary: CALC Paste Special of part of a frequency array interpreted incorrectly
Product: LibreOffice Reporter: Colin <that.man.colin>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 7.2.6.2 release   
Hardware: All   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Simple Sample CALC

Description Colin 2022-04-10 18:01:17 UTC 
Description:
If only a portion of the results from a FREQUENCY() formula is selected and copied and subsequently pasted special - values only - to a new location, then the results differ depending upon prior copy/paste operations.

Steps to Reproduce:
Utilising the attached sheet
A3:A101 is the source data
C3:C17 are the classes
D3:D18 are the results
NOTE: I only selected the classes range C3:C17 but CALC automagically creates the array formula in the range D3:D18 - is this intended or an error?
1 Select C3:C17
2 Copy & Paste to H3
3 Observe the results
4 Clear the results
5 Select D3:D17 NOT D18
6 Copy and Paste SPECIAL values only to I3
7 Observe the results
8 Clear the results
9 Repeat 1 - 4
10 Select C3:D17 NOT D18
11 Copy & Paste SPECIAL values only to H3
12 Observe the results
13 Clear the results
14 Select D1
15 Copy & Paste SPECIAL values only to H1
16 Observe the results
17 Select C3:D17 NOT D18
18 Copy & Paste SPECIAL values only to H3
19 Observe


Actual Results:
Incorrect copy depending upon the previous success unit

Expected Results:
Consistent copy of selected data


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.2.6.2 (x64) / LibreOffice Community
Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
Comment 1 Colin 2022-04-10 18:01:56 UTC 
Created attachment 179443 [details]
Simple Sample CALC
Comment 2 m_a_riosv 2022-04-10 20:02:39 UTC 
You can't copy only part of an array.
So the previous copy it's in the clipboard

*** This bug has been marked as a duplicate of bug 146972 ***