Can QP function like Excel?

At a recent conference numerous applications were shown that had been 
created in Excel. The applications contained pulldown menus, selection 
boxes, and a host of other interactive type functions. The applications 
didn't look like spreadsheets! Can such complex applications be created 
in QP? Thanks, Michael

By Applications, I think you mean workbooks.  In qp, these are called 
notebooks.  The answer depends on what they are doing.

Have you looked into notebook templates made by KMT?  They sort of do it 
using PerfectExpert.  Unfortunately, Corel has not made coding 
PerfectExpert available to users.  You can create workbooks that are 
templates though.  You could use an initial autostart macro to interact 
with the user if needed.  Buttons, menus and such can be used to allow 
more automation.

You can use some controls similar to Excel.  You can use QP dialogs for 
some user interaction but these tend to be buggy.  If you do that, I 
recommend saving the files as WB3 rather than QPW.  Since QP can also do 
VBA, some VBA dialogs or userforms as they are called in VBA, are the same.

Michael:
> The applications contained pulldown menus, selection 
> boxes, and a host of other interactive type functions. The applications 
> didn't look like spreadsheets! Can such complex applications be created 
> in QP?
>
Yes.

Start with:
have some data in B7..B12
(only because my random typing ended up there)
Insert|Form Control|ListBox|drag to create
right-click|Properties|Source Block Tab
click the RangePicker arrow-in-a-square
select B7..B12
click the Maximize button in the Title Bar that appeared
Destination Block Tab
similarly select I7 and return
Macro Tab - type in:
{Let I7, @INDEX(B7..B12,0,I7)}
 - this is needed because of a glitch in v9ff - Ack: Jim Latham
[OK]
Now double-click any item in the List Box.

Explore /ad.lib./
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)