Bug 57478 - UI: FILEOPEN LibOCreated.xls with grouped columns shows "collapse '-'" instead "expand'+'" above collapsed columns
Summary: UI: FILEOPEN LibOCreated.xls with grouped columns shows "collapse '-'" instea...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLS Group&Outline
  Show dependency treegraph
 
Reported: 2012-11-24 07:54 UTC by Rainer Bielefeld Retired
Modified: 2018-10-02 08:43 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2012-11-24 07:54:43 UTC
This one is a spin off of "Bug 51524 - [Fileopen] [XLS] cell-width of invisible cells are not remembered", where this problem has been reported additionally to an other problem.

Because it's not clear how sample document of Bug 51524 has been created you also can use Attachment 70503 [details] of Bug 57477, what has been created as Excel8 document with Excel 2010, and create your own .xls from LibO following steps 1-4 of Bug 57477.

[Reproducible] with "LibreOffice Portable 3.3.0  - WIN7  Home Premium (64bit) German UI [OOO330m19 (Build:6) tag libreoffice-3.3.0.4]":

0. download Attachment 63569 [details] of a.m. Bug, what seems to 
1. Open sample document from LibO start center
   Expected: above column Heading 'D' you should see a small '+' button
             to expand the 2 hidden columns
   Actual: you see a small '-' button to collapse columns, but they are already
           collapsed
2. Click '-'
   As expected, nothing happens with columns, columns are already collapsed.
   But button changes to '+', Clicking it will expand the 3 columns, 
   clicking the now visible '-' will hide columns a-C and so on

So it looks as if there simply would be a FILEOPEN - UI problem, but I did an additional test, what might be interesting for deeper understanding of this bug, but are not necessary 

11. Open a.m. Sample document with MS Excel 2010
    > A correct '+' button will be shown above 
12. Expand Columns A-C and collapse again
13. Save as "document2010.xls", exit
14. Redo step 1
    As expected: above column Heading 'D' you see a small '+' button
                 to expand the 3 hidden columns
   
So there might be a LibO Filesave problem? I submitted a separate "Bug 57477 - FILESAVE as .xls with wrong info concerning collapsed grouped columns" for that.

NEW due to results on <discuss@de.libreoffice.org>
 <http://listarchives.libreoffice.org/de/discuss/msg12890.html>

Same problem with OOo 3.1.1, so inherited from OOo.

Still  [Reproducible] with parallel installation of  "LOdev  4.0.0.0.alpha0+   -  ENGLISH UI / German Locale  [Build ID: a2b3ee)]"  {2012-11-22} on German WIN7 Home Premium (64bit) with separate /4 User Profile for 4.0

@Spreadsheet Team
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf (and remove others in team from CC).
Comment 1 Buovjaga 2014-11-07 09:20:26 UTC
Still reproduced.

I opened attachment 70503 [details] and did these steps:

0. download sample document
1. Open document from LibO Start center
   > You see a small '+' button above column heading D
2. Expand / collapse Columns A...C by clikcing the small + / - button above
   column heading 
3. Click Cell N+, type a blank and <Return>
4. Save as "document2010LibO333.xls" (MSO97)
5. close document 
6. Reopen

and this happened:

you see a small '-' button to collapse columns, but they are already
           collapsed
Click '-'
   As expected, nothing happens with columns, columns are already collapsed.
   But button changes to '+', Clicking it will expand the 3 columns, 
   clicking the now visible '-' will hide columns a-C and so on

Win 7 64-bit Version: 4.4.0.0.alpha1+
Build ID: 8b21b5cbe78945b27525b4ce78ae3d981f90590f
TinderBox: Win-x86@39, Branch:master, Time: 2014-11-06_03:55:51
Comment 2 QA Administrators 2015-12-20 16:12:52 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2017-01-03 19:48:17 UTC Comment hidden (obsolete)
Comment 4 Zineta 2018-10-02 08:43:09 UTC
Can still reproduce in:
Version: 6.2.0.0.alpha0+ (x64)
Build ID: 8b1501d80dc9d3f42c351c6e026fa737e116cae5
CPU threads: 2; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-09-22_23:19:22
Locale: bs-BA (bs_BA); Calc: threaded
OS:Win 7