Download it now!
Bug 104309 - Scrollbar form element is lost entirely when saving as xlsx
Summary: Scrollbar form element is lost entirely when saving as xlsx
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss, filter:xlsx
: 125598 (view as bug list)
Depends on:
Blocks: Form-Controls XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2016-12-01 03:02 UTC by stragu
Modified: 2020-10-15 13:33 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
original testing spreadsheet (7.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-12-01 03:04 UTC, stragu
Details

Note You need to log in before you can comment on or make changes to this bug.
Description stragu 2016-12-01 03:02:55 UTC
Description:
Scrollbar (aka slider) created via the "Form Controls" toolbar disappears after saving as xlsx and opening again, and scrollbar max value is lost when saving as xls.

Not sure if this is a FILESAVE or FILEOPEN issue.

Steps to Reproduce:
1. Open the "Form Controls" toolbar: View > Toolbars > Form Controls;
2. Activate "design mode";
3. Create a scrollbar by clicking the "Scrollbar" button and defining an area, leaving the defaults (which include a max scroll value of 100);
4. Define a linked cell in "Control Properties > Data".
5. Toggle design mode and test the slider.
6. Save as ods, xlsx and xls.

Actual Results:  
- ODS opens and behaves normally.
- XLSX opens but the scrollbar has vanished and the cell value is the last one that was set by the scrollbar before saving.
- XLS opens but the scrollbar max value changed to 0, and if changed back to 100 manually, the value only goes up to max scroll value -1 (i.e. 99 in this case).

Expected Results:
Scrollbar should behave as initially set up, in all three formats.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Comment 1 stragu 2016-12-01 03:04:54 UTC
Created attachment 129176 [details]
original testing spreadsheet

original document after following described steps, before saving into different formats
Comment 2 stragu 2016-12-01 03:05:28 UTC
https://bugs.documentfoundation.org/show_bug.cgi?id=76567 is very much related but is slightly different in its behaviour.
Comment 3 Buovjaga 2016-12-03 19:59:06 UTC
Your XLS issue is bug 101109.

I confirm the XLSX issue.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: 8a238809ba861c810304354f01a5504d43111399
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on December 2nd 2016

Arch Linux 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 4 QA Administrators 2019-02-20 03:47:43 UTC Comment hidden (obsolete)
Comment 5 stragu 2019-02-22 05:10:18 UTC
I confirm the behaviour exactly as described in original report, tested with:

Version: 6.1.5.2
Build ID: 1:6.1.5~rc2-0ubuntu0.18.04.1~lo3
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); Calc: group threaded
Comment 6 raal 2019-06-14 04:06:56 UTC
Please retest. See bug 125598 -  scrollbar is not missing, but doesn't works in excel
Comment 7 stragu 2019-06-16 04:52:29 UTC
Hi Raal

I can still confirm the same behaviour in both 6.2 and 6.3:

Version: 6.2.4.2
Build ID: 1:6.2.4-0ubuntu0.18.04.1~lo1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-GB
Calc: threaded

Version: 6.3.0.0.alpha1
Build ID: 547edd20e527fb02900f6174973770d26306e2e7
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded

Interestingly, the toolbars in 6.3 don't show "Spin Button" or "Scrollbar" anymore. (Which means you have to use the "Insert > Form Control" dropdown menu to add them.)
Comment 8 stragu 2019-07-11 13:14:09 UTC
I can confirm the srollbar disappearing when reopening the XLSX file, with:

Version: 6.3.0.1
Build ID: 41ac97386aba908b6db860cfb4cfe2da871886ae
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded

The issue with 2 the missing buttons I mentioned in the previous comment was reported in Bug 125947 and is already fixed.
Comment 9 stragu 2019-10-22 14:11:19 UTC
Confirmed scrollbar disappearing when saving to XLSX, with:

Version: 6.4.0.0.alpha1
Build ID: cc57df8f942f239d29cb575ea5a7cb01405db787
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded
Comment 10 NISZ LibreOffice Team 2020-06-15 11:52:44 UTC
*** Bug 125598 has been marked as a duplicate of this bug. ***
Comment 11 stragu 2020-10-15 13:33:49 UTC
Reproducible as described in

Version: 7.0.2.2
Build ID: 00(Build:2)
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.2_rc2-0ubuntu0.18.04.2
Calc: threaded