LIST_TABLE_START in Excel

RLJB

Hi support,

Having issues with LIST_TABLE_START/END in an Excel doc.

Row 1 has the 2 column headers.

Row 2 has 2 columns with the table values;

1st column. <<LIST_TABLE_START('Sales_List')>><<Sales.Amount>>
2nd column. <<SalesCall.PrincipalName>><<LIST_TABLE_END()>>

When generating the Excel doc in Aware, we're getting the error 'Error accessing MS Excel document null'

If I use the exact same code in a HTML doc, the table appears perfectly.

Have also tried with <<LIST_TABLE_START('FIND ALL Sales')>><<Sales.Amount>>

Same result.

Am I missing something obvious?

Cheers

Version 1701

RLJB

Sorry should be;

1st column. <<LIST_TABLE_START('Sales_List')>><<Sales.Amount>>
2nd column. <<Sales.PrincipalName>><<LIST_TABLE_END()>>

RLJB

table pic:

weblike

Hi,
Had something similar with MS Word.
In my case was the apostrophe which is different interpreted in MS Office from a simple text editor like Notepad.

hope it helps.
nice day

Rennur

It could a bug with version 1701, I've tested it on 1812 and it works fine.

Process:
DISPLAY DOCUMENT 'myXls.xls' IN WINDOW opens a pop-up window and the the xls file the saves to the disk. All data in the file is correctly created. No error messages.

(IN WINDOW is a feature in build1812)

Cheers