[Libreoffice-bugs] [Bug 137774] New: Calc - Copy Hidden Cells fails when Column is hidden by column context menu

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137774

            Bug ID: 137774
           Summary: Calc - Copy Hidden Cells fails when Column is hidden
                    by column context menu
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Description:
According to the help facility  
file:///C:/Program%20Files/LibreOffice/help/en-GB/text/scalc/guide/cellcopy.html?DbPAR=CALC#bm_id3150440

viz
Cells were hidden using the Hide command in the context menu of the row or
column headers, or through an outline.
Copy, delete, move, or format a selection of currently visible cells.
All cells of the selection, including the hidden cells, are copied, deleted,
moved, or formatted.

However, drag to copy and increment a matrix including the hidden cells/column
fails to copy the hidden cells.

Also, if the missing value is inserted after the column has been exposed and
then a number of rows are hidden and the original column re-hidden then the
incrementation continues sequentially from the complete rows AFTER the hidden
rows without incrementation for the hidden cells 

Steps to Reproduce:
insert the number 1 into C3
Select and drag to fill four cells upto and including F3
Create formula SUM(C3:F3) in cell G3
Note the result is 10
Select and Hide column D utilising the context menu
Select the range C3:G3
Drag to fill the matrix C4:G7
Note the results in Column G
Select Columns C>E and unhide from the column context menu

Note the missing values for the previously hidden cells D4>D7
Note Also the columnar increment allows for the hidden cells D4>D7

Now add the missing value "6" to D7
Hide rows 8>11 and column D
Select the C3:G3 matrix again and drag to increment C13:G15
Unhide all rows and columns
Note the missing row increments and also that the missing rows are not
incrementally adjusted by +5 at row 12 but by +1
Significant contradiction in the incrementation methodology between missing
rows and columns


Actual Results:
Test 1: The contents of Cells D4>D7 are blank and the subsequent columns are
incremented as though the blank cells had correctly incremented

Test 2: The contents of rows 8>11 are blank and the incrementation continues
from row 12 but unincremented for the hidden rows

Expected Results:
Test 1: D4>D7 should have incremented to 6

Test 2: Rows 8>11 should have incremented with rows 12>15 also incremented from
row 11 results

Workaround - Select the column and set the width to an "invisible" value
perhaps 0.01cm


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.4.6.2 (x64)
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: default; VCL: win; 
Locale: sv-SE (en_GB); UI-Language: en-GB
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201026/bb5d185e/attachment-0001.htm>