Issue 126720 - no text imported from xlsx
Summary: no text imported from xlsx
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.2
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2015-12-03 20:06 UTC by tananser
Modified: 2018-08-27 20:17 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.5
Developer Difficulty: ---

two files with different results of import (25.10 KB, application/zip)
2015-12-03 20:06 UTC, tananser
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description tananser 2015-12-03 20:06:11 UTC
Created attachment 85192 [details]
two files with different results of import

I have a lot of files created in MS Excel 2007 and saved as .xlsx. When I open them with OpenOffice 4.1.2 Calc there is no text in cells, but numbers and digits are there. I opened such file with MS Excel and saved it as .xls and it was opened correctly with Calc. Both of xlsx and xls will be attached
Comment 1 Keith N. McKenna 2015-12-04 02:11:39 UTC
I have confirmed that the xlsx file does not import the text values with AOO 4.1.2. Also the xls file open correctly in AOO 4.1.2. The xlsx file opens in the Excel Viewer with all the text entries shown.

System Configuration:
Processor: Intel Core i5 CPU M560 @2.67GHz
Installed Memory: 2.00 GB (1.6 usable)
Operating System: Windows 7 Home Premium 64 bit

Apache Open Office:
AOO412m3(Build:9782)  -  Rev. 1709696
2015-10-21 09:53:29 (Mi, 21 Okt 2015)
Language: en_US
Additional Language Packs: None