Issue 48585 - Cross-tabs from Quattro not properly imported
Summary: Cross-tabs from Quattro not properly imported
Status: CLOSED DUPLICATE of issue 41688
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1.4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2005-05-03 04:42 UTC by c_paulsen
Modified: 2005-06-09 11:10 UTC (History)
1 user (show)

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

Small sample data to check for importing of QPW cross-tabs (10.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2005-06-07 19:27 UTC, c_paulsen
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description c_paulsen 2005-05-03 04:42:12 UTC
Cross-tabs from Corel Quattro spreadsheet were imported as data and not active
Data Pilot tables.  The file was a multi-sheet spreadsheet file with at least 3
Quattro "cross-tab" tables.  I should note that the cross-tabs in Quattro had
problems, particularly in that date fields used as "row" values would lose their
formatting part way through the cross-tab and turn into decimal dates.  I never
figured out the cause of this problem, even after submitting questions to the
relevant Corel newsgroup (noone had an answer for the problem).  Thus this
problem could be specific to my file.

Also, I don't know if this is an intentional omission, in which case this issue
should perhaps be designated as a feature request, or if it is a bug as I've
Comment 1 frank 2005-06-07 11:13:14 UTC
it's a double to Issue 41688

*** This issue has been marked as a duplicate of 41688 ***
Comment 2 frank 2005-06-07 11:13:31 UTC
closed double
Comment 3 frank 2005-06-07 11:13:40 UTC
closed double
Comment 4 c_paulsen 2005-06-07 19:20:25 UTC
I'm not sure this bug has been addressed.
Comment 5 c_paulsen 2005-06-07 19:25:35 UTC
This issue (48585) has been closed as a duplicate of #41688, but that issue was
with OO 2.0 and this one was with 1.1.4.  Also, I checked #41688 and it has no
relation to importing of Cross Tabs from QuattroPro.  It has lots of other
import tests but specifies no problems or issues encountered, and none of the
tests actually relates to Cross Tabs (from what I can tell).  Are you sure this
is a duplicate?  Has the cross tabs issue been addressed yet?

More relevant info:  I used QuattroPro 12.  In trying to reproduce the issue, I
had to first save the test file as an Excel spreadsheet since 1.1.4 doesn't have
a Quattro import/open tool.  Then I opened this intermediate excel file which
yielded the result I reported, that is, the cross tab gets imported as data, not
a Cross-Tab or Data Pilot table.  The issue may well be with the saving from
Quattro to Excel as I don't own Excel and can't verify the functioning of the
intermediate file.   I'll attached a small sample file for testing purposes.  

Comment 6 c_paulsen 2005-06-07 19:27:29 UTC
Created attachment 26991 [details]
Small sample data to check for importing of QPW cross-tabs
Comment 7 frank 2005-06-09 11:09:58 UTC

yes this Issue is addressed and it's a double to Issue 41688 as OOo2.0 is the
only version the development works on. OOo1.1.4 is at the end of it's
development livecycle so only bugfixing is done on it.


*** This issue has been marked as a duplicate of 41688 ***
Comment 8 frank 2005-06-09 11:10:12 UTC
closed double