<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc - Copy Hidden Cells fails when Column is hidden by column context menu"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137774">137774</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc - Copy Hidden Cells fails when Column is hidden by column context menu
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>that.man.colin@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>