Bug 58258 - When hiding selected colums it hides the whole sheet
Summary: When hiding selected colums it hides the whole sheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.6.0.2 rc
Hardware: x86-64 (AMD64) Linux (All)
: medium trivial
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-12-13 19:49 UTC by ponchorat1968
Modified: 2013-12-15 22:00 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
Spreadsheet in which the error can be done. (30.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-12-13 19:49 UTC, ponchorat1968
Details

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.