Jump to content

GetWSSubrow*


t-bud

Recommended Posts

I am writing a script, and am having an issue with the GetWSSubrow functions.

Here is a samble of the script, that creates a spreadsheet, and trys to get the number of subrows created.

PROCEDURE TestGetWS;

VAR
SSheet	:HANDLE;
subrow	:INTEGER;

BEGIN
SSheet := CreateWS('LXSymbols',2,4); {create worksheet with 2 rows and 4 columns}
SetWSCellFormulaN(SSheet, 1, 0, 1, 0, '=DATABASE((R IN [''Lighting Device'']))');
SetWSCellFormulaN(SSheet, 1, 1, 1, 1, '=(''Lighting Device''.''Symbol Name'')');
SetWSColumnOperators(SSheet, 1,0,0,0,1,0,0); {Summarize Column 1}
ShowWS(SSheet, TRUE);
RecalculateWS(SSheet);

subrow := GetWSSubrowCount(SSheet, 1);

Message('There are ',subrow, ' Lighting Symbols');
END;

run(TestGetWS);

I get an error online 14 saying that it expects a new factor. I get the same error regardless of which of the GetWSSubrow* functions I try.

Am I doing something wrong, or is the function broken?

Running VW2016 SP4 on Windows 10

Edited by t-bud
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...