https://bugs.freedesktop.org/show_bug.cgi?id=66223
--- Comment #6 from Laurent Lyaudet <[email protected]> --- Hi, Sorry for the late answer. I've been busy yesterday evening and today until now. I did a few experiments yesterday morning with the original xlsx and the situation is more complicated than what I tought. I'll keep using the two points 1) and 2) of the preceding commentaries, 3) for a new possible feature request and 4) for the possible feature request I talked about last time. 1)There is no split in the original xlsx (none that appears when I open it with Version 4.0.4.2 (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2) on Windows 7) But there is a freeze. If I empty the xlsx and save it, there is still a freeze but no split. I see two possibilities : a) either when opening the xlsx with Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3), a split is imported instead of a freeze. In that case, the split is then saved after emptying the xlsx. b) or when emptying the xlsx, the freeze is changed into a split and then saved. Since the display bug did appear only after emptying the xlsx, either the split becomes buggy after emptying (a), or it is created buggy (b). I'm unable to create a buggy split by hand in the xlsx. It seems that the buggy split could be created in 4.0.2 but doesn't create in 4.0.4. The buggy split, once present, is buggy in 4.0.2, 4.0.4, 3.5.7. I'll add two xlsx attachments to the bug : - One I created by removing the freeze then emptying. - One I created by emptying but keeping the freeze. These two attachments are useful also for the next point. 2)I felt quite dumb for not seeing that I could unhide column A, but my experiments yesterday gave me hope, since I had no hope to unhide this column ;) In fact, you can't unhide column A in the original xlsx. The two attachments obtained by emptying the original xlsx with 4.0.4 have the same property. I do believe this is somehow linked with the split issue and I smell a nasty bug. Note that you can unhide the other columns. Only A seems to be special. A few more elements on that : - the left limit of B is not bold as it should. - it is not draggable - the other methods you mention do not work. - if you click on the X zone X|B|C - 1| - 2| and right click unhide on B, all columns are unhided except A. This last method to unhide all columns could be improved because you can't right click X : you have to click X then right click B or another column. I know why it is that way, since right clicking 1 instead of B would unhide rows instead of columns. But I suggest : 3) Split the X zone in 3 parts like this __ | /| |/\| and make all three zones clickable and right clickable: - right part selects all columns and make it possible to apply actions (from contextual menu or other actions) to all columns - lower part selects all rows and make it possible to apply actions (from contextual menu or other actions) to all rows - upper left part selects all columns and rows and make it possible to apply actions (from contextual menu or other actions) to all columns and all rows 4)Regarding my previous possible feature request and the alternatives: - Selecting cell/range with Menu/Format/Column - Hide/Show. - Selecting column(s) before+after the hidden column(s), right-clik Show, or Menu/Format/Column - Show. Both alternatives unhide all columns between G and J. You can also right click the limit between G and J and choose unhide but this alternative has the same problem of pixel precision than the actual dragging and doesn't permit to unhide H before I. I think that the possibility to hide/unhide while preserving the width of the columns is not incompatible with a more continuous feature of unhiding (since the continuous feature of hiding already works). In fact because of the limitations of all the existing methods, there could be two things in the "popup" : - handles for the continuous feature and - buttons for unhiding with the original width I'll try to give an idea of the popup : - two layers : upper layer is for buttons (rectangular), lower layer is for handles (ellipsoids) _ _ |H| |I| _ _ (H) (I) \ / (on this line I tried to represent some branch from the ellipsoids to the limit) Best regards, Laurent -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
