Issue 116275

Summary: Import xlsx
Product: Calc Reporter: galesch <gerhard.lesch>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rb.henschel
Version: OOo 3.3 RC6Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Incomplete xlsx import none

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.)