Skip to main content

[archive] Strange Active-X behavior

  • June 19, 2008
  • 1 reply
  • 0 views
D

[Migrated content. Thread originally posted on 18 June 2008]

Hi all,

We have created an application called "Clipboard" that simulates the MsOffice clipboard functionality.
It is a simple form with the active-x control "Spreadsheet" (file name ..\\Program Files\\Common Files\\Microsoft Shared\\Web Components\\11\\OWC11.DLL)

We call "Clipboard" from regular forms to add/modify/delete large grid-related data: We send the grid data to a temporary tab-separated text file and then load the text file to the spreadsheet by using the method @loadtext. After that, we can update the original grid by:

INQUIRE SPREADSHEET-RANGE @VALUE IN VALUE_TMP
MODIFY GRID-HANDLE(ROW, COLUMN), CELL-DATA IS VALUE_TMP

VALUE_TMP is a PIC X(500).

This works fine in local and AcuServer access. But when we use AcuConnect-ThinClient, we observe the following:

The spreadsheet control fails to send any international characters back to grid although it had received them successfully from the grid !!!

To be more precise, suppose grid_cell(1,1) = "abcαβγ"
After sending to spreadsheet, spreadsheet_cell(1,1) = "abcαβγ"
After sending back to grid, grid_cell(1,1)="abc" !!!

Thanks for any help...

Thanos

    1 reply

    D

    [Migrated content. Thread originally posted on 18 June 2008]

    Hi all,

    We have created an application called "Clipboard" that simulates the MsOffice clipboard functionality.
    It is a simple form with the active-x control "Spreadsheet" (file name ..\\Program Files\\Common Files\\Microsoft Shared\\Web Components\\11\\OWC11.DLL)

    We call "Clipboard" from regular forms to add/modify/delete large grid-related data: We send the grid data to a temporary tab-separated text file and then load the text file to the spreadsheet by using the method @loadtext. After that, we can update the original grid by:

    INQUIRE SPREADSHEET-RANGE @VALUE IN VALUE_TMP
    MODIFY GRID-HANDLE(ROW, COLUMN), CELL-DATA IS VALUE_TMP

    VALUE_TMP is a PIC X(500).

    This works fine in local and AcuServer access. But when we use AcuConnect-ThinClient, we observe the following:

    The spreadsheet control fails to send any international characters back to grid although it had received them successfully from the grid !!!

    To be more precise, suppose grid_cell(1,1) = "abcαβγ"
    After sending to spreadsheet, spreadsheet_cell(1,1) = "abcαβγ"
    After sending back to grid, grid_cell(1,1)="abc" !!!

    Thanks for any help...

    Thanos
    There is "translation" happening at several layers.

    As this is TC only, it might be a bug, but it can also be a storage issue. Is your data stored in vision? If so, is this ANSI or ASCII? If it is the latter, this might be the reason.

    I suggest you try to create a small reproducable. This usually unveils something. If it does not, you should send it to Technical Support.

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement