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: 4.3.4.1 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-24 19:00 UTC by flo_gain
Modified: 2014-12-12 09:54 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
Excel test file (9.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-03-24 19:00 UTC, flo_gain
Details

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


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.