Apache OpenOffice (AOO) Bugzilla – Issue 48585
Cross-tabs from Quattro not properly imported
Last modified: 2005-06-09 11:10: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 assumed.
it's a double to Issue 41688 *** This issue has been marked as a duplicate of 41688 ***
closed double
I'm not sure this bug has been addressed.
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. Carl
Created attachment 26991 [details] Small sample data to check for importing of QPW cross-tabs
Hi, 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. Frank *** This issue has been marked as a duplicate of 41688 ***