Bug 76567 - Compatibility problem with an Excel file with scrollbar
Summary: Compatibility problem with an Excel file with scrollbar
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
3.4.6 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Scrollbars XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2014-03-24 19:00 UTC by flo_gain
Modified: 2023-07-30 03:16 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Excel test file (9.60 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-03-24 19:00 UTC, flo_gain
Details
File in version office2003 (24.50 KB, application/vnd.ms-excel)
2019-07-02 13:55 UTC, flo_gain
Details

Note You need to log in before you can comment on or make changes to this bug.
Description flo_gain 2014-03-24 19:00:34 UTC
Created attachment 96312 [details]
Excel test file

this is a problem of portability of an Excel file to libreoffice Calc. 
I use my home to an Excel 2007 on a 64bit W7 
and work there libreoffice V 4.1.5.3 on XP SP3 

In the Excel 2007 file, a scrollbar changes the cell value from 0 to 20 by increments of 5. 

I open the excel file with libreoffice calc

1)If I save the file as xlsx and opens with libreoffice calc I'm fine from 0 to 15 in increments of 5, but the next value is 16!? 

2)If I save the file in xls format and opens with libreoffice calc I'm fine from 0 to 15 in increments of 5, but the next value is 19!? 

in both cases when I open the settings window scrollbar in libreoffice Calc I have min = 0 and max = 20 but it is not the value available in the linked cell.


Use scrollbar in calc works very well, the problem is to open an Excel file containing scrollbar. I tried several different settings but the last value is never okay.

many people encounter the same bug, French discussion here: 

http://nabble.documentfoundation.org/Probleme-d-importation-d-un-fichier-excel-avec-des-curseurs-tc4102254.html#a4102832


thank you for your interest in this bug
frédéric
Comment 1 pierre-yves samyn 2014-03-25 11:11:43 UTC
Hello

I reproduce on windows 7/64 and XP with Version: 4.2.3.1
Build ID: 3d4fc3d9dbf8f4c0aeb61498a81f91c5b7922f13

Set status to New

Regards
Pierre-Yves
Comment 2 Win 2014-12-12 09:54:03 UTC
Scroll Bar control does not reach the maximum value set, already open in Excel, works perfect

Excel 2013 x LibreOffice 4.3.4.1
Comment 3 Pierre C 2015-01-29 21:26:58 UTC
The problem is still present with LO 4.3.6.2
Comment 4 Pierre C 2015-01-29 21:31:17 UTC
The problem is also present with AOO 4.1.1 and LO 3.4.6
Comment 5 QA Administrators 2016-02-21 08:37:17 UTC Comment hidden (obsolete)
Comment 6 flo_gain 2016-02-21 20:45:49 UTC
Hello
The bug is still present with LO 5.0.5 with Windows7 64bit
Fred
Comment 7 Stéphane Guillou (stragu) 2016-12-01 02:45:46 UTC
Confirmed with LO 5.2.3~rc2-0ubuntu1~trusty1 on KXStudio 14.04

Thoroughly tested using the attachment 96312 [details]:

* Original file (xlsx) only allows to go up to 16 using the scrollbar (even though the control properties show "20" as max value);
* If original file is saved as ods and opened, it also only allows to go up to 16 using the scrollbar (even though the control properties show "20" as max value);
* If original file is saved as xls and opened, the max value is set to 0 in the control properties. If max is set to 20 manually, the scrollbar can only reach 19.
Comment 8 Xisco Faulí 2017-06-12 11:40:34 UTC
Changing version back to the earliest affected version.
Comment 9 QA Administrators 2018-06-13 02:36:31 UTC Comment hidden (obsolete)
Comment 10 flo_gain 2018-06-14 19:44:58 UTC
HEllo I just tested with the latest version of libreoffice 6.0.4 x64 on a windows 7 x64, the bug is still present.
Fred
Comment 11 QA Administrators 2019-06-15 02:59:11 UTC Comment hidden (obsolete)
Comment 12 Stéphane Guillou (stragu) 2019-06-16 05:14:21 UTC
Tested and confirmed exactly as described in Comment 6, on 6.2 branch:

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

... and 6.3 alpha:

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

@flo_gain@yahoo.fr, it would be great if you could also attach an example xls file? Some people (like me) don't have easy access to MS Office so can't really test the second half of your issue.
Comment 13 flo_gain 2019-07-02 13:55:29 UTC
Created attachment 152513 [details]
File in version office2003
Comment 14 flo_gain 2019-07-02 13:56:57 UTC
Hello
I just tested with version 6.1.6.3 the problem is still here.
I just added the file in xls version office 2003 as requested by stragu
Fred
Comment 15 Stéphane Guillou (stragu) 2021-07-29 07:12:27 UTC
Merci, Flo!

Still reproducible as in the Description (for both the xlsx and xls issues), in a recent build of Master:

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

Changing to affecting all OSs as per Comment 12.
Comment 16 QA Administrators 2023-07-30 03:16:15 UTC
Dear flo_gain,

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 https://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://web.libera.chat/?settings=#libreoffice-qa

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

Warm Regards,
QA Team

MassPing-UntouchedBug