Bug 90439 - EDITING : Unhide of first column is impossible by mouse
Summary: EDITING : Unhide of first column is impossible by mouse
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Cell-Management
  Show dependency treegraph
Reported: 2015-04-03 17:53 UTC by Laurent Lyaudet
Modified: 2024-04-28 18:58 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Sample xlsx to reproduce the bug (363.26 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-04-03 17:53 UTC, Laurent Lyaudet

Note You need to log in before you can comment on or make changes to this bug.
Description Laurent Lyaudet 2015-04-03 17:53:57 UTC
Created attachment 114589 [details]
Sample xlsx to reproduce the bug


I noted a regression with Calc in on Windows 7.
I cannot unhide the first column of an xlsx file (attached to this bug report) by dragging to the right the column separator line left to column B header.
The first column separator line is not draggable anymore.
However the column separator line between column G and column J is draggable and it permits to unhide the columns H and I as usual.

Best regards,
   Laurent Lyaudet
Comment 1 m_a_riosv 2015-04-03 18:42:09 UTC
Hi Laurent, thanks for reporting.

Version: Build ID: c4c7d32d0d49397cad38d62472b0bc8acff48dd6

Going to A1 in the address box makes the column draggable again.
Comment 2 Matthew Francis 2015-04-04 08:37:49 UTC
Reproduced on Linux and OSX with LO - so not our regression as far as I can tell, but inherited from OOo
Comment 3 tommy27 2016-04-16 07:25:36 UTC Comment hidden (obsolete)
Comment 4 Laurent Lyaudet 2016-04-23 08:09:04 UTC

I reproduced the bug with Libre Office 5.1.2 on Windows 10.

Best regards,
   Laurent Lyaudet
Comment 5 QA Administrators 2017-05-22 13:27:18 UTC Comment hidden (obsolete)
Comment 6 m_a_riosv 2017-05-22 22:54:03 UTC
Version: (x64)
Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new; 
Locale: es-ES (es_ES); Calc: group
Comment 7 QA Administrators 2018-05-23 02:37:45 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2022-04-27 04:01:54 UTC Comment hidden (obsolete)
Comment 9 Laurent Lyaudet 2022-04-28 21:42:06 UTC
The bug is still here :
Version: / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 12; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu package version: 1:7.3.2-0ubuntu2
Calc: threaded
Comment 10 QA Administrators 2024-04-28 03:16:19 UTC Comment hidden (obsolete)
Comment 11 Laurent Lyaudet 2024-04-28 16:20:56 UTC

The bug is still here:
Version: (X86_64) / LibreOffice Community
Build ID: 60(Build:2)
CPU threads: 12; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu package version: 4:7.6.5-0ubuntu0.23.10.1
Calc: threaded

I don't understand why it is not corrected yet.
It has been more than 9 years, since I encountered this bug at work.
Moreover, I gave an xlsx file cleaned of business data from my work in 2015.
So this is just a "simple debug task" since it is always reproduced.
I would have hoped that someone with skills in xlsx parsing in LibreOffice would have solved and closed this ticket.
It would avoid to lose time every two years on this.

Best regards,
    Laurent Lyaudet
Comment 12 ady 2024-04-28 18:58:10 UTC
This seems to be some visual issue with the specific file, attachment 114589 [details].


1. Open attachment 114589 [details].

2. Move the mouse to the left-side of the Column C _header_, in order to display the double arrow that allows you to grab the right-side of Column B and modify its width. This can be accomplished.

3. Try the same as in step 2 but pointing to the left-side of the header of Column B, attempting to display the double arrow that would allow to grab the right side of (the hidden) Column A and modify its width.

The double arrow is not displayed. > This is the original report.

4. Scroll the whole worksheet sideways, at least so Column B disappears (to the left) and Column C is seen as the first column on the left side of the main area. Scroll back to the original position, so Column B is seen again on the main area. This is the leftmost position; Column A is still set as "hidden".

5. Repeat step 3. This time the double arrow shows up, and the width of Column A can be modified.

* This proves that this is a visual problem, on this file. IDK how to replicate this problem with a new empty file.

* Instead of scrolling sideways (step 4), using the name/address box to focus on A1 as in comment 1 works too as a workaround of the visual issue.

* Please note that modifying the width of a column is not exactly the same as un-hiding it. It might be a subtle difference with no consequence for this particular (visual) issue, but I wanted to mention it anyway.