Phil,

The difficulty here is that (I'm assuming) the list or printers needed is variable.  Because of this, the data needed for the drop box needs to be written to a memory file.

I tried the following and it seems to work (although I have not coded a Printer_Validate method).

1) Edited the _fm_panel_iol$ hidden variable in the html file to include printer$
2) Included the following code for the printer drop box:

 [row "*\[show usefile field=printer$\]:"][list printer$ size=20 event=Printer_Validate program=c:\webster\prog\tools][/list][/row]<br>

3) Coded the c:\webster\prog/tools program to load a memory file as follows:

 ! tools - load printer list
 !
  ENTER fileno
 !
  OPEN (HFN)"*memory*"
  fileno=LFO
 !
  printer_list$="Printer A/Printer B/Printer C/"
  FOR val$ FROM printer_list$
  WRITE (fileno,KEY=val$)
  NEXT
 !
  EXIT 

You would need to edit your Printer_List method accordingly.

Hope this helps!

Hi Phil,

If I'm understanding this correctly - printer$ is the element in the data file being maintained and printerList$ is the delimited list of available printers (that is not an element in the data file).

I have not tried this - but it sounds like you might need to add a Hidden Variable to the form.  You can do this by adding a line using the [hide] short code to the generated html page that looks something like:

[hide printerList$ value=""]

 - or -

If you are running PxPlus 2022 or later, you should be able to also do this from within the File Maintenance Generator.  Press the Hidden Variables button on Step 6 and add an Additional Variable of printerList$.
 

We are having some difficulty determining the exact window you are referring to.
 
Could you perhaps detail the exact steps you follow to display the window or, better yet, attach a screen shot of the the window that is too short?   

Thanks!

Tom,

The PxPlus Excel object will look for Excel locally on the machine that instantiates the object (X_OBJ=new(*obj/excel).  If you run the program on a workstation, that workstation will need to have Excel installed.  If the program is run on the server - only the server should need to have Excel installed.  However, the excel file created would also be on the server.

There may be ways around this if you do not use the PxPlus Excel Object.

Tom,

You can print TCB(29) to see what version is installed.  Version 16 should show 16000000 and 16.2 should show 16200000.

Just to clarify - were you still using WindX when it worked using verison 20?

Thanks,

Hi Tom,

I tried this with our current version and with PxPlus 2019 (version 16) of the excel object and it works fine for me.

When the workbook is created - it will use the excel default template.  Is it possible this has some sort of formatting already there for these cells?

Hi Ron,

I tried creating an embedded panel with a rectangle shape control 2 lines high.  It did not work correctly when the embedded panel height was defined as 3 - but did work when the embedded panel was made higher (14 high).  Only the rectangle is embedded - but the height/width ratio is used when trying to compute  how to stretch the controls.

Hope this helps

James,

Perhaps this is unrelated to the update ...

Is it possible that the default Book1.xlsx file already exits and was opened or in use elsewhere?  The CreateWorkbook method  attempts to add a workbook and then tries to save it with the supplied path.  If no path is supplied, it will try to save it with the default path and may fail.  It may be easier to supply a path name - but you can also call the Create Workbook method with a second parameter - a flag telling the object to always overwrite the existing file (in this case Book1.xlsx).   

return_value=x'CreateWorkbook("",1)