Bug 48183 - FILEOPEN: scrollbar form control inactive when saved as xls
Summary: FILEOPEN: scrollbar form control inactive when saved as xls
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: filter:xls
: 101109 (view as bug list)
Depends on:
Blocks: Form-Controls XLS
  Show dependency treegraph
 
Reported: 2012-04-02 03:33 UTC by Dan
Modified: 2019-04-29 08:10 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
test case for control anchoring (8.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-06-28 23:28 UTC, sasha.libreoffice
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dan 2012-04-02 03:33:05 UTC
Problem description: 
Xls files do not preserve the properties of control(s).

Steps to reproduce:
1. Create a new spreadsheet document.
2. From toolbar "Form Controls" create a new Scrollbar.
3. Set "Linked cell" proprieties to "A1".
4. First, save the document with .ods extension.
5. After, save the document with .xls extension.
6. Close the document.

Expected behavior:
When i open '.xls' document, the "Scrollbar" control is INACTIV.
In the '.ods' document, the "Scrollbar" control works normally.


Platform : Windows XP
              
Browser: Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20100101 Firefox/11.0
Comment 1 sasha.libreoffice 2012-06-28 23:23:51 UTC
Thanks for bugreport
reproduced in 3.5.4 on Fedora 64 bit
Fileopen problem. Calc saves this property into xls correctly, as I can see in msExcel 2007.
Possible duplicate of Bug 48123
Comment 2 sasha.libreoffice 2012-06-28 23:28:37 UTC
Created attachment 63586 [details]
test case for control anchoring
Comment 3 Teo91 2013-09-30 13:14:38 UTC
I can confirm this with LO 4.1.1 on Windows 7 SP1: after the .ods conversion the Scroolbar control doesn't work.
Comment 4 QA Administrators 2015-04-01 14:41:38 UTC Comment hidden (obsolete)
Comment 5 Buovjaga 2015-04-23 18:52:37 UTC
Reproduced with attachment 63586 [details]

Win 7 Pro 64-bit Version: 5.0.0.0.alpha1+ (x64)
Build ID: f3375fa07f27bd2ade519af3c07d69040d10eaa9
TinderBox: Win-x86_64@42, Branch:master, Time: 2015-04-22_23:38:50
Locale: fi_FI

Ubuntu 14.10 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 6 QA Administrators 2016-09-20 09:32:09 UTC Comment hidden (obsolete)
Comment 7 Buovjaga 2018-02-19 15:20:44 UTC
*** Bug 101109 has been marked as a duplicate of this bug. ***
Comment 8 Buovjaga 2018-02-19 15:25:19 UTC
I got suspicious about the feature being supported by .xls, but apparently it is an old one: https://support.microsoft.com/en-gb/help/291073/how-to-use-the-forms-controls-on-a-worksheet-in-excel "Applies to: ..."
Comment 9 stragu 2018-02-20 04:06:07 UTC
Confirmed with the following:

Version: 5.4.5.1
Build ID: 79c9829dd5d8054ec39a82dc51cd9eff340dbee8
CPU threads: 2; OS: Linux 3.13; UI render: default; VCL: kde4; 
Locale: en-GB (en_GB.UTF-8); Calc: group

Updated steps to reproduce:

Steps to reproduce:
1. Create a new spreadsheet document.
2. Create a new scrollbar with top menu item "Insert > Form Control > Scrollbar" and define an area with the pointer for the scrollbar to be rendered.
3. Set A1 as the "Linked cell" (right click on scrollbar, click on "Control", select the "Data" tab).
4. First, save the document with .ods extension.
5. After, save the document with .xls extension.
6. Close the document.

The scrollbar in the ODS file can control the value contained in A1, but the scrollbar in the XLS file is greyed out and not selectable.
It is however possible to open the form control toolbar (in top menu: "View > Toolbars > Form Controls"), activate the "Design Mode" and change the current "Control" values (Scroll value max = 0) back to the default values (Scroll value max = 100) and make the scrollbar operational again.

The issue seems to be that the "Scroll max value" of the form control is set to "0" at fileopen.

The modified "Scroll max value" is the issue specifically described in duplicate bug 101109.
Comment 10 QA Administrators 2019-04-26 02:57:22 UTC Comment hidden (obsolete)
Comment 11 stragu 2019-04-29 08:10:12 UTC
Confirmed as per comment 9 with: 

Version: 6.2.2.2
Build ID: 1:6.2.2-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-US
Calc: threaded