[Libreoffice-bugs] [Bug 48183] FILEOPEN: scrollbar form control inactive when saved as xls

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48183

stragu  changed:

   What|Removed |Added

 Resolution|--- |WORKSFORME
 Status|NEW |RESOLVED

--- Comment #13 from stragu  ---
I could reproduce with:

Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: default; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: threaded

But not with:

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 67f2a99229101757af4f40118f4d3c83ba38648b
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: threaded

So the issue was fixed somewhere in between LO 7.0.6 release and now (or
previously, but didn't make it into the 7.0 branch).

The remaining issue is that the scrollbar only can change the value to a
maximum of "max value - 1" (i.e. 99 if the max value is 100).

Marking this bug as RESOLVED - WORKSFORME.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48183] FILEOPEN: scrollbar form control inactive when saved as xls

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48183

--- Comment #12 from stragu  ---
Confirmed as described in comment 9, 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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48183] FILEOPEN: scrollbar form control inactive when saved as xls

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48183

--- Comment #11 from stragu  ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48183] FILEOPEN: scrollbar form control inactive when saved as xls

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48183

--- Comment #10 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48183] FILEOPEN: scrollbar form control inactive when saved as xls

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48183

Aron Budea  changed:

   What|Removed |Added

 CC||ba...@caesar.elte.hu
 Blocks||109072


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109072
[Bug 109072] [META] XLS (binary) format bug tracker
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48183] FILEOPEN: scrollbar form control inactive when saved as xls

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48183

--- Comment #9 from stragu  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48183] FILEOPEN: scrollbar form control inactive when saved as xls

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48183

Buovjaga  changed:

   What|Removed |Added

   Keywords||filter:xls
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||4309

--- Comment #8 from Buovjaga  ---
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: ..."

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48183] FILEOPEN: scrollbar form control inactive when saved as xls

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48183

Buovjaga  changed:

   What|Removed |Added

 CC||em...@christian-fries.de

--- Comment #7 from Buovjaga  ---
*** Bug 101109 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs