Bug 99980 - FILEOPEN: XLS and XLXS filters with absolute & relative referencing of entire column (and maybe row)
Summary: FILEOPEN: XLS and XLXS filters with absolute & relative referencing of entire...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.0.0.alpha1
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-05-21 10:11 UTC by Óvári
Modified: 2016-06-01 21:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
A.ods (9.17 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-05-21 10:11 UTC, Óvári
Details
B.xls created using A.ods (20.50 KB, application/vnd.ms-excel)
2016-05-21 10:27 UTC, Óvári
Details
C.xlsx created using A.ods (8.81 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-05-21 10:28 UTC, Óvári
Details
Error Dialog in LibreOfficeDev5.2.0.0.alpha1+ (60.48 KB, image/png)
2016-05-22 11:02 UTC, Óvári
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Óvári 2016-05-21 10:11:10 UTC
Created attachment 125210 [details]
A.ods

1. Open LibreOfficeDev
2. Open A.ods
3. Save as B.xls (in xls format)
4. Save as C.xlsx (in xlsx format)
5. Close LibreOfficeDev
6. Open LibreOfficeDev
7. Trying to open both B.xls and C.xlsx produce a not working as error message shows with Dialog box:
  Title:
    LibreOfficeDev 5.2.0.0.alpha1
  Description:
    General Error.
    General input/output error.
  OK

Both these LibOffice Masters gave the error:
  libo-master~2016-05-21_02.44.13_LibreOfficeDev_5.2.0.0.alpha1_Win_x86
  master~2016-05-19_23.16.49_LibreOfficeDev_5.2.0.0.alpha1_Win_x86_en-US_de_ar_ja_ru_qtz

Windows 8.1 64-bit
LibreOfficeDev Version: 5.2.0.0.alpha1+
Build ID: 6821ad076c276b997c44520fd700817566a718c5
CPU Threads: 2; OS Version: Windows 6.2; UI Render: default; 
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-05-19_23:16:49

However, LibreOffice Version: 5.1.3.2 (x64)
Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b
CPU Threads: 2; OS Version: Windows 6.29; UI Render: default
could open the files.

This may relate to bug 83746.

Thank you
Comment 1 Óvári 2016-05-21 10:27:49 UTC
Created attachment 125211 [details]
B.xls created using A.ods

1. Opens with:
   LibreOffice Version: 5.1.3.2 (x64)
   Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b
   CPU Threads: 2; OS Version: Windows 6.29; UI Render: default

2. Unable to open with:
   LibreOfficeDev Version: 5.2.0.0.alpha1+
   Build ID: 6821ad076c276b997c44520fd700817566a718c5
   CPU Threads: 2; OS Version: Windows 6.2; UI Render: default; 
   TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-05-19_23:16:49

Thank you
Comment 2 Óvári 2016-05-21 10:28:22 UTC
Created attachment 125212 [details]
C.xlsx created using A.ods

1. Opens with:
   LibreOffice Version: 5.1.3.2 (x64)
   Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b
   CPU Threads: 2; OS Version: Windows 6.29; UI Render: default

2. Unable to open with:
   LibreOfficeDev Version: 5.2.0.0.alpha1+
   Build ID: 6821ad076c276b997c44520fd700817566a718c5
   CPU Threads: 2; OS Version: Windows 6.2; UI Render: default; 
   TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-05-19_23:16:49

Thank you
Comment 3 m_a_riosv 2016-05-21 11:46:38 UTC
I can't reproduce the issue with my created files and with the attached files:
Win10x64
Version: 5.2.0.0.alpha1+
Build ID: 7b704dfbdb23540ff6366fa60c73474bbda9dc26
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-05-20_05:45:40

Please try resetting the user profile, sometimes solves strange issues.
https://wiki.documentfoundation.org/UserProfile
Usually it's enough renaming/deleting the file "user/registrymodifications.xcu",  it affects all the options in Menu/Tools/Options, and the files "user/basic/dialog.xlc" and "scrip.xlc" are overwritten, additionally custom colors in "user/config/standard.soc" are lost.
Comment 4 Óvári 2016-05-22 11:02:35 UTC
Created attachment 125223 [details]
Error Dialog in LibreOfficeDev5.2.0.0.alpha1+

1. (In reply to m.a.riosv from comment #3)
   Deleted all files, folders and subfolders in:
   %APPDATA%\LibreOfficeDev\4\user
2. Opened LibreOfficeDev
3. Dragged C.xls into:
   Drop a document here or pick an app from the left side to create one.
4. Error dialog box, as attached, returned.
Comment 5 Óvári 2016-05-22 11:03:55 UTC
(In reply to Óvári from comment #4)
> 3. Dragged C.xls into:
Should read:
3. Dragged C.xlsx into:
Comment 6 Buovjaga 2016-05-26 16:00:33 UTC
No repro. May try on Win later.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.3.0.0.alpha0+
Build ID: 60041cb237ea73c2c1885dd6afd99d88780c2dfc
CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on May 26th 2016
Comment 7 Buovjaga 2016-06-01 10:07:06 UTC
No repro.

Version: 5.2.0.0.beta1 (x64)
Build ID: 1e9933ef611c66bcded94b84052543c78cf1c223
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
Locale: fi-FI (fi_FI)
Comment 8 Óvári 2016-06-01 21:52:50 UTC
Status changed to WorksForMe as B.xls and C.xlsx now open with Windows 8.1 and LibreOffice Version: 5.2.0.0.beta1 (x64)
Build ID: 1e9933ef611c66bcded94b84052543c78cf1c223
CPU Threads: 2; OS Version: Windows 6.29; UI Render: default

Thank you