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
Created attachment 129176 [details] original testing spreadsheet original document after following described steps, before saving into different formats
https://bugs.documentfoundation.org/show_bug.cgi?id=76567 is very much related but is slightly different in its behaviour.
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
** 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
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
Please retest. See bug 125598 - scrollbar is not missing, but doesn't works in excel
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.)
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.
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
*** Bug 125598 has been marked as a duplicate of this bug. ***
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
Main issue with XLSX reproduced with: Version: 7.1.0.3 / LibreOffice Community Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Issue with XLS is only that the maximum value the slider can give the cell is Scroll value max - 1. (In our example, 99) Note that the XLSX issue is the same for a Spin Button.
Reproduced on Windows 10 as well, just as describe in Comment 12. 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
*** Bug 154185 has been marked as a duplicate of this bug. ***