Issue 116275 - Import xlsx
Summary: Import xlsx
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.3 RC6
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2011-01-02 01:10 UTC by galesch
Modified: 2013-01-29 21:42 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Incomplete xlsx import (1.36 MB, text/plain)
2011-01-02 01:16 UTC, galesch 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description galesch 2011-01-02 01:10:46 UTC 
When I import the attached xlsx file Sheet9 is empty while this is not the case.
Part of the contents is below:					
					
Count of Throttle	Column Labels				
Row Labels	01:00:00	01:00:01	01:00:02	01:00:03
	01:00:04
HI					
T1	1	1	1	1	1
T2					
T3					
T4					
T5					
T6					
T7					
T8					
Grand Total	1	1	1	1	1
Comment 1 galesch 2011-01-02 01:16:56 UTC 
Created attachment 75455 [details]
Incomplete xlsx import
Comment 2 Regina Henschel 2011-01-02 11:51:43 UTC 
The document contains a pivot table with 4803 columns x 11 rows.
(4801 data columns, row heading column, grant total column,
9 data rows, column heading row, grant total row).

OOo is not able to handle such pivot tables.
Limits: 8 data variables, 1024 columns per sheet.

I set this issue to "new" and "enhancement" because I think, OOo should give a
warning, when column count of documents exceeds the maximal columns count of OOo
and when pivot table contains more than 8 variables.
(I cannot search for duplicates because Issuetracker is nearly unresponsive.)