Summary: | Scrollbar or Spin Button form element is lost entirely when saving as xlsx | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Stéphane Guillou (stragu) <stephane.guillou> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | dav1dblunk3tt, ilmari.lauhakangas, libreoffice, raal, stephane.guillou |
Priority: | medium | Keywords: | dataLoss, filter:xlsx |
Version: | Inherited From OOo | ||
Hardware: | x86-64 (AMD64) | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=76567 https://bugs.documentfoundation.org/show_bug.cgi?id=48183 https://bugs.documentfoundation.org/show_bug.cgi?id=143328 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 107742, 133999 | ||
Attachments: | original testing spreadsheet |
Description
Stéphane Guillou (stragu)
2016-12-01 03:02:55 UTC
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. *** |