invalid cast exception Calc C#

[l@bus]

Hi I am new to OO programming so i found some sample codes for Calc. But when I try to run it I get invalid cast exception.

here is the code:

[pitonyak]

Which line generates the exception?
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php

[l@bus]

this one:

[pitonyak]

Now I see that you have it labeled in your original post (smack head).

Odd, the return type looks OK there. I wrote this little script to call my data inspection routines:

[l@bus]

When i change the line to this

[bjozac]

I have the exact same problem on:
Windows 7
VS 2008

Trying to run the provided samples,
ViewSample.cs together with SpreadsheetDocHelper.cs

[adatpro]

Hi

Os: WinXp, Open office (czech language)| 3.2 +SDK 3.2.1, C# express 2008

I had the same problem (compiler throw exception: invalid casting) on line :
XSpreadsheet oSheet = (XSpreadsheet) oSheetsIA.getByIndex(0).Value;

I changed Open office version on Open office us version| 3.2.1 +SDK 3.2.1
and then on the line
XSpreadsheet oSheet = (XSpreadsheet) oSheetsIA.getByIndex(0).Value;
compiler didn't throw exception, but next line
XCell oCell = oSheet.getCellByPosition( 0, 0 );
didn't work a compiler return error messge something like " oSheet isn't valid "

Stefan Slovakia

[glw]

Hello,

Problem with: WinXp, Open office 3.2 SDK 3.2.1, C# express 2008

I run into a version-dependent error when trying to accees a sheet
by using the function:getByName().

My old program never caused any problems
with my previous installation of OpenOffice 2.4.3 and the SDK 2.4.3.

But when I tried to run the same program after installing
OpenOffice 3. and SDK 3.1 (and updating the CLI-references)
the function:getByName() returned NULL.

Switching to an old version is, of course, not the correct solution
but if did solve my problem.

Gerlof