https://bugs.documentfoundation.org/show_bug.cgi?id=148500
Bug ID: 148500
Summary: CALC Paste Special of part of a frequency array
interpreted incorrectly
Product: LibreOffice
Version: 7.2.6.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: that.man.co...@gmail.com
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
--
You are receiving this mail because:
You are the assignee for the bug.
