Issue 19125 - Failure to properly import spreadsheet
Summary: Failure to properly import spreadsheet
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-05 19:04 UTC by welshpjw
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
File with reported probelm (2.5MB, sorry, had to gz) (405.03 KB, application/octet-stream)
2003-09-05 19:09 UTC, welshpjw 		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 welshpjw 2003-09-05 19:04:02 UTC 
Imported spreadsheet does not contain the drop down selectable options that MS
Excel contains. I am not sure if they are VB macros? Not sure how to tell. No
warning appears in OOo.

GNU/Linux RH7.3 OOo 1.1RC3 and 1.1RC2 and 1.0.3.
Comment 1 welshpjw 2003-09-05 19:09:18 UTC 
Created attachment 9041 [details]
File with reported probelm (2.5MB, sorry, had to gz)
Comment 2 welshpjw 2003-09-05 19:11:16 UTC 
Would not let me send at original size. Had to gzip the file to 400Kb.
Only displays 60 lines or so. Looks like it must have ALOT of lookup
information embeded!
Comment 3 frank 2003-09-08 08:48:58 UTC 
Hi PJ,

this is a limitation of the excel import. What you're facing is a
datapilot which is slightly different from the original Excel Pivot
table. Rows 1 to 15 and many more are hidden and the Pivot table
control is simply not available in OOo Calc.

So I have to set this one to invalid, as it works as intended.

Frank
Comment 4 frank 2003-09-08 08:49:18 UTC 
closed invalid