Bug 58258

Summary: When hiding selected colums it hides the whole sheet
Product: LibreOffice Reporter: ponchorat1968
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: trivial    
Priority: medium CC: ponchorat1968
Version: 3.6.0.2 rc   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: Spreadsheet in which the error can be done.

Description ponchorat1968 2012-12-13 19:49:03 UTC
Created attachment 71460 [details]
Spreadsheet in which the error can be done.

Please advise if selected correct version in version option, I am using Version 3.6.0.2 (Build ID: 360m1(Build:102)) and updated using Ubuntu Software Centre and not an off-site build. Please advise where I can get an up-to-date .DEB version.
--------------------------------------------------------------------------------
I have created a finance spreadsheet which has a month per page/tab and is laid out daily so that you can see whats going in and out on a daily basis.
The problem I am having is, I don’t want the cells I’m not using to be displayed so I delete them.
Heres the steps I use to do that;
1 CTRL & A
2 Goto Column ‘A’, hold CTRL & click in the header of column ‘A’
3 Goto Column ‘AF’ & hold CTRL & SHIFT & click in the header of column ‘AF’ (The last column of one particular month)
4 Right click header of column ‘AG’ (The column after the last day of the month)
5 Select ‘Hide’ from the drop down menu

All that should happen here is the selected columns from ‘AG’ should disappear but ALL the cells disappear.
To get them back;

6 CTRL & Z

I then have to perform step 5 AGAIN for it to work properly this time.
It does NOT do this when hiding ROWS.

I have included a copy of the spreadsheet without any details filled in but the cells have their correct format, i.e. text and currency, as I am in England, it’s in UK £
Comment 1 john.pratt 2012-12-21 16:33:48 UTC
Comment on attachment 71460 [details]
Spreadsheet in which the error can be done.

correct mime type
Comment 2 john.pratt 2012-12-21 16:47:33 UTC
Reproduced using 4.0 beta 2 on windows XP.
Works exactly as ponchorat1968@hotmail.com describes.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.