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 Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Scrollbars
  Show dependency treegraph
 
Reported: 2014-03-24 19:00 UTC by flo_gain
Modified: 2019-07-02 13:57 UTC (History)
3 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 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 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