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
Created attachment 179443 [details] Simple Sample CALC
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 ***