Issue 117885 - get/setPrintAreas generates [automation bridge] exception in UnoConversionUtilities<T>::variantToAny
Summary: get/setPrintAreas generates [automation bridge] exception in UnoConversionUt...
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.3
Hardware: PC Windows XP
: P3 Normal (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-04-18 15:03 UTC by angelo.cacini
Modified: 2013-08-07 15:14 UTC (History)
4 users (show)

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

Attachments
VBScript test replicating the unexpected exception (1.47 KB, text/plain)
2011-04-18 15:03 UTC, angelo.cacini 		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 angelo.cacini 2011-04-18 15:03:19 UTC 
Created attachment 76403 [details]
VBScript test replicating the unexpected exception

The exception is generated programming OpenOffice by COM Automation.

Since OpenOffice v3.3.0 the array of struct CellRangeAddress reported by getPrintAreas() method is unusable. If you try to refer a property (e.g. EndRow) an [automation bridge] exception is generated.

In order to replicate the problem run the attached VBScript. If run the script with OpenOffice v3.2.1 it works, with OpenOffice v3.3.0 it doesn't work.

The script does the following:
1. Create a black Calc Document
2. Create a new CellRangeAddress [A1:B10]
3. Assign it to Sheet1 PrintArea, thru sheet.setPrintAreas()
4. Obtain the PrintArea assigned to Sheet1 thru sheet1.getPrintAreas()
5. Assign it to Sheet2

The exception arises executing step 5 (on OpenOffice v3.3.0).
Comment 1 Oliver Brinzing 2011-04-19 11:02:12 UTC 
confirming with oo3.4beta1.
is it another dup of http://openoffice.org/bugzilla/show_bug.cgi?id=117010 ?
Comment 2 angelo.cacini 2011-04-20 12:46:12 UTC 
Additional tests:

1. Using OO v3.3 with original oleautobridge.one.dll v3.3, the test script doesn't work

2. Using OO v3.3, replaced original oleautobridge.one.dll v3.3 with oleautobridge.one.dll v3.2, the test script works

3. Using OO v3.3, replaced original oleautobridge.one.dll v3.3 with oleautobridge.one.dll v3.4Beta1, the test script doesn't work


Reading bugs 117010 and 117523 it seems this defect (117885) has a common origin, but I have no evidence to confirm it is a duplicate.
Comment 3 bmarcelly 2011-04-27 12:00:58 UTC 
I added one line in the code :
  areas = sheet0.getPrintAreas()
  msgBox areas(0).Sheet   ' <---- line added

I got an error on this last line, saying : Object requested: 'areas(...)'
So, areas did not receive an array of CellRangeAddress

This is the same kind of bug as Issue 117010 : impossible to get an array from OpenOffice. It only appears later.
Comment 4 Oliver-Rainer Wittmann 2012-06-13 12:18:32 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 5 angelo.cacini 2012-10-20 08:09:12 UTC 
The testing VBScript on AOO v3.4.1 runs without any problem. The bug appears to be fixed.