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
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
Created attachment 63586 [details] test case for control anchoring
I can confirm this with LO 4.1.1 on Windows 7 SP1: after the .ods conversion the Scroolbar control doesn't work.
** 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 on a currently supported version of LibreOffice (4.4.1 or later) https://www.libreoffice.org/download/ *If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior *If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-04-01
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
** 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 on a currently supported version of LibreOffice (5.1.5 or 5.2.1 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20160920
*** Bug 101109 has been marked as a duplicate of this bug. ***
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: ..."
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.
** 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
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
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
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.