Presence of named formula in template makes corrupted result

[jsfkcz]

Hello,
there is defined named formula MyList ={"Volkswagen";"Seat";"Audi"} in template workbook. Nothing another.
When result file is creating from template, only number 1 is writing to cell A1.

Just presence named formula is enough to cause corruption in result file.
During openning the result file excel shows error message "corrupted file repair/cancel" with opening the result file.
If I choose "repair" then named formula is deleted by excel repair.

If I use a template without this MyList defined formula, the result file is ok.

I tested it with XLSRW 5.20.40
It works ok under XLSRW ver 4.00.65 .

The template and result are at http://www.genet.cz/kohout/xlsrw/xlsrw_ ... ormula.zip for download.

Josef Kohout

P.S.: I use defined array MyList in another formulas like this VLOOKUP(D24;MyList;1;0) .

[larsa]

Hello

There is a bug with some lists in functions. This will be fixed in the next update, ready in mid february. As a workaround, you can set FormatSettings.ListSeparator := ','; Must be done before the component is created.