Obviously a pita but I need to create a form in calc that is shared with excel users and it needs to have a scroll bar.
If I save a scrollbar in LO and reload it:
- .xls format: the scrollbar is there but the min and max values are 0,0 so it doesn't scroll. If I put them back to 0,100 and save/reload it is back to 0,0.
- .xlsx format: the scrollbar is simply missing.
Steps to Reproduce:
Create a spreadsheet with a scroll bar save as .xls or .xlsx, reload and the scrollbar is broken or absent
.xls :scrollbar is present but has incorrect range
.xlsx: scrollbar is absernt
scrollbar should be there and working
User Profile Reset: No
[Information automatically included from LibreOffice]
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
FWIW it seems to work ok in writer fr both doc and docx
Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug.
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
Created attachment 151795 [details]
slider in ODS format - works
Created attachment 151796 [details]
slider in XLS format - range incorrect
Created attachment 151797 [details]
slider in XLSX format, slider missing
Created attachment 151799 [details]
screen shot .ods format
Created attachment 151800 [details]
screenshot .xls format
Created attachment 151801 [details]
screenshot .xlsx format
Confirm with Version: 18.104.22.168.beta1+
Build ID: 4904391e125eb66304a5c029def8d4c1a150952d
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
in 4.1 is slider completely missing in LO. In 6.3 the slider is visible in LO, but in excel2010 error message "Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded" and slider is removed upon open.
save as xlsx
I can confirm that if a slider is placed in excel and saved then LO can load it correctly. So it appears to be a LO filesave issue.