Skip to main content

[archive] Excel thin client

  • February 7, 2007
  • 1 reply
  • 0 views

[Migrated content. Thread originally posted on 06 February 2007]

When I try to add a range in excel in the thin client version I get the following errormessage. 'Cobol datatype does not match object datatype'.

I use the following code :
03 Exp-Table.
05 ExpAbo HANDLE OF VARIANT OCCURS 4.
03 WRANGE PIC 9(06).
03 WHULPX PIC X(07).

CALL "C$SETVARIANT" USING PK1OMSC EXPABO(1). CALL "C$SETVARIANT" USING WDIME EXPABO(2)
CALL "C$SETVARIANT" USING WZNART EXPABO(3).
CALL "C$SETVARIANT" USING AR2ARTL EXPABO(4).
MOVE SPACES TO WHULPX.
STRING "A", WRANGE DELIMITED BY SIZE INTO WHULPX.
MODIFY haWrkSh
Range(WHULPX)::Resize(1 , 4)::VALUE = Exp-Table.

This works fine except with the thin client.
I now write each cell, but this takes a lot more time.
Does anybody know how i can resolve this.

1 reply

[Migrated content. Thread originally posted on 06 February 2007]

When I try to add a range in excel in the thin client version I get the following errormessage. 'Cobol datatype does not match object datatype'.

I use the following code :
03 Exp-Table.
05 ExpAbo HANDLE OF VARIANT OCCURS 4.
03 WRANGE PIC 9(06).
03 WHULPX PIC X(07).

CALL "C$SETVARIANT" USING PK1OMSC EXPABO(1). CALL "C$SETVARIANT" USING WDIME EXPABO(2)
CALL "C$SETVARIANT" USING WZNART EXPABO(3).
CALL "C$SETVARIANT" USING AR2ARTL EXPABO(4).
MOVE SPACES TO WHULPX.
STRING "A", WRANGE DELIMITED BY SIZE INTO WHULPX.
MODIFY haWrkSh
Range(WHULPX)::Resize(1 , 4)::VALUE = Exp-Table.

This works fine except with the thin client.
I now write each cell, but this takes a lot more time.
Does anybody know how i can resolve this.
Safearrays are not supported in Thin Client yet. It is scheduled support for Safearray in Thin Client for version 8.0.